Report Help Needed

C

ChrisP

I have a report that basically a service bill. It
displays a client's case and all the issues related to
that case. Each issue can contain parts.

The report is arranged like this; I have an Issue Header
which will repeat all the Issue info for that particular
case of this client. I have a Detail header which repeats
all the Parts that are used in that issue.

I want to set a condition in my report that will not
display a part if the serial# = 0.

I did this because the report is running off my query
which will not display the right records unless there are
parts for that issue. So i set a DUMBY part with serial#
0. Now everything is dandy, but my report is showing the
DUMBY part.

I have no idea how to set a condition in a report to now
display the Detail section, which contains part info, if
the part number = 0.

Thanks for your help ahead of time,
Chris
 
F

Fons Ponsioen

On your report I assume there is a textbox with a source -
Serial#- Change the source to :
=IIF([Serial#]= "0" , "", [Serial#])
If the srial# is a number rather than text, change the "0"
to 0 (without the quotes).
Now if your textbox is named like your data element
Serial#, make sure you change the name to anything other
than the data name like Serial#Calc.
Hope this helps.
Fons
 
C

ChrisP

This did not work for me. It still displays the unwanted
DUMBY part and now when I view the report an inputbox
pops-up and asks for a value for the Serial#


I really still need help in this matter.

Chris
-----Original Message-----
On your report I assume there is a textbox with a source -
Serial#- Change the source to :
=IIF([Serial#]= "0" , "", [Serial#])
If the srial# is a number rather than text, change the "0"
to 0 (without the quotes).
Now if your textbox is named like your data element
Serial#, make sure you change the name to anything other
than the data name like Serial#Calc.
Hope this helps.
Fons
-----Original Message-----
I have a report that basically a service bill. It
displays a client's case and all the issues related to
that case. Each issue can contain parts.

The report is arranged like this; I have an Issue Header
which will repeat all the Issue info for that particular
case of this client. I have a Detail header which repeats
all the Parts that are used in that issue.

I want to set a condition in my report that will not
display a part if the serial# = 0.

I did this because the report is running off my query
which will not display the right records unless there are
parts for that issue. So i set a DUMBY part with serial#
0. Now everything is dandy, but my report is showing the
DUMBY part.

I have no idea how to set a condition in a report to now
display the Detail section, which contains part info, if
the part number = 0.

Thanks for your help ahead of time,
Chris
.
Click to expand...
.
Click to expand...
 
Top