Search results for query: *

Working now - Oracle client was working, but reinstalled MDAC and configured it normally. Thanks for your help, but can anyone tell me why the MDAC components might vanish??

SQL Server 2000 linked server to Oracle was set up and working fine for over a year. It quit working - not sure what happened - but when I deleted it and tried to add it back, there are no providers in the dropdown. I can add it via Query Analyzer, but it still won't work (error 7399)...

Put a distinct count of the datefield in the group footer for the week. Then put a count of the same field in the same group footer. This formula is the average: Count({table.Datefield}, {table.datefield}, "weekly")/ DistinctCount ({table.Datefield}, ({table.Datefield},weekly")

I think a better approach is to create a date table, which can be easily populated with a record for every day from now through whenever. You can include a column that has the corresponding first day of the week for every date, one for fiscal year, fiscal quarter, payroll date, whatever you...

I'm guessing that you have created parameters for each level of your cascading prompts. For instance, if your hierarchy is: Country State City Then you only need to create one parameter for {?City}, not one for each level. Let me know if I'm wrong.

Finally found the thread I was looking for - 149-1356319, and in this case the answer was even simpler - just put the following formula in the display string: whileprintingrecords; numbervar v_totalcount:= currentfieldvalue/10; totext(v_totalcount,"#.#") Retroactive thanks to lbass.

Crystal XI crosstab issue: 2007 2008 2009 Total Town 1: 3 5 8 16 Don't need the total, but I'd take it if needed. What I really need is a calculation on the total (divided by 10): 2007 2008 2009 Total Target Town 1...

Never mind - it's in the history.txt in the Program Files\Business Objects\Business Objects 11.5\Patches directory. Thanks.

Complete brain lock - how can I tell which patches have already been installed in my recently inherited XI RS system?

I appreciate your comments and I'll file that away for future use. In this case I'm simply suppressing various company logos, so I need the actual value of the max appID to suppress all logos but one, so a boolean won't work. The problem I was having is that if the report returned no values...

Well it's simpler than that for now but you opened my eyes. I have to test the field value (or in this case the max field value), not the variable. whileprintingrecords; numbervar v_appID; if isnull(maximum({Command.appgroupID})) then v_appID := 99 else v_appID :=...

I may be especially stupid today, but how can I test to see if a variable value is null in CRXIR2? whileprintingrecords; numbervar v_appID; v_appID := maximum({Command.appgroupID}); v_appID; The variable defaults to 0, but if the report returns no records then it's being assigned a null value...

Thanks elsenorjose - That's good information. What I've found out since is that the problem only occurs with the .NET Infoview, and the message is something very much like “Unable to parse XML structure” Interestingly, the .NET Administration tools work fine. I'll continue to post as...

Anyone know anything about Enterprise XI blocking client access when using Internet Explorer 7? I haven't uprgraded yet, but I've heard there is a problem. Nothing in BOBJ hotfixes yet.

Not too strong on crosstabs, so hopefully this won't be too difficult. I have a crosstab which calculates employee terminations by week: 11/1 11/8 11/15 11/22 Total 1 2 1 3 7 I also have a static number of total employees at the beginning of the...

Paulmarr - I desperately need to talk to you about an archived thread. Search for my handle and you'll see the thread I opened. Thanks, dukeslater

Steps tried so far: Verified that the database password is stored within the report object in Crystal Server. Verified that the reports will process properly within the Crystal Reports designer on the Crystal Server. Verified that the job and page servers are running under a domain account...

Job and page servers run under domain admin account; others run under local system account. What I mean is that I can refresh data against the Progress system dsn within Crystal Reports on the Enterprise server with no problem. If I schedule them via the CMC or Infoview it fails with "The...

From archived thread 782-1164845: "paulmarr (Instructor) 13 Dec 05 18:04 Hi everyone, Perhaps someone could point me in the right direction. We are using CR v10 and CE10. We have created reports against a Progress Database using the MERANT 3.60 32-BIT Progress SQL92 v9.1D ODBC driver that...

Beautiful - thanks!!!