Help with using FLOAT on report. 1

[Judi201]

Hi!

I am down to (I hope) my last problem with this invoice.

I need to print additional charges immediately below the detail lines. That is, after the detail lines print (number of lines vary), I need to follow this with additional charges. There may be 0 to 5 of these.(shipping, setup, crate chgs, etc)

I used the comma and semicolon in the address lines in one field and thought I might use the same idea here, but can't get it to work.
I need it to look like this.

Detail line1
Detail line2
............
Detail line?
shipping chg shipamt
other chg othchgamt
..........

I am trying to use float to close up the lines when I set Print When charge > 0

I get syntax error on everything I try. Is this workable or am I way off base here?

Any help is much, much appreciated, as always.

Judi

 

[Stella740pl]

Judi,

Can you please clarify, what are those additional lines as far as data organization concerned?

Are they also just additional detail lines, something flat and constant, or they are the same (and printed once) for the whole invoice (but will change for the next one)? Where do you want to print them from, same table, different table, or variables? Can you give a feel of what are you doing that gives you syntax errors?

 

[Judi201]

Hi Stella!

Can't believe you're up to another round with me!! You get a medal for bravery

This is what I am trying to do.

The invoice detail lines print in the detail band. This may be any number of lines but is usually 1 to 5. After printing these, I need to print additional charges (from 0 to 5) immediately below the detail lines. I can do this, but if I set the field to print when value > 0 then I have empty lines on the report.
Thus:

detail line

Shipping

Other chgs

etc

What I need is to float up if the charge above it is not printed.

what are those additional lines as far as data organization concerned?

All of this needs to be in the detail band. If it requires 2 or more pages, so be it. I just need these charges to be following the last regular detail lines. Now they print in the particular place that I put then on the form. Blank lines show if the charge does not apply.

As for syntax errors, I have tried so many things that I could not begin to duplicate.

Do you think this is 'doable' or do I need to go back to the code and work something there??

The source is variables entered on the form that set up the report.

Any ideas?

I truly appreciate any direction you can give me, even if it is 'forget this' and go another way.

Judi

 

[Stella740pl]

Can't believe you're up to another round with me!!
Well, I can try. I do many of them myself.

The source is variables entered on the form that set up the report.
I can do this, but if I set the field to print when value > 0 then I have empty lines on the report.

The secret is to mark "Remove line if blank" at the same time with setting "Print When" to value > 0; and not only for this particular item, but for every single item on the same line.

Say, if you used labels, other fields, short lines/shapes/other report elments on the same line, and you don't want to print your field because it is =0. But the empty line will still be there, because other elements on the line are not blank.

So use the same "Print When" expression for each of them - let your shape, or label print only when the value of that other field is >0, and mark "Remove line if blank" for every single one of them.

 

[Judi201]

Hi Stella,

I can't believe how many times I have been through that screen and not noticed 'Remove line if blank'.

I can always remember reading about something after soneone on here tells me about it. I have caused something else to error on my report and will have to get it back to going before I can try this, but I am sure it will work.

Thanks so much for your help.

Judi

 

[Stella740pl]

Please let me know how it goes if and when you try it.
All the best.

Stella

 

[Judi201]

Stella,

I will certainly not ever let it go without reporting on my success of failure with suggestions I get here. All of you at least deserve that.

I just tried it and it worked perfectly; so, as far as I know now, my invoice is meeting all requirement. On to the next problem.

I don't know exactly how the stars work but the prompt says 'Thanks Stella for the valuable post!" and it was a valuable post for me. Anything that gives me a solution to my problem is valuable to me. So a star for you, Stella!!!

Judi

 

[Stella740pl]

Thanks for the star, and for the feedback.
And I am always pleased to hear that it worked.
Thanks!