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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Group by: Date; but the date range is not there!
OK so i know next to nothing about crosstabs so i might need some help there though your explanantion sounds good. two things - 1. currentdate is completely irrelevant. 2. i assume something more than dateadd is required since these half year periods must correspond to the first or last half of...- geek15
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Group by: Date; but the date range is not there!
Modifying the database is something that would be a last resort. It is possible, but would require script, as one program - and one report - has multiple data sources that need to match. Every time a new database is created, it needs to be modified. Is there an easier way?- geek15
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Group by: Date; but the date range is not there!
I am grouping data by date in half-year sections. If a certain half-year contains no records it is left out. The situation is this: Every 6 months x percent is added to the unpaid amount on an invoice i.e. a type of interest. All payments a customer makes toward an invoice in a 6 month period...- geek15
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 4 Other topics
