Viewing 15 posts - 1 through 15 (of 183 total)
Another thing to check is permissions in SSRS need to be given all the way up the folder chain. If you have a Reports folder and within that you give...
March 30, 2020 at 5:54 pm
AFAIK you have to use the full address http://servername/reports because, well, that's the address. I save the keystrokes of typing the report manager addresses on our various servers...
November 12, 2019 at 6:43 pm
Try adding to your query something like:
WHERE (col1 IN (@parm) or @parm IS NULL)
Then in Visual Studio make sure the parameter @parm can be NULL.
October 21, 2019 at 6:29 pm
It looks like you probably want to group your report on AccountNumber and/or PatientName. That gives you a header with that grouping and sub-listings with the details.
October 7, 2019 at 6:00 pm
A couple suggestions - one, you could try putting the row count text box in the footer, so it will always be at the bottom. Or, perhaps placing the data...
September 10, 2019 at 7:50 pm
Make sure the top border of the textbox below has the same settings that you want for your bottom border. I've seen instances where the border settings for a neighboring...
September 5, 2019 at 5:18 pm
Do you have clustering/load balancing in your environment? We had an issue with report subscriptions sometimes failing, and it turned out that we had two servers in the cluster that...
August 30, 2019 at 5:20 pm
Part of the problem may be there is an errant comma in your Partition:
PARTITION BY [c.col2,]
Should be (if you only want to partition on the one field):
June 13, 2019 at 5:43 pm
I have used SSRS 2008 against a SQL 2005 DB, so I know backward compatibility was part of the package then. I would assume it still is.
April 11, 2019 at 5:15 pm
I'm not sure about plan guides, but in regular queries it's legal in 2005. If you are using aliases the nolock needs to come after the alias.
This will generate...
April 9, 2019 at 5:42 pm
My understanding is you can change data on the replicated server, but it will remain changed until the subscriptions are re-initialized (which you could do nightly). However, I think altering...
March 28, 2019 at 11:31 am
Pasting the error into google yields this as the first hit: https://support.microsoft.com/en-us/help/106167/error-message-not-enough-server-storage-is-available-to-process-this-cIt seems to be a Windows error, not SQL.
March 13, 2019 at 12:06 pm
I have mainly used shared datasets where I have common lookups for parameters in reports (location, section, accounting category, etc.). Rather than make a new dataset every time I have...
February 27, 2019 at 1:06 pm
Would it work to change your select for that field to something like LEFT(Field, 255)?
February 14, 2019 at 12:51 pm
You should be able to easily do this with a nested IIF expression in the color property of the field in question.
February 13, 2019 at 1:44 pm