Use of ParameterRR
Posted: Mon Oct 27, 2003 9:43 pm
I have a simple report with just a master table. It has a column (Character field of size 4) which I would like to use in the report filter.____I want to create a ParameterRR field representing a user input value which the column will be compared to. i.e. select the record if cloumn is equal to my ParameterRR field. I construct the report filter accordingly.____I create the ParameterRR field with a default value, say "ABCD" (including double quotes as instructed). When I run the report, I enter an alternate value in the ParameterRR Value Entry Dialogue.____I then receive and ODBC-based error stating that I have an invalid column name equal to the new value that I enter for the ParamaterRR field.____Checking the SQL I see that the where clause has the form AAAA."bbbb" = "CCCC"__ where AAAA is the alias for my table__ bbbb is the table attribute__ CCCC is the value entered in the ParameterRR entry____If I change my report filter to have the column caompred to a constant value, the SQL has the form AAAA."bbbb" = ^CCCC^____It is obviously the double quotes around my test value that causes the SQL syntax problem.____What changes to my report definition can I make to be able to utilise the ParameterRR field for comparison?__