Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Cascading parameters Post Reply Post New Topic
Author Message
automaster
Newbie
Newbie


Joined: 09 Oct 2008
Location: Romania
Online Status: Offline
Posts: 2
Quote automaster Replybullet Topic: Cascading parameters
    Posted: 09 Oct 2008 at 5:09am
Please help me resolving the next situasion:
I have to create 5 DCPs in a report that is using a stored procedure. For that, i've created a command that returns a table containing all the possible values for my parameters. But it doesn't work! Some of the values are lost in the sequence of choosing the parameters. In first step it's ok, all the possible values apears. The next step, the same! But further, some of the values are lost... in the last step i have only one value for the "submodel" parameter.

Another problem is that after first step, some of the values apears twice or more in the list of possible values..

My command is:

select distinct
        isnull(VEH.CLASS,'None') [Class],
        case when VIN.PROPERTY = 'C' then 'Stock'
               when VIN.PROPERTY = 'P' then 'Demo Car'
               when VIN.PROPERTY = 'L' then 'Auto leasing'
               when VIN.PROPERTY = 'F' then 'Personal use'
               when VIN.PROPERTY = 'M' then 'Another site'
        else 'None' end [Type],
        isnull(FUR.NAME,'None') [Suplier],
        VEH.MAKE [Make],
        isnull(VEH.MODEL,'')+' '+isnull(VEH.SUBMODEL,'') as [Submodel]
from VINSS01           VIN
left outer join VIBBS01 VIB on (VIN.VINSID = VIB.VINSID)
left outer join VEHI    VEH on (VIN.VEHIID = VEH.VEHIID)
left outer join VSELS01 SEL on (SEL.VINSID = VIN.VINSID)
left outer join SUPL    FUR on (VIB.SUPLNO = FUR.SUPLNO)
where VIB.RECNO is not null

Where did i go wrong?
Can anyone give me a hint?

Thx!!!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.