CRXI Crosstab

[fwatanabe]

Hi there,
I am using CRXI against a Postgres database.
In my report, I have a crosstab with several groups. Is there a way to show each group on every row?

Right now my output looks like this:
Country  Province  City
                   City
         Province  City
                   City

And the requirement is this:
Country  Province  City
Country  Province  City
Country  Province  City
Country  Province  City

Is there a way to do this?
Thanks in advance,
Amy

 

[Tatertot45]

I had to write a crosstab like this with Customer names, but when i grouped in the crosstab, all 15 "Jones Grocery" grouped together. I simply wrote a little formula that concatenated the fields into one. It was easy with not a lot of fuss.

Good luck.

 

[lbass]

Yes, you can either concatenate the fields and use the result as your only row, or you could reorder the rows:

city->province->country

-LB