Print Page | Close Window

multi value parameters - selection editor

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7743
Printed Date: 08 May 2024 at 2:19pm


Topic: multi value parameters - selection editor
Posted By: djstephens
Subject: multi value parameters - selection editor
Date Posted: 21 Sep 2009 at 12:07am
Hi
 
?lcc_inp_tech is setup as multi value parameter field which displays several values from a table
 
not ({lcc_requests_timespent.Request Status} in ["Closed", "Resolved"]) and
{lcc_requests_timespent.Technician} in [{?lcc_inp_tech}]
 
needs to be setup as array , can someone advise what is the correct syntax
 
cheers
 


-------------
Dazza


Replies:
Posted By: DBlank
Date Posted: 21 Sep 2009 at 7:05am
In this case you should be able to make it = rather than in and it will check all values entered into the pararm
 
not ({lcc_requests_timespent.Request Status} in ["Closed", "Resolved"]) and
{lcc_requests_timespent.Technician}={?lcc_inp_tech}

Posted By: djstephens
Date Posted: 21 Sep 2009 at 5:44pm
Still get message this array has to be subscripted ?

-------------
Dazza

Posted By: Jyothi Yepuri
Date Posted: 21 Sep 2009 at 6:11pm
Try
{lcc_requests_timespent.Technician} in {?lcc_inp_tech}

Jyothi

Posted By: djstephens
Date Posted: 21 Sep 2009 at 6:20pm

get message this array has to be subscripted

inputting



-------------
Dazza

Posted By: Jyothi Yepuri
Date Posted: 21 Sep 2009 at 6:30pm
Is it working when you provide a index number?

like this
{lcc_requests_timespent.Technician} in {?lcc_inp_tech}[1]

Jyothi

Posted By: djstephens
Date Posted: 22 Sep 2009 at 9:13pm
Yes it will select the multivalue that equals the number
 
so i need to create an array ??


-------------
Dazza

Posted By: Jyothi Yepuri
Date Posted: 22 Sep 2009 at 9:20pm
{?lcc_inp_tech} is an array rgt!!

did you try this {lcc_requests_timespent.Technician} in {?lcc_inp_tech}
with out []

Jyothi


Posted By: djstephens
Date Posted: 23 Sep 2009 at 5:04pm
yes dosnt work system message about creating array

-------------
Dazza


Print Page | Close Window