Search results for query: *

I am creating a measure in the universe as current YTD. I have created the Individual month measures for 2011 and 2012. like there are two folders 2011 and 2012 and in that they are month measures from jan to dec. 2011 -----...

The problem was solved.. RevCycleTemplateEffectiveDate is the respository custom function that i need to add to the report and use that in the report... I was not adding that to report and was trying to create a formula based on that Thanks for your reply and help...

i have one crystal template which has one formula EffectiveDate: RevCycleTemplateEffectiveDate + ToText(DataDate) I tried applying this template to my report. when applied the template i was not getting the formula which is in template and when i try to create that formula in my report its...

In my report i have group on Username,auditstamp,pkgid when i group by username under that i may get 5 or 6 dates and after that there is a group by pkgid. I need to get two random pkgid's for each user with the respective dates Please help me out its very urgent Thanks, reacha

i want the 2 pkgid's which are random with the corresponding dates Please help me out!! Thanks, reacha

Any two pkgid's for any dates so that they want to quality audit process on that

@reset ------ whileprintingrecords; numbervar cnt := 0;

befor start of the group you can create one reset forumla as @reset ------ whileprintingrecords numbervar cnt := 0; Thanks, reacha

I have a report in which first i have grouped by supervisorname,username,auditdate,pkgid Now i need to get only 2 pkgid's for each username they should be on different dates For Ex: Supervisor Username Auditstamp pkgid ---------- --------- ---------- ------ TOM Peter...

Thanks lbass. Surely,I will help others by responding to there threads if i know the answer Thanks, Rupa

The same case as i posted earlier (Need to get the first record from the third group) but in this report i have group by username and then group by accountnumber and pkgid. now i have the count({command.pkgid},{command.pkgid}) i need to get the username and accountnumber,pkgid when the count...

Thanks very much it worked for me.... I have grouped by user,Scanneddate,accountnumber. Placed the group headers of scanneddate and accountnumber in the groupheader of user and suppressed everything Thanks, reacha

No i need the username plus oldest date and the account number associated with that date and all others need to be supressed Username ScannedDate AccountNumber --------- ----------- ------------- tom 11/24/2010 1000 George 11/6/2008 2000...

It was also wierd for me.. but i got the error in crystal reports when trying to choose date from the calendar... but when i enter the date manually the report was running fine. The calendar option is not working for me.. I am assuming that there might be some file missing in from the...

Actually i have first grouped by user than by scandate and then by account number if a user has 3 dates and 3 account number correspondence to that 3 dates.. i need to get the account number of the oldest date means i grouped the date by ascending order the oldest date comes first i need to...

In my report i have group by username,ScannedDate,AccountNumber. So i need to get the only one account number per user that is oldest account associated with that user for EX: Username ScannedDate AccountNumber --------- ----------- ------------- tom 11/24/2010...

i tried that but still the same error Thanks, reacha

i am getting the same message... actually i have created parameter timeperiod which is string In that i have last4weeks and daterange {AUDIT.PROCESSNAME} = "MCR Auth" and {AUDIT.AUDITMSG} = "Event completed by user" and (if {?TimePeriod} = 'DateRange' then Date({AUDIT.AUDITSTAMP}) >=...

i am getting different values if i use Auditstamp = Last4WeeksToSun and Auditstamp in DateAdd("ww", -4, currentdate) to currentdate what is the difference in these two and some times i am getting more than 4 weeks if i use any one of those. I need to get exactly Last 4 weeks Thanks, reacha

{AUDIT.PROCESSNAME} = "Auth" and {AUDIT.AUDITMSG} = "Event completed by user" and (if {?TimePeriod} = 'DateRange' then Date({AUDIT.AUDITSTAMP}) >= {?StartDate} and date({AUDIT.AUDITSTAMP}) <={?EndDate} ) when i was trying to select enter the parameter values like on the calendar option i was...