Report: Repeat Data on Every Page - Use String?

[Stan Mathews]

Re: Report: Repeat Data on Every Page - Use String?

Interesting, I had never tried that approach. You can almost get the split percentages to right align if you change the first part of the content variable to

content = "'<tr><td> '+case(yarn_split->split<10,'[COLOR="#FF0000"]&nbsp;&nbsp;[/COLOR]'+str(yarn_split->split,3),yarn_split->split<100,'[COLOR="#FF0000"]&nbsp;[/COLOR]'+str(yarn_split->split,3),.t.,str(yarn_split->split,3))+'% ..........

There probably is a right align html command but I don't it.

[Al Buchholz]

Re: Report: Repeat Data on Every Page - Use String?

Interesting, I had never tried that approach. You can almost get the split percentages to right align if you change the first part of the content variable to

content = "'<tr><td> '+case(yarn_split->split<10,'[COLOR="#FF0000"]**[/COLOR]'+str(yarn_split->split,3),yarn_split->split<100,'[COLOR="#FF0000"]*[/COLOR]'+str(yarn_split->split,3),.t.,str(yarn_split->split,3))+'% ..........

There probably is a right align html command but I don't it.

I refer to W3Schools to learn my html and let them remember all of those little details...

Like text-align CSS

[MoGrace]

Re: Report: Repeat Data on Every Page - Use String?

Thanks Al - I bookmarked that site. They refer to using CSS to text-align cell data, but only give the example for the <th> tag. Creating the string needed for xbasic is a bit of a challenge when you look at their examples.

In tweaking your example, something changes with the mrecno() break I am using. My plan is to allow batch printing of these lot controls, but when the lotsize changes on a new schedule, the record count gets messed up on the first page for that schedule. I 'm going to try setting a var to lotsize in the OnInit and Sch_no section and use that instead of the field in the break expression. brb

Well that didn't work - returns the error 'missing right parenthesis' - which of course it is not.

[Stan Mathews]

Re: Report: Repeat Data on Every Page - Use String?

Using <div> </div>

content = "'<tr><td><div align = \"right\">'+str(yarn_split->split,3)+'%</div> </td><td>'+substr(yarn_item->yarndesc,1,30)+'</td><td> '+substr(yarn_item->lotno,1,10)+' </td><td> '+yarn_item->vendid +' </td></tr> ' "

[MoGrace]

Re: Report: Repeat Data on Every Page - Use String?

Thank you Stan - 1 problem solved!

I noticed that the html control must be sized to display the greatest number of records the table will hold; ie, it can't 'grow' like other controls on the report, even with the growable property checked. Although growable also has a dynamic setting - what would that be?

[Stan Mathews]

Re: Report: Repeat Data on Every Page - Use String?

Seems to me it would be any expression that evaluated, dynamically, to a logical result.

I attempted to set the html object height dynamically with the expression

line_count(Var->content)*.20

but it doesn't seem to be honored.

[Al Buchholz]

Re: Report: Repeat Data on Every Page - Use String?

Thank you Stan - 1 problem solved!

I noticed that the html control must be sized to display the greatest number of records the table will hold; ie, it can't 'grow' like other controls on the report, even with the growable property checked. Although growable also has a dynamic setting - what would that be?

I think the growable issue is because the html is in the page header for the group Schno.
That region doesn't show shrink contents of band as an option.

Move the html and headings to the Group LotBreak Header after you have enabled that header.

[MoGrace]

Re: Report: Repeat Data on Every Page - Use String?

I broke something yesterday because this morning the html is not rendering at all. I did move it to the Lot Break header - and back again and nothing appears in either place. So my guess is the content string is wrong. Could someone post a working string from the get_lots function so I can check it? TIA

[Stan Mathews]

Re: Report: Repeat Data on Every Page - Use String?

Like post#19?

[Al Buchholz]

Re: Report: Repeat Data on Every Page - Use String?

