Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameters show incorrectly first time thru

Status
Not open for further replies.

mgallot

MIS
Jan 22, 2001
93
US
I am using Visual Studio 2005 to create a report with 2 parameters. The first parm is division, the second is team (must be within division). I have 5 report parms set up, Div, output, delimiter, team, team_output. There are 4 datasets, div just pulls all divs, output parses the list because its multivalued, team uses the output from div to constrain the team list, then a team output that is parsed. The Team parameter list only constrains correctly after the view report button is pressed once. So the first time thru it just uses the default division to show the list of Team values. Any ideas what I am doing wrong? The parameter list is in this order... div, delimiter, output, team, team output. Thank you.
 
Is this a Reporting Services report, or are you using the .rdl design within Visual Studio itself to create a report for the ReportViewer control?
 
I don't do a ton in the VS .rdl's, but try a call to YourReportViewer.LocalReport.Refresh() or YourReportViewer.RefreshReport().
 
Try not using a default value for the division

that will prompt the user to select a division which should then force the Team parameter to refresh

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top