July 31, 2018 at 1:19 am
I have a query that returns YearMonth as 2018-01, 2018-02, 2018-03 etc.
The report tables below are based on a dataset.
I would like the table to expand the results starting with 2018-04, 2018-05 ie April 18, May 18, etc based on sums and the expressions table.
My YearMth field is a Parent Column group in the table.
My report table columns are as:
Area YearMonth (2018-01 etc)
No. Clients [Sum(ClientNo)]
Leeds No of Places [Sum(Places)]
Night Stays [Sum(Nightstays)]
YearMonth (2018-01 etc)
Total No. Clients <expression>
No of Places <expression>
Night Stays <expression>
Does anyone know how to solve this issue.
August 2, 2018 at 6:56 am
Hi. I'm having a hard time understanding what you are asking. Perhaps others are too.
August 2, 2018 at 7:18 am
jman76 - Tuesday, July 31, 2018 1:19 AMI have a query that returns YearMonth as 2018-01, 2018-02, 2018-03 etc.
The report tables below are based on a dataset.I would like the table to expand the results starting with 2018-04, 2018-05 ie April 18, May 18, etc based on sums and the expressions table.
My YearMth field is a Parent Column group in the table.
My report table columns are as:
Area YearMonth (2018-01 etc)
No. Clients [Sum(ClientNo)]
Leeds No of Places [Sum(Places)]
Night Stays [Sum(Nightstays)]YearMonth (2018-01 etc)
Total No. Clients <expression>
No of Places <expression>
Night Stays <expression>Does anyone know how to solve this issue.
if your YearMonth were a date, then it's just a formatting issue in SSRS. Format the date as YYYY-MM
August 2, 2018 at 7:24 am
Thanks guys I have managed to fix this by joining on to a dates table.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply