Parameter Help

[AnnieRider]

I have a report that has two parameters, one to select the client record (a Non Query with null default) into which Users will type the Client_Ref.

The other selects required history types the User wants to view for that Client, I have set this to MultiValue with no default.

My SQL query is

WHERE (dbo.CR_CLIENTS.Client_Ref = @Client_Ref) AND (dbo.CR_HISTORY.HistoryType_Ref IN (@HistoryTypes))

I have included in my report the reference table that denotes the Description for each History Type and I want the Users to be able to pick from the description rather than the ref.

If I do this using From Query I get the error message

The report parameter 'Histories' has a DefaultValue or a ValidValue that depends on the report parameter "Histories". Forward dependencies are not valid.

It works if I use Non-Queried and type in the info, but I'd like to get the problem fixed as lots of our reports are run like this and I'd rather not have to type in the parameter data for all of them (some of our reference tables are quite big)

Thanks
Annie

 

[xlbo]

Are you using a seperate query to get your list of values? Sounds like you may just be using the same one you have for your main data set....? If this is the case, simply create a seperate dataset based on:

Select distinct dbo.CR_HISTORY.HistoryType_Ref, dbo.CR_HISTORY.HistoryType_DESC
FROM dbo.CR_HISTORY




Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[AnnieRider]

Thanks as ever Geoff, I'm rather bemused at having to create another dataset for parameter drop downs (it's not like Crystal is it?!) but I have to say I've done alot more this week and am slowly getting used to it ) possibly even liking it.

 

[xlbo]

No worries - you don;t have to create a different data set for your parameter but it's often much cleaner and easier to do so

I never used Crystal really - was on Business Objects before RS but I do like RS - best thing I think is the ability to make pretty much any property the result of an expression....allows for a lot of dyanamism...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question