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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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