Hi all,

I'm new to the world of Crystal and wonder if I might ask what's hopefully a simple question please:

I have a number of reports for which I'd like to produce dynamic parameters - the list of values can't be pulled straight from the relevant table as some of them are soft deleted, which is indicated by an boolean attribute either set to 0 or 1.

So for example, I may want to produce a dynamic list consisting of Names pulled from a table:

Bob Jones
John Smith


but in the table the list will appear like:

Analyst_Name                Deleted
Bob Jones                            0
John Smith                           0
Joe Bloggs                           1

As Joe has been soft deleted, I don't want him in the parameter list - any ideas how I could achieve this please?

Thank you

 

Yes it would be possible to create a View on the database - but I'm not sure how I would then use that as part of the paramater itself.

 

Could you please advise?

 

Thanks, JL

 

But when I run the report, I see: "cannot determine the queries necessary to get data for this report"

 

The view itself is not linked to any tables within the Database Diagram - dunno if this makes a difference?

 

Any help would be really appreciated, JL