Last post Feb 24, 2015 04:52 PM by Ysa206
Jun 17, 2013 12:28 PM|kimloong888|LINK
I have 3 databases, db1/db2/db3, every db with 3 tables - customer master, sales record master and item master. In the web page, I got 5 selections for users to choose,
User can generate the report by fill in all the required information or they can just fill in some of them.
Example user can fill in age and item type to generate the report. System will search the record in all db's customer master table and item master table
or user can fill in db2, area, total purchase value and item type to generate the report. System will search record in db2's customer master table, sales record table and item master table.
i am using VB to code. I able to generate the report with single db and multiple fixed parameters (means user must fill in all required information).
It is highly appreciated if anyone can give me some idea how to generate this kind of report in asp.net 4.0 (VB).
Thanking you in advance.
Jun 18, 2013 03:54 AM|Abhi.ssrs|LINK
Please refer to my previous post :
This post mentions that you can use a dynamic connection string for your report to get the desired database. All other parameters can remain as they are.
Please mark as answer if this helps!
Jun 18, 2013 04:06 AM|kimloong888|LINK
Jun 18, 2013 04:39 AM|Abhi.ssrs|LINK
The connection string is available in Report datasource. Click on Report Datsource --> got o daatsource properties and in expression write :
="DataSource =" & Parameters!RServer.Value & ";InitialCatalog=" & Parameters!Rdatabase.value
Now got reportParameters-->right click and select addParameter. Name the parameter RServer . Now add second parameter and name it Rdatabase. Thereafter in your VB code add these paarmeters to receive values from user selected dropdown values and post them
to Report url wherever the report is calle din your code.
Sorry but its not possible to give more detailed steps here.
Jun 19, 2013 12:03 AM|kimloong888|LINK
Jun 19, 2013 06:26 AM|Abhi.ssrs|LINK
Hi, In that case, you will need to do that in dataset using a stored proc. I dont think we will be able to achive that in SSRS . You might send the database names selected by user to stored proc as paarmeters and in stored proc use the fully qualified table
name with database names and then join the results. In case the Database are on different servers, I am not sure how to query them. you might need to search for that on net.
Jun 19, 2013 06:37 AM|Abhi.ssrs|LINK
These links may help :
Jun 21, 2013 12:35 AM|kimloong888|LINK
Feb 24, 2015 04:52 PM|Ysa206|LINK
you CAN USE lookUPS in order to see information from other dataset.....