October 16, 2012 at 3:05 am
Hi geniuses,
I'm having problems with a traffic light indicator expression:
=SWITCH(
ReportItems!Textbox21.Value="1.1.PC" and ReportItems!Textbox23.Value<>"",0,
ReportItems!Textbox21.Value="4.2.PP" or "4.3.PE" or "4.4.S" and ReportItems!Textbox23.Value="",1,
ReportItems!Textbox21.Value="1.1.PC" or "1.2.PV" or "1.3.PNV",2
)
The error: ...an error: Input string was not in a correct format.
But if I only use:
=SWITCH(
ReportItems!Textbox21.Value="1.1.PC" and ReportItems!Textbox23.Value<>"",0,1
)
It works fine.
???
Thanks
Regrdas
October 16, 2012 at 4:06 am
ReportItems!Textbox21.Value="4.2.PP" or "4.3.PE" or "4.4.S" and ReportItems!Textbox23.Value="",1
You got to change the above line to :
(ReportItems!Textbox21.Value="4.2.PP" or ReportItems!Textbox21.Value="4.3.PE" or ReportItems!Textbox21.Value="4.4.S") and ReportItems!Textbox23.Value="",1
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 17, 2012 at 5:21 am
Hi I'm getting a warning error while rendering my report, it says that 'Input string was not in a correct format.'
=SWITCH(
ReportItems!Textbox70.Value="2.2.PA" and IsNothing(Lookup(Fields!ProjectGUID.Value, Fields!ProjectUID.Value, Fields!PBSD.Value, "DataSet3")),1,
ReportItems!Textbox70.Value="2.2.PA" and Lookup(Fields!ProjectGUID.Value, FIelds!ProjectUID.Value, Fields!PBSD.Value, "DataSet3")="",2,
ReportItems!Textbox70.Value="1.1.PC" or "1.2.PV" or "2.1.PS",3)
It is for sure because, when I want to to know if Fields!PBSD.Value is = "" or not.
Any solution?
Thanks
Regards
October 17, 2012 at 6:57 am
Anyway, it gives me the same error.
Thanks!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply