Separate table, no. The way to handle this is to pull that separate table into your dataset query.

If you can get away with links instead of page numbers, you can use a document map.

Look at your parameter data. Does any of it have a quotation mark in the actual data?

=ReportItems!textBoxName1.Value - ReportItems!textBoxName2.Value

This should work if you are subtracting within the same scope (Group or detail)

There is a configuration tool in Start >> Programs >> Sql Server >> configuration tools

I recommend you move this to one of the Integration Services forums, you will probably have better luck.

http://www.sqlservercentral.com/Forums/Forum364-1.aspx

Why do you get 3 qsoNOpercentage columns? Without knowing the data structure etc., I think you would be better off going a step back and reworking the query that...

Inches

In SSIS you can use a Derived Column transformation and use REPLACE. You will find it in the String Functions folder in the Derived Column transform

What is the error you are getting?

What is the expression that you believe is the problem?

So you have a cartesian product at the district level? What error do you get when you try to do the sum?

Select the desired textboxes and click the "B" button in the toolbar for bold, and then click the Pencil Icon with little color squares beneath it (4 icons to the...

One word that describes so many feelings. I came here to the WOTD thinking I would just put Monday, but apparently it is a wide running theme...

If you are only getting 4 of 2000 rows back, and you should be getting more, then there is either a problem with your data or your query, you should...

sreeya (5/6/2011)

---

Trying to run a report that retrieves data from cube. A particular column has no values in it, so when I execute the query in query designer it not...