Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

reportnet: One column list box to fit exactly within a table Cell

Status
Not open for further replies.

roberda

IS-IT--Management
Apr 14, 2005
14
FR

Hi,

under report studio, In a table cell with a fix Width, I insert a one column list box.
The list column width has also the same value as the parent cell.

now when I run the report in pdf the list column does not fit exactly the parent table cell.

I used padding and other margin, but with no result.

thanks for your comments on this

david

------------------
extract of the xml:

<tableCell>
<style><CSS value="padding:0px;vertical-align:top;text-align:right;width:25px;border-bottom-style:none;border-left:1.5pt solid black;border-right:1pt solid black"/></style>

<list refQuery="CALENDRIER">
<listColumnTitles><listColumnTitle><textItem><queryItemRef content="label" refItem="CJOU"/></textItem><style><CSS value="display:none"/></style></listColumnTitle></listColumnTitles>
<listColumns><listColumn><textItem><queryItemRef refItem="CJOU"/><style><CSS value="width:25px"/></style></textItem><style><CSS value="padding:1px 0px 1px 0px;font-family:Arial;font-size:6pt;vertical-align:top;text-align:center;border-top-style:none;border-left-style:none;border-right-style:none;width:25px;height:3px;border-bottom:0.5pt solid black"/></style><conditionalStyle refVariable="DateJourJaune"><style><CSS value="background-color:yellow"/></style><style refVariableValue="1"/></conditionalStyle></listColumn></listColumns>
<style>
<CSS value="border-collapse:collapse;width:25px"/>
</style>
<XMLAttribute name="RS_ListGroupInfo" value=""/></list>
</tableCell>
 
I found the solution, here is the answer for each level of objects

1. At the table level: border-collapse:collapse;table-layout:fixed"

2. at table cell, you need to define a fix size with a padding at zero: padding:0px;width:3cm

3. at <list> box: border-collapse:collapse

4. finally for queryItemRef : set its width equal to the table cell one defined above: width:3cm



example:

report xml:lang="en" xmlns=" <layoutList>
<layout>

<pageSet>

<page name="Page1">
<pageBody><table><tableRow><tableCell><style><CSS value="padding:0px;width:3cm;border:1pt solid black"/></style><list refQuery="Query1">
<listColumnTitles><listColumnTitle><textItem><queryItemRef refItem="CJOU" content="label"/></textItem><style><CSS value="width:3cm"/></style></listColumnTitle></listColumnTitles>
<listColumns><listColumn><textItem><queryItemRef refItem="CJOU"/></textItem><style><CSS value="width:3cm;vertical-align:middle;text-align:center;border-top-style:none;border-left-style:none;border-right-style:none;border-bottom:0.5pt solid red"/></style></listColumn></listColumns>
<style>
<CSS value="border-collapse:collapse"/>
</style>
<XMLAttribute name="RS_ListGroupInfo" value=""/></list>
</tableCell><tableCell><style><CSS value="padding:0px;width:3cm;border:1pt solid black"/></style><list refQuery="Query1">
<listColumnTitles><listColumnTitle><textItem><queryItemRef refItem="CJOUOUV" content="label"/></textItem><style><CSS value="width:3cm"/></style></listColumnTitle></listColumnTitles>
<listColumns><listColumn><textItem><queryItemRef refItem="CJOUOUV"/></textItem><style><CSS value="width:3cm;vertical-align:middle;text-align:center;border-top-style:none;border-left-style:none;border-right-style:none;border-bottom:0.5pt solid red"/></style></listColumn></listColumns>
<style>
<CSS value="border-collapse:collapse"/>
</style>
</list>
</tableCell></tableRow><style><CSS value="border-collapse:collapse;table-layout:fixed"/></style></table></pageBody>
</page></pageSet></layout>
</layoutList>
<modelConnection name="/content/package[@name='Daily Sales PROD BW+ORACLE']/model[@name='2005-05-10T09:27:22.375Z']"/><querySet xml:lang="en"><BIQuery name="Query1"><cube><factList><item aggregate="none" refItem="DJOU"/><item aggregate="none" refItem="CJOU"/><item aggregate="none" refItem="CJOUOUV"/></factList></cube><tabularModel name="Tabular Model"><dataItem name="DJOU" aggregate="none"><expression>[SAP_BW_PROD].[CALENDRIER].[DJOU]</expression></dataItem><dataItem name="CJOU" aggregate="total"><expression>[SAP_BW_PROD].[CALENDRIER].[CJOU]</expression></dataItem><dataItem name="CJOUOUV" aggregate="total"><expression>[SAP_BW_PROD].[CALENDRIER].[CJOUOUV]</expression></dataItem><filter><condition>[DJOU] between _first_of_month(current_date) and _last_of_month(current_date)</condition></filter></tabularModel></BIQuery></querySet></report>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top