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

ok so maybe I can't even do what I need, the reason I was using what i was is i need to be able to prompt for Begin Date, End Date, COB, & Company ID but cob & company id need to provide a list of choices for the user to select and in company id there can be more than one choice. The only way to...

ok, i have done this and linked like you said but it is not limiting the data. main rpt sql DATES SELECT d.yearmonthnum, ccg.name, ccg.id, c.customer, c.cob FROM dbo.Master M (NOLOCK) INNER JOIN dbo.Fact F (NOLOCK) ON M.Customer = F.Customerid INNER JOIN dbo.Dim_Date D (NOLOCK) ON...

Thank you TeyBrady, this is pretty cool and it works however it takes a very long time to run but if i am working with smaller data sets this could definately be used. LBASS, I have the 2 sub reports in the report footer of the main report, 2 subs have same parameter, do I need to pull in data...

Sorry lbass not sure what you mean so make each sql a subreport and on the main report create the prompts for begin date and end date and then link to sub reports??? I am sorry for appearing dense but how will that speed up the return???

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

Thank you, worked perfectly.

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

I'm sorry but when I use your solution in Crystal It still is not allowing me to leave one blank. I too am not understanding why your solution won't work, you had {?SelectGroup}, is this a formual I should be using???

This is inside Crystal Reports that they are now wanting this done and it is not allowing me to leave any field null.

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

Ok, can i do a dynamic list of values in the command, the user will not always know exactly what the input should be??? Also, is it better to set up parameters like this in the command or inside crystal, the reason i ask this is there are 18 sqls that make up one report.

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

Ok, got it to stop throwing the error by putting, {?Company Name}[1] in {Transactions.CampaignName} HOWEVER not it takes FOREVER to run, is there a way to do this better and possibly speed up the performance???

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