I have a "Detail" button in my report that should only show if there is data in the Start and End columns of that row.
Right now, my setup for my Detail text box is:
General > Expression:
=IIF(IsNothing(Fields!StartTime.Value) OR IsNothing(Fields!EndTime.Value), nothing, "Detail")
Action > Go to report > Specify a report > Expression:
=IIF(IsNothing(Parameters!StartDate.Value) OR IsNothing(Parameters!EndDate.Value), Nothing, "Detail Report")
In the report viewer via browser, once you run the report, the cells where Nothing should be applied show a hyphen (-). This hyphen can be clicked on for some reason, despite my "Specify a report" code. However, in the PDF version (or other exported) version of the report, the hyphen is not there. I don't care that the hyphen is there (and I also don't know why it's there), but it can't be clicked on.
If I run the report in Visual Studio I don't see the hyphen. It's when I upload it to our report server and access it from chrome. Once this hyphen is clicked on, it gives an error saying "The 'StartDate' parameter is missing a value."
Am I doing something wrong?
Ended up being a mistake on my part. In my goto action, I was referencing Parameters!StartDate.Value and Parameters!EndDate.Value, while in my "Detail" text box expression I had it referencing Fields!StartTime.Value and Fields!EndTime.Value. I changed the goto action to the latter, and my problem was fixed.