Search results for query: *

Hi, I'm trying to determine the highest number of concurrent users of a system (grouped by date). A formula evaluates each log entry and correctly displays a counter but the list is be huge so I'd love a summary for each day (eg Maximum of the formula). I'm using Whilereadingrecords for the...

When I export a report from CRXI to Excel 2007, everything works fine but when a colleage does the same with her CRXI and Excel 2007, the Time field appears as Datetime in Excel. We're both on the same LAN network (Citrix - so our O/S settings can't be edited and our CR will have the same...

I need to print documents which are stored in a fixed location on the LAN as opposed to being inside a DB. For example our SQL DB allows users to brows/upload Risk Assessments (usually 3-4 pages in Word format), but it doesn't then store the documents within the DB. It merely places the files...

I have a formula in GF1 (@CountNewLeanersThisYr): Numbervar CntNewLearners; If Maximum ({@DidCourseThisYr}, {vRepPeople.PeopleID}) = 1 and Maximum ({@DidCourseWithin2Yrs}, {vRepPeople.PeopleID}) = 0 Then CntNewLearners:= CntNewLearners + 1; I'm counting learners who studied this year but...

I'm trying to identify courses which have been set up incorrectly : the last part of the text field Activity.Name should contain a pound sign followed by a numberic value at the end Correct: Course Name £5000 Incorrect: Course Name 5000 Incorrect: Course Name Can someone please suggest a way...

I have a subreport, with a shared boolean variable called "Show" (simply warns that a "course" has been setup incorrectly). The subreport is placed inside GF3 of my Main Report. Ultimately, I wish to use if for Group Selection and/or Suppression but the Main Report doesn't seem to be reading...

To easy to explain this, sorry - so I'll explain using a short outline of my report structure: GH1 - ManagerID (suppressed) GH2 - StaffType GH3 - StaffID (suppressed) DETAILS (suppressed) GF3 - summaries per StaffID (eg No of qualifications passed) GF2 (suppressed) GF1 - summaries per ManagerID...

Other than archiving reports and waiting for users' wrath, can anyone think of a way to tell when a report was last run?? Update a text file somehow?? I maintain over 100 and want to prove that they're still being used. Thanks J

The thread heading could be better - I just couldn't think of one. I want to display an alert if final records in Group2 contain a zero in {Attendance}: GH1 GH2 - also displays field {Expected_No_Of_Events} eg 4 {EventID}1 {Attendance}1 {EventID}2 {Attendance}1 {EventID}3...

I'm using the output from a formula as the Row inside a Crosstab. Results are displayed in two formats: a) three alpha characters followed by three numberic values; ABC001 DEF002 XYZ567 b) a numeric value between 1 and 50 1 2 3 4 It works fine but I need to change the sort so that numbers...

I have an unusual problem ... Somehow, I need to develop a report to be run by various users with varying rights to see data. They'd all be using CRXI (ie not just a Viewer) and be on a LAN. Basically, I have no idea whether it's possible to link to a certain table BUT hide sensitive data...

I have a report (mailing letters and forms) that consists of multiple sections as follows: GH1a GH1b GH1c GH2 D GF2 GF1 I need to withhold letters from people according to data in GF2 (uses summaries and formulas) - in other words suppress all sections according to data in GF2. My brain hurts...

Hi all. A text field contains the following string: A=£64.00; B=£49.00; C=£10.00 I need to replace the A, B and C so that the text reads as follows: Full=£64.00; Partial = £49.00; Remitted = £30.00 Can anyone please suggest a formula that would work in version 7? Thanks J

re: CR v 7 At runtime, we let users choose from several default parameter values. To speed up processing, we allow them to choose "Any" by creating a default value of "*" (asterisk) then modifying the selection formula to say "FieldName LIKE ParameterName". That works great for string fields...

We mainly use v11 but rely on v7 to distribute compiled reports which are then run by users without CR. These are mainly administrative letters, forms and other correspondence which must go out in hard copy - and large volumes. Our admin needs are growing fast so we need more copies of v7 to...