Could you not just put a table after your other table, with it's rows, or the whole table itself, having a expression for its visibility?

This is more likely that you have some white space under your final item in your report, which SSRS "can't fit" on the same page because the item above is...

Jeff Moden (7/7/2016)

It comes from a computer. It can be changed. It's ok to do a temporary work around but they...

Would it not be a better option instead be to treat all columns coming in at the source as strings and then use a Data Conversion Transformation Note and try...

Really should of remembered it was 8 not 4. We only recently(ish) split and moved our TempDB Data files and I remember reading this is standard in 2016 and so...

What happens if your data has more than 8 rows, is that ok?

Are you talking visually when viewing the report in the web interface, or when exporting (For example, in Excel create a new worksheet every 100 lines)?

The best way to do this would be using a series on your chart and using a stacked column chart. You can then have different colours like you have shown...

Feel a little cheated that I had to choose 3. Was confident on the first 2, guessed the 3rd, to be told the 2 I was confident on were right...

This question seems to be asked here.

To avoid confusion, you should really only post a question once, and continue to use the same account. It can makes things difficult for...

You only answered one of my questions there, and didn't really, as there's no create statement, select statement, etc. To help you, you need to help me. Please answer my...

CAn you supply some opf the folloowing, so I can help further, your previous comment didn't really build on it.

Do you have access to the SQL serv Query?

What version of...

If you are exporting different companies, how are you telling the report to export for the different companies?

The best way to do this would be to have 5 different subscriptions....

To use queries such as this you need to enable Ad Hoc Distributed Queries.

This does have certain security implications, so here's the link to MSDN, which explains about it, and...

I feel like a Merge would be a better idea here, rather than a delete and insert. Then you can update or insert, depending on if the record is there...