Can I have an embedded Select statement in the Report Selection Expert

[golyg]

Is it possible to have a statement like this in the Report Selection Expert:

({VLSYY_YEAR_YEAR.CASENUM} in (SELECT caseNo from subject  case_subject where su_code = code and su_code = ToNumber({@Filter-SubjectNumber})))

I keep getting an error message that states:
"The ) is missing" right before the (SELECT

I can't join these tables in my SQL statement because it will return non-distinct records and I need my records distinct. This in (Select....) statement would allow me to do this, if I can only do it...

I'm using CR7.0.


thanks,

 

[IdoMillet]

Not allowed...

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[golyg]

Thanks for the response..

Is there anyway to work around this then?

Thanks again,

 

[IdoMillet]

Need more detail about data source and what you are trying to do.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[golyg]

Well, I found a work-around.
I linked the tables and then check to see if the caseid is equal in both tables...

thanks for your help,

 

[golyg]

well, ok, my work around didn't work..
here's what I would like to do:

I have a report that would contain a line graph for 2 values displayed by year. The values would be for total records for all subjects or for a specific subject. The records(caseIDs) can have mulitple subjects. The user would be able to search for all subjects or individual subjects. The report is coming off a view that is grouped by year so that I can count the totals. If I include subject table in my report it returns multiple records of the same caseID and that skews my total of records.

well, thats what I have to do.