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.
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.
I got a suggestion from one instructer to avoid subreports by creating multiple detail sections, formatting each differently,
and suppressing all but one according to the parameter
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 # of labels Across
the page, when i selected Avery 5160, it has default three columns but in 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.
Please let me know, if possible how can I have a single report prompting multiple label types.
They want to choose from Avery 5160, Avery 5162, Avery 5260 and Avery 5261.
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.
I got a suggestion from one instructer to avoid subreports by creating multiple detail sections, formatting each differently,
and suppressing all but one according to the parameter
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 # of labels Across
the page, when i selected Avery 5160, it has default three columns but in 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.
Please let me know, if possible how can I have a single report prompting multiple label types.