473,554 Members | 3,240 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Generating Reports from Two Different Databases in SSRS-2005

14 New Member
I'm Generating Reports in SSRS-2005..

Previously I got the Data from One Database & Generated Reports.. Now I used to get the Data from Two Different Databases(ie Database-1 & Database-2) & to generate the Reports..
I'm having one Stored Procedure(Get_D ata) which will combine Two databases & get the data from them.. It is working fine for Me..(I tested in Sql Server Management Studio)..

But it is Not working fine in my Visual Studio..

If i'm using Connection String with SqlDataSource(f rom Tool Box) it is working fine.. Report is Generating Normally....

But through Coding it is not working..

Previously when i'm generating Report through Single Database it is worked fine(Through Coding only.. that time also I used Stored Procedure's).. But when i'm working with Two Stored Procedures it is not working.. ie Reports is not Generating..


What is the Problem...

Please give me Suggestions for this...


Thank You..
Mar 11 '08 #1
0 1841

Sign in to post your reply or Sign up for a free account.

Similar topics

2
1946
by: Ryan | last post by:
We have an MIS system which has approx 100 reports. Each of these reports can take up to several minutes to run due to the complexity of the queries (hundreds of lines each in most cases). Each report can be run by many users, so in effect we have a slow system. I want to seperate the complex part of the queries into a process that is...
2
1253
by: airkart | last post by:
Hello, I've scoured groups and the web, and haven't found a question like mine answered. I'm using Visual Studio 2003 with the Crystal Reports it comes bundled with and SQL Server 2000. Throughout the project I'm working on, I often find I need a temporary table displayed in a report, something that I cannot seem to do. Since temporary...
2
2385
by: MattC | last post by:
Hi, I am developing a timesheet system that collects information about employees activities. In this I collect details about projects they do work for, what type of work, how long, when etc etc. For distributed data input/storage and display I am happy using ASP.NET. However ther eis one aspect of the project I am not entirely...
1
2613
by: Kiran | last post by:
Hi, I have my reports at http:\\localhost\ReportServer and need to use them in ASP.NET Web Form.I have a few questions reg. this ------> I want to generate a PDF when a button labeled "Generate Report" is clicked" (1) I tried this using the below code:
3
1201
by: TS | last post by:
I have 2 sql server databases on 2 different servers, a web app, and a crystal reports interface. When the app uses 1 database and the reports datasource points to a different database, both databases on different servers, the application always comes up, but the report comes back saying no data. When i have both the app and reports...
16
6495
by: JoeW | last post by:
I'm utilizing a database that I created within MS Access within a program I've created in VB.NET. I am using the VB front end to navigate the information, but want to be able to print a report, that I've also created within MS Access. I've attempted using the Access.Application instance, but I get errors when it tries to load the ...
2
4762
by: BillCo | last post by:
Does anyone know if it is possible to integrate SQL Server Reporting Services Reports in an ADP? Is there a plugin or anything that can do this? I have a hunch that the Web Viewer Active-X componant wont be up to the job. I've googled it but it seems to be slim pickings! I need to keep this ap as easy to ".NET-ise" as possible, so I'm...
0
902
by: vic07 | last post by:
hello all I desperately need some help with Perl! I am very new to this programming language, never practiced it before, however where I work I have to write a program that does the following: There are two very large databases one is done on Oracle, the other in SQL server. The overall aim is to report the differences of certain fields in the...
4
2797
by: Max2006 | last post by:
Hi, I am developing a web application on windows XP. A page within my application needs to access to SSRS running on the same machine. Once the web application tries to consume the SSRS web services, I receive the following error: System.Web.Services.Protocols.SoapException: The permissions granted to user DEV1\ASPNET' are insufficient...
2
1843
by: Rob | last post by:
I've used Crystal Reports for years and whilst it's been a love-hate relationship, it does it job. But I think it's become rather bloated over time and I have one big issue with it - the installation on a web server requires installation of a huge MSI which puts stuff all over the web server, not just in the web folder. This is fine (well...
0
7583
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7873
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6127
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5424
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5143
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3534
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2007
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1115
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
825
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.