Recent content by senglish

I have a Crystal Report that calculates staff hours with two parameters - Username and period so it brings back hours for a specific period. I am quite happy for the user to select the appropriate period. However, I do not want them to be able to enter another user as they could look at data...

I have a report of projects that I want to run every night with event and with certain default parameters including one to select data changed today. I use a generic user called scheduler to schedule this report in Crystal Enterprise XI. This seems to prevent a user from scheduling it On Demand...

I have a section that includes a very long text box which goes over 1.5 pages. I have 0.4 page of other data first on page 1 and I want it start on page one and finish on page 2. It always starts this section on a new page and leaves the bottom of page one blank and then runs over to page 3...

We have some reports where we can set any of the parameters on the Process tab and others where the second and third groups are grayed out. Second group is Use custom database logon information specified here Third group is When viewing report WE particularly want to set to "Use same database...

We have recently purchased APOS and I have set up the Access Bursting database with the details of who needs to receive the slices and the appropriate selection formula. Much of this information is in the employee database that I am running the report against. I would like to link some tables...

Above should read I want multiple columns for GH2 and Details and then when it hits next Division in GH1, it displays that as one column.

In Group Header 1, I want to list Division Name and Teams by manually putting a number of fields across the section but it will only let me put them in the left hand column. Example Team 1 Team 2 Team 3 Team 4 Team 5 Team 6 (There are...

I am using crXI I have an application with reports created with an earlier cersion of cr. It had columns in Group Header2 but not in Group Header 1. I need to recreate the same effect in crXI. Does anyone have any clues please? Stephen

I am using Cr XI

I have one field in a Group Header and three fields in details and they are all very narrow fields but I have a lot of rows so I want to set these two sections to print in three columns so the data all fit on one page. This is not a cross tab report. I know how to do it in Access and assume...

I'm using the "in Array" command to select records with specific values in a field eg {locn} in ["A", "B", "F", "K"] . What is the command where I want to exclude rather than include certain values. Thanks Stephen

We have created a dynamic parameter within a report (CE XI) and it is asking for a password when the user is trying to set the parameter to run the report. How do we prevent the user from having to login. For example you can set the ODBC password on the report so that you can run the report...

I am using CR XI I have a table with authors and have created a parameter to select an author by using a dynamic list and it works fine. However, I would like to be able to add a * (as you can in a static list) to select all authors. Is there any way of doing this please? Stephen

I am using the code below to generate a url and I want it to open in a new window. This code displays it in the current window. function CreateRSS(inform) { var RSStext = "http://dcw.salisbury.sa.gov.au/site/page.cfm?u=" location.href=RSStext + inform.options[2].value; } I am calling it from...

I am getting this message using some script that I got from the web I actually found almost identical script from two sources and both give same problem Error: 'document.globe.region' is null or not an object The problem is in the onchange of this FORM script <FORM name="globe"> <SELECT...