SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



Preview while building report - action on web Expand / Collapse
Author
Message
Posted Sunday, October 07, 2007 10:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 04, 2010 12:11 PM
Points: 5, Visits: 371
I have built 3 reports that are linked together.
1 - Region report (contains region, zone, location, month, hiring plan count) - no Parameters needed to run this report, but carries out the location parameter to next report. The regions appear in a matrix report with drill down to zone, then drill down to location. Link is out from location at this point.

2 - Location report (contains location, month, hiring plan count, actual hired count) - uses location parameter when linked from region report. The location name is distinct, so do not carry out the region and zone to the location report.

Note - the location report can also be used from a link by itself - the user picks from 3 cascading drop down lists for region, zone, location. The cascading lists are only used for a limit to the number of location names a user has to choose from.

3 - Actual report (contains location, month, actual hired count, employee info).

When working in reporting services, all links work fine and each report functions as I need.

When moved to server and the reports are accessed through a Visual Studio application, the Parameters will not link down to each report.

In the Location report, there are 3 drop down list Parameters that the user chooses from. During building and preview, the choices can be changed, click the view report button, and the data changes accordingly. When the report is accessed through the application from Report Manager, the 'view report' button does not cause the data to change to the new Parameters.

Would appreciate any comments on why the reports function as designed in the 'preview' while building, but will not function or carry Parameters when accessed through the application.
Post #407785
« Prev Topic | Next Topic »


Permissions Expand / Collapse