Ok. Thanks for the reply.
agowinuk (BOB member since 2006-08-25)
Ok. Thanks for the reply.
agowinuk (BOB member since 2006-08-25)
Can someone assist me in getting this to open? I’m assuming it is a Crystal Report file and I should be able to open in CR XI.
When I try, I get an error message that says:
This document has the expected file extension (.RPT), but seems to be corrupted. If this report used to work, try opening it with a different version of Crystal Reports and if that still does not work, please contact your administrator.
I’ve tried both the XI and v5,v6 files and get the same message from either.
Any pointers to show me how to use this?
Many thanks!
Norman
neheyen (BOB member since 2006-08-22)
What would give you that idea? The .rep extension indicates a full client (now called Desktop Intelligence) document. Manually changing it to .rpt is not going to make it a Crystal Reports document, sorry.
Dwayne Hoffpauir (BOB member since 2002-09-19)
I have a question about this… Im working with the download for 6.xx and wondering; We have a universe created that gives us backend information about users, groups, universes, etc. On the report from the download, Im trying to create/add a dataprovider to go after information with this backend universe we have. In the universe weve got an object called “Universe Name” that is created from table/field, universe.M_UNI_C_LONGNAME. On the report, Im linking this object to the Object, Universe Name which on the download is DataRow(5) = DProv.Universe.LongName in the code. (I changed this from 'DataRow(5) = DProv.Universe.ShortName & “-” & DProv.UniverseName).
The data that comes back is identical but its not working. The VBA code is working properly, listing only the universe(s) used in the report(s). But the object from my new dataprovider is giving me all universe names that we have, and Im just expecting the universe name(s) that are on the selected reports. Im wondering
.is the VBA code executing before or after the dataprovider is refreshed? Reason why I’m here is that I use this awesome download to list the information about a report but I’m also trying to get more info about the universe…I also want the table and field names of each of the objects on the report…
Hope I explained myself ok!
thanks!!
nonyup (BOB member since 2008-01-07)
Will it be possible for you to provide the code which can retrieve objexts used in user defined variables?
Thanks,
Kumar
mkumar (BOB member since 2002-08-26)
Try this … List report level variables in full client reports
Dwayne Hoffpauir (BOB member since 2002-09-19)
Hi Dwayne,
Reviewing your code, I could improve it, including SQL objects. How can I send it to you, to posted in the forum?
Maybe it could be helpful
Leonardo
leonardo.contreras (BOB member since 2008-07-07)
Hy,
I’ve read your post and I am very intersted with your code for the two next pbs :
Thank’s for your help
Ty_Bou (BOB member since 2005-02-16)
Take a look at the latest version of this utility … Save for all users. It includes a technique for recursively processing a folder structure.
As previously stated in this thread, I don’t think there is a way to prevent the Document_Open event from firing.
Dwayne Hoffpauir (BOB member since 2002-09-19)
Code below is the main change, in the Dwayne’s code, to process Manual Querys.
'code included to process Manual SQL Querys.
Else
'Processing Manual Providers
If DProv.GetType = "DPSQLC" Then
DataRow(3) = DProv.Name
DataRow(4) = "SQL"
DataRow(5) = "SQL Manual"
DataRow(6) = DProv.Name
DataRow(7) = ""
For Each Col In DProv.Columns
DataRow(8) = "Field"
DataRow(9) = "Variables"
DataRow(10) = Col.Name
DataRow(11) = ""
Call dpCube.DpVBAColumns.AddLine(DataRow)
Next Col
End If
End If
Maybe it helps
Bye
leonardo.contreras (BOB member since 2008-07-07)
Is there any limit on the number of documents it can process? I cannot run this macro for 600+ reports.
BOisBest (BOB member since 2004-04-05)
Works great …thanks
pravin_kadambi (BOB member since 2005-05-18)
Well, apparently there is a limit … smile … but not by design. It may help if you could describe exactly what you mean by “I cannot run this macro” … error message, unexpected result, crash, other?
Dwayne Hoffpauir (BOB member since 2002-09-19)
Step through the code, and tell me what line generates that error. Also, what version of Business Objects are you using?
Dwayne Hoffpauir (BOB member since 2002-09-19)
I found the problem…works super…thanks once again for your reply…
pravin_kadambi (BOB member since 2005-05-18)
Care to share the solution, in case it helps anyone later on?
Dwayne Hoffpauir (BOB member since 2002-09-19)
Does anybody know if this is part of the standard functionality in XI R3.1 ?
RikDeclercq (BOB member since 2006-09-28)
Is it possible to find the fields used in the crystal reports by doing this way?
Thanks,
-JB
Jayabal (BOB member since 2009-01-05)
Hi All,
I want to add two more column in this reports.
If anybody has idea please suggest how to go for it.
Regards,
Shahnawaz ALam.
YARAHMAT786 (BOB member since 2009-05-20)
This request doesn’t fit “neatly” into the existing model. The sample VBA code below will pop up a message box for the items you requested. You should be able to adapt the properties it uses to a new tab in the original model.
Sub ListSQL()
Dim DProv As DataProvider
For Each DProv In ThisDocument.DataProviders
MsgBox DProv.SQL
Next DProv
End Sub
Sub ListPrompts()
Dim Var As Variable
For Each Var In ThisDocument.Variables
If Var.IsUserPrompt = True Then
MsgBox Var.Name
End If
Next Var
End Sub
Dwayne Hoffpauir (BOB member since 2002-09-19)