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.

BSM with SSRS(2005) on a different box

Could anybody help provide some detailed information about installing BSM with SSRS 2005? My installation needs to have SSRS running on a different box than the BSM server.

There are 2 issues involved here:

The BSM Server.msi by default looks for Reporting Services 2000. I need to have the complete installation based on SQL2005. Do i have to install RS2000 and then manually configure it to use SSRS2005?

In addition to this, I would prefer to have the Report Server on a different machine. How do you convey this altered configuration to the Server.msi file which looks for a reporting services instance on the same machine. The set up does not proceed without having RS2000 on the same box.

You'll probably have more luck in the Reporting Services forum, http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1. This one is dedictated to Microsoft SQL Server Notification Services.

In the meantime, you might find this thread interesting; it describes how BSM works with SQLNS. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137502&SiteID=1

Good luck!

Joe

|||Thanks. I have posted the same question here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=252677&SiteID=1

Browsing a cube in ssrs Matrix

When we browse the cube in management studio we are able to see the correct aggregates where as in the report from reporting services we are just getting the sums instead of running aggregates especially in the intersection cells of columns and rows. ( where ever the aggregrate function is difference/division. )

Is there a setting in reporting services which would make the report return the running aggregates like in the management studio.

thanks in advance

The brower is diferent in Reporting Services, but if you use the MATRIX in reporting Services, you all the cells for columns, rows and data!

Try it... if you never did that, use the wizard!

Helped?

Regards!

|||

--

|||

PedroCGD wrote:

The brower is diferent in Reporting Services, but if you use the MATRIX in reporting Services, you all the cells for columns, rows and data!

Try it... if you never did that, use the wizard!

Helped?

Regards!

Can you eloborate please.

Even when I use the matrix and the wizard still it dosent give me the running aggegates it is just giving me the sum in the intersections cells.

Any thots ?

Browser similar to SSAS required for SSRS

Hi,

How to import analysis browser in SSRS. I need features similar to SSAS Cube browser and SSAS dimention browser.

Regards

Spandan

As you probably know, SSRS has an MDX Designer which you can use if you target SSAS 2005. It is possible to host your own query designer although this feature is currently not documented. You need to contact the RS product group for more details.

Browser similar to SSAS required for SSRS

Hi,

How to import analysis browser in SSRS. I need features similar to SSAS Cube browser and SSAS dimention browser.

Regards

Spandan

As you probably know, SSRS has an MDX Designer which you can use if you target SSAS 2005. It is possible to host your own query designer although this feature is currently not documented. You need to contact the RS product group for more details.

Browser Compatibility in SSRS 2005

How can I get my report to render correctly in Firefox?
The report displays squished to the left side of the browser as it did in SSRS 2000.
Is it the viewer that does this or a setting I need to set?
I am running my report from a URL.

Also seems to open ok if I export to PDF.
Does not work in HTML view.Check sizes of report items in your report and CanShrink/CanGrow properties. If they are set incorrectly in most cases IE will still show them right. Firefox is picky.|||Thanks that was it
|||

I need suggestions regarding the report being viewed in firefox:

Problem:

In Matrix reports the "sub Total" Columnm is getting wrapped to .0001 in (Probably!!!!! not to that accuracy), But i can see the remaining part like Row and Column Cells r displaying properly.

only the Last Column is being truncated..

This happens only in FireFox But not in IE.

Required Result:

"Sub Total" column also has to be seen clearly as other cells.

Any Suggestions?

Regards,

Sri Harsha Kasi

Browser Compatibility in SSRS 2005

How can I get my report to render correctly in Firefox?
The report displays squished to the left side of the browser as it did in SSRS 2000.
Is it the viewer that does this or a setting I need to set?
I am running my report from a URL.

Also seems to open ok if I export to PDF.
Does not work in HTML view.Check sizes of report items in your report and CanShrink/CanGrow properties. If they are set incorrectly in most cases IE will still show them right. Firefox is picky.|||Thanks that was it|||

I need suggestions regarding the report being viewed in firefox:

Problem:

In Matrix reports the "sub Total" Columnm is getting wrapped to .0001 in (Probably!!!!! not to that accuracy), But i can see the remaining part like Row and Column Cells r displaying properly.

only the Last Column is being truncated..

This happens only in FireFox But not in IE.

Required Result:

"Sub Total" column also has to be seen clearly as other cells.

Any Suggestions?

Regards,

Sri Harsha Kasi

Browser Compatibility in SSRS 2005

How can I get my report to render correctly in Firefox?
The report displays squished to the left side of the browser as it did in SSRS 2000.
Is it the viewer that does this or a setting I need to set?
I am running my report from a URL.

Also seems to open ok if I export to PDF.
Does not work in HTML view.Check sizes of report items in your report and CanShrink/CanGrow properties. If they are set incorrectly in most cases IE will still show them right. Firefox is picky.|||Thanks that was it
|||

I need suggestions regarding the report being viewed in firefox:

Problem:

In Matrix reports the "sub Total" Columnm is getting wrapped to .0001 in (Probably!!!!! not to that accuracy), But i can see the remaining part like Row and Column Cells r displaying properly.

only the Last Column is being truncated..

This happens only in FireFox But not in IE.

Required Result:

"Sub Total" column also has to be seen clearly as other cells.

Any Suggestions?

Regards,

Sri Harsha Kasi