Summary Operation Order

[Ronald Anusiewicz]

I've just spent about 4 hours trying to make a summary report work. My design goal is to have a space after every 10th record.

I made a report using a filter and order defined in the report. The report worked correctly, but I was not getting a space after every 10th record. I was but I believe the count included the records that did not match the filter.

So then I decided to create a summary operation and design a report using the summary table. My dilemma is that the summary operation does not populate the table even though there are valid records. The same code used in the report filter works. Moving the code to the summary operation does not. No error messages, just a blank table.

The one thing I noticed looking at the XB code, the order is defined, but not by me. And no where can I find a place to define the order. What am I missing??

[G Gabriel]

Re: Summary Operation Order

My design goal is to have a space after every 10th record.

Is this what you are looking for?

[Tom Cone Jr]

Re: Summary Operation Order

[ cancelled ]

-- tom

[ken doucet]

Re: Summary Operation Order

Is this what you are looking for?

Gabe, I went to the thread but there were no attachments there that had your solution. Any chance of getting it so I can see how you resolved it?

Thanks

Ken

[Ronald Anusiewicz]

Re: Summary Operation Order

Thanks Gabe.

I'll take a look later as I'm short on time right now.

I was using the technic on Dr. Wayne's site which worked fine with a summary table.

My real problem right now is that I can't create a summary table using the summary operation. Additionally, I can't set the order of the summary table and the underlying XB has an order that can not be changed.

I'm not sure if the order is the cause of the summary operation to fail.

When I run the operation, the filter works as I get a message box which tells how many records will be summarized. As I change the value of the filter variable, the number of records to be summarized changes. When the operation is completed, the summary table opens with no records. And there are definitely valid records that should be summarized.

Looking at my screen shot, there is no where that I can see to change the order of the summary table.

[Stan Mathews]

Re: Summary Operation Order

Looking at my screen shot, there is no where that I can see to change the order of the summary table.

Intrinsic to the summary operation is the assumption that if your first order grouping is by "Alphaid" then you want the records ordered by "Alphaid", etc. Are you having trouble re-ordering the summary table after it is created or are you still having issues with running the summary?

[G Gabriel]

Re: Summary Operation Order

Ron:
I thought you resorted to the summary operation as a work around, which I don't think you need, nonethless, in Summary operation, the order is the order of the grouping and it is by default ascending.

For example, if you group by F_Name then by L_name, that's what the order will be and it will be in ascending order.

So, if you want to change the order, change the order of the grouping.

What if you want to do it in Descending?
Hmmm.. take a guess!

Incidently, I don't have that attachment. Perhaps somebody else does. I am sure Cheryl does.

[G Gabriel]

Re: Summary Operation Order

When the operation is completed, the summary table opens with no records. And there are definitely valid records that should be summarized.

Is vyear a global variable?

[Cheryl Lemire]

Re: Summary Operation Order

Gabe,

I am sure Cheryl does.

Is that your way of saying that I am a pack rat? That thread was from more than a year ago. I will go look on my old computer to see if I still have your zip.

However, I did detail in the thread what was done in the zip in order to get the desired results.

[Cheryl Lemire]

Re: Summary Operation Order

Ken,

I am sorry, but I cannot get my old computer to stay booted long enough for me to search the files (hence my 'old' computer).

Please read further down in that thread, I explain what we did. In simpler terms, open your report in design mode, create a calculated field:

blank = if(mod(run_count(Serial_Num,GRP->Model),10)=0,crlf(2),"")

In my case the calculation was based on my field name of serial_num in my model group of the report. You would have to modify the field name and group to match your needs.

Then all we did was add an 'rtf' object to my report at the end of the detail line (far right). After every tenth record, the blank calculated field adds a blank line.

Hope that helps.

[ken doucet]

Re: Summary Operation Order

Ken,

I am sorry, but I cannot get my old computer to stay booted long enough for me to search the files (hence my 'old' computer).

Please read further down in that thread, I explain what we did. In simpler terms, open your report in design mode, create a calculated field:

blank = if(mod(run_count(Serial_Num,GRP->Model),10)=0,crlf(2),"")

In my case the calculation was based on my field name of serial_num in my model group of the report. You would have to modify the field name and group to match your needs.

Then all we did was add an 'rtf' object to my report at the end of the detail line (far right). After every tenth record, the blank calculated field adds a blank line.

Hope that helps.

Thanks Cheryl, I appreciate the effort and have copied this code to my evernote folder so I don't lose it.

Ken

[Ronald Anusiewicz]

Re: Summary Operation Order

Thanks all.

After a good nights sleep, I figured out the order question within a minute. Duh!!!!

I can't get the summary to work because of the filter. I'm trying to run the summary operation on a set with part of the filter from the parent and part of the filter from the child. I did this to have a table with all valid records. Then using the expression in the group break, int(mrecno()/10-.01), I'd get a space after every 10th record. But I can't get the summary operation to work.

I've tried placing the filter expression in the report which works just fine. The problem then is that the expression int(mrecno()/10-.01) seems to be counting the records that do not match the filter along with the filtered records. Hence, the spaces are all over the place.

Gabe, I will take a look at your suggestion in a few minutes. But if it counts all the records, it probably won't work either. And yes, vyear is a global variable. I did try putting a fixed value and that did not work either.

[Cheryl Lemire]

Re: Summary Operation Order

Hi Ron,

What is your filter? Do you have group breaks? Look at the expression I posted earlier and see if you can change yours to run the count on the field that you need.

Good luck

[G Gabriel]

Re: Summary Operation Order

I was too lazy to re-do the zip file, but here it is.

[Ronald Anusiewicz]

Re: Summary Operation Order

Thanks all,

I was having a bad time getting things to work, so I just walked away.
When I came back, I started with a new report.

Thank you Gabe for your solution of placing a calculated field in an RTF object. I think it's the best solution I've seen yet to add blank lines. It's easy and it gives me the greatest amount of control.

blank = if(mod(run_count(Name_of_Field_to_Count_IN_Report),10)=0,crlf(2),"")

In this case, my report does not have any details, just a footer for the group break. In the footer are fields, one which totals the amount donated by the group.

Thanks,

Ron