I have an existing XSLT file that someone else wrote that is used to create an HTML page to view a report. The report worked fine but now I need to change the report and when I did the column alignment got all screwed up because the columns size was set to a fixed value.
When I tried change the value to auto the columns it didn't work because each block was it's own table.
The report blocks are like this:
Report Title - Weekly Schedule
Paramater block -Schedule Start Date:"04/14/2013"
Column header block - JobName, FullName, Day1, Day2, Day3, Day4, Day5, Day6, Day7
Data rows looking like this.(groups expand/collapse with the detail rows showing or not)
Groups
- Job Name
Details
- JobName, FullName, Day1, Day2, Day3, Day4, Day5, Day6, Day7
I tried to just change the stylesheet to auto size but when I changed the stylesheet the columns don't align any more and I would really rather have auto sizing columns anyway. I attributed this to the XSLT setting each block up as it's own table and then the whole thing being wrapped in a table container. So the size needed wasn't carrying over from one table
But when I remove all of the tables but one, the detail rows the expand/collapse didn't work. And if I have more than one group then only the first group returns data after that nothing returns.
Here is the XML(which I abbreviated to make easier to read). Sorry about the formatting I couldn't get the copy/paste to work correctly. I will reply to this message with the XSLT again because of copy/paste issues.
="1.0"
<data>
<report datetime="4/30/2013 15:14 PM"/>
<schedulestartdate displayas="Schedule Start Date">04/14/2013</schedulestartdate>
<storename displayas="Stores">Bojangles</storename>
-<colheaders>
<colheader day7="04/20/2013" day7name="Saturday" day6="04/19/2013" day6name="Friday" day5="04/18/2013" day5name="Thursday" day4="04/17/2013" day4name="Wednesday" day3="04/16/2013" day3name="Tuesday" day2="04/15/2013" day2name="Monday" day1="04/14/2013" day1name="Sunday"/></colheaders>
-<groups>
-<group id="1" name="Hourly Associate">
<row day7="8:00AM-4:30PM</br> " day6="8:00AM-4:30PM</br> " day5="8:00AM-4:30PM</br> " day4="8:00AM-4:30PM</br> " day3="8:00AM-4:30PM</br> " day2="8:00AM-4:30PM</br> " day1="8:00AM-4:30PM</br> " storenumber="547" storename="Store 0001" missingdata="true" heartbeattime="" schedulestartdate="2013-04-14" middlename="" lastname="BETZ" jobcodename="Hourly Associate" fullname="SKYLER BETZ" firstname="SKYLER" businesssiteid="1F9807A3-6E6F-4802-B37C-6076462E2AC3"/>
<row day7="8:00AM-10:30AM</br>12:30PM-2:30PM " day6="8:00AM-10:30AM</br>12:30PM-2:30PM " day5="8:00AM-10:30AM</br>12:30PM-2:30PM " day4="8:00AM-10:30AM</br>12:30PM-2:30PM " day3="8:00AM-10:30AM</br>12:30PM-2:30PM " day2="8:00AM-10:30AM</br>12:30PM-2:30PM " day1="12:30PM-2:30PM</br>8:00AM-10:30AM " storenumber="547" storename="Store 0001" missingdata="true" heartbeattime="" schedulestartdate="2013-04-14" middlename="" lastname="BLEDSOE" jobcodename="Hourly Associate" fullname="PAIGE BLEDSOE" firstname="PAIGE" businesssiteid="1F9807A3-6E6F-4802-B37C-6076462E2AC3"/>
<row day7="8:00AM-4:30PM</br> " day6="8:00AM-4:30PM</br> " day5="8:00AM-4:30PM</br> " day4="8:00AM-4:30PM</br> " day3="8:00AM-4:30PM</br> " day2="8:00AM-4:30PM</br> " day1="8:00AM-4:30PM</br> " storenumber="547" storename="Store 0001" missingdata="true" heartbeattime="" schedulestartdate="2013-04-14" middlename="" lastname="BODENHAMER" jobcodename="Hourly Associate" fullname="BRITNEY BODENHAMER" firstname="BRITNEY" businesssiteid="1F9807A3-6E6F-4802-B37C-6076462E2AC3"/>
<row day7="11:30AM-8:00PM</br> " day6="11:30AM-8:00PM</br> " day5="11:30AM-8:00PM</br> " day4="11:30AM-8:00PM</br> " day3="11:30AM-8:00PM</br> " day2="11:30AM-8:00PM</br> " day1="11:30AM-8:00PM</br> " storenumber="547" storename="Store 0001" missingdata="true" heartbeattime="" schedulestartdate="2013-04-14" middlename="" lastname="BOGGS" jobcodename="Hourly Associate" fullname="ALLYX BOGGS" firstname="ALLYX" businesssiteid="1F9807A3-6E6F-4802-B37C-6076462E2AC3"/>
<row day7="11:30AM-8:00PM</br> " day6="11:30AM-8:00PM</br> " day5="11:30AM-8:00PM</br> " day4="11:30AM-8:00PM</br> " day3="11:30AM-8:00PM</br> " day2="11:30AM-8:00PM</br> " day1="11:30AM-8:00PM</br> " storenumber="547" storename="Store 0001" missingdata="true" heartbeattime="" schedulestartdate="2013-04-14" middlename="S" lastname="BURKE" jobcodename="Hourly Associate" fullname="SONYA BURKE" firstname="SONYA" businesssiteid="1F9807A3-6E6F-4802-B37C-6076462E2AC3"/>
<row day7="5:00PM-11:00PM</br> " day6="5:00PM-11:00PM</br> " day5="5:00PM-11:00PM</br> " day4="5:00PM-11:00PM</br> " day3="5:00PM-11:00PM</br> " day2="5:00PM-11:00PM</br> " day1="5:00PM-11:00PM</br> " storenumber="547" storename="Store 0001" missingdata="true" heartbeattime="" schedulestartdate="2013-04-14" middlename="" lastname="Crew" jobcodename="Hourly Associate" fullname="Person6 Crew" firstname="Person6" businesssiteid="1F9807A3-6E6F-4802-B37C-6076462E2AC3"/>
<row day7="5:00PM-11:00PM</br> " day6="5:00PM-11:00PM</br> " day5="5:00PM-11:00PM</br> " day4="5:00PM-11:00PM</br> " day3="5:00PM-11:00PM</br> " day2="5:00PM-11:00PM</br> " day1="5:00PM-11:00PM</br> " storenumber="547" storename="Store 0001" missingdata="true" heartbeattime="" schedulestartdate="2013-04-14" middlename="" lastname="Crew" jobcodename="Hourly Associate" fullname="Person7 Crew" firstname="Person7" businesssiteid="1F9807A3-6E6F-4802-B37C-6076462E2AC3"/></group>
<group id="2" name="Salaried Management">
<row day7="8:00AM-6:00PM</br> " day6="8:00AM-6:00PM</br> " day5="8:00AM-6:00PM</br> " day4="8:00AM-6:00PM</br> " day3="8:00AM-6:00PM</br> " day2="8:00AM-6:00PM</br> " day1="8:00AM-6:00PM</br> " storenumber="547" storename="Store 0001" missingdata="true" heartbeattime="" schedulestartdate="2013-04-14" middlename="" lastname="Holmes" jobcodename="Salaried Management" fullname="Jeff Holmes" firstname="Jeff" businesssiteid="1F9807A3-6E6F-4802-B37C-6076462E2AC3"/>
<row day7="2:30PM-11:00PM</br> " day6="2:30PM-11:00PM</br> " day5="2:30PM-11:00PM</br> " day4="2:30PM-11:00PM</br> " day3="2:30PM-11:00PM</br> " day2="2:30PM-11:00PM</br> " day1="2:30PM-11:00PM</br> " storenumber="547" storename="Store 0001" missingdata="true" heartbeattime="" schedulestartdate="2013-04-14" middlename="E" lastname="ROBERTS" jobcodename="Salaried Management" fullname="CREIG ROBERTS" firstname="CREIG" businesssiteid="1F9807A3-6E6F-4802-B37C-6076462E2AC3"/>
-<totals level="0"><row missingdata="True" heartbeat=""/></totals>
</group>
</groups>
-<totals><row missingdata="True" heartbeat=""/></totals>
</data>