Recent content by phellis

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...

I forgot to mention that I'm using Crystal Enterprise 10

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...