list groups without records 1

[VE]

I'm using CR 2008

I have been asked to create a report where each of 4 possible codes in group 2 are listed under group 1. The problem is that I don't have each record in group 2 for each record in group 1. (I hope that makes sense).

How can I get a list of all possible codes in group 2 to display under each group 1 record?


thank you
VE

 

[lbass]

To what end? How will these listed codes be used? It would be easy enough to just list them, but the question is whether you have to work with them in some way.

-LB

 

[Madawc]

If you just wanted an entry for all group 1 values, you could do a 'left outer'. Assuming they are two different tables: your explanation is unclear.

For what you seem to want, I think you'll have to use a Mock-Crosstab. If you can't add a table, you'll be stuck with creating a 'Mock Crosstab'. Crosstabs are fine if you don't mind the absence of rows or columns with no data, but you said you wanted empty slots to show.

A 'Mock Crosstab' is something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then. Crystal should have included an example along with the Crosstabs.

You can save a little time by doing a paste to a dummy report, changing the name and then pasting back. In Crystal 11.5, you can also duplicate formula fields using the Field Explorer.

Of course if all Group 1 and Group 2 values are certain to occur somewhere, a normal crosstab would show this.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[VE]

Madawc, I'm not sure I understand how a putting this in the footer would work, I will have to just do it and see.

lbass, what they want is for this report to look like their excel report:
date date date
name
code X
code
code X
name
code X
code
code
name
code
code
code

Thank you
VE

 

[lbass]

Is this intended to be a crosstab type of report with, e.g., months or years going across? If so, you should check out thread149-1567016.

-LB

 

[VE]

Yes! that cross tab challenge thread is what I needed. It didn't come up in my searches.

thank you

VE