Hi,
Did someone already tried (or succeeded) to retrieve report level variables from WID documents ?
The WID scanner doesn’t either include this functionnality…
As you might already find out, Dwayne is not the author of WID scanner nor does this topic discuss the same. So please ask your questions in more appropriate forum, here:
Great macro. As noted in the thread on the objects the Variable Formula can be truncated to 256 characters. To work around this I added a line to the DefineCube function (MaxWidth bit) :-
Function DefineCube(dpCube As DpVBACube) As DpVBACube
Dim dpCol As DpVBAColumn
Set DefineCube = dpCube
DefineCube.DpVBAColumns.SetNbColumns (3)
Set dpCol = DefineCube.DpVBAColumns(1)
dpCol.Name = "Report Filename"
Set dpCol = DefineCube.DpVBAColumns(2)
dpCol.Name = "Variable Name"
Set dpCol = DefineCube.DpVBAColumns(3)
dpCol.Name = "Variable Formula"
dpCol.MaxWidth = 1024
End Function
Thank you so much for such a great utility. I am using XIR2 Deski but what I have noticed is that the macro is skipping the Detail variables created at the report level sometimes.