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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DarthGAD

  1. DarthGAD

    How do I parse text between two "tabs" in a memo field

    I meant to say between two "Tags" NOT tabs. Sorry about that.
  2. DarthGAD

    How do I parse text between two "tabs" in a memo field

    QUESTION: How do I parese a list of names stored in a memo field so I can put them on separate rows of data. BACKGROUND: I have a memo field that includes, among other things a list of names separated by comas. The names are between two tags <SME> and </SME>. Here is an example: The list of...
  3. DarthGAD

    How to combine result sets from different DB using Business View

    satinsilhouette: The question is how to do it. Remember that I am trying to combine both tables into one result set. Something I would typically do with a untion such as: Select DeviceName from SERVER1.DB1 union Select DeviceName from SERVER2.DB2 So if... SERVER1.DB1.DeviceName had the...
  4. DarthGAD

    How to combine result sets from different DB using Business View

    Crystal Reports XI with BusinessObjects Enterprise XI BusinessViews MS SQL 2000 Databases I have two database servers SERVER1 AND SERVER2. SERVER1 stores realtime data in a table. SERVER2 stores historical data and has a view to access the data. Datasets are compatible (Same fields) SAMPLE...
  5. DarthGAD

    Where are the users and groups stored in CMS database

    The data is encrypted. Starting with CE 10, Business Objects does not allow reporting off the system DB. You need to use the managment console, a third party tool (APOS has one), or write your own using the SDK.
  6. DarthGAD

    Who is using my 10 concurrent licenses

    The sample reports are located in the CD. Page 339 of the Crystal Enterprise Administrator's Guide has instructions on how to use the sample audit reports. You can publish them to CE or use them with Crystal. Note: You will need to crate an audit DB and enable auditing on the corresponding...
  7. DarthGAD

    Advanced Reports?

    It's all relative to the environment, data source, quality of the data, etc. If I have to write a supposedly simple report from a database that is poorly written it may take advanced skills to pull it off. Advanced is also ralative to your experience. A seasoned report developer may be able...
  8. DarthGAD

    Can't publish a BO XI report to BOE XI Pro???

    Do you get the Development tool for BO in BO XI Premium as well? It seems that they are also allowing one to publish all three types but one has to buy the development licenses separately. This makes sense when you use the stand alone client but for Web Clients Such as Crystal Explorer 10.5...
  9. DarthGAD

    Scheduled Reports in Enterpise 10

    One last question? Did you purchase the maintenance agreement? If so, you are elegible for the BOBJ XI R1 or R2 upgrade. If you are starting from scratch I strongly urge you to consider the benefits of the upgrade in your envoronment to see if it is worth the effort. I upgraded from CE 10 to...
  10. DarthGAD

    Scheduled Reports in Enterpise 10

    If you have Crystal Enterprise Express than you will most likely need to install Pro. I am not sure if you will be required to uninstall Express before upgrading to Pro or if the Pro license key will unlock Express to Pro. I tested Express and Premium on separate lab boxes and only installed...
  11. DarthGAD

    Can't publish a BO XI report to BOE XI Pro???

    What did your CE 10 license include? Did you have a license of BusinessObjects 6.5 or earlier (Their analitics product). The picture will get more complicated. We own XI Premium but I am still trying to sort out what we can publish. For sure we can publish CR and OLAP but Webi is still up in...
  12. DarthGAD

    Who is using my 10 concurrent licenses

    Are you using the Professional or the Premium Version? If you are using the Professional version, did you purchase the Auditor add-On? If you are using the Pro version with the Auditor Add-on or the Premium Version you can: 1. Enable auditing 2. Install the sample reports There are several...
  13. DarthGAD

    Scheduled Reports in Enterpise 10

    What version Enterprise are you using? CE 10 Professional, CE 10 Premium, XI Pro, XI Premium, etc. This would help to troubleshoot.
  14. DarthGAD

    Hiding Group Tree in BO XI

    One last point to clarify: For the .NET, you have to set the value of key=”viewrpt.groupTreeHide” to True and value of key=”viewrpt.groupTreeGenerate” to False in the c:\program files\Business Objects BusinessObjects Enterprise11\Webcontent\ web.config file.
  15. DarthGAD

    Command parameter changes name when used with report parameters

    Can you post the full code for the Command? From my experience, if you create a command parameter it becomes available for you to use in the report. Are the names of the command parameter and the report parameter the same? If so, that may be the problem. I have not tested this however.

Part and Inventory Search

Back
Top