Hi all,
I've got an infomaker report which pulls data using a stored procedure. I've added a new field to the SP and the data gets returned correctly.
Then I added the new field onto the infomaker report, the field should only be visible if there is data returned. Weirdly, the field was remaining visible when I returned no data, so I put a default 'N' in the field inside the SP and am now checking for an 'N' to make the field visible or not, like this: if(cont_desc = 'N',0,1).
The field continued to remain visible, whether an 'N' was returned or not, so I checked in the Data tab and the field is blank. I changed my 'If' statement to check for blanks, but it made no difference.
So I actually have two questions: Why doesn't my default 'N' get sent to infomaker (I've run the SP and the 'N' appears when it should do)? and Why doesn't my If statement in the 'Visible' property of the field respect the contents of the field.
Any help would be much appreciated.
Debbie
I know this sounds dumb, but are the fields returned lined up correctly between all three pieces? Infomaker, report setup, and the the proc? I've had it where report setup had crossed the fields so the data returned was blank. Just a thought.
Hi Troy,
You are spot on. I feel a little dumb now, as I should have double checked that before posting. You know how it is when you have looked at something for so long, you are convinced you are right and it turns out you are wrong? That's me!!!
Thanks for getting back to me with a suggestion.
We've all been there... and go back there from time to time. Glad you got it.