Change the Prompt type - HELP!!!

[lorenmario]

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!!!
:)

[MFGF]

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.

[lorenmario]

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!

[MFGF]

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.

[lorenmario]

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!