As you can see in my Query I have 5 parameters for the report.

1) ApplicationName: 'Informatica', 'Velocity' & 'MSCloud'. (I have manually enter the 3 values in parameter)

2) Environment:...

Looks like I need some serious help. No matter what Option I try I'm getting error on the parameter ServerName. I'm not able to cascade this parameter. Below is the...

both the queries pull from save view. the result set changes according tot he selected parameters in the report. Thats the plan unless you have better way to do it.

I have got this script from old post of Gail. I have few small questions on this. Please let me know so that i can start using this for my...

Thanks but. Me selecting from sysjobhistory will not work in my case.

I just want to know if I give 2 dates, how many times does 2:00 , 8:00, 14:00 ...

I just read online that While enabling CDC, we can point the CT table to reside on different filegroup. Now my question is is there a way to move the...

actually there was no dot... its just 'BAK' I should not have typed dot while i was replying to you.

Yes I did. '.BAK'. Is it case sensitive? should I mention '.bak' instead?

Yes, I understand and I do know that holding up an open query fro so hold is certainly not good. But as per our design of the Environment I'm restricted...

I guess It should be stored in the SQL Server Logs. but not sure what was the retension period your SQL Instance was set to.

My Bad I might have miscommunicated. My estimate of 15 mins means it would take 10-15mins min for the Post ETL process to come and hit this table that I'm...

That worked thanks a lot. You saved me big time tonight..

How can I add a condition to the below expression? Please help

(CInt(Left(Fields!Runtime.Value,1)) >= 2,"Red"),"Transparent"

That was just my thought. I mean please share your idea how mark the background color as red.

Is there a way that I can take only the first digit of the column and see if its >= 2 and mark it as red color in the expression?