Search results for query: *

Thanks Ian, Your approach helped perfectly! I was doing it almost correctly but your slightly different approach helped to highlight my error. Thank you, thank you, thank you :)

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

Hi Madawc and thanks. I did look in File > Options > Field, yes, and all the Report Options areas too. Both programs have identical options %-) FYI, I got around the problem this time by creating a new formula which converted the Datetime to Time format then displayed that - as opposed to...

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

Hi briangriffin and everyone, This is absolutely brilliant - what skills you have!! I now have to work out how where I can use it [2thumbsup]

Fantastic, thanks [bigsmile] Simply changing from denoninator to numerator (once I'd worked out which was which!!) did the trick. It's obvious to me now. I've adopted your other suggestion about avoiding nulls. I'm as grateful to you as as always lbass. J

Hi lbass, that's exactly what my display formula looks like (stupid me ... I forgot to mention the "WhilePrintingRecords" bit, sorry) [blush] In any event ... you just helped me find the cause [dazed] The RF section also contains a running total called {#Tot_Learners} (all learners in a...

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

Hi lbass, I love your suggestion! I prob have 50 reports which use group record selection, so will benefit from your suggested approach, thanks [peace] I've used CR for years & read many CR books but remain stumpted by your idea [dazed] So ... is the rule that using Group Record Selection is...

Thanks kray4660!! Copying and pasting Running Totals has always been one of the biggest attractions of newer versions (along with handling Portrait and Landscape orientations in the same RPT definition). But, if I edit a copy of a RT (renamed from the original, of course) then I don't want the...

Grrrrr! I can't see the option anywhere and have long wished for the ability to copy Running Totals (not just formulas). So, I guess my version of CR is too old (it's XI but therefore isn't R2 and our IT folks won't upgrade). Shame.

Sounds very interesting Madawc, but I've checked several of my reports containing Running Totals - but can't see that option anywhere [sad] Do you have any ideas about when the option becomes available so that I can invesigage further ... I hate not having something haha! J

I didn't start this thread but am learning from other folks' problems etc. So purely for interest/learning, can someone please help my understanding? I don't understand the need for this statement in IanWaterman's solution: if ubound(split({your.field},"-")) > 0 Does it basically do the...

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

Thanks LB, I adapted your feedback to my report sections and it's virtually perfect [2thumbsup] J

That's fantastic LB, the new section did the trick [bigsmile] I don't know whether you expected the next question or not, but how does one now stop the entire GF3 from displaying based upon the value of that shared variable - which is read correctly?? That'd turn my 25 page report into a...

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

WOW!! How did you know there were any LOL?? I removed a percentage formula and suddenly it all added up. Thank you so, so, much LB. J [2thumbsup]

Hi LB, it's a new day so I followed your instructions again ... slowly and exactly : FORMULA1 (just as you suggested): ================================= whileprintingrecords; numbervar x := {#Cnt M01 Per Tutor} + {#Cnt M02 Per Tutor} + {#Cnt M03 Per Tutor} + {#Cnt M04 Per Tutor} + {#Cnt M05 Per...