Ssrs Report Help

[dotnetrockz]

ssrs lo naku dataset lo 2 columns unnayi like manufactured year and model ani..

ee rendu values ni kalipi nenu oka expression rayali to populate in a table column

1)if both of them are not null ---then it shud be manufactured year + model
2)if model is null then it shud be manufactured year +'Year model'(static text)...

[pavan_613]

Help

[Mustodi_2ndsetup]

primary key violation avochu may two datasets ki kalipi oka query rayi it will be easy

[ghazni]

iff condition in expressions try chesara

query loney coalesce or ISNULL vadochu.......

[dotnetrockz]

ledhu bhayya...ssrs kotha iff exp try cheyyala rendu columns ni merge cheyyadaniki

[dotnetrockz]

[quote name='Giants' timestamp='1368044389' post='1303724843']
primary key violation avochu may two datasets ki kalipi oka query rayi it will be easy
[/quote]

okate dataset lo unna columns

daaniki primary key voilation em untadhi...just concatenating columns kada?

[fullmeals]

[ghazni]

[quote name='Nissan' timestamp='1368044514' post='1303724852']
ledhu bhayya...ssrs kotha iff exp try cheyyala rendu columns ni merge cheyyadaniki
[/quote]
yes... query loney cheyochu like case statement use chesi ....... or see my above reply

[Mustodi_2ndsetup]

[quote name='Nissan' timestamp='1368044563' post='1303724854']
okate dataset lo unna columns

daaniki primary key voilation em untadhi...just concatenating columns kada?
[/quote]
2 data sets anukunna my bad query rayi bhayya case statement vadi
OR

=iif (is noting(column1 & col2),true ,false)

[rapchik]

[quote name='Nissan' timestamp='1368044189' post='1303724830']
ssrs lo naku dataset lo 2 columns unnayi like manufactured year and model ani..

ee rendu values ni kalipi nenu oka expression rayali to populate in a table column

1)if both of them are not null ---then it shud be manufactured year + model
2)if model is null then it shud be manufactured year +'Year model'(static text)...
[/quote]
idhi try cheyi


[color=#333333]IIF(Fields![/color][color=#282828][font=helvetica, arial, sans-serif]year[/font][/color][color=#333333].Value == null AND [/color][color=#333333]Fields![/color][color=#282828][font=helvetica, arial, sans-serif]model[/font][/color][color=#333333].Value[/color][color=#333333] == null ,"[/color][color=#282828][font=helvetica, arial, sans-serif] manufactured year + model,([/font][/color][color=#282828][font=helvetica, arial, sans-serif] manufactured year +'Year model')[/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color][color=#333333])[/color]

[Mustodi_2ndsetup]

nissan bhayya nested iif try chesava


=iif(
Parameters!StartMonth.Value <= 1 AND Parameters!EndMonth.Value >= 1,
ReportItems!txtTotal2.Value,
iif(
Parameters!StartMonth.Value <= 2 AND Parameters!EndMonth.Value >= 2,
ReportItems!txtTotal3.Value,
iif(
Parameters!StartMonth.Value <= 3 AND Parameters!EndMonth.Value >= 3,
ReportItems!txtTotal4.Value,
Nothing
)
)
)

[rapchik]

[quote name='Giants' timestamp='1368044755' post='1303724883']
2 data sets anukunna my bad query rayi bhayya case statement vadi
OR

=iif (is noting(column1 & col2),true ,false)
[/quote]
This would work perfectly

[pavan_613]

[quote name='ReddyGaru' timestamp='1368044994' post='1303724918']

This would work perfectly
[/quote]


Antey Nuvvu Cheppindhi work kada

[dotnetrockz]

THANKS EVRYONE THIS WORKED

[size="2"]=Fields!MANUFACTURED_YEAR_NR.Value & [/size][size="2"][color="#a31515"][size="2"][color="#a31515"]" "[/color][/size][/color][/size][size="2"] & IIF(Fields!MODEL_AN.Value [/size][size="2"][color="#0000ff"][size="2"][color="#0000ff"]Is[/color][/size][/color][/size] [size="2"][color="#0000ff"][size="2"][color="#0000ff"]Nothing[/color][/size][/color][/size][size="2"],[/size][size="2"][color="#a31515"][size="2"][color="#a31515"]"YEAR MODEL"[/color][/size][/color][/size][size="2"],Fields!MODEL_AN.Value)[/size]

[pavan_613]

[quote name='Nissan' timestamp='1368045114' post='1303724933']
THANKS EVRYONE THIS WORKED

[size="2"]=Fields!MANUFACTURED_YEAR_NR.Value & [/size][size="2"][color="#a31515"][size="2"][color="#a31515"]" "[/color][/size][/color][/size][size="2"] & IIF(Fields!MODEL_AN.Value [/size][size="2"][color="#0000ff"][size="2"][color="#0000ff"]Is[/color][/size][/color][/size] [size="2"][color="#0000ff"][size="2"][color="#0000ff"]Nothing[/color][/size][/color][/size][size="2"],[/size][size="2"][color="#a31515"][size="2"][color="#a31515"]"YEAR MODEL"[/color][/size][/color][/size][size="2"],Fields!MODEL_AN.Value)[/size]
[/quote]


Gud one !!