Chart Per Week Display in Crystal Reports 1

[elansienna]

Help! I am designing a report using Crystal XI with an SQL Server 2000 datamart on the backend. My task is to produce a report that captures data for a given month and the requirements are to display a separate chart for each week of data. The layout is two charts side-by-side per section. Is there an easier way to do this? My initial thoughts are to create four reports representing each week of data and combine into one report, but this will not work as this report will eventually become a subreport. Can I prehaps create a formula that will extract from the result set one week of data and use that formula in the chart creation -- for all records based on that formula? If so, does anyone have a cleaver alogorithm that I can use to pull the weeks out seperately? Am I making this harder than it really is? Any assistance will be greatly appreciately as I have been pondering over this for a while.

 

[lbass]

Insert a group on {table.date} and choose print on change of month. Insert a second group on the same field, only selecting print on change of week. Place the chart in the group header section, and suppress the detail section and group footer. Then go to the section expert->details->format with multiple columns->layout tab->width: 4 (or something like that)->gap: .5 (or so)->check across then down->check format groups with multiple columns.

-LB

 

[elansienna]

lbass, this is excellent! I tried it and it worked wonderfully. However, I went back to do some make some changes change the page layout to landscape, changed my chart around and now I only have a single column, not the double column as it was initially. I followed your directions once more and for some reason now I can't get the multi column to work. Any suggestions?

 

[lbass]

Play with the width and gap in the layout tab in the section expert. The dimensions have to work in order to force the multiple columns. There has to be room for your chart width x 2 plus the gap.

-LB

 

[elansienna]

Cool, thanks for your help and quick response!