[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Intermediate SSRS Reports Page

Posted on 2008-10-05
4
Medium Priority
?
811 Views
Last Modified: 2008-10-06
I have added two previous E-E questions as reference here for my current attempt at an intermediate screen for ssrs.
By using the previous two questions, I was able to work my way thru four complicated stored procedures as datasets for my report- (reservation/confirmation) and as parameter filters for my report.
I am creating an Intermediate Reports Parameter Page, basically which mimics the reporting services parameter screen, but is a custom asp page with all of the same parameters: start and end date, clientid and eventid available from two separate drop downs, and three optional parameters.

I am having trouble calling my .rdl SSRS report from this intermediate page:
Attached is the code I am using but, when I step thru, it always takes me to the Root directory of the reportserver.
Can anyone help?
My .rdl report takes seven parameters and i think Im calling it correctly.
Basically, Id like this logic:

If Page.IsValid then
     response.redirect(reporturl) & params
else
     'error!'
end if

Thanks in Advance.

John
Dim sb As System.Text.StringBuilder =  New System.Text.StringBuilder("Total") 
 
If DropDownList1.SelectedIndex > 0 Then
   sb.Append("&ddClient=" + DropDownList1.SelectedValue.Trim())
End If
If DropDownList2.SelectedIndex > 0 Then
   sb.Append("&ddEvent=" + DropDownList2.SelectedValue.Trim())
End If
If TextBox1.Text <> "" Then
   sb.Append(String.Format("&txt1={0}%", TextBox1.Text.Trim()))
End If
If TextBox2.Text <> "" Then
   sb.Append(String.Format("&txt2={0}%", TextBox2.Text.Trim()))
End If
If TextBox3.Text <> "" Then
   sb.Append(String.Format("&txt3={0}%", TextBox3.Text.Trim()))
End If
If TextBox4.Text <> "" Then
   sb.Append(String.Format("&txt4={0}%", TextBox4.Text.Trim()))
End If
If TextBox5.Text <> "" Then
   sb.Append(String.Format("&txt5={0}%", TextBox5.Text.Trim()))
End If
 
 
Response.Redirect(String.Format(reportServer, sb.ToString()), True)

Open in new window

0
Comment
Question by:jtrapat1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
rob_farley earned 2000 total points
ID: 22648448
Have you tried just outputting the URL, so that you can check that it looks valid?

Another option is to consider using the webservice to render the report in HTML, so that you can check it's valid and then just write to your response buffer?

Rob
0
 

Author Comment

by:jtrapat1
ID: 22648955
rob-
thanks for the response-
Can you expand a little on that?
I am having a tough time with the string buffer; i dont know why.
I cant seem to trap any values at all.

Thanks
John
0
 

Author Comment

by:jtrapat1
ID: 22649177
rob-
You were correct - I had the path wrong.
Maybe I should have asked this differently- since Im new to SSRS.
I would like to send my Intermediate page, with the seven parameters TO the ssrs report, bypassing the parameter page and launching the report with these entered values.

Im trying to concatenate the parameters onto my url but I cant get it working-
Do you see anything wrong with my syntax?

From what Ive read:
1. you have to disable the parameter prompts from the report side.
2. in the url in the Response.Redirect, I would like to hide the toolbar and the parameter fields.

Thanks
John
0
 
LVL 15

Expert Comment

by:rob_farley
ID: 22655513
You should look at a URL like:

http://localhost/reportserver?/ReportPath¶m1=1¶m2=2&rs:Command=Render&rc:Toolbar=false

Make sure you have the questionmark, as the page is /reportserver.

Rob
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question