Morning All,
I need to select seat numbers based on the seat row selected in the previous parameter in Report Setup, but I'm running into a problem with double quotes.
So, my Seat Row parameter, selects the rows from T_SEAT based on the Performance, but when I try to add a parameter for seat num with a WHERE clause using the Seat Row parameter, I get an error which specifies Incorrect syntax '"A","B"'. I've deduced from that, that I need to strip out the double quotes, or replace them with single quotes, before the value gets passed to my SQL VIEW.
Has anyone done this? Is it possible? Should I try something else instead?
Thanks in advance, Debbie
Debbie,
I have never tried it in the Report Setup application, but in the server you could just use REPLACE(seat_row,'"',''), and I do not see any reason why that should not work. Let me know if that helps.
John
Ha! Yes, it works beautifully. Thank you John.
Debbie