Post reply

Exporting To Excel Issue - Most Urgent

  • August 10, 2004 at 8:21 am

    #161867

    Hi,

    I have a typical problem, I have a cell in a report which has to display content in two lines, which is not an issue, however the font of the content in the first line of cell should be different from the font in the second line of the same cell, which may sound little ridiculous but I need to support that, to accomplish the same , I introduced a table and inside which I placed two Text Boxes which hold data that was earlier displayed as two different lines and accomplished the job of displaying the two lines data in the same cell in different fonts, it looks perfect in the report, however when I try to export it to Microsoft Excel, it displays the following message instead of the data in the excel cells.

    "Data Regions within table/matrix cells are ignored"

    Any help in this regard would be highly appreciated.

    Thanks in Advance

    -Prasad

     

    Prasad Bhogadi
    www.inforaise.com

  • August 11, 2004 at 2:20 am

    #518425

    I hope this url would solve your problem.

    http://groups.google.co.in/groups?q=exporting+sqlserver+excel+cell+formatting&hl=en&lr=&ie=UTF-8&selm=c5fhe8u8BHA.1532%40cpmsftngxa08&rnum=3

    Thanks,

    Ganesh

     

  • August 13, 2004 at 2:16 am

    #518814

    Instead of using a table try using a Rectangle. place the two text boxes in Rectangle and place the rectangle in the Matrix Cell.

    Hope this solves the Problem.

    -Nagasree

  • November 16, 2005 at 7:24 am

    #604197

    Hi!

    I had the same problem, and i found a solution for the embedded data regions in EXCEL! Altough it is a limitation in RS :

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_8yhy.asp

    There is a solution! Have a look at the riport item "List" in design mode! It has almost the same functionality like teh "Table". You have to manually add headers over the "List" and manually place the textboxes hierarchical inside the list if you want to group fields, but it has a big advantage! Inside the "List" every embedded data regions (just like matrix, or subreport) are displayed correctly in EXCEL!

    IMPORTANT: if you place embedded data regions in a "List" you have to right click on the "List" and select properties. On the first tab of the property window click "edit details group" and you must specify grouping expressions here. For examle if there are "Parent" and "Child" rows inside a "List", a good grouping expression would be the Parent row ID.

    I hope this helps

    Rolf

  • November 16, 2005 at 7:25 am

    #604198

    Hi!

    I had the same problem, and i found a solution for the embedded data regions in EXCEL! Altough it is a limitation in RS :

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_8yhy.asp

    There is a solution! Have a look at the riport item "List" in design mode! It has almost the same functionality like teh "Table". You have to manually add headers over the "List" and manually place the textboxes hierarchical inside the list if you want to group fields, but it has a big advantage! Inside the "List" every embedded data regions (just like matrix, or subreport) are displayed correctly in EXCEL!

    IMPORTANT: if you place embedded data regions in a "List" you have to right click on the "List" and select properties. On the first tab of the property window click "edit details group" and you must specify grouping expressions here. For examle if there are "Parent" and "Child" rows inside a "List", a good grouping expression would be the Parent row ID.

    I hope this helps

    Rolf

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

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