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!

Register Log in
  • Congratulations Rhinorhino 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: reacha
  • Content: Threads
  • Order by date
  1. reacha

    YTD calculation

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

    applying template to existing report

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

    help in using rnd function

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

    Help needed with the report

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

    help needed in report

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

    Need to get the first record from the third group

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

    An error has occured in the script on this page

    {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...
  8. reacha

    Getting last4weeks data

    I have a report which is grouped by username first and after that grouped by auditstamp for each week. now what i need to write in the record selection to get last4weeks data Please help me out!! Thanks, reacha
  9. reacha

    help with placing an image in group header

    There is a group called supervisor in my report and each supervisor has personid associated with him. but if there is any blank supervisor then the image should come as blank..but i am still getting image.. I have placed OLE object an in format graphic used this "http://quarterly.edu/photos/"...
  10. reacha

    help in creating a dsn on business objects enterprise

    I need to create a dsn on business objects enterprise. Steps in creating a dsn on business objects enterprise Please help me out!!
  11. reacha

    help with creating a dsn on business objects enterprise

    Please help me in creating a dsn on business objects enterprise Thanks, reacha
  12. reacha

    Exporting a report which has ondemand subreport in that

    Problem with exporting the report which has on demand subreport in it. Pleaase help me out!! Thanks, reacha
  13. reacha

    problem with getting data from subreport

    In the main report i have a groupby name and using subreport i was getting the repective values for name from subreport. linking the main report and subreport by name. but i have some Null values for name in subreport and Main report does not have any Null values.how to get the data for that...
  14. reacha

    Help with the hyperlink in the chart

    Can anyone please tell me how to insert a hyperlink on one of the axes in the chart. I have a chart called completed emails/supervisorName In the chart layout advanced option in the on change of option i used supervisorName and on the showvalues as count(ID) i need to insert a hyperlink on...
  15. reacha

    Problem with parameter when using lastfullweek

    The query that i have to build the report is declare @test table(pkgid int,processid int,EventName varchar(100),Auditstamp datetime) insert into @test(pkgid,processid,EventName,Auditstamp) SELECT AUDIT.PKGID, AUDIT.PROCESSID, EVENT.NAME, AUDIT.AUDITSTAMP FROM AUDIT INNER JOIN...
  16. reacha

    problem with retrieving the value from subreport

    I have a main report which is grouped by Name and processid which gets the data for the previous day. I have a subreport which gets data for all the days. Now i created a 2 subreports each for one group but the problem is if in the main report there is a value for the name in main report and...
  17. reacha

    retrieving the value from subreport into main report

    there is a report which has two groups called Name,processid in it The main report is showing the data for yesterday Name Processid Emailscame emailcomple emailsoldyester Agency 7 1 0 6 6 2 2 5 Attorney...
  18. reacha

    help in using yeartodate and monthtodate in selection formula

    I am trying to use this in my selection criteria but when i run the report for monthly the values were not correct Is this the correct formula to use Year ({Command.AuditStampEntered}) = 2010 and ( if {?Time Period} = 'Weekly' then ({Command.AuditStampEntered} = WeekToDateFromSun) else if...
  19. reacha

    Scheduling the report on Business objects enterprise

    When i shedule the report on Business objects emterprise in excel format to go to my mail box. When i tried to open the report that i got in my mailbox getting the different format which i cannot open Please help me out!! Thanks, reacha
  20. reacha

    SCheduled the report on BO Enterprise

    When i schedule the report on Business objects enterprise in excel it gives me different format other than excel when the report comes to my mailbox Please help me out!! Thanks, reacha

Part and Inventory Search

Back
Top