data in the report

[Former Member]

hi,

I have the following data in the table

Account_Num Payment_type

TEST0001 Credit Card

TEST0001 Auto Debit

TEST0001 EFT

TEST0001 Credit Card

TEST0001 Cash

TEST0001 Auto Debit

ACC00000016 Credit Card

ACC00000016 Auto Debit

ACC00000016 EFT

ACC00000016 Credit Card

ACC00000016 Cash

ACC00000016 Auto Debit

ACC00000017 EFT

ACC00000017 Credit Card

ACC00000017 Auto Debit

ACC00000017 EFT

ACC00000017 Credit Card

ACC00000017 Cash

ACC00000017 Auto Debit

in the report data look like,

accountno cash eft autodebit credit

ACC00000017 1 2 2 2

ACC00000016 1 1 2 2

TEST0001 1 1 2 2

for each accountnum how many payments has been occured their count.

please can provide solution,appreciate u r solution.

thanks

sekhar

[Former Member · Accepted solution]

Hi,

Here is a solution which you can use without any updates in the universe.

You can run a query with or without retrieving duplicate rows. In this case you want to retrieve duplicate rows.

The initial table BO will show are the unique combinations of Account_Num and Payment_type.

Add an additional column to that table and in that column put:

=RowIndex()

Now you have all the rows retrieved. Put a break on Account_Num and on Payment_type.

In the footer of the column with RowIndex put a count on the RowIndex.

Next define this count as a variable and evaluate the formula in its context.

Now create a crosstab with the Account_Num in the rows, Payment_type in the columns and the just created variable in the block.

This should give you the required result.

Good luck,

Harry

[Former Member · Accepted solution]

Hi Harry,

As provided solution by you was fine, it was helped me to format report.

I was thankful and appreciate your solution.

regards

sekhar