I've problem with Paratmeter in report studio. The column works fine with Hard coded value
when I select a particular field in value prompt, the report breaks
can any one explain ? Thanks for your ideas
Can you give us the error message please ?
No error message here : when I run the report after selecting the prompt, reports shows blank white/ page
is it because use value is different and display value is different and you might be using the wrong thing in the filter... just a wild guess...
use value is different and display is different. Here I'm using static choices and if I hardocode the filter it shows the correct value. If I use drop down and select the field from drop down the report breaks.
I used the correct values from the Data Base
Sounds like something is wrong with the query that populates the drop down. Perhaps the values don't exactly match the database column you are filtering on (e.g., char vs. varchar where 'ABC' <> 'ABC ').
I don't think the report breaks, I think it is just filtering for a value and finds no matches. Try putting a no data handler on your list to display a message 'no data' or something like that. Then you can confirm if that is the case or not. Also look at the generated SQL for both approaches to compare and see what is different about the hard coded value vs. the parameter selection.