Yes, But there are two separate Main reports.

So, In actions If I pass the report name as X it will work fine. But when I want to go to y...

Can you add the columns you want in the Query and just bring the Total Column from there?

This resolved the Issue

case

when right(rtrim(ApplicationType ),1) = ',' then substring(rtrim(ApplicationType ),1,len(rtrim(ApplicationType ))-1)

Else ApplicationType

End as Application

Great! I did not know we could use With Ties with TOP Clause.

Thanks a Ton

Great. Thank y'all.

Thank you.

This worked!

Convert(Varchar,(DateAdd(HH,05,DateAdd(MINUTE ,30,Time1))),100)NewTime

Yes, Infact using this: CONVERT(Varchar,(DATEADD(Hour,-5,Time1)),100)NewCSTTime resolves but then when I implement this same with 5.30 it rounds to 6 hours.

Tried DAteadd with Minute , 30 and it works...

It should be 2:01

Thanks . That helps.

Let me be a little bit more clear on that...

There are two columns

CurrentDate Date,

Time Varchar(10)

If I do , Select * from Data

Order By Date Desc , Time Desc...

This helps! Thanks

Sure will try that.

Lookup Data Set.

No Worries , There is a Rotate Label Property under Horizontal axis ...