Hey people. I’m new to this forum and I hope you can help me with this.
If I try to delete a variable it looks like everything has gone fine. The variable doesn’t appear at the list anymore. But if I use the VB editor to work with every documentvariable object in the document, it’s still there! I’ve tried closing session and opening it again, but the DocumentVariables collection of the Document object keeps on having the same objects. Is this a well-known problem of BO? Is there any workaround to solve it?
I have the spanish version and I can’t remember the name of that window. I meant the window that you can show/hide on the left of the window, where you can see every object, variable, formula and constant, and from which you drag the objects onto the report. Is it clear? (could it be something like report manager?)
Also, the variable doesn’t appear in the window opened by the “variables” menu command.
I refer to variables which I created in the report, not objects coming from the universe. For example: let’s imagine that I have in my universe two objects called “Employee’s Name” and “Employee’s ID”. I create a new data provider with this two objects and I run it. Later, when the query is executed, I define a new variable called , defined like: “=<Employee’s ID> & " - " & <Employee’s Name>”, which would be a dimension. The problem: If I delete this variable from the report, it still will be referenced by the DocumentVariables collection. I think it’s expected this collection to have an object for any variable in the report, but not for the deleted ones!
barni07, you are correct. This is one thing that most certainly contributes to file size bloat over time. When you delete the variable, it does disappear from the report manager; from the Data, Variables list; so for all practical purposes it is “gone” from the report. However, if you use VBA to look at the DocumentVariables collection, it is still in the list! I’ve found no solution.
(BOB member since 2004-07-28)
(BOB member since 2002-09-19)