search

fuel9 / DisplayMonkey

Display Monkey digital signage solution
Other
126 stars 50 forks source link

relation between SSRS width and Canvas size #75

Closed carntsen1 closed 5 years ago

carntsen1 commented 5 years ago

I am having difficulty figuring out the relation between SSRS report width and Defined panel size.

Example; My panel is full screen (1600x1000). I write a report that is 'normal' paper size and many columns on the right get cut off. I have to keep reducing the width (and font) until the report is only about 4" wide before it all displays on the screen.

I thought I might need to set my report page size to match the screen aspect ratio. 1600x1000 would be the same as 8" x 5". This might the output much worse

Can anyone advise how to properly size a report to the panel? Cam

carntsen1 commented 5 years ago

I should add... Crop, Stretch and Fit each fill the screen differently, but the right columns remain missing Cam

michaelmalmgren commented 5 years ago

Hi Cam,

Only the first page in a multi-page report will be shown. What is included on the first page will depend on Interactive Page Size in SSRS. DM will display the report as an image and the options "Fit" should make the entire first page of the report to show.

/M

psined1 commented 5 years ago

Another thing to consider is that every SSRS report has page setup under report properties in SSRS designer. I advise you to play with those settings and see if they will have any effect on how report turns out in DM.

carntsen1 commented 5 years ago

Thank you… I am doing just that this morning. So far I am finding that while the report may look good on my screen (in report designer), If I select ‘Print Layout’ it exactly matches the DM output with cut off columns. Getting better quickly as I focus on settings in report designer.

Thanks for your help Cam

From: Denis P. notifications@github.com Sent: Thursday, October 18, 2018 10:57 AM To: fuel9/DisplayMonkey DisplayMonkey@noreply.github.com Cc: Cam Arntsen carntsen@jdsmith.com; Author author@noreply.github.com Subject: Re: [fuel9/DisplayMonkey] relation between SSRS width and Canvas size (#75)

Another thing to consider is that every SSRS report has page setup under report properties in SSRS designer. I advise you to play with those settings and see if they will have any effect on how report turns out in DM.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/fuel9/DisplayMonkey/issues/75#issuecomment-431041895, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AYD4q-aWnVWbvVz-Qx__5YDfqoOBLgIeks5umJbGgaJpZM4Xliyp.

psined1 commented 5 years ago

Hi, are we all set? Can we close this?

carntsen1 commented 5 years ago

I think so… output is looking much better now Thanks

From: Denis P. notifications@github.com Sent: Tuesday, October 23, 2018 11:16 AM To: fuel9/DisplayMonkey DisplayMonkey@noreply.github.com Cc: Cam Arntsen carntsen@jdsmith.com; Author author@noreply.github.com Subject: Re: [fuel9/DisplayMonkey] relation between SSRS width and Canvas size (#75)

Hi, are we all set? Can we close this?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/fuel9/DisplayMonkey/issues/75#issuecomment-432286726, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AYD4qxaBVQDomRyEnatQgr0h9-F-aYZUks5unzLJgaJpZM4Xliyp.

psined1 commented 5 years ago

Awesome! OP was able to self-assist. Closing.