Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display multiple group fields across page

Status
Not open for further replies.

dninus

Programmer
Feb 8, 2012
13
US
Hi All,

I've been struggling with creating this report. Our company has 300 stores and we need to report sales everyday, WTD, MTD and Total (YTD).
Currently, we have similar reports but it display one store per page since we group by store. Therefore, it is a 300 pages report.
I need to create a report that will display 3 stores on each page.
The report should look like this.

Store1 Store2 Store3
Date TY Sales Budget LY Sales TY-LY TY Sales Budget LY Sales TY-LY TY Sales Budget LY Sales TY-LY
M Oct 1
T 2
W 3
Th 4
Fri 5
S 6
S 7
WTD
M 8
T 9
W 10
Th 11
Fri 12
S 13
S 14
WTD
.
.
.
S 28
MTD
Total

The report need to group by date, Week, and Month. I don't know how I can display 3 stores at a time on one page with it's data.
Please help!
Thank you very much!

Dninus

 
I have had to do something with benefits like this. It means a lot of formulas!

In a nutshell you have the following:

@STORE_1_WTD
IF STORE = STORE_1 THEN WTD

@STORE_2_WTD
IF STORE = STORE_2 THEN WTD

@STORE_3_WTD
IF STORE = STORE_3 THEN WTD


@STORE_1_MTD
IF STORE = STORE_1 THEN MTD

@STORE_2_MTD
IF STORE = STORE_2 THEN MTD

@STORE_3_MTD
IF STORE = STORE_3 THEN MTD


Then you can place these across as follows:

DATE STORE_1_WTD STORE_1_MTD STORE_1_TOTAL STORE_2_WTD STORE_2_MTD STORE_2_TOTAL STORE_3_WTD etc...



Hope this helps!

FireGeek
(currently using Crystal Reports XI with Lawson 9.01)
 
Thank you FireGeek for your reply.
I wasn't being very clear on the format of the report.
-----------Store1----------- --------Store2-----------------Store3--------------
Date ----- TY Sales Budget LY Sales TY-LY--------TY Sales Budget LY Sales TY-LY --------TY Sales Budget LY Sales TY-LY------
M Oct 1------ 1290 1289 1300 -.76% --------------1253 1500 1235 0% ---------------------- 2500 1999 1896 31%
T 2
W 3
Th 4
Fri 5
S 6
S 7
WTD
M 8
T 9
W 10
Th 11
Fri 12
S 13
S 14
WTD
.
.
.
S 28
MTD
Total
 
Same premise. Multiple formulas that first ask what store and then writes the TY Sales or Budget L or, Sales TY-LY

In a nutshell you have the following:

@STORE_1_TY Sales
IF STORE = STORE_1 THEN TY Sales

@STORE_2_TY Sales
IF STORE = STORE_2 THEN TY Sales

@STORE_3_TY Sales
IF STORE = STORE_3 THEN TY Sales



@STORE_1_Budget LY
IF STORE = STORE_1 THEN Budget LY

@STORE_2_Budget LY
IF STORE = STORE_2 THEN Budget LY

@STORE_3_Budget LY
IF STORE = STORE_3 THEN Budget LY


@STORE_1_Sales TY-LY
IF STORE = STORE_1 THEN Sales TY-LY

@STORE_2_Sales TY-LY
IF STORE = STORE_2 THEN Sales TY-LY

@STORE_3_Sales TY-LY
IF STORE = STORE_3 THEN Sales TY-LY


Then you can place these across as follows:

| STORE 1 | STORE 2 | STORE 3 |
DATE....TY Sales....Budget LY....Sales TY-LY....TY Sales....Budget LY....Sales TY-LY....TY Sales....Budget LY....Sales TY-LY




FireGeek
(currently using Crystal Reports XI with Lawson 9.01)
 
If you are NOT using an inserted crosstab, I think you should try formatting the detail section to "format with multiple columns" in the section expert. Then go to the format tab in the same screen and adjust the column width and gap to force three columns, check "down then across" and "format groups with multiple columns".

Also in the section expert, select the store group footer->check "print at bottom of page". This will force each new store to start at the top of a column.

-LB
 
PS. Please do not crosspost (same topic different forum).

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top