Search results for query: *

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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