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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can I have crosstab type reporting while linking on a formula field?
Would I not lose the dollars that did not have a corresponding count if count was the main report? The table.dollars date is a date The table.count date is a string [6] We are in a db2 environment.- lydarose
- Post #5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Can I have crosstab type reporting while linking on a formula field?
I tried creating a shared variable, but I could never get that to work. Based on a reply you posted to another thread, I created a formula field on a report with the Table.Dollars to make the Date YYYYMM format and added a subreport to get the information from the Table.Counts. That exports a...- lydarose
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Can I have crosstab type reporting while linking on a formula field?
I have one table with dollar amounts and mmddyyyy dates broken out by grouping and class. TableDollars for example: Date grouping class amount 01192010 12345 abc 987.54 01072010 23456 abc 361.87 12152009 23456 xyz...- lydarose
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 2 Data Access
