I have a navigation from reportA to reportB, based on 3 paramater Subject, date and age so ive set the following on the navigation expression @subject = Fields!Subject.Value @date = Fields!date.Value @age = Fields!age.Value but if the age field is blank then the report will fail, is there a way around this?? The 'age' parameter is missing a value

HI Sam, Dont assign Field Value to the Parameters , just something like shown below IN Action Window use as below Name --------------- Value From --------------- @FromDate To ---------------@ToDate where @FromDate and @ToDate are the parameters of ReportB while From and To of ReportA. Amit Please Propose As Answer if it is useful

i dont have an AGE parameter... if i need to create this in reportA then i must pass something to this field, how can i do this?

Hi, In the ReportB for the Age parameter select "allow blank values" checkbox. Hope its clear & helpful....Pavan Kokkula Tata Consultancy Services.

place a tick in the allow blank values... this time the report does load but no records are shown... but i have checked and there is data for this record

Hi Sam233, Thanks for your question and other partners’ replies. If just when the age’s value is blank, the error displays, thus I would suggest you using an expression with IsNothing() function instead of the age, just like below. =Iif(IsNothing(Fields!age.Value),0,Fields!age.Value) Please replace the Fields!age.Value with previous expression. Hope it helps you. If your issue still exists, please don’t hesitate to let me know.. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.