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.
How to send a query from a C#/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.
Reply:You can used the stored procedure
Reply:wow...i ddon't even know what your talking about..........sorry
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment