i really hope you'll do more videos on Report builder. There is no where else to find training on this software, even the online course websites out there on the internet don't have material on this
Thanks! Happy to hear that you found the Report Builder videos useful! I'd like to add more videos on indicators, gauges, charts, lists, maps and working in the SSRS web portal.
Thank you for the great video ! I was wondering if there is actually a way to remove all row groupings ? I would like to export the document to excel and have no grouping on the row level
Hi, sure you can! View the Group Properties dialog for the row group, on the General page select the group expression and choose to delete it. I hope that helps!
Hi Anders! Yes, you can include as many "detail" rows within your matrix groups as you like. Right-click on the data cell in the matrix and choose Insert Row | Inside Group - Below
How do I make Genre Rows - (Action) to keep repeating it instead of 1x 'Action', it will keep populating Action repeatedly on every row. What setting is that? thanks
Hi Phillip! You can insert a new column in the Country group to do this. 1) Right-click in the cell containing [Country] 2) Choose: Insert Column | Inside Group - Left 3) Assign the [Genre] field to the new column I hope it helps!
Hi Ankit. It might be easiest to create a helper column in the dataset to calculate which date a shift should be associated with. You could check if the shift is the first shift of the day, it's shift date should be on the previous day, otherwise its shift date should be the same date. You can use the If and DateAdd functions to do this. You can then group your table or matrix using the calculated shift date column rather than the actual date. I hope that helps!
You are Great!!! Thanks For All
You're welcome, thanks for watching!
Thanks!
Thanks you for these amazing videos!
@@mmenapr You're very welcome Miguel, thanks for your support!
After a long time!!. Amazing Video. Please kindly post regularly.
you are great, explain things that I neglect before, thank you.
You're very welcome, I'm happy to hear that you found it useful!
Thanks, been super helpful
You're very welcome Nolan, happy to hear it was helpful!
Insert 21:49
If rows contains same values/text it is merging by default how to avoid.
i really hope you'll do more videos on Report builder. There is no where else to find training on this software, even the online course websites out there on the internet don't have material on this
Thanks! Happy to hear that you found the Report Builder videos useful! I'd like to add more videos on indicators, gauges, charts, lists, maps and working in the SSRS web portal.
Headers 17:30
Thank you for the great video ! I was wondering if there is actually a way to remove all row groupings ? I would like to export the document to excel and have no grouping on the row level
Hi, sure you can! View the Group Properties dialog for the row group, on the General page select the group expression and choose to delete it.
I hope that helps!
What to do if i want an average of the average value below each column of certificate?
hello,
is there any way to put many measures on rows keeping the defined groups?
thank you in advance for your answer
Regards!!
Hi Anders! Yes, you can include as many "detail" rows within your matrix groups as you like. Right-click on the data cell in the matrix and choose Insert Row | Inside Group - Below
How do I make Genre Rows - (Action) to keep repeating it instead of 1x 'Action', it will keep populating Action repeatedly on every row. What setting is that? thanks
Hi Phillip! You can insert a new column in the Country group to do this.
1) Right-click in the cell containing [Country]
2) Choose: Insert Column | Inside Group - Left
3) Assign the [Genre] field to the new column
I hope it helps!
How can i add the values of first shift on 27/5/2021 to last shift of 26/5/2021. the values are in column group by on date.
Need some help in this.
Hi Ankit. It might be easiest to create a helper column in the dataset to calculate which date a shift should be associated with. You could check if the shift is the first shift of the day, it's shift date should be on the previous day, otherwise its shift date should be the same date. You can use the If and DateAdd functions to do this. You can then group your table or matrix using the calculated shift date column rather than the actual date.
I hope that helps!
God report builder