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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pass static value to subreport from master

Status
Not open for further replies.

shera4111

Programmer
Apr 12, 2006
27
CA
Hi all,

I have created a subreport that has a parameter called {?Ticket Type}. It has three valid values - Change/Task/HelpDesk.

What I'd like to do is create a master report that includes three 'versions' of the subreport. The first subreport would run with
{?Ticket Type}=HelpDesk, the second with
{?Ticket Type}=Change, and the third with
{?Ticket Type}=Task

The idea here is that I don't really want to run the subreport once for each of these values - I'd rather run the master report, which would run all three as subreports.

Is there a way to pass a static value to a subreport from a master?

I know I could split the subreport into three, with static select statements, but I'd rather have one master, and one sub report, just to make maintenance easier.

Thx in advance

shera4111
 
Never mind all - wasn't thinking straight.

Put the ticket type as a group in the master report, and then linked the subreport via the normal way... removed the {?Ticket Type} parameter from the sub, used the default
{?Pm Ticket Type} linking parameter with 'Select data in subreport based on field' box checked, and it works like a charm.

Apologies for superfluous posts. Maybe someone can benefit from my lack of coffee problem this morning... :)

shera4111
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top