[BO 6.5] Show Only Summary Count on BREAK

[MJRBIM]

I have a table of transaction-activity with Date Captured and Date Completed information.

I have inserted a "Days Elapsed" variable...

=DaysBetween(<Date Created> ,<Date Complete>)

I have inserted a Break on the "Days Elapsed" variable - and a CountAll(<Transaction no>) in the footer of the Break.

This gives me all the info I want...but I only want to see the Summary Data at the Break-Footer Level.

In Crystal I would use the Suppress Detail function.

In BO-6.5 when I FOLD the table I lose my Breaks as well, and only see the whole Report Footer.

Anyone got a work around for this...?

Thanks in advance!

 

[blom0344]

I think you can solve this by using the proper context , like:

CountAll(<Transaction no>) in <Days Elapsed>

I doubt that you need to have breaks at all, but I have no BO environment to test this assumption..


Ties Blom

 

[MJRBIM]

Thanks for the suggestion...

The code sample you provided returns a "1" unless I put the <Transaction Number> in each row.

I want to show only the SUMMARY of Tranaction count by days elapsed (if possible in a single table)without showing the Transaction IDs.

EXAMPLE
=======

00 Days = 400 Transactions
01 days = 125 Transactions
02 days = 93 Transactions
etc.

 

[blom0344]

The easiest solution is to define a universe measure that performs the count, like:

count(<transaction number>) and use this instead of fetching the indiviual lines and performing a CountAll within the report. This is also more efficient if you only need the summary results. (smaller dataset)

The countAll function is meant to supplement the reporter function count which performs a distinct count.

If you cannot modify your universe, then you can try to use the count function (in the report) instead of CountAll on a composite object that is unique (if the transaction number is not)

Excuses for not being more precise, but I have no BO environment anymore to check..


Ties Blom