Recent content by fallsr

Thanks for the input. Your response confirms my understanding that there is no good solution. Unfortunately, the format of the data wanting to be sorted is very inconsistent. The expectation is from the client as they need to be able to identify available number sequences to assign to new...

I have used solution located here and it works. http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do;jsessionid=D460FF3706037B6A62EEE536D346D479?cmd=displayKC&docType=kc&externalId=c2005689&sliceId=&dialogID=360384&stateId=1%200%20356275 Thanks, Bob

What I need or expect is that the data be sorted alpha-numerically from position 6 and beyond. The code I found tends to ignor "-" and other special characters. What I am getting is almost what I need except that the default sort is an alpha sort so numbers do not order properly. I don't know...

I am working in Crystal XI against an Oracle database. I need to sort my data alpha-numerically. I have a lot of different combinations of alpha and numeric data. The data is drawing numbers for old facilities where there are often up to 100,000 rows to be sorted. Example: 5A90-1 5A90-2 5A90-12...

Outstanding - I appreciate your reply. Thanks, Bob

Working in BOEXI - need to know what the schedule object can contain. Expect things like frequency and parameters but what else can the schedule contain? Thanks, Bob

Using BOEXI - would like to know all of the elements of a schedule. Obviously, the frequency and database connection info but what else? Need to know everything that a schedule could contain. Thanks, Bob

bwdude, We are on BW 3.0b and CE 8.5. We went to Business Objects and they thought it was a registry setting on the number of datasources that you can see in the Data Explorer. I am still not sure exactly what the problem is but we have a work-around. Typically, when I create a report I use the...

I created a BEx query in the Business Warehouse (SAP) like I have many times but this time the query is not available in the Data Explorer. I am curious if anyone else sourcing BEx queries from SAP BW has had this problem. Thanks, Bob

I needed the first Monday of every month for performance indicator work. I used a formula from the BusinessObjects Knowledge Base article number c2006781 as the basis for the following code. Create a formula like @FirstMondayOfMonth Local NumberVar yr; Local NumberVar mo; yr :=...

I had a similar need - I needed the first Monday of every month. I used a formula from the BusinessObjects Knowledge Base article number c2006781. I think you will find what you need there. Thanks, Bob

http://support.businessobjects.com/library/kbase/articles/c2002512.asp shows a couple of ways to get your parameter with both of its values to display.

Yes there is. When you put the report on the enterprise server, your hyperlink must be made to "A web site on the internet." On the server, there is a Crystal Server Page that the report is identified on. Your Crystal administrator should be able to provide you with the url you need to do this...

No - the connection string for the database is identified or chosen when the report is developed. At runtime, the user (or the schedule) simply provides a password. What I am looking for is a function or formula that gets the database name (i.e., connection) for display purposes. I can create a...

This would be a standard report connecting to an oracle database. This is done outside the application. Could you provide an example of your suggestion? Thanks, Bob