making my own summary table

[mirror152]

I'd like to create something like a cross tab but a cross tab won't work because I want to count summary fields. Right now, I have formulas that count the information that I need but I am having trouble displaying it in a grid. Ideally I would insert a table and then just display the variable contents in the table fields. I'm not finding any way, however, of doing that. Any suggestions.

And, I know the easiest thing to do would be to simply export the data to excel and do a pivot table there. I'm trying to avoind that one as I'm not going to be the one running the report and would prefer to keep as few steps as possible to get the product that I need.

 

[CoSpringsGuy]

Will this 'table' always have the same number of rows and columns or do you want it to shrink and expand based on the data brought back from the results?

and just curious ... why cant you count summary fields?

_____________________________________
Not the brightest
Crystal Reports XI Developer Version
user in the world........

 

[Madawc]

Crosstable create their own summary fields. Depending on yours crystal version, it may be possible to create a crosstab based on some sort of formula field. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

If you need to show data as both details and a totals grid, and can't use a crosstab, consider a subreport in the report footer.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

What is your version? You could return the summaries from a command so that you could then summarize the "summaries" in a crosstab.

-LB