Thank you champion, when ever we want to see the results form log table we can simply do select with order by date..right.?

Hi Champion, Thank you.

You are right,this needs to be done in application. we are using jqgrid,the data which is populated in the grid has

id description date

34 'present' ...

Hi,

Thank you for replying soon.

The idea is that i created a new table persons is to log the changes which are updated from frontend.

When...

Hi,

In mcal table the Caldate is datetime and the data in the caldate column is getting as

2014-10-01 00:00:00.000

Thanks for the suggestions.....

Thank you for helping me champion,I am very new to

?

ffsdfdsf

Hi champion,

Do you prefer to use temporary tables

Hi champion,

Thanks for replying,ya its popping a lot of...

Thank you for the reply

But the entire value in the field is as like 1.00-2.00

Its not separate from the database itself its retrieving as like 1.00-2.00

No,I don't want to check for all the rows

The problem here is that its grouping with system name

we will get page wise right one page have data and one...

I tried in this way

=IIF((Parameters!SystemId.Value) = "ALL", "ALL Systems DATA",Parameters!SystemId.Value+" " +"DATA")

It got worked;Thank you so much..

Thank You for the reply

I have a question here -

If I select parameter system as 'ALL' in the data base I have a system name column showing data as ALL...

I understood,but I am using column name as Systemname

From system name I am getting values ad 1184-abc

Now I want in ssrs report only 1184 how can I write the expression...

Thank You So much..It got worked.