My RB Comeuppance

Yahoo Archive
1
Todd, when I am faced with mult-level sorts or groups with aggregates, I
create calculated fields to combine the several fields into one -
Custnumber+PartNumber. Then I do the prepass aggregate with reset on the
calculated field. This method sometimes makes the seemingly impossible quite
easy.

Regards
Jim Stetter


-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, January 25, 2001 9:49 AM
To: 'vantage@egroups.com'
Subject: [Vantage] My RB Comeuppance


I thought I was getting pretty good at Report Builder until I ran across
the
following to put me in my place.

I have a report which totals job value & costs to derive margin. Sorted
and
grouped by customer and part to show total for parts (all closed jobs for
a
part) within customer (and totals for customer too). We get away with
this
because of 1-to-1 relationship of part to customer (job-shop). Everything
is fine so far. Now our VP wants parts sorted descending by margin $ (an
aggregate) - best margin part to worst within each customer. Like:
Customer
Best Part margin (aggregate of all jobs for part)
Worst part margin " " " " " "
Customer....

Because margin is a pre-pass aggregate derived value at the Part level RB
is
not allowing sorting on the resulting margin value. I can easily sort on
part margin at the top level (a different report) for all parts but not
within customer. Before I waste another day on a task that might be
impossible I thought I'ld check the experts. Seems to me I would need a
3rd
pass similar to the way I wrote this same report in COBOL for Clasic. Is
there an RB equivalent to Crystal sub-reports?

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.




[Non-text portions of this message have been removed]


eGroups Sponsor

www.




To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com





[Non-text portions of this message have been removed]
2
I thought I was getting pretty good at Report Builder until I ran across the
following to put me in my place.

I have a report which totals job value & costs to derive margin. Sorted and
grouped by customer and part to show total for parts (all closed jobs for a
part) within customer (and totals for customer too). We get away with this
because of 1-to-1 relationship of part to customer (job-shop). Everything
is fine so far. Now our VP wants parts sorted descending by margin $ (an
aggregate) - best margin part to worst within each customer. Like:
Customer
Best Part margin (aggregate of all jobs for part)
Worst part margin " " " " " "
Customer....

Because margin is a pre-pass aggregate derived value at the Part level RB is
not allowing sorting on the resulting margin value. I can easily sort on
part margin at the top level (a different report) for all parts but not
within customer. Before I waste another day on a task that might be
impossible I thought I'ld check the experts. Seems to me I would need a 3rd
pass similar to the way I wrote this same report in COBOL for Clasic. Is
there an RB equivalent to Crystal sub-reports?

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.




[Non-text portions of this message have been removed]
3
Crystal is not an option, eh?

Troy Funte
Liberty Electronics
----- Original Message -----
From: Todd Caughey
To: 'vantage@egroups.com'
Sent: Thursday, January 25, 2001 6:49 AM
Subject: [Vantage] My RB Comeuppance


I thought I was getting pretty good at Report Builder until I ran across the
following to put me in my place.

I have a report which totals job value & costs to derive margin. Sorted and
grouped by customer and part to show total for parts (all closed jobs for a
part) within customer (and totals for customer too). We get away with this
because of 1-to-1 relationship of part to customer (job-shop). Everything
is fine so far. Now our VP wants parts sorted descending by margin $ (an
aggregate) - best margin part to worst within each customer. Like:
Customer
Best Part margin (aggregate of all jobs for part)
Worst part margin " " " " " "
Customer....

Because margin is a pre-pass aggregate derived value at the Part level RB is
not allowing sorting on the resulting margin value. I can easily sort on
part margin at the top level (a different report) for all parts but not
within customer. Before I waste another day on a task that might be
impossible I thought I'ld check the experts. Seems to me I would need a 3rd
pass similar to the way I wrote this same report in COBOL for Clasic. Is
there an RB equivalent to Crystal sub-reports?

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.




[Non-text portions of this message have been removed]


eGroups Sponsor

www.




To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com





[Non-text portions of this message have been removed]
4
Would be except that they want it on the Vantage menus and I think that
would mean anyone wanting to run it would require ODBC connector ($). I
suppose I could use RB to try to create my own .dbf file and have the final
pass in a distributed Crystal report. If a future version of Progress has
better ODBC facility I would certainly consider a pure Crystal solution but
he wants the report by month-end.
-Todd C.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, January 25, 2001 11:59 AM
To: vantage@egroups.com
Subject: Re: [Vantage] My RB Comeuppance


Crystal is not an option, eh?

Troy Funte
Liberty Electronics




[Non-text portions of this message have been removed]
5
Todd,

I am not sure why you are not able to do this, but maybe I am missing
something. We have a report that is not the same as what you are doing, but
sort of similar. We group by customer and then by customer contact. The
invoice$ are totaled by customer contact and by customer. We have the
percent of total sales for each also listed, by year. we have another field
that totals the year totals for customer and customer contact and it sorts
by customer total% and then by customer contact total%. I don't know if the
calculation of the margin is perhaps the difference here?

This probably didn't help you. Sorry,

Sarah
6
What we have done as far as distributing Crystal reports is:

Decide which PC's will have ODBC. (we limited it to 11).
Have two of those PC's available for other non-ODBC users to request reports.
Compile the crystal reports in a common area on Network.
Simply place a shortcut to the compiled report on the Vantage Favorites bar.
- This is actually less mouse-clicking than going to a sub-menu in Vantage to find a RB report.

I do even the most simple reports in Crystal now because most of the people needing the reports are the five or so folks who need 90% of the reports.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Todd Caughey
To: 'vantage@egroups.com'
Sent: Thursday, January 25, 2001 7:17 AM
Subject: RE: [Vantage] My RB Comeuppance


Would be except that they want it on the Vantage menus and I think that
would mean anyone wanting to run it would require ODBC connector ($). I
suppose I could use RB to try to create my own .dbf file and have the final
pass in a distributed Crystal report. If a future version of Progress has
better ODBC facility I would certainly consider a pure Crystal solution but
he wants the report by month-end.
-Todd C.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, January 25, 2001 11:59 AM
To: vantage@egroups.com
Subject: Re: [Vantage] My RB Comeuppance


Crystal is not an option, eh?

Troy Funte
Liberty Electronics




[Non-text portions of this message have been removed]


eGroups Sponsor


www. .com




To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com





[Non-text portions of this message have been removed]