General discussion

Locked

Programming in Crystal Reports 8.5

By dave.grasman ·
I have designed a query in Crystal Reports that returns the following information

1 2 3 4 5 6
101 431 KP 980 982 350.00
101 431 KP 980 982 500.00

The first row represents column numbers.What I want is for the query to return the same infomation like this

1 2 3 4 5 6
101 KP 980 982 350.00
431 KP 980 982 350.00
101 KP 980 982 500.00
431 KP 980 982 500.00

Can anyone suggest how I can accomplish this? My query selects the records as follows

{FDM_TRANSACTION_DETAILS.FUND_TYPE} = {?Fund Type} and
{FDM_TRANSACTION_DETAILS.FUND} = {?Fund} and
{FDM_TRANSACTION_DETAILS.SUB_FUND} = {?Sub Fund} and
{FDM_TRANSACTION_DETAILS.FISCAL_YR} = {?Fiscal Year} and
{FDM_TRANSACTION_DETAILS.FISCAL_MO} <= {?Fiscal Month} and
({FDM_TRANSACTION_DETAILS.ACCT_1_DR_ACCT} in "040" to "999999" or
{FDM_TRANSACTION_DETAILS.ACCT_1_CR_ACCT} in "040" to "999999")

Thanks

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by SparkieIT In reply to Programming in Crystal Re ...

My apologies if I am over simplifing this, but couldn't you just:

1) Expand the detail section of the data row to be twice its current height.

2) Copy the second field ("431") down under the first field ("101")

3) Create duplicate fields for the remaining to make it look like the "KP", "980", "982" and "500.00" are really a seperate record?

I think that would have the same result.

Collapse -

by dave.grasman In reply to

I want to do it without copying fields or creating duplicate fields. I want to create a third field based on the first and second fields. I want the query to select each record twice and then eliminate the value in column 2 for the first record and eliminate the value in column 1 for the second record. The end result would be

1 2 3 4 5 6 7
101 KP 980 982 350.00
431 KP 980 982 350.00
101 KP 980 982 500.00
431 KP 980 982 500.00

Collapse -

by SparkieIT In reply to Programming in Crystal Re ...

In that case, I think you would need to modify your query outside of Crystal. For example, in Access create two seperate queries - one where the 101 value is the first field, and one where the 431 value is the first field. Then create a third query and append the two together.

It isn't really pretty, but ideally if the data corresponds in this manner it should be normalized in the data structure.

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Forums