Continuing a field on next page

[damonkimble]

Using Crystal 10 connecting to MS SQL via ODBC.

I am working on converting the printing of CMS form 700 (

http://www.cms.hhs.gov/forms/cms700.pdf)

to crystal. A few of the boxes (12, 20, 21) can contain more data than can physically fit inside the allocated space. I would like to continue printing the information in the same location on additional pages. Is this possible? Crude drawings below provided for further insight

thanks,
damon


page 1
-----------------------------------------
- name id -
- random info -
- -
- abcdef -
- ghijklm -
- opqrstu -
- -
- even more info -
- -
-----------------------------------------



page 2
-----------------------------------------
- name id -
- -
- -
- vwxyz -
- -
- -
- -
- -
- -
-----------------------------------------

 

[lbass]

What sections are the above sample fields displaying in? You could achieve most of this by setting the group header (name or ID) to "repeat group header on each page" (go to report->group expert->options). The details would then continue on the next page. If you have something displaying on the bottom of each page, that could be in a page footer section.

-LB

 

[synapsevampire]

Yes, but I think it will involve creating additional sections that conditionally suppress/unsuppress based on the length of this field (meaning will it span to a second page).

So you might guess at how much can fit in one page, then parse it into 2 variables for use on the 2nd page. This might be based on number of characters, or carriage returns if the exist within the data.

The crudeness of your example data limits the response, had you posted specifics, you'd find that you receive specific answers.

-k

 

[damonkimble]

Everything is in the detail section.

using query of form:
select id, name, random info, textfield, even more info
from table

textfield is supposed to print in fixed size box. In reality, as big as 7" x 2". In crude example, about 21 char over three lines. When it runs out of space, I want to start printing at the beginning of the same box on the next page.

Not sure how to give anymore information without being overwhelming.

Synapse's suggestion of parsing sounds about right. Can this be done in Crystal or would I need to do it in my query?

thanks,
damon

 

[synapsevampire]

You could parse in a query, but it's probably easier within Crystal.

Something like:

whileprintingrecords;
stringvar Output1:="";
stringvar Output2:="";
if len({table.field}) > 200 then
Output1 := left({table.field},200);
Output2 := mid({table.field},201);

Now you have the two variables that you can use to display with.

You might instead use a loop to find a space before that point if you want a clean break.

-k

-k

 

[damonkimble]

Thanks for the suggestion. I'll give it a shot and let everyone know.

 

[damonkimble]

No time to take a look at this yet. Will do ASAP.