Jim has one idea.

Another way to do it is to script requiring SQLCMD mode, then you can specify the connection in the script. You can include this snippet...

Have you added a Row Group on Division? Just doing the Sum() on the detail row isn't going to add grouping. You need to explicitly add a group....

I'd open a support case for this since you have applied the CU that should have fixed this issue. It is unlikely you'll get an answer on a forum...

Once you have deployed a report the original settings for parameter defaults are not changed when you re-deploy the report. If you need to add or change defaults to...

Sean Lange (8/20/2014)

---

dirk.dromgoole (8/20/2014)

---

I need to add a check constraint on a field that checks the time of the date to make sure it is 23:59:59.997. When records are...

If you provide table DDL and some sample data as mentioned in the first link in my signature it would make much easier to provide accurate and tested solutions.

Whenever you...

Since you are returning everything in one data set you need to use filters on the tablii. Here's an article on filters that should get you started.

For data region...

If I understand your question correctly, the answer is no. You cannot make the report header appear above the parameters. The parameter selection area is not really part...

abigail.tomlins (8/20/2014)

---

Hiya

The report is calling a stored procedure so speed wise it should be ok, I'm wondering whether it's just the amount of data it's trying to retreive as...

Like2SQL (8/19/2014)

---

Thanks for the responses guys. But the reason I asked for some numbers is because, as mentioned by some on this thread, the recruiters often try to get me...

Greg Edwards-268690 (8/19/2014)

---

Koen Verbeeck (8/19/2014)

---

David Burrows (8/19/2014)

---

Koen Verbeeck (8/19/2014)

---

higgim (8/18/2014)

---

Not a happy chap with some of the help being offered! Go figure 🙂

Qira (8/18/2014)

---

Dear Mr Higgam,

You're helping me sir. Thanks...

I agree with most of what gbritton1 has posted.

This type of business logic does belong in the application and a submit button shouldn't be enabled until all the data passes...

mnovosel (8/18/2014)

---

Thanks for your response! Actually I would just like the field to be added as a column but was thinking that the union could combine the data from...

Something like this could work:

DECLARE @string VARCHAR(1000) = 'this is a string with some non-printable characters at the end '

/* 67 characters including spaces at...

clayman (8/18/2014)

---

Thanks for your response.

The result sets returned for those data sets are different (number of columns returned / data types) so not sure if it's possible to do...