Hi, I'm using SSRS2008, I'vea subreport embeded into merged horizontal cells in a tablix. The problem I'm having is that the table/cell border lines are not lining up. I've set the padding on all cells to 0, I set the subreport cells widths and heights to match thier respective cells in the parent tablix. The cell alignment in the HTML preview looks wrong, and when the report is exported to Excel an extra empty colum beside every column of the subreport is added. If I remove the subreport the parent report exports to excel fine. I've found another post which is quite similar,but that post refers to SSRS2005 Does anyone know if this is arecorded bug, is there a fix? Regards Dan

Hi Dan, Sounds like you have a tablix in your subreport as well? What you're trying to do might be tricky to accomplish, since IE handles a lot of the cell sizing/spacing. But you can try a few things to try and mitigate the issues you are seeing: -ensure the the body size is the same size of the tablix in the subreport (ie. not white space) -make the body/tablix width the width of the max cell width from the main report -make the cells in the subreport cangrow = true, canshrink=true. Also I assume you are using subreports because you need multiple datasets? If so (if it is possible), redesigning the report to use embedded tablices instead of subreports may help make the sizing output more consistent. Hope this points you in the right direction. -Gerry

Hi Gerry Thanks for your help here, I do have a tablix in my subreport (is there any alternative for a table of data when using subreports?). I had already set the body/tablix/cell widths to match the parent/subreport, but has never worked, There is no whitespace in my report, I've checked the size properties as well as the GUI. I also set the cangrow and canshrink values to True - again no joy. I can't see how adding an embedded tablix can help here? can you explain more? Ideally I'd like to have my report produce one table with multiple rows (cases), with optional (parameter set) additional data for the parent rows from linked datasets/subreports, But I need these tables to align so that it lines up in excel. Is it really that complicated to have a subreport tablix align with a parent report tablix? Regards Dan

Has anyone elserun intothis problem? surely its not that un-common to want to nest reports within each other and expect the columns to line up?RegardsDan

Have you tried converting both your main report and subreport to the PT system?The excel rendering engine has to do the conversion and acts kooky on the demimal rounding....check out my blog on the subjectRich Samford

Hi Rich,Your workaround has done the trick, Thank you very much. :o) I spent hours changing the value of all the objects to points (pt) rather than cm's. Its a shame Microsoft haven't fixed this, it would certainly make life easier if they would fix it.Do you know of any workarounds for the row height when exporting to excel? I have noticed that with the 'can grow' value set to true, the row height in excel seems to be determined by the length of the value in the first(populated) columnin a row. I've yet to work out how to make the row height grow based uponallthe data in the other columnsforthe row. Thanks again for your help.RegardsDan

I am having a similar problem with reports and subreport columns not lining up in SS 2008. How do convert a report to PT system? Our reports are being reendered as PDFs. Thanks! B Duncan