sku370870 (5/9/2012)

---

You've spend hundreds of hours developing. A lot of your business logic is in your stored procedures and functions. You can't afford SQL Server hosting of your own. You...

This article released today is something I wish I'd seen about the time I wrote this forum post:

http://www.sqlservercentral.com/articles/RegEx/88586/

I...

Pensions are a frightening thing - 5 years delay can wipe a few grand a year off your return so save, save, save!

I know people only just starting to...

First off - the Peter Principal

http://www.guardian.co.uk/education/2010/nov/01/random-promotion-research

If you've ever thought you boss was incompetent - it could be because he was too awesome at his last job and...

Sounds like you're removing your detail group i.e. your lowest grouping level that tell the report what field to iterate over to display. Without this piece of info it's...

Two things string to mind (bad pun time!) to check for:

Is it trying to sum a string (i.e. your product code)

Is it trying to format a string as number

Check out...

I think you have to create a table/matrix outside the graph itself, however, there are some neat ways of making it correspond to the chart (like a legend) and even...

I often get export issues when my report elements don't align well.

Best thing to do is get the report in BIDS and make sure that everything conforms to a nice...

Waste to Energy power is a great technology, and the conception that the process is smelly is inaccurate. Obviously the input tends to be smelly but so long as...

Not quite.

BI and OI have five steps:

- gather data

- cleanse data

- consolidate data

- make it accessible (practical)

- present data

- keep the data as the one and only truth about the...

Frankly - so long as there is as Excel in your company you have a BI application. Understanding that there is always BI/MI running around the place will help...

I'd say that doing the delimiters in the report is probably your best option as you can test it on the report by stripping out speech marks and adding them...

Is it showing an error or a white space where the report should be when deployed?

Does the individual report work fine?

I found this forum post presenting two options using either OLEDB or ODBC.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=130650

I've used the ODBC connector before (for MySQL) and you don't have to go through the...