So, what is the answer?

Rob --

Two things:

1) Did you actually modify the query to handle parameter sniffing? From my own experience, I've had situations where parameter sniffing was the problem -- modifying a...

We applied a data viewer immediately after the excel data connector, and could see that the values are distorted coming out of the connector before being handed off to a...

Thanks for such a quick reply, Phil.

As you suggested, I exported a spreadsheet as a text file. The values in the text file match the values in the spreadsheet...

Couple of quick thoughts for you:

1) Not sure a radar plot is possible in SSRS -- (Don't see it as an option in SSRS 2005, at the very least)

2) If...

Ryan Duclos wrote an article for Redgate's technical solutions site, simple-talk.com, that may be of value for you. He discusses creating a calendar report in SSRS 2005:

https://www.simple-talk.com/sql/reporting-services/ten-common-sql-server-reporting-services-challenges-and-solutions/

[/url]

He also wrote a...

I believe you need to be a local admin of the server that SSRS resides on. Anyone who is a member of the local admin group should be have default...

Couple of quick thoughts for you:

1) The key to making this work is to strip the unit of measure from the initial dose. For example, if a drug dose...

Couple of thoughts for you to consider which might not give you the answer you desire, but certainly provides options:

1) Pie charts are not the best data visualization tool. Recommend...

Any chance you can provide a screenshot, perhaps from excel, of what you are trying to accomplish with the graphs?

Your post doesn't explain if your graph reflects a time series:...

One last thing, the code I posted is essentially a proof of concept. Ultimately, for SSRS reports that I build that involve a multivalued parameter, I pass the parameter to...

Now, assuming you have a tally table already or built one from the script I provided in the previous post, below is the sql to build a sample test table...

OK -- you've can create stored procs and such... good to know.

Next question -- do you have a "numbers" table or "tally" table on the server?

If not, here's some SQL...

Barbara -- Just out of curiosity, do you have permissions to create a stored proc or function on SQL server from where the data is being sourced? If not, then...

Barbara:

A couple of thoughts come to mind. Top of my head, I don't think SSRS has an equivalent built-in feature you described in Crystal. So, for the moment, I'll offer...