"Frank Ashley" <a@a.com> wrote in message
news:%23Lr4fYg3EHA.3616@TK2MSFTNGP11.phx.gbl...
>I have two parameters that are filled with the results from two sprocs.
>Either both or only one is to be passed into the report sproc. Is there any
>way to add say -1 as a datarow to one of the datasets so I can trap this in
>the report sproc and not process this parameter?
>
>
> Thanks
> Frank Ashley
>
>
>

"Frank Ashley" <a@a.com> wrote in message
news:uGsbkxh3EHA.2248@TK2MSFTNGP11.phx.gbl...
> If I used text to query the Db then pasting that in would be it but how do
> I append that to a sproc that I'm calling?
>
> eg
> GetValuesFromLookupTable UNION SELECT -1, "All"
>
> throw errors as it tries to execute
>
> GetValuesFromLookupTable UNION SELECT -1, "All" as a single sproc
>
>
> Thanks
> Frank
>
>
> "Jeff A. Stucker" <jeff@mobilize.net> wrote in message
> news:e50dBgg3EHA.1192@tk2msftngp13.phx.gbl...
>> Yes, you can use a UNION in your source query for the parameters.
>>
>> SELECT parmValue, parmLabel FROM parmTable
>> UNION
>> SELECT -1, "All"
>>
>> --
>> Cheers,
>>
>> '(' Jeff A. Stucker
>> \
>>
>> Business Intelligence
>> www.criadvantage.com
>> --------------------------------------
>> "Frank Ashley" <a@a.com> wrote in message
>> news:%23Lr4fYg3EHA.3616@TK2MSFTNGP11.phx.gbl...
>>>I have two parameters that are filled with the results from two sprocs.
>>>Either both or only one is to be passed into the report sproc. Is there
>>>any way to add say -1 as a datarow to one of the datasets so I can trap
>>>this in the report sproc and not process this parameter?
>>>
>>>
>>> Thanks
>>> Frank Ashley
>>>
>>>
>>>
>>
>>
>
>

"Jeff A. Stucker" <jeff@mobilize.net> wrote in message
news:e50dBgg3EHA.1192@tk2msftngp13.phx.gbl...
> Yes, you can use a UNION in your source query for the parameters.
>
> SELECT parmValue, parmLabel FROM parmTable
> UNION
> SELECT -1, "All"
>
> --
> Cheers,
>
> '(' Jeff A. Stucker
> \
>
> Business Intelligence
> www.criadvantage.com
> --------------------------------------
> "Frank Ashley" <a@a.com> wrote in message
> news:%23Lr4fYg3EHA.3616@TK2MSFTNGP11.phx.gbl...
>>I have two parameters that are filled with the results from two sprocs.
>>Either both or only one is to be passed into the report sproc. Is there
>>any way to add say -1 as a datarow to one of the datasets so I can trap
>>this in the report sproc and not process this parameter?
>>
>>
>> Thanks
>> Frank Ashley
>>
>>
>>
>
>

"Jeff A. Stucker" <jeff@mobilize.net> wrote in message
news:%23cttPLi3EHA.3756@TK2MSFTNGP14.phx.gbl...
> You have to modify the stored procedure and put the UNION in there.
>
> --
> Cheers,
>
> '(' Jeff A. Stucker
> \
>
> Business Intelligence
> www.criadvantage.com
> --------------------------------------
> "Frank Ashley" <a@a.com> wrote in message
> news:uGsbkxh3EHA.2248@TK2MSFTNGP11.phx.gbl...
>> If I used text to query the Db then pasting that in would be it but how
>> do I append that to a sproc that I'm calling?
>>
>> eg
>> GetValuesFromLookupTable UNION SELECT -1, "All"
>>
>> throw errors as it tries to execute
>>
>> GetValuesFromLookupTable UNION SELECT -1, "All" as a single sproc
>>
>>
>> Thanks
>> Frank
>>
>>
>> "Jeff A. Stucker" <jeff@mobilize.net> wrote in message
>> news:e50dBgg3EHA.1192@tk2msftngp13.phx.gbl...
>>> Yes, you can use a UNION in your source query for the parameters.
>>>
>>> SELECT parmValue, parmLabel FROM parmTable
>>> UNION
>>> SELECT -1, "All"
>>>
>>> --
>>> Cheers,
>>>
>>> '(' Jeff A. Stucker
>>> \
>>>
>>> Business Intelligence
>>> www.criadvantage.com
>>> --------------------------------------
>>> "Frank Ashley" <a@a.com> wrote in message
>>> news:%23Lr4fYg3EHA.3616@TK2MSFTNGP11.phx.gbl...
>>>>I have two parameters that are filled with the results from two sprocs.
>>>>Either both or only one is to be passed into the report sproc. Is there
>>>>any way to add say -1 as a datarow to one of the datasets so I can trap
>>>>this in the report sproc and not process this parameter?
>>>>
>>>>
>>>> Thanks
>>>> Frank Ashley
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>