DataReport with CanGrow line?

Hi all,

I am facing with a problem while developing with DataReport.

I have RptTextBox in my "Detail" section, those RptTextBox are set with CanGrow=True in case of they are longer string. I draw horizontal and vertical lines so that the report looks in tabular format. However it comes to the problem as RptTextBox can grow, while Line cannot grow. The output of the report is as attached.

Any solution for me?

Some said I need to determine the maximum character from the database, and then adjust the width in DataReport accordingly. But this is not what I wanted because I need to print the report in portrait format and they are many columns per row.

There may be a way to make this work. It depend on how you collect the data for the report and how you set the reports datasource. When the package description is more than one line you would need to insert a new record containing the additional description into the recordset of the reports datasource.

Does this make sense?
Means if the "package" description is 3 lines, then i need to insert into 3 record set?

If the description is three lines then there would be three records in the recordset for that item. The first containing all the usually info and the other two containing only the additional descriptions.

Like I said, it depend how you collect/create the data for the report. You haven't provided any info on that subject.

My description cannot separate into main & sub description, it is only 1 sentence and maybe the length of 1 to 100. I think it is not suitable if reserved the space in the program. It should be in runtime since we can make the row 1, 2, 3 or more row depending on the "package" column.

Hi, I am having the same problem with pu8y.. Do you have any solution with this? Where the line height will increase with the height of the textbox (cangrow=true) in the data report..

First of all, when I put MsgBox(rptwarehouse.Sections("Section1").Controls.Item("txtremarks").Height) in DataReport_Initialize(), it's value is the textbox's height on design time.. It doesn't capture the height on runtime w/c basically increases if the text exceeds..

Thanks in advance for some help guys!

Hi AndyXis,
Until now I haven't got any solution regarding this matter. :(
Do you have any idea to achieve this?

Hi pu8y, I've been searching the web and got nothing yet.. Although this link has a solution for Ms Access reports (the same problem) that has classes written in vb.. haven't tried it yet..
If only we know what fires the cangrow event at run time.. I need to capture the textbox's dynamic height.. It doesn't seem to be on the Initialize event of the data report.. :confused: