We are trying to set a report that has grouping based not on a particluar category (mach 1, mach2, clipper, etc…), but by date. I.e. - have the report show a new group for each day, so that the end user can see how much product was weighed on a daily basis during each weighout, then a total for each day. We have the query sorted/grouped by t_stamp, but beyond that, how can we group the data by day? Any help is appreciated. Thanks
You just need to bring back that grouping as extra columns in the dataset. For example, if you want to group on month you can bring back:
SELET MONTH(t_stamp) as Month …
in your query and use the table grouping options in the report to group on Month. Hope that helps getting you started.
That was the key we were looking for. Sometimes we’re are too close to the obvious. Thank for the help.
We put in the extra column in our query: Day(t_stamp), and it comes up just fine in the data table for the query. But when we try to reference that column in the report, it either comes up as 0, or as . It’s as though that extra column is not visible to the reporting module. Is this a possibility?
Try adding “AS some_other_variable_name” after that function in your SQL query. Then verify that your new column and data exists in the dataSet. You should then be able to access it in the Report.
Nathan, we added: Day(t_stamp) AS Date. Then used Date at the grouping column. That worked out perfectly. Thanks!