Search found 3 matches

by TPerson
Sun Mar 07, 2021 7:14 am
Forum: Report Workshop
Topic: Cross tabulation table with day of week as header
Replies: 8
Views: 63412

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 f...
by TPerson
Fri Mar 05, 2021 9:17 am
Forum: Report Workshop
Topic: Cross tabulation table with day of week as header
Replies: 8
Views: 63412

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...
by TPerson
Thu Mar 04, 2021 1:56 pm
Forum: Report Workshop
Topic: Cross tabulation table with day of week as header
Replies: 8
Views: 63412

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 t...