question

IsmailCassiem-3967 avatar image
0 Votes"
IsmailCassiem-3967 asked IsmailCassiem-3967 answered

SSRS Landscape Template of Roughly 17 Measures thats fits within margins

Good day,

I am replacing a static excel pivot file with a more interesting and nicer ssrs report
The catch i have is that it has roughly 17 measures and to fit into landscape page width

Does anyone have a template rdl to share that is very modern nice with landscape +/-17 measures that fits within page width?
Below is the excel static im looking to modernise with ssrs and looking to add a few more measures

Please Help & Share, something modern or any ideas please. Thank You

125343-variancetemplate.png


sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @IsmailCassiem-3967 ,
I have checked the snapshot you have provided and if you want to create an similar report in the SSRS,first you need to create data in the database, and then you need to create Matrix or Table in SSRS. You can use SUM(), IIF() functions to achieve certain values, or you can also do calculations in SQL queries.

But I believe that no one can provide you with a template that is completely suitable for you, because it depends entirely on your data and your needs. If you have a deep understanding of SSRS, you will understand that you may need to learn how to create datasets and data sources from the very beginning.

Here I will provide some tutorials for your reference:
Reporting Services Tutorials (SSRS)
Create a Basic Table Report (SSRS Tutorial)
Tables, Matrices, and Lists (Report Builder and SSRS)
Hope this helps.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

IsmailCassiem-3967 avatar image
0 Votes"
IsmailCassiem-3967 answered

Hi, Thank You

i think what i was looking for is modern design "pic" on how to fit in 20measures
i will play with landscape setting but I'm not sure if the static file is already not too busy and i need to add additional 6 measures.

I know SSRS, no expert but im looking more for modern setup that interests users and not cause more confusion

Any ideas please?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.