Solved

How do I prevent the Reporting Services Parameter Bar disappearing?

Posted on 2010-08-25
1
1,383 Views
Last Modified: 2012-05-10
I've made a report for SSRS 2008. the report has 4 parameters that are hierarchical in nature (You pic something from the 1st param, it loads the 2nd param list based on that 1st param. Then you pick something from the 2nd param, it loads the 3rd list... etc).

When I make more than 1 parameter change before clicking "View Report", the parameter bar disappears entirely - not the Hide mode, where you can click on the arrows to open it, but FULLY gone. The screenshots tell the tale.

How can I stop this?
SSRS-1.png
SSRS-2.png
SSRS-3.png
SSRS-4.png
0
Comment
Question by:Paul Kahl
1 Comment
 
LVL 3

Accepted Solution

by:
Paul Kahl earned 0 total points
ID: 33526914
Ok, folks. Figured it out.

There was a report, basically just a few text boxes that were an Action link to other reports. Using that report to get to the other reports somehow screwed up the parameter bar when you would arrive at your destination report.

I removed the 'navigation page' from the reports, renamed the destination reports with friendlier display names for the customer, and all's well. Now they go straight to the report, and there are no issues.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

707 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now