Showing posts with label feel. Show all posts
Showing posts with label feel. Show all posts

Sunday, March 11, 2012

Bug in SQL Server Reporting Services?

I've come across what appears to be a bug in SSRS. If after reading this post you feel otherwise, please reply to this thread...

I am trying to use SSRS to print to a Dymo LabelWriter 400 printer. This is a specialized label printer that prints one label to a page. The label paper I am using 2-1/2 inches by 1-1/2 inches. The Dymo printer driver prints portait layout as being the 2-1/2 inches width and 1-1/2 inches height. I assume that is because the paper rolls through the printer that way and labels normally are printed with more width than height.

Other software programs I use to print to this printer handles it properly (Microsoft Word, Microsoft Office Document Imaging, Dymo Label software). However, SSRS seems to assume that portrait layout must mean paper height > width, as there is no explicity setting in SSRS to for page layout. The result is that no matter how I layout my SSRS report (e.g., switch width-height values, use tb-rl to rotate text), SSRS makes the final decision on whether it is portrait or lanscape. And in this case of the Dymo printer, it always sets it to the opposite of what it should be. Changing the printer settings (whether default or whether in print dialog) does not correct it.

Although assuming that portrait layout must mean paper height > width may seem to make logical sense, not every printer works that way; and other software programs (including Microsoft Office) do not make that assumption. It seems that SSRS and/or RDL spec should allow one to explicitly set portrait/landscape setting and not care about width-height ratio. It should be left to the printer and printer driver to decide.

Have other people come across this issue, either with Dymo printer or in other context? Were they able to find a workaround?

I have the same exact issue. Is there any way to force the print orientation (horizontal or vertical) on SSRS?|||In the printers and faxes folder, select properties of tour dymo label printer, select the advance tab. Setup your printer default, label size and orientation and apply. Select the advance tab again in the label properties and select "print directly to printer. This seemed to work for me.

Bug in SQL Server Reporting Services?

I've come across what appears to be a bug in SSRS. If after reading this post you feel otherwise, please reply to this thread...

I am trying to use SSRS to print to a Dymo LabelWriter 400 printer. This is a specialized label printer that prints one label to a page. The label paper I am using 2-1/2 inches by 1-1/2 inches. The Dymo printer driver prints portait layout as being the 2-1/2 inches width and 1-1/2 inches height. I assume that is because the paper rolls through the printer that way and labels normally are printed with more width than height.

Other software programs I use to print to this printer handles it properly (Microsoft Word, Microsoft Office Document Imaging, Dymo Label software). However, SSRS seems to assume that portrait layout must mean paper height > width, as there is no explicity setting in SSRS to for page layout. The result is that no matter how I layout my SSRS report (e.g., switch width-height values, use tb-rl to rotate text), SSRS makes the final decision on whether it is portrait or lanscape. And in this case of the Dymo printer, it always sets it to the opposite of what it should be. Changing the printer settings (whether default or whether in print dialog) does not correct it.

Although assuming that portrait layout must mean paper height > width may seem to make logical sense, not every printer works that way; and other software programs (including Microsoft Office) do not make that assumption. It seems that SSRS and/or RDL spec should allow one to explicitly set portrait/landscape setting and not care about width-height ratio. It should be left to the printer and printer driver to decide.

Have other people come across this issue, either with Dymo printer or in other context? Were they able to find a workaround?

I have the same exact issue. Is there any way to force the print orientation (horizontal or vertical) on SSRS?|||In the printers and faxes folder, select properties of tour dymo label printer, select the advance tab. Setup your printer default, label size and orientation and apply. Select the advance tab again in the label properties and select "print directly to printer. This seemed to work for me.

Bug in SQL Server Reporting Services?

I've come across what appears to be a bug in SSRS. If after reading this post you feel otherwise, please reply to this thread...

I am trying to use SSRS to print to a Dymo LabelWriter 400 printer. This is a specialized label printer that prints one label to a page. The label paper I am using 2-1/2 inches by 1-1/2 inches. The Dymo printer driver prints portait layout as being the 2-1/2 inches width and 1-1/2 inches height. I assume that is because the paper rolls through the printer that way and labels normally are printed with more width than height.

Other software programs I use to print to this printer handles it properly (Microsoft Word, Microsoft Office Document Imaging, Dymo Label software). However, SSRS seems to assume that portrait layout must mean paper height > width, as there is no explicity setting in SSRS to for page layout. The result is that no matter how I layout my SSRS report (e.g., switch width-height values, use tb-rl to rotate text), SSRS makes the final decision on whether it is portrait or lanscape. And in this case of the Dymo printer, it always sets it to the opposite of what it should be. Changing the printer settings (whether default or whether in print dialog) does not correct it.

Although assuming that portrait layout must mean paper height > width may seem to make logical sense, not every printer works that way; and other software programs (including Microsoft Office) do not make that assumption. It seems that SSRS and/or RDL spec should allow one to explicitly set portrait/landscape setting and not care about width-height ratio. It should be left to the printer and printer driver to decide.

Have other people come across this issue, either with Dymo printer or in other context? Were they able to find a workaround?

I have the same exact issue. Is there any way to force the print orientation (horizontal or vertical) on SSRS?|||In the printers and faxes folder, select properties of tour dymo label printer, select the advance tab. Setup your printer default, label size and orientation and apply. Select the advance tab again in the label properties and select "print directly to printer. This seemed to work for me.

Monday, February 13, 2012

Branding of Reporting Services Web Site

Is there any documentation out there as to how you go about changing the look and feel of the Reporting Services Web Site?

Not being able to apply the corporate 'brand' to the site is the only thing that prevents us from adopting this as the corporate reporting service, from my evaluation of the product so far

Thanks

I don't think you can change the look of reporting services site. But you could in ASP.Net view reports by using the report viewer control which is like a mini interface of reporting services. You can toggle the parameter prompt, the toolbar and some of the options of the toolbar. From your web you can set the parameters and specify the output (excel, pdf, html) programatically.|||Thanks for the response. I was hoping not to have to build my own Web Site as all the functionality that I need is available from the Reporting services site 'out of the box'. Ill keep looking for something to assist in my quest!|||

you should get this book:

http://www.amazon.de/exec/obidos/ASIN/0321268288/qid=1149712638/sr=1-5/ref=sr_1_11_5/302-7371721-4022418

it contains a good description of the css-files.
but i dont know what happens to your warranty if you touch the files and pimp your report manager.

cheers
markus

|||This is not supported, I saw this mentioned in a posting last week. I once tricked it by swapping out some graphics files. This broke some things from what I remember. The MS staffer who reviewed the other posting suggested that for now branding can be achieved by building a custom implementation.|||

I cant imagine that the need of some other colors which could be achieved by changing some colors in the css would need the whole set of doing a custom app.

Could changing colours be dangerous for the reporting manager?

But that is licensing...
:-)