report viewer

I have asp.net page
That has a gridview..

ID
1001
1002
1003


IA m trying to call reporting services report in Report view if I click ID
For example, if I click ID 1001 ..it will pass the parameter 1001
And run a reporting services report in Report viewer on new web page..

How can I do this? Is there a example I can take a look?
jung1975Asked:
Who is Participating?
 
AsishRajConnect With a Mentor Commented:
first you have to make a report that accepts parameters. then you have to embed it into a webpage. lastly you have to pass the parameter from your viewing page to report page.

do you know how to create reports that accept parameters.
0
 
AsishRajConnect With a Mentor Commented:
refer below url on how to pass dynamic parameters to reports

http://www.aspfree.com/c/a/ASP.NET/Working-with-Parameters-with-Crystal-Reports-and-ASP-NET-2-0/

once you do that then we can move forward
0
 
jung1975Author Commented:
i know how to create reporting services report with parameter..
i just wnat to know how to pass the paratmenter form the grewview to reporting services report in report view control?

any example?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
AsishRajConnect With a Mentor Commented:
in that case you have an hyperlink in your gridview something like this

<asp:TemplateColumn HeaderText="Transaction No.">
     <ItemTemplate>
         <asp:Hyperlink runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "TXNNumber")%>' NavigateUrl='<%# "PointDetails.aspx?Transaction=" & DataBinder.Eval(Container.DataItem,"TXNNumber") %>' ID="Hyperlink1"/>
         </ItemTemplate>
</asp:TemplateColumn>

then

on the page load have something like this

Dim TxnNo As String = Request.QueryString.Item("Transaction")
loadReport(TxnNo) 'Function to load report.
0
 
AsishRajConnect With a Mentor Commented:
sorry forgot to mention...TxnNumber is you ID. and replace points details with your report page path
0
 
AsishRajConnect With a Mentor Commented:
on the page load of the report page have something like this

Dim TxnNo As  String = Request.QueryString.Item("Transaction")
loadReport(TxnNo)  'Function to load report.
0
 
jung1975Author Commented:
thanks..

on the report page..
how to pass the parameter to reporting services report..
let;s say, if i have a report in http://prod1/reportserver
and it;s call Auditreport  and it accepts the parameter @ID ...

how can I call this report in repot viewer and and pass the parameter @ID?
0
 
AsishRajConnect With a Mentor Commented:
You need to load the report using a Function. that would solve the issue.
Pass the ID to the function and let the function pass the ID as the parameter to the report.
0
 
jung1975Author Commented:
so how to create a loadreport function?

0
 
AsishRajConnect With a Mentor Commented:
have a look at the url i gave above.
0
 
jung1975Author Commented:
yes.. thanks.. but is there Reporting services example not Crystal report?
thakns for your help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.