Search results for query: *

ok, have a report that returns the following details, campaign ttl cls bizdays EOPGRAY 7333 5 EOPGRAY 4311 4 EOPGRAY 3713 5 EOPGRAY 6094 5 EOPGRAY 5335 5 EOPGRSKP 21 5 EOPGRAY 6294 5 EOPGRSKP 85 4 EOPGRAY 3459 4 EOPBEGRY 780 5...

I have 2 sql commands that run in under 3 minutes in sql as follows, the problem I am having is when I pull them into Crystal the run and hang forever, I have killed it everytime after an hour, I am linking them together on the d.yearmonthnum, I have tried linking every possible way, can anybody...

Is there a way to average a sum at a group level??? Ok, I have 12 weeks worth of data grouped to a weekly count I also need to get an average of the whole twelve weeks and compare that to the last week of data. So currently I see this... Grouped on date printed for each week 8/8/2010...

We recently acquired a company that has an MySQL database I need to get data out of, can anyone point me in the best direction to find out how to successfully link to the database with BO XI R2 & Crystal Reports???

(({Placements.name} in {?Company Name} or isnull ({?Company Name})) or ({Placements.customer} in {?Customer Id} or isnull ({?Customer Id}))) and {Placements.cob} in {?COB} Above is what I have in my record selection, I am needing to prompt for company, customer and cob, cob must ALWAYS have...

I have a query and I need to be able to prompt for 3 pieces of information, see below. WHERE (ccg.Name = 'MCG - Grays Harbor Comm Hosp' or c.customer = xxxxxxxx) AND C.COB = '00500 - Early Out Clients' c.cob is ALWAYS needed, however, if they fill in ccg.name then c.customer can be blank or...

Ok, trying to set up a Master-Shorcut scenario as follows, Report 1 will be in a master folder and I want to create a shortcut to report 1 in folders EOS & BDS, Security on Master for everyone is AL - Inherited Rights, NA - SCHEDULE, Security on Sub Folders is the same, is this the correct set...

Ok, new to administration of business objects and I am still learning. Security is set on all of this already, and what I want to know is how to FORCE a user to schedule a report, we do NOT want them to be able to run on demand, we only want them to get a report if they schedule now or create a...

Have a couple questions here, can I set a list of values for a parameter in a command??? I have a sql command as follows... (SELECT M.Received, Count(M.Number) AS ActiveAccts, SUM(M.Current1) AS ActiveAmt, c.company, c.cob, c.customer FROM dbo.Master M (NOLOCK) INNER JOIN dbo.Customer C...

I have a field type that contains the following Eopgray Eopgrays Eopbgry Etc… it is a (nchar(8), null), I am trying to create a parameter but its not working, I have tried several things and can't get it, any ideas???? When I do as is I get an array error.

Have a report Month Total Calls Daily Average 1/2010 914,416 2/2010 432,581 3/2010 426,258 4/2010 165,872 5/2010 246,191 6/2010 328,448 Need to be able to determine the daily average based on # of days in each month. The number in total calls is a count of a specific...

Need help with the following, fairly new to sql. The inner join is not working correctly because the transactiondate has an actual time and the fulldate has all zeros so I just want to join on the dates, how do I strip off the time and accomplish this???? select r.startcall, r.skillset...

Ok, not sure if the best way to do this is in a cross tab or not but basically I need to provide the following, Last Full Week 195 4 2.05% MTD 212 3 1.42% Last Full Month 304 9 2.96% For some reason I am struggling...

I am being tasked with coming up with a solution for archiving old reports and instances, can anyone help with this???

Can I get a sum of dollars based on the distinct count of another field??? Example... 120.00 123 1621.73 456 543.40 789 175.00 012 175.00 012 From the above I am seeing 2635.13 5, I would expect to see 2460.13 4.

Recently started a new job, their current structure is BO XI R2 SP 2, what release do I need to go to and become up to date, ALSO, all reports in system are crystal, all reports are housed in the repository is there a way to export them out WITHOUT having to open and save each one seperately...

Couple of questions, Is Crystal 2008 v1 sp2 compatible with business objects xi r2??? When I try to open a report from enterprise I get an error saying I can't open a previous version of the CMC. How do I determine what version/sp of business object I am running???

I have to get two lists out of Business Objects, one is a list of all users, the other is a list of all reports in their folder structure with last instance ran. I am not real familiar with query builder but am assuming its not any different than sql. Any help would be appreciated.

select * from accumulator where accumtype = 'Maxout' and (description not like '%OON%' and description not like '%In-Net%') I need to incorporate the above SQL criteria into a Crystal XI report formula but it is NOT working, any ideas?? Below is my Crystal formula. if {accumulator.accumtype}...

I have a cross tab as follows: 123 456 m123 name ma123 m123 m678 m912 123 456 m123 name ma123 m123 and so on and so on. What I would like is to see the details from the first 5 columns carry down for each...