Report viewer

[Aptiva Dave]

Here is my problem: I have a web app connected to a SQL database. I need to create a report that displays counts of certain records during a certain time period. Also, within the report I need to display the name of the person who created the report, their phone number, and the date that the report was printed, but all of this is entered from a different page and I was passing it via query string. Can this be done and how can I do it?

[ReactiveX]

That is most definitely possible, with the following constraints: In order to display the records for a certain time period, your rows need to have a created date column or something that you can base your query on. You won't be able to report the time that the report was printed on because the event hasn't happened yet. You could alternatively store this date in the DB and report on it later. To pass the person's name and phone number via a query string is easy. Once you're ready to redirect the user to the report page, do the following: Response.Redirect("Report.aspx?name=" & sPersonName & "&phone=" & sPersonPhone)

Daniel Minnaar Lead Software Developer

[Aptiva Dave]

Yes, but how do I put that information into the report? I already have a date column that I can base my query on, but the issue is that I just don't know how to search by these parameters.