Interview Question in SQL Server Reporting Services (SSRS)


 

Interview Question :: How to send a query from a cSharp/VB.net application to a report made using SQL reporting services


Suppose my query is "SELECT * from Finance". How to pass this query from my VB/C#.net application to a report "FinanceDetails.rdl" report? Please help.
Answers to "How to send a query from a cSharp/VB.net application to a report made using SQL reporting services"
RE: How to send a query from a cSharp/VB.net application to a report made using SQL reporting services?

I would create a SQL view with the data that you need, something called 'myView'. This can pull in data from different tables if needed. Then, within your report you should be able to select this the same way you would a table so you wouldn't need to pass anything to the report from your .NET app. If you wanted to you could pass a param to the report if you were selecting certain data or wanted to pass a 'SORT BY' criteria.
 
Vote for this answer ::  
RE: How to send a query from a cSharp/VB.net application to a report made using SQL reporting services?

You can used the stored procedure
 
Vote for this answer ::  
RE: How to send a query from a cSharp/VB.net application to a report made using SQL reporting services?

wow...i ddon't even know what your talking about..........sorry
 
Vote for this answer ::  
Update Alert Setting