Crosstab - Colum heading interval (v7)

This public forum is for user-to-user discussions of PHP Report Maker. Note that this is not support forum.

Crosstab - Colum heading interval (v7)

Postby Fvs44 » Tue Feb 13, 2018 4:42 pm

Hello,

I'm using PHP report maker v7 with a MSQLServer database.
I want to create to charts with the field "Date" (which is a datetime on MSQL database) as column heading, but I'm not available to choose an interval (the listbox is greyed out).

Also, when I choose a date filter for the chart, the queries for MSQLServer looks like "SELECT DISTINCT [Date] FROM [View1] WHERE (([Date] = "2018") AND ([Machine Nb] = 'XYZ')) ORDER BY [Date] ASC" which returns nothing as Date = 2018 cannot exists.
The query should be something like "SELECT DISTINCT [Date] FROM [View1] WHERE ((YEAR([Date]) = "2018") AND ([Machine Nb] = 'XYZ')) ORDER BY [Date] ASC".
I don't find where to modify it in the template.

Some help would be helpful, thanks.
Fvs44
 
Posts: 4
Joined: Wed Jan 17, 2018 12:10 am

Re: Crosstab - Colum heading interval (v7)

Postby Webmaster » Wed Feb 14, 2018 11:11 am

It should work. v7 is probably too old. Try newer versions (the current version is PHP Report Maker 11).
Webmaster
 
Posts: 10790
Joined: Fri Aug 06, 2004 5:59 pm


Return to General Discussion (PHP Report Maker)