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!

Register Log in
  • Congratulations derfloh 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. petperson

    Count Query not Returning

    I'm trying to get a count of households where there is not a Head of household defined. There are different account types for different members of a household - but there should only be one head of household. Please help! My query is set up like: SELECT HH, COUNT(HH) NumOccur FROM HHOLDS...
  2. petperson

    BOE-XI from version 5-6...

    Hello, I have been out of the Business Objects arena for several years. The last version I worked on was either 5 or early 6. I am now going back into BUSOBJ with the current version. From what I understand, the architecture has pretty much completely changed from previous versions. Having...
  3. petperson

    Data Integrator - BusObj

    Hello, Am looking for any comments on using Business Objects' ETL tool, Data Integrator as a stand alone. For a small, startup company, not alot of data sources, not alot of data..yet. Will implement using MySQL data warehouse. They are looking to pair it up with MicroStrategy on the front...
  4. petperson

    Data Integrator as Stand Alone

    Hello, Has anyone used DI as a stand alone ETL tool? Can it be used stand alone and then another BI reporting tool be used on the front end? thanks, p.p.
  5. petperson

    SQL generated behind a Prompt?

    Does anyone know/remember the shortcut key combination to get MSTR Desktop to show you the SQL that was executed to generate a prompt? As I recall, you would execute a report, then you are presented with the prompt. At that moment, you could do something like ctrl-alt-m-o-u-s-e and get a window...
  6. petperson

    New BO Implementation - Linux?

    Is there an advantage of running BO (Crystal Decisions) on Linux vs Windows O/S? Are there disadvantages? Comments welcome. thanks
  7. petperson

    BusObj Hardware Specs

    For a small startup company, does anyone have a baseline for hardware specs for a BO implementation? I am looking for a windows platform, memory, CPU, processors, etc. I know what the 'recommended' minimums are; but am looking for some real world configurations that work well. Environment may...
  8. petperson

    correlated subquery and UPDATE

    trigger was the problem..thanks for pointing it out.
  9. petperson

    correlated subquery and UPDATE

    any idea why this: update individual set referenceid = 11 where individualid in (select refid from ref_temp2) would generate the following error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <= , >, >= or when the subquery is used as an...
  10. petperson

    Using an Oracle Store Procedure for decryption

    Hello, We have been tasked with decrypting certain fields within the data warehouse, ie, credit card number. If the value is stored as an encrypted field, is it possible to run a stored proc to decrypt the value so that it can be displayed on a report or used to join to another table? Would...
  11. petperson

    Changing Mouseover on 'Jump to URL'

    Hi, I have a navigation set using the 'Jump to URL'. Is there a way to have the name of the field change color (red) and underline when mouse over? Currently the mouse over just displays what I have in the tooltip, but I would like it to also change color and be underlined to appear more...
  12. petperson

    ThreadStart Delegates

    I am very new to C#. I need to create a windows app to practice multi-threading. My form is simple with a start button and a stop button, and 2 text boxes to display output. Requirements are: the Start button 1)creates a SharedMsg boject and a SharedClick object 2)creates a Server object and a...
  13. petperson

    Sharepoint Portal Server

    New in version 8.01 (GA in a couple of weeks), MSTR now integrates with several portlets. One of which is Microsoft's Sharepoint server. I have been trying research this for awhile - and am not exactly clear on whether or not MSTR Web must be loaded on the same server as Sharepoint in order to...
  14. petperson

    Date/Time datatypes

    thank you xlbo, can you give me an example of the syntax?
  15. petperson

    Date/Time datatypes

    Actually we are populating a table in SQL server from an Oracle database. The date fields in Oracle do not have timestamps, but when I build the table in SQL server, it has a timestamp of 00:00:00 appended to the date. This timestamp displays in my report and I would like to display only the...
  16. petperson

    Date/Time datatypes

    Reading more about SQL Server, I discovered that there are only 2 datatypes to handle dates, smalldatetime and datetime - both of which store timestamps. I am confused however, how when displaying dates in RS, you only display the date portion of the field. Is this possible to do in RS...
  17. petperson

    Number of Tables

    Hello, Still quite new to RS, I am learning the tool with books and by just playing with it. Is there a limitation as to how many tables you can add in a dataset? Does it get complex as to how the tables can be joined together? Are you able to specify the join relationships? Just curious as...
  18. petperson

    New to Reporting Services - Deploying

    thanks for the info, and also directing me to the right forum.. p.p.
  19. petperson

    New to Reporting Services - Deploying

    Hi, this is my first time working with Reporting Services. I have a report built and am trying to deploy it to the target URL, but the build message tell ms me that the permissions for user 'me' are insufficient for performing the operation. Is this an IIS priviledge I'm missing or is it SQL...
  20. petperson

    Upgrading from v724 to v754 or v8?

    All in all, our upgrade went well. There are always a few issues to deal with. I think the one that has caused the most pain is the fact that 8.0 web no longer supports IE 5.5. We didn't realize that we had field users still on IE 5.5. Screens are distorted and reports with prompts are very...

Part and Inventory Search

Back
Top