Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ontu78
-
grouping formula
Hello Ian and Lbass, I took both of your suggestions. Here is what I did: - Used the following SQL: select BU as "Entity", 'A' as "Type",Affiliate as "Entity2", Amount from Mytable union select Affiliate as "Entity", 'B' as "Type", BU as "Entity2", Amount from Mytable This results in the...- ontu78
- Post #7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
grouping formula
Thanks for your suggestion. The Bus Unit and Affiate values are actually characters ( as in GL01, GL02 etc). I'm somewhat confused as to how creating a formula field at the detail section and grouping by it, can enable the opposite Bus Unit/Affiliate to follow each other and calculate the...- ontu78
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
grouping formula
Hello, We are currently in the process of designing a report from a table that has the following sample data Bus Unit Affiliate Amount ----------- ---------- ------------ 01 02 2500 01 03 2330 01...- ontu78
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 1 Formulas
