Interview Question in SQL Server Reporting Services (SSRS)


 

Interview Question :: VB 6 and SQL Server 2005 Reporting Services


Im using SQL Server 2005 Express Edition as a database for my VB 6 aplication. I would like to pass a parameter from my vb6 aplication to a report which i made from SQL 2005 reporting services. Can somebody help me with the codes on how to pass a parameter and other which is needed to generate the report. Thank you.
Answers to "VB 6 and SQL Server 2005 Reporting Services"
RE: VB 6 and SQL Server 2005 Reporting Services?

to pass parameters to your report just open the report thru the web site, copy the url, and add your parameters in the url. Example:



Lets say your sql report has two parameters, intheight and intweight that is used to generate the report. You can run the report by opening the url like so:

http://<server name>/<report server name>/?%2f<folder name>%2f<report name>&intHeight=<value>&intWeight=<value...
 
Vote for this answer ::  
Update Alert Setting