Recent content by dukeslater

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