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