I would hazard a guess that it's hardware limitations. Are you running sufficient RAM on your server? Are you running any other services apart from SQL on the server?

SQL Server...

I assume you're talking about the display at the top of the page, where you select your dates, and other parameters? If so, this isn't a problem with SSRS, it's...

For questions like this, it best to give us some sample data and table set up.

Can you provide some create and insert statements? It would also probably help to...

The latest post you've made states that you've got a connection error, which is separate to the above. SSIS is advising it can't connected to ServerDB. Check that your login...

To pass a variable in SSIS in the Execute SQL Task node, you use a ?, and then add map your parameters on the Parameter Mapping Pane.

So, for example. Say...

I'm afraid I don't really understand what you're asking for here. Can you provide some detail on what your sample data looks like and the end result.

Your best option, if you don't want the data to be shown at all, is using a filter on your tablix.

Open the Tablix properties window, and then select the Filters...

It might be easier to show you if you provide some sample data. Can you provide a create statement with some fictitious data, should help me to explain better, won't...

Sorry I misunderstood the question initially.

Is this dataset likely to grow at all? If you have multiple "applicable" resuts for a single locations (like dubaiin ths example), I can quickly...

tmmutsetse (5/30/2016)

---

Good day Experts,

I have a table with the following columns Name , Memory, Model

I...

You're almost there. A join will always return every valid row, so yes, you'll have multiple joins here.

A better approach would be using APPLY, as follows:

SELECT a.Time, b.Time AS [Time(B)],...

No filters, just groupings. This doesn't really answer why it takes 10 minutes to "load". There's not many rows...

Have you tried running a trace to see what SQL SSRS is actually running? If you have parameters involved, it may be it's passing a value you're not expecting and...

I hate to say it, but your 9% is correct, for the maths you've supplied at least. You're creating an overall % using that formula, not an average of your...

Create a parameter in your report, and create filter on your results based on that. Then set the parameter to the value you need for that subscription so that you...