Cannot Process Text Parameter to Tabular View Report
I'm setting up a couple of base reports. Then, on my website, I'm displaying the same report using ZOHO_CRITERIA to select relevant data for the specific pages. The syntax for this command doesn't appear to be consistent, and it doesn't always work.
Report Type = Chart View, embedded as an image. This is working OK for me using the syntax ZOHO_CRITERIA=(Area='Potomac') where Area is my field and Potomac is the value that I'm filtering.
Report Type = Table Report, embedded as an iframe. This works OK for me if I filter on a number, but acceptable syntax is different -- ZOHO_CRITERIA=(Zip=20814) where Zip is my column, and 20814 is the numeric I'm filtering on.
This doesn't work if I filter on a text field -- like I do with a Chart report. I've tried every combination of quotes, double quotes and no quotes, but cannot use this command to filter a Table Report if the criteria is text. I tried to embed a Table, and got the same results.
Please advise. Thanks.