Yes Danny. Use the query like this

select datetimeCol from TestTable where datetimeCol >='01/13/2009 01:30:00' and datetimeCol<='01/13/2009 18:45:00'

where datetimeCol is your table column

Instr() is also avilable in SSRS and you can check the condition like below

=iif(InStr(FieldName,ParameterName)>0,TrueCondition,FalseCondition)

You can use this expression where ever you want.

Hope this below post will help you

http://www.sqlservercentral.com/Forums/Topic685955-150-1.aspx

Still if you not clear, revert back to me

I think you can't but what my suggestion is to have a dropdown and hardcode the value like 01:15,01:30,01:45,02:00,02;15... in both fromtime and totime field. Then you can filter the...

use like below sql code to covert the datetime field

select CONVERT(VARCHAR(10),datefieldname, 101) AS datefieldname from tablename

Use the above code in your dataset while selecting the date value from table

Thanks for your respone Ar. Its is not working. I developed many reports.Bold format for text is not coming in pdf and also in print out. But while viewing the...

Ya.. i solved this in the below manner

I created a parameter(Report_Parameter_1) and get the default value as CompanyName from dataset

I kept a text box in the page header and added...

Add the below code in report properties

public function IsFirstValueSel(ByVal SelectedMultiValue as String) as boolean

if SelectedMultiValue .Contains("1") then

return true

else

return false

end if

end function

Add the below code in the visibility proprty of subreport1

=code.IsFirstColSel(Join(Parameters!Report_Parameter_0.Value,",...

Apply the page number in the report footer. This will solve your issue

Thanks for your response Richa

But i'm getting the CompanyName in page header only in the first page not in all the page of the header.

Please help me to solve...

Try this one

=IIF(IsNothing(Fields!CLSDDATE.Value), Count(Fields!OPENDATE.Value), 0)

I'm not clear in your requirement. Will u pls expalin me clearly?

I placed the text box in the page header and added the following expression

=First(Fields!companyname.Value, "DataSet_ServiceCenterComapnyName")

But I'm getting the following error

An error occured during local report processing

The expression for the...

Hi Zee,

Use this code. Hope this will solve your problem

=IIF(IsNothing(Fields!CLSDDATE.Value),"True","False")

Still if you have a problem pls feel free to revert back

You can achieve this using switch statement.

Add the below expression in state field.

= switch(Fields!City.Value="dallas","Texas",Fields!City.Value="atlanta","geogria",true,Fields!City.Value)

Hope this will help you.

Still you have a problem pls feel free to revert back.