Hello!
I need some help! I created a report in Report Studio using a SQL Server datasource.
The report is a crosstab and connected SQL object, needed to do the query manually because the base was not all relationships. The report runs perfectly, the problem is that I need to create two prompts using two fields in this query. The first prompt will return me the year/month, and the second store name.
The problem is that when I create the prompt using the wizard prompts, the report is not filtered :(
Then, manually added two parameters in the query:
[Year_Month_REF] in ?P_YearMonth?
[CD_Store] in ?P_Store?
When the report runs two prompts selection and search appear for me, but I need to change prompts to Value Prompt, how to do this if you do not have prompt page in the report, only the parameters??
ps. I have attached the screen prompts for you to see.
Thank you!!!
:)
Hi,
The answer is to create a prompt page and define the prompt types you want on the page. Is there a reason you don't want to do this?
MF.
Yes,
When I create a prompt page with the "Value Prompt", using the wizard only have the option of choosing packet fields, but this report was created from a SQL object (not used packet fields), and when I run the report, the prompts are displayed, choose the parameters but does not filter ...
I need to make the prompts point for the fields of my query, and not for packet fields, is it possible?
Thank you so much!
Yes. Once you have defined the prompt you can change the query which drives the prompt from the prompt's properties. Probably the best bet is to code a new SQL query specifically to drive the values to display in the prompt.
Unless you define a prompt page you are not going to be able to control the prompt type.
Cheers!
MF.
Hello,
I did another query using packet fields, and created a relationship with the fields of the sql query, I created a prompt page using packet fields and it worked!
Thank you for the tips!
Cheers!