Help Needed in Creation of Report with Changing Fields

[dbielenda]

I have a report that goes like this:

Field Desc Comparison Qty
------ -------- --------------
If {tablename.QOHB} if {tablename.QOHB} tablename.field
<> {@Comparison Qty} <> {@Comparison Qty} +tablename.field
then &quot;QOHB&quot; then &quot;On Hand&quot; +tablename.field

Then I need this to change to:

Field Desc Comparison Qty
------ -------- ---------------
if {tablename.QALCB} if {tablename.QALCB} sum(tabelename.
<> {@Comparison Qty} <> {@Comparison Qty} field+tablename.
then &quot;QALCB&quot; then &quot;Order Deatils&quot; field)

How do I get both of these to be on my report when fields and formulas are changing?

Any suggestions would be a great help. Thank you s-)

 

[dgillz]

The way this displays after you posted it os not too clear. Can you clarify at all? Maybe repost with the formulas in rows instead of columns? Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[dbielenda]

I am so sorry dgillz.. here is the report once again:

Field - If {tablename.QOHB}<>{@Comparison Qty} then &quot;QOHB&quot;

Desc - if {tablename.QOHB}<>{@Comparison Qty} then &quot;On Hand&quot;

Comparison Qty - tablename.field + tablename.field +tablename.field

NEW SECTION:

Field - If {tablename.QALCB}<>{@Comparison Qty} then &quot;QALCB&quot;

Desc - if {tablename.QALCB}<>{@Comparison Qty} then &quot;Order Details&quot;

Comparison Qty - sum(tablename.field + tablename.field)

Is this bit clearer now? THE QUESTION AGAIN: How do I get both of these to be on my report when fields and formulas are changing, yet the headers (Field, Desc, and Comparison Qty) are the same?

Hope this clarifies it a bit better s-)

 

[dbielenda]

I am still having this issue, does anyone have a solution? Thank you! s-)

 

[dgillz]

Are you saying that you have 2 groups and you want the header section to read differently depending on the group? If so create formulas to make the labels a different value as the group changes.

If that is not what you are trying to do please elaborate. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[kenhamady]

Sorry, I read the question twice and I still don't understand. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com