Search found 3 matches
- Sun Mar 07, 2021 7:14 am
- Forum: Report Workshop
- Topic: Cross tabulation table with day of week as header
- Replies: 8
- Views: 95241
Re: Cross tabulation table with day of week as header
Thank you for all the information. I'll take a look at the film demo. My project uses a Paradox database accessed with BDE, and the SQL for BDE is limited. Instead of DATEPART I can use EXTRACT, like this: EXTRACT(month from TimeOfSale) EXTRACT(hour from TimeOfSale) But there is no EXTRACT(weekday ...
- Fri Mar 05, 2021 9:17 am
- Forum: Report Workshop
- Topic: Cross tabulation table with day of week as header
- Replies: 8
- Views: 95241
Re: Cross tabulation table with day of week as header
I suppose I will have to create a temporary database table where the DateTime field has been separated into several other fields that can be used for different crosstabs: Year, Month, Day, Hour, Monthname, WeekdayName.... That way values for all Mondays in January can be summed up, correct? I attach ...
- Thu Mar 04, 2021 1:56 pm
- Forum: Report Workshop
- Topic: Cross tabulation table with day of week as header
- Replies: 8
- Views: 95241
Cross tabulation table with day of week as header
Hi, I've been playing around with your ReportEditor demo, reading online help and watching videos. The component seems great and like what we are looking for. There's one thing I haven't figured out how to do, below is a simplified example. Fields marked with a * are part of the primary key Master ...