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
Hi Alvin, I have exactly the same problem. Did you find any solution ?
Create an inner join , create a Model Query subject , create a filter in the MQS to force the join.