ashish.chaudhari (1/29/2009)

---

I am using Function in Report properties->Code to defined the colors and passing the value to this function.

However if i had to control the colors depending on numeric values...

Lowell (1/28/2009)

---

i think the error is here:

the select into would insert a column name dColumn_name:

insert into #DISTINCTC SELECT Column_Name FROM INFORMATION_SCHEMA.COLUMNS WHERE Table_Name = 'AGEN'

------------------------

--select * from #DISTINCTC

the cursor looks...

Hi Rachitha,

I am not getting your question at all... Could you make it more clear?

If you want to calculte the Max value from your dataSet then you can go for...

Hi Rachitha,

Try this:

=Max(Fields!FieldName.Value, "DataSetName")

Hi,

Personally I believe that we can't paas variable into child package.

Best thing you can do is that create two child packge having the variables and call these packages into parent...

Hi,

I would personally suggest you not depend on SSIS to accomplish this work. What you can do is add all stuff in Stored Procedure (keep Best Practice cases in mind)...

This is not possible in SSRS 2005 because richTextBox is not supported in SSRS

I think Y have copied this in textbox (ReportItem) expression.

Instead, You have to copy it in Format properties.

You need to configure your package.

You can use Package Configuration Organizer for this.

Later on, you can use config file to change your connection variables.

Hi,

Sorry for inconvenience duw to my post.

There is a little bit change in my script...

I have updated it in my post.

IF EXISTS

(

SELECT 1 FROM master.dbo.sysobjects...

Hi Mirza,

Whether you need a script for list of all Contries,States, and cities by using joins

or

you need a...

...

Hi Gila,

I am very comfortable with T-SQL and serious about...

Hi Chuck Rivel,

Thank you for your help!!

I'll try this and I hope it will work.

DBCC FREEPROCCACHE Removes all elements from the procedure cache.

Use DBCC FREEPROCCACHE to clear the procedure cache. Freeing the procedure cache causes, for example, an ad hoc SQL statement to be...