The CONSTRAINED flag requires the selected member name to be resolved to a qualified member name. Drop a textbox on your report and set it to expression:

=Join(Parameters!<parameter name>.Value,", ")

Run...

hi,

write following query in a dataset and then add that dataset to the report parameter named say => ServerName

select distinct servername from temp2

union

select 'ALL'

Add the following query to the...

Hi,

Before the insert or update takes place attach a Execute SQL Task and Write BEGIN TRANSACTION.

AND if some error occurs divert to an Execute SQL Task and Write in it...

Raunak Jhawar (9/25/2010)

amarsale (9/24/2010)

i have been asked to build a datawarehouse cube which includes data from three product master tables. So i have to bring together each product that exists...

thanks..

I will check it out.

Regards,

Amar

Hi,

There are different products in different product master(pM) tables so if join is used on PK the query will return zero rows.

The Grand product master table will have maximum columns...

Hi,

does the for each loop iterates based on the no. of rows from select statement you mentioned ??

Regards,

Amar

page break at start doesn't do anything. i have tried it.

Regards,

Amar Sale

Or you can also Try this....

Replace(NAME,chr(34),"")

Regards,

Amar Sale

Hi,

i didn't get the problem ur facing. Try to use some images to show ur problem and also be specific ?? what r u trying to achieve ??

Hi,

You have to check the DataType of Both the columns. i.e,if you have to convert a column of datatype DT_WSTR to DT_STR then the first error (Columns "Derived Column T_TIME"...

Hi,

1) Select the field to which you want to add conditional background color and press F4 to open the properties window.

2) Then CLICK on the dropdown box next to BackgroundColor...

Hi,

1) Select the field to which you want to add conditional background color and press F4 to open the properties window.

2) Then CLICK on the dropdown box next to BackgroundColor...

Hi,

I Think i had a hangover 😀 but it's gone.

Just do what raunak said...

Regards,

Amar Sale

sum(Recieved_Late) / (SUM(Recieved_Late) + SUM(Recieved_on_Time))

add 'P2' to its format