Could the scale of your graph be responsible for flattening the spikes?

Your report parameter needs to have a data type of Date/Time

Atlas

Interesting question, and an interesting bit of reading. However

That quote comes from a section in whch the topic is encryption and encrypted data; SQL Server encryption always uses a...

Smash

I had to do a little research. I definitely learned something useful. Thanks

Never

Giants

If I am not mistaken RS looks at the fields in the select query to determine what fields to display. First, from your example, I don't see a dataset...

Dairy Queen

I would probably do it in the SP, yes.

If you want it to throw the error when they enter the value, then no. You could build the report dataset to do parameter validation and feedback an error...

A couple of ideas.

First you might want to try a horizontal bar chart and just let all items display. This might make your paging easier.

Another option is to add...

I am guessing but you may be running up against the character limit for your data type.

Are you using a JOIN of the original parameter data to feed your second dataset?

JOIN(Parameter.Value,", ")

Is your second dataset being fed by an inline query of stored procedure. If...