tonelm54
asked on
ReportViewer arguments
I have a ReportViewer on a page, but I need to be able to set variables such as StartDate and EndDate inside the query for the report, but can seem to find any examples of how to set a query in code.
The field names will remain the same, so hopefully I dont need to re-design the report, all I really need to do is something like ReportViewer1.query = "select * from myTable where startDate < = 22/09/2010"
Any suggestions or examples would be great if anyones done anything like this before?
Thank you in advance!
Tony Cross
The field names will remain the same, so hopefully I dont need to re-design the report, all I really need to do is something like ReportViewer1.query = "select * from myTable where startDate < = 22/09/2010"
Any suggestions or examples would be great if anyones done anything like this before?
Thank you in advance!
Tony Cross
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I was using many of different reporting tools but for me the best so far is FastReport.
If you can't switch, please send us more code - then somebody will help you quicker.
Regards
Daniel