Search results for query: *

Hey everybody, I have a report that has three levels of grouping, level two and three are suppressed. The end-user wants the report to be sorted based on a formula in the last grouping level, but I haven't found a way to do that yet. Any ideas (possibly using a formula as the group sort...

Wow LB, thanks so much for that solution. It worked like a charm! Madawc, thanks for your help as well. Now to look up how it works. Thanks again, Cheers!

I need some help with this report: Background: There are electronic documents we have in our company that list each training a person receives. I've created a report for this already, it shows the different people trained on a particular subject and it's grouped by that subject. Good. But I...

Thanks everybody, I was able to pull this off. Attached is a link to the report definition if it helps anybody. A different grouping was made for weeks, months, and quarters. Formula @workdays in the attached text was used for the subreport that showed weeks. I created a formula that...

The report shows how many average days it takes for a workflow to go from open to closed status in our document management system. This is reported per week, but should also show monthly averages and quarterly averages. I've managed to get the weekly averages so far. I've done a grouping for...

Hey all, Can someone tell me how to count records that reset on a group without a running total? The running total I have works well, but I can't pull the formula that includes it into a cross-tab to display averages. The report has a Month grouping, and a week grouping. For this particular...

Wow, this worked great! Thanks lbass!

Thanks lbass, I hope the following information is what you were asking for. I've also uploaded a sample of the first page of the report (.pdf) given to me by the requesting department. Row #1 Name: ARSLMFIL_SQL.slspsn_no (String) Row #2 Name: ARSLMFIL_SQL.slspsn_name (String) Row #3 Name: @...

Thanks lbass, You are correct, the sum of a particular row should be greater than or equal to 30 to display. There are several rows in this report, but the one that is most important is @Order# The summarized field is @qty sold The column name is {OELINHST_SQL.item_no} and can be one of the...

I've seen some topics on how to filter out records in a cross tab report, but have had no success. I am trying to do something similar to this: http://www.tek-tips.com/viewthread.cfm?qid=1619621&page=1 I have a cross tab report that I would like to remove entire rows if the sum of the column...