Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Showing chosen values in a heading 1

Status
Not open for further replies.

DJWheezyWeez

Technical User
Jun 5, 2008
265
0
0
US
In my report, I have a parameter for Job# and it allows you to choose whatever Job#'s you want. My problem is in my heading, the text reads:

Job#: {?JobNum}

When I run the report, it only shows the first Job# I choose in the parameter. If possible, I'd like it to show something like:

Job#: 200197, 200198, 200200, 200196

I'm using CR XI.

~DJWW

 
join({?JobNum},",")

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
I really will appreciate any help


I have table with 4 fields.

DispValue, Max , Min and month


I want to write a formula to count the fields for every month with that condition:

If Max is null use the DispValue field with condition that it is not < that the Min field
If Min is Null use the display field with condition that it is not > than the Max field

That what I did but it is not working. It give the count number for all records.



Dim x,v,w,z
x=0
z=0
for x=0 to count({all the record})-1

if isnull({Max}) then
v={DispValue}
else
v={Max}
end if
if isnull({Min}) then
w={DispValue}
else
w={Min}
end if
if {DispValue} < w or {DispValue} > v then

z=z+1

else
z=z
end if

next
formula=z
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top