Can't Insert a New Group

[Sweetworks]

Hello.

Crystal 8.5, Oracle 8.1.7.4.1
Ok, I just had a question resovled to catagorize a customer as New, Renew, or Decline based off of a Current Periods Invoiced Sales vs a Prior Period (CP vs. PP). See post "Embedded In then, else not working" or copy the Link here for details.

http://www.tek-tips.com/viewthread.cfm?SQID=829872&SPID=767&page=1

Anyway, I have that formla working, and I wanted to group by it.

Currently I have 3 Groups.
Group 1 - Sales Rep
Group 2 - Catalog (Spring Catalog, Holiday Catalog)
Group 3 - Customer_ID

I want to insert my @Type formula as a Group and move the current group 3 "Customer_ID" down to group 4.

When I go to > Insert > Group and click the drop down box to find @Type, it is not an available selection.

What am I missing?

 

[Katy44]

I've had this, and it seems to just be hit and miss as to whether it is displayed or not. Is the @type formula field displayed on your report? If not, put it on your report, as then it may appear. Also try closing and re-opening Crystal.

 

[kchaudhry]

Place your formula @Type anywhere on the report canvas. Then try to insert group and you should be able to see it under the "report fields".

Hope this helps!

Kchaudhry

 

[Sweetworks]

Thanks for the suggestions, but is still isn't inserting.

I had it appearing in Details (Which is suppressed) and on the Group 3 Footer. I removed it from Both, Saved and exited the file. I opened it back up, put @type back in Details and GF3, went to insert the group, but it still isn't there. I then saved and closed the report and re-opened it, and still can't insert. I then closed crystal down and re-opened the report, but it still didn't work.

If shutting my PC down will help, I'll try it, but I don't think that would work.

Any Further Suggestions?

 

[Katy44]

Are you sure it's not there in your report fields?

 

[Katy44]

I ended up deleting the formul field and recreating it. Whether it had been there all along and I just hadn't spotted it, or whether that did something, but it seemed to work.

 

[kchaudhry]

Are you trying to insert a group on the formula or summary of a formula?

Kchaudhry

 

[Sweetworks]

Here is my Formula for @Type
__________________________________________
whileprintingrecords;
IF (Sum ({@CP Invoiced}, {CUSTOMER.ID}) = 0 and Sum ({@PP Invoiced}, {CUSTOMER.ID}) = 0) then 'DECLINE' else
IF (Sum ({@CP Invoiced}, {CUSTOMER.ID}) = 0 and Sum ({@PP Invoiced}, {CUSTOMER.ID}) > 0) then 'DECLINE' else
IF (Sum ({@CP Invoiced}, {CUSTOMER.ID}) > 0 and Sum ({@PP Invoiced}, {CUSTOMER.ID}) = 0) then 'NEW' else 'RENEW'
___________________________

I guess it is a formula of the summary's (Sum ({@CP Invoiced}, {CUSTOMER.ID}).

Does crystal not allow groups of summary's

 

[kchaudhry]

Unfortunately as soon as you have a summary referenced in a formula you would not see this formula in the "report fields" for creating a group.

There might a work around but I am not familiar with it. Maybe someone else can help you with this.

Good Luck!

Kchaudhry

 

[Sweetworks]

Would it get messed up if I redo the @type formula,
Create teh Group, then Put it back?

WTF, I'll give it a shot.

 

[Sweetworks]

Well, It worked to get the Group in, but now the report doesn't work when I put the Summed info Back.

Any other Suggestions? Maybe I rework my @type Formula, or organize it a different way.

I'm at wits end. Any Suggestions?

 

[chelseatech]

I've come into this one late, but can see the cause of your problem and have an answer for you.

Your "@type" formula is WhilePrintingRecords and includes summary functions. This is processed after the groups are created. You can't group by a "WhilePrintingRecords" formula.

However, what you can do to get the correct sequence in the report is to use the Sort function inside the TopN Group Sort Expert. You probably can't use your @Type formula here either, but you can get close by calculating a number that runs in parallel with @type.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm