Page setup

[chinnijahn]

I am using crysal report XI and Vb.net.

I have a report which consists of two tables
I want the second table to extend to the bottom of the page dynamically.

HOw can I do that.

Thanks in advance

 

[lbass]

Do you mean you have two crosstabs? Where are they located? How are they behaving now? It is unclear what the issue is.

-LB

 

[chinnijahn]

I apologize for limited information.
well here it goes..I dont have the cross tabs.
I am using manual tables.

I have two tables first table gives the details of all the products from the database and i have it in my details section which is working fine

In report footer I have a comments table which is also working fine.

However the report is always one page ..there is a very little chance that it will grow more than one page...

we want the report should behave like this...
suppose the first table took half page then the second table should start from the end of the table one and stop at the end of the page...

so the table two height should be changed dynamically based on the page size left...

i hope this makes some sense..if not please ask me where i am lacking the information...

Thanks a lot

 

[chinnijahn]

PAGE STARTS
productname PRdouctCode ProductCost
1 abc 87
2 xcv 99
3 ssx 76
4 swx 90

Date Comments
---------------

---------------

---------------

page ends


suppose if the proudct table has more products then the report should like this below

PAGE STARTS
productname PRdouctCode ProductCost
1 abc 87
2 xcv 99
3 ssx 76
4 swx 90
5 yyy 12
6 234 89

Date Comments
---------------

---------------

page ends


so the secodn table has to limit it rows and adjust the height based up on the page leftover area..

hope this description helps a little bit more to get the situation.
Please let me know if you need any other information

 

[lbass]

Your use of "table" is confusing. Do you mean you are placing fields from one table in the detail section and fields from a comments table in the report footer? If so, are you using a subreport for the comments table? Otherwise, if you were placing fields from a comments table in the report footer, you would only see the results for the last row. Please clarify.

-LB

 

[chinnijahn]

ok..I am showing results in a tabular format.

In details section I get the values from the database table Products.

In report section it is a blank comment table format which after taking printout user can write comments on its own..so it is just an empty table format..I am not using any subreport for this...also It is in the report footer..

TO acheive a blank comments table i have used a box and then drawn lines between.

The comments table should be adjusted dynamically based on how much space is left on the page.

I really appreciate your patience and I hope this time i made some sense

 

[lbass]

Instead of using an inserted box, insert a text box. Do not stretch it in height. Place it in the report footer and stretch it to fit the report width only. Right click on the text box->format text->check "can grow" and uncheck "keep object together". On the borders tab, set the borders to single line. Then create these formulas:

whileprintingrecords;
numbervar cnt := cnt + 1;

Place this formula in the detail section. If there any group sections that appear on the page, you should also place a copy of the formula in these. Then create a formula {@lines} like this:

whileprintingrecords;
numbervar cnt;
if onlastrecord then
replicatestring("______________________________________________________________________________________________________" +chr(13),60-cnt);

Place this formula in the text box in the report footer, in the left hand corner.

In the section expert, format the report footer by unchecking "keep together."

Note that you need to adjust the 60 to whatever number would coincide with the number of rows on the full page if it were filled with data--play around with this until you get the right match, with no lines extending onto a second page.

-LB

 

[chinnijahn]

I will try this and let you know how it worked out..Thanks a lot LB.

 

[chinnijahn]

I had to stop working on this program as something else came up which we have to give priority so i was unable to cheeck ...I will post if the solution worked or not asap..

thanks a lot guys