Viewing 15 posts - 1 through 15 (of 191 total)
This won't help you after the fact, but when I have lots of textboxes I find it useful to stick them in a rectangle. That way I can just shift...
July 16, 2020 at 5:13 pm
Before your query, put SET STATISTICS TIME ON, and after the query, put SET STATISTICS TIME OFF. On the messages tab, it will tell you how long each component took...
June 27, 2020 at 7:08 pm
I'm not familiar with Oracle or Toad, but maybe one of them is enforcing a semicolon terminator? Try adding a semicolon at the end and see if the error goes...
June 25, 2020 at 6:49 pm
A simple CASE expression would suffice for this, something along the lines of:
CASE WHEN IS_DIABETIC = 'YES' THEN 'OUI'WHEN IS_DIABETIC = 'NO' THEN 'NON'ELSE 'Whatever you want...
June 8, 2020 at 5:54 pm
I don't know a way to do it directly with SQL, but you could do it using Visual Studio/SSRS to make a report. When you make a report with page...
June 6, 2020 at 6:45 pm
Is there a blank footer row in the report? Those will often look invisible when you are previewing or running the report, but will show up when you export it. ...
April 25, 2020 at 5:15 pm
If it runs fine for other parameters but not for this one, it might be a bad parameter sniffing issue. The stored proc is third party so you can't modify...
April 16, 2020 at 6:23 pm
I would start by checking indexes. Replication usually doesn't copy indexes, so the replicated DB most likely doesn't have indexes that Prod does.
April 14, 2020 at 8:01 pm
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