Now the mess is complete. In the sort list of months I now have THREE entries for every month:
‘August’
'August ’
'AUGUST ’
Why is BO keeping all the values? I’ve REMOVED the lov from the universe but still is reporter listing values which are not in the resultset. Can I specify reporter to forget lov’s? Or can I edit lov’s?
Now the mess is complete. In the sort list of months I now have THREE entries for every month:
‘August’
'August ’
'AUGUST ’
Why is BO keeping all the values? I’ve REMOVED the lov from the universe but still is reporter listing values which are not in the resultset. Can I specify reporter to forget lov’s? Or can I edit lov’s?
First of all, if you have the rights, you can edit the LOV from reporter.
Why are there different values? I guess your database holds all these different values! If you do a refresh, BO goes to the database for possible values, and, of course ‘August’ is different from 'August ’ and ‘AUGUST’! What you can do is simply redefine your corresponding object in designer to give you month names in either uppercase or, all names in Initcaps or whatever format…
You should also check the option ‘delete trailing blanks’ (or so…) in the query panel! And, be sure that you check the box ‘export with universe’ in the object properties tab…
WM
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
The database doesn’t hold all these different values as the object is doing a to_char() to display only the month. I must admit, though, that I changed the format string from “MONTH” to “Month” to have better readably reports. I thought of doing this on the report it selve by using “InitCaps” but finally desided for the Universe patch.
In the datamanager only one “type” of month name is displayed. Which is logical as the refresh can only give me “August” types of monthnames. Btw. the remove trailing blanks checkbox is switch to on.
What is funny and I guess causing the problem is the fact that I cannot display the list of value’s. In Designer when I Display the LOV in the Properties sheet of the object I get an SQL error: “ORA-00904: invalid column name :-904”. Checked everything the columnane i use is correct. When I try to edit the LOV in reporter I get the same error when I try to display it there. I guess BO is not able for some reason to get to the LOV anymore, whereas when I parse the select query in the object definition I get no errors.
I just send this because others might run in a similar situation.
The problem of the months LOV was really the inability of BO to do an update of the LOV. The reason for that was that I specified a general rule in the Supervisor for the universe excluding test data in our database. The Where clause of the universe was errornously included in the query to update the lov causing the ORA-0094 problem. Therefore the list did not change.
What is funny and I guess causing the problem is the fact that I cannot display the list of value’s. In Designer when I Display the LOV in the Properties sheet of the object I get an SQL error: “ORA-00904: invalid column name :-904”. Checked everything the columnane i use is correct. When I try to edit the LOV in reporter I get the same error when I try to display it there. I guess BO is not able for some reason to get to the LOV anymore, whereas when I parse the select query in the object definition I get no errors.
Click on the “reset” button in the object properties tab of the LOV definition in designer, this resets the name of the LOV query, and also resets the query definition to the default. This normally should help.
Walter
Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna, Austria Tel. +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at