Post reply

Reporting Services Format of rendered Excel report

  • January 10, 2005 at 3:00 am

    #112928

    Hi All,

    I am so very distressed with Reporting Services. When the report is rendered, the values are perfect. BUt once it is viewed in Excel, the values go haywire though they remain alright in PDF.

    Besides, no article gives me info on subscription appropriately.

    Best regards,

    Yogs

     

     

     

  • January 10, 2005 at 11:27 pm

    #536753

    Can you elaborate on what you mean when you say "the values go haywire"?

    Are the values different, or are they just presented differently.

    I've noticed with my reports that export to Excel you have to be very exact with your column alignments. It takes a lot of trial and error to get it right.

    --------------------
    Colt 45 - the original point and click interface

  • January 11, 2005 at 6:25 am

    #536794

    How is your report designed?  Is it columnar using the table control?  I too have found that if the report is not columnar, going to excel puts most of the text in the first column so it looks elongated rather than in each column.

    manash

  • January 11, 2005 at 8:17 am

    #536821

    Can you be more descriptive of "haywire".  If for example you are using a numeric value for a part number and the value is 12345678901, it should display correctly but if the value is 123456789012 then Excel will display it as

    1.23457E+11

     Excel assumes that the value is numeric, but if the cell which contains the value is formatted as text BEFORE any entries are made then it will display as 123456789012.  If this is what you mean by "haywire" then you need to display your data using an Excel template with the columns properly formatted for the data that they will contain.

    Hope this helps

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • January 12, 2005 at 2:44 am

    #536971

    Thanks to all for your answers. By going haywire. I meant I used the format for a cell in Reporting Services as ##0.##,"%". Thus implying that it is a number with maximum two decimal places and appended with it is the % sign.

    The report thus generated had correct values when deployed and viewed in IE but when ported to Excel, the cell showed correct value in the display bar at the top of the Excel file but in the cell it displayed a different value.

    Now I have put the value ##0.## in the Reporting Services and it displayes correct values. But I need to append % sign to it as well. Any suggesstions?

    Thanks,

    Yogita

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply