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

Linking reports

Status
Not open for further replies.

nikol

Programmer
Apr 12, 2005
126
US
Hi,
Can I link two parameter fields in subreports?
 
Why would you link parameters within a subreport?

You can link parameters from a main report to parameters in a subreport, although you're probably better served to link (called join in Crystal) the main report parameters to the fields in the subreport so as not to have multiple parameter prompts.

-k
 
Actually, I created a report with a Parameter field_1, which has few subreports. I linked all subreports with Parameter Field_1. Now I have to add one more parameter_2 in the report. When I linked the parameter_2 in subreports,its giving me multiple Detail Sections of each report.
Any help where I'm wrong.
 
Where are the subreports?

Adding a parameter shouldn't add details sections.

Each subreport does have it's own detail section though.

-k
 
I have four subreports(already saved) as age,gender,zipcode,race.I created a dynamic prompt(Provider) on these reports which will display certain providers with their age,zipcode,race..& I linked all four subreports by Prompt(Provider). It was working fine.
Now I have add one more Dynamic Prompt(Quarter)which will give certain provider for certain quarters. So,I added a quarter prompt. & linked to just a single report age for test purposes. Its giving my 15 age report o/p.(Need only 1 report).I dont now why it is so?
I hope I explained well my problem..
Thanks for ur time.
 
Hey!
I tried to run my same report with 1 parameter field its working but when I add 2nd parameter field I get multiple detial sections like da,db,dc,da,dba,dc,da.....
I linked both the parameter columns from available fields- to -fields to link.
Still looking for help
 
I'm sorry that I don't understand.

What does "I linked both the parameter columns from available fields- to -fields to link." mean?

Parameters aren't available fields, they are separate entities, however you can prepopulate them from columns.

I would suggest that what you're getting is a subreport with multiple detail sections that is within a group to show up, but it's hard to say.

Perhaps if you described where the subreport is in the main report, and if the subreport has multiple detail sections.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top