Export Excel Problem

• ofir shoval

  Ten Centuries

  Points: 1278

  More actions

  September 20, 2005 at 1:22 am

  #363691

  Well as i wrote here before i did a report that show a Week WorkPlan.

  I did it using a table which ds get all the missions for the week and has 5 columns for each labor day.In each column there's a inside table which shows the missions for the current day(using hidden property...).

  It worked great but now when i export to excel I get in each cell this message:"Data Regions within table/matrix cells are ignored."

  Whats the problem???

• ofir shoval

  Ten Centuries

  Points: 1278

  More actions

  September 21, 2005 at 3:27 am

  #591641

  Well I found an answer in this forum (and others as well)that instaed of using Table I should use a rectangle:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=130983&edit=failed

  But stil there's a problem:

  The report is with table which has 1 group = Area.I use only the group row no details row so Area will apeare only once.in each cell in this table i enterd a inner table so there will be multiple rows within the cell.so if i will use a rectangle there will be only one row.

  so i changed the table so the missions will be in the details row but now if i want to hidden some rows i will get blank rows ....

  What 2 do???