Viewing 15 posts - 46 through 60 (of 200 total)
My impression is that all 12 will run concurrently. AFAIK this won't cause any extra subscription blockage, just the usual "multiple processes accessing the same data" blockage. These are just...
December 27, 2017 at 1:23 pm
I don't think the header needs to have the same number of boxes as the tablix. It's just that the ends of the header box should line up with columns...
September 15, 2017 at 1:07 pm
OUTPUT needs to go between the DELETE and WHERE:
Delete from X
OUTPUT DELETED.[PKey],
DELETED.,
DELETED.[C],
DELETED.[D],
DELETED.[E],
DELETED.[F]
INTO Y
where X.Pkey...
August 30, 2017 at 3:30 pm
To be sure you've got the most recent version, the best way would be to use some sort of version control (we use Vault). Barring that, you can download the...
August 30, 2017 at 1:48 pm
It's hard to say without knowing your data, but COUNT and SUM do two different things. Let's say we have three values in Booked: 0, 1, and 0. The COUNT...
August 25, 2017 at 4:34 pm
The stairway to Indexes on this site is a good starting point.
Gail Shaw has a good article on ordering columns in indexes.
August 15, 2017 at 4:00 pm
For starters, you probably don't need that DISTINCT in the subselect, nor should SalesLines be included in the GROUP BY. This could easily be done with dynamic SQL. A cruder...
August 9, 2017 at 4:14 pm
I'm not familiar with the perfmon counters, but I have seen wonky reporting in Replication Monitor. Several times I've seen it list a Publication's performance as Excellent, when it actually...
August 4, 2017 at 4:21 pm
The Stairway articles concerning replication on this site are a good start:
The last step is specifically on troubleshooting:
July 27, 2017 at 1:23 pm
AFAIK, you should be fine. I would assume the standard edition should be able to run any query SSRS passes to it and hand the data back. I've done the...
June 23, 2017 at 1:32 pm
If you put a page break after Tablix A, it should render on the first excel sheet and the others should be on the second.
May 22, 2017 at 5:46 pm
April 27, 2017 at 11:59 am
Rather than converting the date to INT, I would convert the User.id to Varchar. UNION returns the data type that has precedence among the various results. Currently your date is...
March 17, 2017 at 3:20 pm
Add groups for state and country, with subtotals below each group.
March 15, 2017 at 12:15 pm
I think you've got it right - parameters are what you probably want to use. Filters are more for hardcoding certain limits on the report. For instance, your data set...
March 13, 2017 at 11:36 am
Viewing 15 posts - 46 through 60 (of 200 total)