Last post Jul 07, 2011 06:57 AM by ziako
Jun 27, 2011 09:12 AM|ziako|LINK
I have report (Built in Report Builder) with the following SQL:
WHERE Productuniqueid = @Productuniqueid
The report is based on a parameter. ie The user has to type in the productuniqueID before the report can be run. I have a ASP.net webpage linked to the same database.
After a product search on the page information is pulled to the webpage. I would like the user to be able to print off the webpage as a Reporting Services report. I would like the user to be able to bypass this and print off the information from my query
based on the productuniqueID..linked to the webpage. So in essence they dont need to input the productuniqueID.
I understand this is called Passing a query string parameter to a report.
Jul 01, 2011 03:00 AM|You-Hu Fu|LINK
It seems you want to pass a parameter's value to a rerport via URL. Actually, you can use parameters as part of a URL to configure the look and feel of your reports. Parameters are case-insensitive and begin with the parameter prefix
rs: if directed to the report server and
rc: if directed to an HTML Viewer. The most common parameters are listed in this section
If I misunderstand you ,please feel free to let me know.
Jul 07, 2011 06:57 AM|ziako|LINK
I have created a report in Report Builder. The SQL is as below:
I have the exact same fields on a ASP.NET Page whereby the data is pulled from a database when the user enters a enquiryID into the search field.
I would like the user to be able to print the exact same fields via my report which I have designed.
So basically the user will click on a asp.net Link 'Print' and the reporting services print page will fire up.
How can i achieve this without the user being able to type in the parameter before printing.
The page has fields on there which are the same as the SQL i provided.
What i want to achieve is for the user to be able to print off a report. The asp.net page will have a link which states Print.
I would like the user to print off the details from the webpage. The report also has the same fields which i have coded in SQL.
Instead of the user having to type in the EnquiryID (parameter) i would like the user to bypass this...and instead just print off the details relating to the enquiryID without having to enter the enquiryID.
There is enquiryID field on the webpage.
I understand this is called passing a query parameter
Accounts.AccountUniqueID AS [Accounts AccountUniqueID]
,Accounts.CreatedBy AS [Accounts CreatedBy]
,Accounts.DateCreated AS [Accounts DateCreated]
,Enquiries.CreatedBy AS [Enquiries CreatedBy]
,Enquiries.DateCreated AS [Enquiries DateCreated]
,Enquiries.AccountUniqueID AS [Enquiries AccountUniqueID]
INNER JOIN Enquiries ON Accounts.AccountUniqueID = Enquiries.AccountUniqueid
WHERE Enquiries.EnquiryID = @EnquiryID