Avatar of Dave Roger
Dave Roger
Flag for United States of America asked on

Crystal Report list parameters in main header that is fed into sub report

I have a sub report that user feeds in region, skills and certifications.  Skills and Certification parameter are set to multi value  to a sub report.  Main report uses two views that join to the skills and certification multi value  parameters.  Those two parameter values are numeric ID but it has description names.  I'm trying to set up a global variable that is created in sub report that captures the skills the user selected and / or certification user has selected and in the main report have those selections outputted to the top of the main report.  Any assistance would be appreciated.
Crystal Reports

Avatar of undefined
Last Comment
Dave Roger

8/22/2022 - Mon
Mike McCracken

If I understand what you want to do, you would have to put the subreport into the report header.

Subreports are run v ery late in the report creation process so the only way to get the subreport results into another section is if the section appears after the subreport.

mlmcc
Dave Roger

ASKER
After discussion with Business Analyst, it's ok to have skills listed at the bottom of report.  After some research, I need to create a global variable and then another formula variable that captures unique skills the user has selected and then create another variable that outputs the latest variable.  I believe there is an afterevaluate function.
Dave Roger

ASKER
I mention the afterevaluate because it's ok to have results after the sub report.  My Question is still open.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
SOLUTION
Mike McCracken

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Dave Roger

ASKER
I tried your suggestion and no values came back on report.   I created three formulas and 1st on main report with your code and then I went to sub report and created another formula and placed it in details which is suppressed and then back to main report and created third formula to place it in page footer on main report.
Mike McCracken

Try unsuppressing the sub detail section.  Suppressing a section sometimes causes the formula to not evaluate

mlmcc
SOLUTION
James0628

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Dave Roger

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Dave Roger

ASKER
Thanks again guys.  It looks like your solutions would have worked too..  We ended up using the SQL stored procedure to do the heavy lifting and have it return the values we need as a single, simpler variable.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.