Using SQL Syntax query with Prompt

[Canata_013]

Hi to All,

   I am just in a hurry and has no time reading other post.
   I am developing a report in Report Studio.. My question is, is there a way in SQL Query using Native SQL Syntax where in we can use a filter other than Prompts? Please see below.

    >> SELECT SUM(SALES_AMOUNT)
         FROM SALES
         WHERE CUSTOMER = #prompt('prm_customer')#
    >>

    This works fine in SQL Query.


    Is there a technique where in I can filter my SQL Query which will depend on another query in my published package? Please see below again:

  >>SELECT SUM(SALES_AMOUNT)
       FROM SALES
       WHERE CUSTOMER = #[Layer1].[SALES].[CUSTOMER]#

    I'm thinking of something like that.. Is that possbile?? Can someone direct me to other links/post with common problem.

Thanks,
Alvin

 


 

[d_idaho]

Hi Alvin, I have exactly the same problem. Did you find any solution ?

[cognostechie]

Create an inner join , create a Model Query subject , create a filter in the MQS to force the join.