ie: Select * from table1 where ID = request("ID")
What I am doing is opening a report from a webpage and printing out what is displayed in a report. Some are straight forward that are just a listing of information where others the results are based on a unique value like an ID that is passed in the URL. Is there anyway to pass that to the report as well and filter the information based on a request or something along those lines?
Thanks in advance!
Hmm, I don't know if I understand you but when designing your report, create dataset with query: "select * from table1 where ID = @.ID" then in report parameters define @.ID parameter (it can be "static" or depend on another dataset).
Next, before you execute report you must assign to your parameter a value. In Rerpoting Services portal you have GUI that allow user to do so. You can also create GUI for your report parameters on your web page and send parameter values in URL.
Maciej
No comments:
Post a Comment