Group selection formula in Crystal.NET

[danal13]

hi,

I am looking for sytax for multipal selection in group name.
Something like this:

{group name 1} in "USA,Canada"

Thanks,

 

[lbass]

You could use:

GroupName({your.groupfield}) in ["USA","Canada"]

But I think it is more usual to just use the group field itself as in:

{your.groupfield} in ["USA","Canada"]

...which could be used in the record selection formula or the group selection formula.

-LB

 

[danal13]

Thanks for your respond. I'm trying to use seggested code and it doesn't work:

GroupName ({Command.SiteName}) in ["DC Hospital","NYC Hospital"]

 

[lbass]

You would only be able to use this in the group selection formula area, which you indicated you wanted to use in the heading of your post, and if you had already created a group on {Command.SiteName}. Go to report->edit selection formula->GROUP and enter the formula there.

If this doesn't work, then instead of saying that it doesn't work, please provide the error message that you get or explain the results you get.

Again, why not create a record selection formula:

{Command.SiteName} in ["DC Hospital","NYC Hospital"]

You could put this in the regular record selection formula area. Or if you want the ability to select sitenames each time you run the report, use a parameter instead.

-LB

 

[danal13]

Report does'not generate any error and dislays all data.
I used record selection insted of group and gat the same result

Thanks,

 

[lbass]

Please post your entire record selection formula by copying it into this thread. Your results do not make sense to me.

-LB

 

[danal13]

I'am using Crystal.NET. I removed formula from the report
and added code to the application:

crystalReportViewer1.SelectionFormula="{Command.SiteName} in ['DC Hospital','NYC Hospital']";

Everything is OK right now.

Thanks for your time and syntax