Crystal XI - New page to display list of data contained in main report 2

[ReillyC]

I have a report where I group data by product type.
For example,
Model No: 123699
Location: USA
Order from: Portugal


Model No: 563336
Location: USA
Order from: China

Model No: 8696633
Location: France
Order from: Italy



I want to have a separate page preferably the last page where I can list the models only.
Is this possible without creating a subreport?

Thanks for your help in advance.

 

[GJParker]

if all you want is a simple list of models then use a formula to build a string for display at the end i.e.

//@BuildString -place in GH1 suppressed
WhilePrintingRecords;
Shared StringVar strModels := strModels & chr(13) & {MyTable.Model};

//@Display - Place in Report footer, set to can grow
WhilePrintingRecords;
Shared StringVar strModels;

Gary Parker
MIS Data Analyst
Manchester, England

 

[lbass]

You could just insert a crosstab that uses Model as the row, and then max of Model as the summary. You could then suppress either the label or the summary and remove the grid.

-LB

 

[ReillyC]

GJParker Thanks for the tip. It works. But I actually ended up using Lbass' suggestion.

Thanks for your time.

Cheers!!

 

[ReillyC]

I wonder if I could trouble you one more time. Using lbass'suggestion, is there any way to number each model.
For example,
1. Model No: 123699
2. Model No: 563336
3. Model No: 8696633

Thanks for your help yet again.

 

[lbass]

Please see thread149-1130706.

-LB

 

[ReillyC]

Oh my that works beautifully. One small question how do I get the sequence of numbers as whole numbers rather than with digital

Currently
1.00
2.00
3.00

Desired
1
2
3

Thanks! Thanks!

 

[ReillyC]

Duh never mind. I used format field. Sorry for bothering.