create a report parameter report

type , give it values like type A, type B in the parameter window.

now create 2 different lay outs or dataregions or tables in the...

Thanks for the reply , I do need to have formatting there. I also have to consider that it should print right,making the column wider may not help.

the problem is...

As the previous poster mentioned, you need multiple datasets based on requirements.

I think your report has multi parameters or more than one data region.

usually you need multiple datasets if you...

Thanks all !!. I will play around with pivot for this situation in my spare time.

Appreciate your help.

Thanks for your reply. yes there can be third, fourth, ....

TEXT (ABCD or EFGH)is basically concatenation of 'datetime + TEXT '

so ABCD = '8/20/2010 10:00 AM'

...

Thank you. I am going to test it.

This forum is awesome. Thanks everyone. It has been great help. I am able to extract the numeric portion.

Now , I need to extract the part after 'TEST:'

...

Thanks , I just tried it.

but I I ran into error,

Invalid length parameter passed to the SUBSTRING function.

Is there something else that needs to be added. sorry...

DECLARE @item table

(item_id int,

ITEM_desc varchar(100),

)

insert into @item

select item_id,

ITEM_desc

from ITEMS

where ITEM_desc like 'test%'

These item_desc fields (strings) from @item...

Thanks everyone. greatly appreciate that.

I have some confusion here , I have a table variable which first brings these strings after joining to different tables..

in other words If...

I just used this and it seem to work fine...I hope I am doing it right

=IIF(instr(Join(Parameters!Cost_Type.Value,", "),Trim(Fields!Cost_Type.Value))=0,True,False)

Thanks a bunch !!

Thanks,

As you said, I entered in the Row's Visibility> Hidden>expression

=IIF(InStr(JOIN(Parameters!Cost_Type.Value,","),Fields!Cost_type.Value),False,True)

But now if I choose LOW as an option in the multiselect for instance, it hides all rows...

Thank you sooooo much Daniel. That worked like magic,

but now I face a new problem, I want to Hide/show "row" based on multi-select parameters., but I cant

although the columns...

For each of the three columns I am using visibility /Hiddden condition as for instance for the LOW column :

=iif(Parameters!Cost_Type.Value="LOW", false, true)

When I choose 'LOW' in my report i the...

Thanks Daniel,

Its actually going to be a multi-select parameter and user wants the flexibility to choose for instance LOW + MED , Only LOW, ALL &...