Might be as simple as

=Sum(IIf(Fields!Factory.Value <> "ABC", Fields!Total_Progs.Value,0))/Sum(IIf(Fields!Factory.Value <> "ABC", Fields!Anotherfield.Value,0))

If you need the total size of Total_Progs/(Total_Progs + Factory), you would have to alter it a little.

Note, you will...

This works...

SELECT A, B, C, txt

FROM

(SELECT 1 AS A, 2 AS B, 3 AS C

UNION ALL

SELECT 2,1,3

UNION ALL

SELECT 4,1,2) x

CROSS JOIN

(SELECT 'Text1' AS txt

UNION ALL

SELECT 'Text2') y

In your...

(See, told ya Eirikur could do it... even if I can't remember how to spell his name!)

but be sure to get the second edition (or later). The first one was a bit wonky.

Eirkur would no doubt be able to do this in a nanosecond, but in a nutshell, you would have to use XQuery to do this. Here's the article that...

Error: The buffer manager cannot extend the file "C:\Users\}.tmp" to length 2030084 bytes. There was insufficient disk space

Bigger hard drive? Space on another network drive?

Do not pass go. Do not collect $200. Go directly to the bookstore and by a copy of Ralph Kimball's book. he explains how to build a star schema/Data Warehouse...

What if you put a parameter in the place of the literal numeric values?

IIf(((DatePart("q",Today)=@theQuarter) and Fields!Qtr.Value=(@theQuarter-1)), False,True)

Did you increase the timeout on the report?

Exercise your googlefu!

http://blog.sqlauthority.com/2010/02/04/sql-server-get-the-list-of-object-dependencies-sp_depends-and-information_schema-routines-and-sys-dm_sql_referencing_entities/

and dig around on sqlauthority... it's probably on there.

can you upload your report (with an embedded SQL statement?)

hard to tell from here.

The problem is that you have to remove the duplicates before you insert the batch of records.

This is one option:

insert into table_2 (col1,col2,col3)

select DISTINCT col1,col2,col3

from table_1 t1

where not exists (select...

Are you sure that's the output you're expecting? Don't you mean you just want a normal output that you get from a comma-separated list of column names? Shouldn't the...

Could you post some consumable sample data? It would make it a lot easier to answer your question. And include the correct answer based on the data provided.

Here[/url]...

can you post the CREATE TABLE and INSERT scripts so we can reproduce the problem?