Grouping Question 3

[Myla944]

Hello,

When you want to add a second group, with the same product does it always show up right underneath your first group? Example

1st Group Reg
2nd Group Reg
1st Group Qtr
2nd Group Qtr

I wanted to add another group but not directly underneath the first group. I wanted it to look like this:

Reg
Qtr
BM

Reg
Qtr
BM

Can Crystal Group this way (like example right above this)? Or would I have to add a sub-report? Also if I have a parameter field, will this field work on the sub-report as well or do I need to make a parameter field for the sub-report as well?

Thank you and have a great day today!

Sincerely,
Myla

 

[pgtek]

hi
Create a sub report and inseted in the group footer

cheers

pg

pgtek

 

[Myla944]

Thanks. When I create a sub-report, would the parameter from the 1st report affect the sub-report? Or can I create a parameter field for the sub-report as well?


Sincerely,

Myla

 

[synapsevampire]

I've no idea how anyone can accurately advise you as your post doesn't supply any technical information.

Try supplying the basics:

Crystaal version
Database/connectivity used
Example data (real world examples of the datqa being returned)
Expected output

Why would you show another grouping of the exact same information?

Grouping is a hierarchy, so if you want something grouped, and then a seperate summary based on that value, then a subreport MIGHT be in order.

-k

-k

 

[synapsevampire]

And yes, a subreport can have a different parameter, but if you're linking to the main report, I'm not sure why you wqould want this.

Please provide some technical info.

-k

 

[Myla944]

Crystal Reports 9, SQL Database

I have to have the same information shown again because one section is for manufactured dozens of buns:

WE 4/3 WE 3/27 QTD YTD

REG 52,500 25,400 77,900 105,500
QTR ETC ETC

Second group (or sub-report) needs to show dozens sold of buns:

WE 4/3 WE 3/27 QTD YTD
REG
QTR

3RD Section needs to show percentages sold of each product with the same format as above. My supervisor wants it to resemeble the current workbook that I created in Excel.

I am sorry for not being more precise with what I am using and what database I am in. I was just asking a question in general. I did not know that I always need to show this information whenever I ask a question. I will remember that in the future.
The parameter I made for the 1st group (manufactured dozens) uses a week ending date that reads Saturday's date. The dozens sold uses a Monday date which is when it is billed and I cannot get the parameter to read the dozens sold table date too, so I thought I would create another parameter, since I am not very fluent in Crystal yet and I am having to figure this program out without any help except from this site.

Again sorry for not being more specific.

Sincerely,
Myla

 

[pgtek]

hi
yes u can use a parameter in your sub report and u can link them

cheers



pgtek

 

[Myla944]

Thank you pgtek, I shall read up on linking parameters. I have not done that yet,ahhhh (this is making me insane, hahaha).

Thank you Synaspvampire and I shall remember in the future to post what version, etc.

Have a great day and thanks for all your help.

Sincerely,
Myla

 

[Turkbear]

Hi,
Just an added note:

If you can create a formula that returns either Manufactured
or Sold you can use this as your first group and place the data within the details.

Don't know if you data supports this, however.