Focal Point
Header Problem in Accordian Report

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7091006192

July 15, 2008, 04:39 AM
<B_B>
Header Problem in Accordian Report
Hi,
I am using active accordian report. I need to do some formatting around the header.
I want the header in the center, but it by defaults come to the left.

Also, while generating active accordian report(using FORMAT AHTML)i get a unwanted text like - '25 of 25 records (100%), Page 1 of 1'.

Please suggect how do i get rid of this.

Thanks,
Bhavna
July 15, 2008, 05:16 AM
<Naak>
Hi B_B,
please try this example.

TABLE FILE EMPDATA
PRINT
SALARY
BY DIV
BY DEPT
HEADING CENTER
"KOTI"
ON TABLE SET EXPANDABLE ON
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$

ENDSTYLE
END
July 15, 2008, 06:47 AM
<B_B>
Hi,

Thanks for the reply.

But, i need to get rid of '41 of 41 records (100%), Page 1 of 1'

Also, the heading 'KOTI' need to come in the center of the page.

Please suggest.

Thanks,
Bhavna
July 15, 2008, 06:52 AM
<B_B>
Hi Naak,

I guess, the heading works fine as we expand the report. Thanks for it.

1) Is there any way where i can get rid of unwanted text like - 41 of 41 records (100%), Page 1 of 1'.

2) I need to wrap text so that appears in next line.I used wrap=On.It does not seem to work on accordian.
Please suggest.

Thanks,
Bhavna
July 15, 2008, 09:14 AM
GinnyJakes
For #1, that text is part of the Active Report. You can move it to the bottom but not sure if you can turn if off completely. Check the properties box for AHTML to see if you can do that.

For #2, wrapping doesn't seems to work for AHTML. And, in fact, from page to page, the width of a specific column will vary depending on the length of the data items displayed.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
July 15, 2008, 09:19 AM
<Naak>
Hi B_B,
Please increase the lenght of text in heading and try this example
TABLE FILE EMPDATA
PRINT
SALARY
BY DIV
BY DEPT
BY LASTNAME
BY FIRSTNAME
BY TITLE
BY JOBCLASS
BY HIREDATE
HEADING CENTER
"KOTInnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn,ccccccccccccccccccccccccccc"
ON TABLE SET EXPANDABLE ON
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$

ENDSTYLE
END