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: *

  • Users: phellis
  • Content: Threads
  • Order by date
  1. 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
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. phellis

    Crystal Reports and history tables

    I have a couple of tables that store the status history and the address status of a person. In SQL the query would be something like Select P.Forename, P.Surname, S.Status, A.Line1, A.Line2, A.Line3, A.City From Person P Join StatusHistory S On P.PersonUID = S.ParentUID...
  10. phellis

    Stopping user Submitting forms twice.

    When a user pressing the Submit program the form validates the data before submitting using the standard .NET generated validation routines. Once validated the form is posted to the server and a confirmation screen is returned to the user This can take time which allows the user to press the...
  11. phellis

    Calculating running totals

    I have a table with multiple rows where users can enter a number on weach row. I had a running total that gets calculated each time the user changes a value which was done by looping through the values. However although this works well with 20 or so rows it starts becoming slow when doing 200...
  12. phellis

    OLE Automation Server Timeout Messages

    When the OLE Automation Server Timeout message appears I have been able to change the displayed message using the OLERequestPendingMsgText. However this changes the message box so that a Help button is shown. I can not assign this to anything and I can't find a way of suppressing it either...
  13. phellis

    CRViewer Hot Keys/Methods

    Is there a way of using the "Find" button/method on the toolbar of CRViewer using the keyboard instead of clicking on it using the mouse. Is there anyway of using any of the toolbar buttons without clicking on them. I'm using VB6 and Crystal Reports 8.5 Thanks in advance Paul
  14. phellis

    Is there a function similar to GETDATE to use in UDFs

    I'm trying get a result set based on the current system time. In normal instanced this is just a case of using GETDATE(). However, due to the limitations of UDF's the GETDATE function can not be called. Does anybody know of a work around that will return a System Date to a UDF.

Part and Inventory Search

Back
Top