This issue has been resolved with the latest Monthly Hot Fix for Business objects XI R2 revision 11.5.7.607. The monthly hot fix was relesed in october and you can download it at http://support.businessobjects.com/downloads/monthly_hot_fixes/boxir2.asp
Make sure the FQDN of the server is listed in the "Trusted" domains list in your Internet Explorer Settings. Specifically make sure that the “Automatically Logon with Current User Name and Password” setting is selecting. Internet Explorer will assume that Host names containing a "." belong in...
In the past I have had similar issues with trend reports. The fact is that Crystal Reports can not report against data that does not exist in the database. You can trick the report by left outer joining your transaction Table to a “Calendar Table” (As suggested Above) but you can not filter data...
Based on your example you can do the following:
Local numbervar w := instr({Field},'reflector:');
local numbervar x := len({Field});
If instr({Field},'reflector:') <> 0 Then Mid({Field},w,x) Else 'not in string'
Try changing your Report Options to convert database NULL values to default. You can find the option under the reporting tab in the individual report options or Crystal Report options.
Try a Formula like this:
Mid({field},1,30) & " | " & Mid({field},31,30) & " | " & Mid({field},61,30)
Replace {field} with the free text field and repeat the
"& " | " & Mid({field},61,30)" untill you reach the maximum size of the field.
Check the security rights on each object and field in the business view, element, foundation, and data connection used by your LOV. Sometimes the import wizzard removes the original rights and assigned a default list that does not allow anyone to view the Business View.
Clustering requires a good understanding of the Business Objects enterprise architecture. It would be difficult to list out all the facets required to “Properly” cluster the servers in your environment. The guides listed above provide a good starting point, but I would recommend that you acquire...
I go through the migration almost weekly and have found that 99.9% of the information in transferred over without issue. For example: I have found minor glitches with the Crystal Web Viewers causing columns to overlap when they should not and the Oracle 8 clients is not supported in XI R2. The...
There is a SharePoint integration kit for Business Objects XI and XI R2. Look for Portal Integration Kits at http://support.businessobjects.com/documentation/product_guides/default.asp
If I had the time I would build the formula, so let me apologize in advance for the following answer:
The short answer is that you will need to build a dynamic array consisting of the each “date time” with in the range of the beginning “date time” to the ending “date time” field. Then evaluate...
In addition to what "synapsevampire" posted, try to replace each sub-report with Sub-query’s used in an Access Query.
For Example:
SELECT
[FIELD1],
(SELECT [FIELD3] FROM TABLE1 WHERE TABLE3.FIELD1=TABLE1.FIELD3)as SQuery,
[FIELD2],
[FIELD5]
FROM TABLE3
When you specify the...
If you are using a version of Crystal Reports that support the "Command" style connection, then you can execute a Stored Procedure then Execute a Select Statement. I implement this process routinely to create what I call "Fly Marts" or to remedy situations where I run out of report passes...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.