Put a debug in your code to see if it's run and help with finding the error.

[MoGrace]

Re: Report: Repeat Data on Every Page - Use String?

Moving the control changed the alias from HTML1 to HTML4

[MoGrace]

Re: Report: Repeat Data on Every Page - Use String?

Like post#19?

Yeah like that...

[Al Buchholz]

Re: Report: Repeat Data on Every Page - Use String?

Moving the control changed the alias from HTML1 to HTML4

Good catch....

Is this when I mention a best practice is to rename objects to something unique and meaning full?

Even though my example didn't do that?

(I was trying to make as simple of an example as possible.) That's my story and I'm sticking to it....

[MoGrace]

Re: Report: Repeat Data on Every Page - Use String?

I've been trying a few things to get the Lotbreak to break properly when the SCH_NO group changes the Lotsize and get rid of the page break in the Lotbreak footer that caused a blank page

Moved the fields in the Grp->Schno header to the Grp->Lotbreak header and deleted the Grp_Schno header

Moved the HTML object to the Grp->Lotbreak footer (and lost which section event populated it). Now the object can be sized to accomodate more records.

I added a field to the subreport Rolls table to see what the MRECNO() value was and discovered I could use the field TAGNUM instead which resets the break correctly - new break expression: int((Tag_Nos->Tagnum+lotsize-1)/Lotsize)

Moving the HTML object to the Lotbreak footer was working fine until I changed the group break expression - any ideas on how to fix it? Since the sections changed, I tried topparent:HTML1.value = get_lots(sch_no) in both the Lotbreak and Schno section's OnRecord event - but the html is not rendering.

Oh, and I changed all the field names back to their default names.

Edit: This works in the Lotbreak section - (my syntax skills are lousy)

dim vnsch as n
vnsch = topparent:sch_no.value
topparent:HTML1.value = get_lots(vnsch)

I think I am done now - just need to move it to the v12 report.

Thank you so much for all your help - you guys are the best!

[Al Buchholz]

Re: Report: Repeat Data on Every Page - Use String?

I've been trying a few things to get the Lotbreak to break properly when the SCH_NO group changes the Lotsize and get rid of the page break in the Lotbreak footer that caused a blank page

Moved the fields in the Grp->Schno header to the Grp->Lotbreak header and deleted the Grp_Schno header

Moved the HTML object to the Grp->Lotbreak footer (and lost which section event populated it). Now the object can be sized to accomodate more records.

I added a field to the subreport Rolls table to see what the MRECNO() value was and discovered I could use the field TAGNUM instead which resets the break correctly - new break expression: int((Tag_Nos->Tagnum+lotsize-1)/Lotsize)

Moving the HTML object to the Lotbreak footer was working fine until I changed the group break expression - any ideas on how to fix it? Since the sections changed, I tried topparent:HTML1.value = get_lots(sch_no) in both the Lotbreak and Schno section's OnRecord event - but the html is not rendering.

Oh, and I changed all the field names back to their default names.

Edit: This works in the Lotbreak section - (my syntax skills are lousy)

dim vnsch as n
vnsch = topparent:sch_no.value
topparent:HTML1.value = get_lots(vnsch)

I think I am done now - just need to move it to the v12 report.

Thank you so much for all your help - you guys are the best!

The event code I sent you was:
topparent:Html1.value = GET_LOTS(topparent:Sch_no2.value )

When you did this...

Oh, and I changed all the field names back to their default names.

That broke the link to topparent:Sch_no2.value, since the 2 was dropped.

I use the object explorer to get the relative object names to make sure I get what Alpha think they are.

So

dim vnsch as n
vnsch = topparent:sch_no.value
topparent:HTML1.value = get_lots(vnsch)

is the same as

topparent:HTML1.value = get_lots(topparent:sch_no.value)

but not the same as:
topparent:HTML1.value = get_lots(sch_no)