Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BOjdh2n

    My InfoView in release 2 is greyed out

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

    Upgrading Crystal 10 to 11 - Any known issues

    Are you using Crystal REport XI or XI R2 Developer addition? The web viewers only come with the developer version of Crystal Reports XI and XI R2.
  3. BOjdh2n

    Count Hours

    Please Do.
  4. BOjdh2n

    prompt to log on to server, prior to log onto enterprise

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

    Using MS Access Query in Crystal

    What .mdb driver are you using?
  6. BOjdh2n

    Using Date to select records...

    Thanks, Good catch and recomendation for passing the SQL to the DB.
  7. BOjdh2n

    Can I show all fields when the fields have no data?

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

    Extracting part of a string based on a pattern

    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'
  9. BOjdh2n

    Can I show all fields when the fields have no data?

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

    how can i insert a character

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

    Business View Parameter Issue

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

    CMS clustering

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

    Upgrading Crystal 10 to 11 - Any known issues

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

    Crystal Reports and Sharepoint

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

    Using Date to select records...

    Or you can use: datediff('d',{Reservation.insert.date} - {Scheduled.Ride.Date}) >= 7
  16. BOjdh2n

    CR XI Asks for parameters twice

    What steps did you take to attach a LOV to your Stored Procedure Parameter? List them out Please..
  17. BOjdh2n

    Count Hours

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

    Sub report Not showing

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

    Username / Password required for all Reports

    Use a File based DSN and store the User name and Password in the File DSN.
  20. BOjdh2n

    Can CR write back to the dB

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

Part and Inventory Search

Back
Top