Prompting a Label Dynamically in a Single report.

[khan007]

I have a problem with labels. User wants only one report and wants to allow label type as parameters. They want to choose from Avery 5160, Avery 5162, Avery 5260 and Avery 5261. Please let me know, if possible how can I have a single report prompting multiple label types.

 

[synapsevampire]

I think that you'll need to use multiple subreports, one with each formay in separate sections (right click the report footer and select insert section below) with the different label formats to accomplish this.

Then you would suppress the various sections (right click each section->format section->X 2 next to Suppress) based on the parameter choices made (preload the different choices), as in:

{?lblparm} <> &quot;Avery 5160&quot;

With each having it's respective choices.

The above would allow the subreport containing the 5160 format to be the only subreport firing.

-k

 

[khan007]

Thanks for replying so fast.

I was thinking of creating four sub reports.
Initially in each subreport I need to go to fromat section and Format with multiple colums and set the layout of each type.
In main report calling four different sub reports with each label type in four detail sections.
Then in main report use a formula based on user parameter to supress other three.

Your logic was almost similar to mine.
Thanks a lot
Really appreciate.

 

[IdoMillet]

You may be able to avoid subreports by creating multiple detail sections, formatting each differently, and suppressing all but one according to the parameter.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[khan007]

Hi Idomillet,

Thanks a lot.

When I tried to use multiple detail sections, the Format with multiple columns option is disabled, (even not appeared.)So it means I cannot Format different detail sections in one report, second it doesn't have a option to show # label Across the page, when i selected Avery 5160, it has default three columns but it my report only two appears.

I faced the same problem with subreports too. it is showing two columns in Avery 5160, which has basically three.

Any Comments...
PLease

Thanks

Masood Khan