I managed to add the Data Access right using the AddCustomRight method
ObjectPrincipal.Rights.AddCustomRight(21495815, "MetaData.DataConnection")
I do not know if 21495815 is system specific but identified it having looked at known ObjectPrincipals who had the right set. All this seems to be...
Has anyone tried to grant "Data Access" rights on a Data Connection to an ObjectPrincipal using the .NET SDK?
ObjectPrincial.Rights has 3 methods: Add, AddCustom, AddSystem of which none seem to be documented as to assign the Data Access rights.
Can anyone help please?
Thanks
Changing the SI_SERVER (as I type) appears to be working for the 700 or so reports that were changed.
I won't know if its fully worked until the original email server is switched off!!
Fingers crossed! :o)
Is there an email size limit set on your email server?
This error keeps occuring on our server when the size of the report is too big for the email server.
Worked it out. It turns out to be fairly simple to do I just hadn't realised how deep the properties went on the the infoobjects.
Private Sub Logon(ByVal strCMS As String, ByVal strUsername As String, ByVal strPassword As String)
Dim mySessionMgr As New SessionMgr
Dim...
Out IT department are in the process of changing our email server. I reconfigured the crystal enterprise server so that any new reports will be scheduled to the new server.
However I now have an issue where I need to change all existing scheduled reports so that they will also be sent to the...
I'd workde out that I could use this logic using either checking the CurrentCEUserName or by adding the users to the "Full Data Access" filter.
However doing either of these in the Data Foundation is causing the report to hang. So I've currently moved the logic into the report itself.
I want to be able to implement Row Level Security using filters in data foundations.
So far I've set up the filter
not ({field1}) startswith "AAA")
So far so good.
the issue I'm having is trying to apply it to the correct users in the Edit Rights screen.
Basically I want to apply this...
I've now found a way of using sub reports "without" hitting the database server if the subreport is using the same data as the main report. I'm using v10 to do this.
Basically you populate shared arrays with the data you are interested in showing in the subreport. One array for each field.
To...
I have set up a dummy subreport at the group footer level of my main report. The idea being that I can build up a shared array and pass it to the subreport.
I'm successfully setting up the array in the main report however when I try to get the data out in the subreport it appears that my array...
This is why I was hoping there may be a way around having to hit the DB each time for the subreports.
Is there a way of passing the information into the subreport using arrays. The idea being that I could make the hit to the DB in the subreport simpler so that it runs and links but the detail...
I don't think cross tabs are going to do it.
Here's an example of what the data looks like coming from an SP.
Portfolio, Client, Completed, Completed within Deadline, Within 10 Days, Within 20 Days
PortfolioA, ClientA, 20, 10, 5, 5
PortfolioA, ClientB, 10, 1, 6, 3
PortfolioB, ClientC, 20, 10...
The issue is that the subreport is using exactly the same data as the main report. However the subreport is held at a group footer level so it calls the subreport and hits the DB each time the group changes.
Your suggestion of a cross tab may work however to add to the problem the grouping...
I have a crystal report (v10) which contains a subreport. Both the Main report and Subreport contain the same data, just presented differently.
As it stands the report queries the database for the main report and then queries it for each time it needs to load the subreport.
Rather than doing...
I've have reports that contain numeric values which export to excel (data only) and maintain their data format as numerics.
However when i export a report to excel (data only) that contains a cross tab then the numeric values are reformatted in excel as characters.
I've also found this to be...
Thank you. That worked.
So my understanding now is
Everyone - Access Level - View
AUser - No Access
Results in Auser having access.
Using the Advanced option results in AUser not having access.
Once again. Thanks
I'm having problems with setting up the rights to a folder within CMC.
Basically I'm trying to grant Everyone view rights to the folder (easy enough so far) but I don't want AUser to have access.
I've tried setting up (a simplistic demo)
Everyone - View
AUser - NoAccess
This results in AUser...
I have a report that cna be drilled down and can be viewed through the DHTML viewer.
However when I try to export the drill down page all I get is the top level report.
If I do the same from with Crystal Reports itself the export function works properly export the page I'm currently viewing...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.