Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. phellis

    Granting Data Access rights to Data Connections in .NET

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

    Granting Data Access rights to Data Connections in .NET

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

    How do I change the SI_SERVER of an existing scheduled report?

    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)
  4. phellis

    SMTP Issues

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

    How do I change the SI_SERVER of an existing scheduled report?

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

    How do I change the SI_SERVER of an existing scheduled report?

    I forgot to mention that I'm using Crystal Enterprise 10
  7. phellis

    How do I change the SI_SERVER of an existing scheduled report?

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

    Row Level Security using filters in data foundations

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

    Row Level Security using filters in data foundations

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

    Passing Shared arrays to subreports at group level

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

    Passing Shared arrays to subreports at group level

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

    Using the same data within the Main report and subreports

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

    Using the same data within the Main report and subreports

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

    Using the same data within the Main report and subreports

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

    Using the same data within the Main report and subreports

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

    Cross Tabs exporting to Excel

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

    Folder Rights - Restricting 1 user

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

    Folder Rights - Restricting 1 user

    I'm using Crystal Enterprise 10. From what I can gather the Everyone View right overides the AUser No Access rights.
  19. phellis

    Folder Rights - Restricting 1 user

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

    CE10:Exporting Drilldown pages DHTML viewer

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

Part and Inventory Search

Back
Top