Search results for query: *

I am trying to create a Stored Procedure that the columns can be accessed in SSIS and processed. Here is an example of the code that I am trying to produce: MS SQL 2005 and Visual Studios 2005. CREATE PROCEDURE AIMS_sp_BuildReport04_Barcode_No_Match AS SET NOCOUNT ON CREATE TABLE...

Hi All, I would like to produce a field definition list so that I can export it to excel. Does any know how I would do this?

I would like to create a stored procedure that contains the following logic: Create myproc with out parameters TempCPT4F Create tempA1 table Create tempA2 table Create tempB1 table Create tempB2 table Create tempC1 table Create tempC2 table Create TempCPT4F table...

Hi All, Is it possible to create a custom function that queries an Oracle Table and brings back the results?? I have a Table in the Main (Relationship=1-1) and another Table (Relationship=1-Many) which has nothing to do with my report except I need to know if the userid exists against the...

Hi All, I need to evaluate the following and I think my syntax is wrong. Please help!! IF ({Q.SAMPLENO} = {Q.MASTERSAMPLENO} OR ISNULL({Q.MASTERSAMPLENO})) OR {Q.ISTIMEWEIGHTED} <> -1) AND {Q.APPROVED} = -1 AND ***** This replaced the Oracle Function ***** (IF...

I know I can create a blank main report and add my detail to a subreport and pass the CurrentCEUserName from the Main Blank Report to the subreport and this will prevent the subreport from prompting a parameter that is referenced in a stored procedure. I would like to know is there anyways to...

How would I call a Function within an Oracle View?

I have a Report that I want to mimic the NOT EXISTS clause in Crystal Reports XI R2. I have a Report that uses Business View Manager linked to Oracle 10g database. I am only using the Main Survey Table Only in my Crystal Report. If the ProductID Parameter is ...ALL then I want all of the main...

Hi All, I am working with --> Business Objects XI R2 (View Crystal Report using InfoView) --> Business Views XI R2 ( access the data using Oracle 10g ) building LOV location table with the proper access to the location(s) they have to. --> Crystal Reports XI R2 (Database connection is the...

Hi ALL, I have a Description Table with approxmiately 90,000 records in it. I would like to break that up into smaller chunks so that it is not a drain on performance. So I created a cascading prompt i.e.. Status (Level 1) Value (...ALL/Active/InActive)...

Hi All, I can't remember but I use to be able to pull custom parameters up by referencing another customized crystal report i.e.. ?MyReport.State.rpt Does anyone remember doing this? The Dynamic parameters in Crystal are not producting the functionality that I need. Thanks, Rick

Hi All, I am having a problem with Business View Prompts. I am trying to follow the instruction on creating prompts but I seem to come up short getting the interface to work. My environment is BOE XI R2 and this is were I created the Business View with LOV prompt. I then login into the BOE...

Hi everyone, I have a Union SQL query on the AS400 that I need to access in the AS400. I have worked with other systems were I can creats a stored procedure or a view and join the multiple select statements just fine. I have never worked with Stored Procedures on the AS400. Any Suggestions...

Hi, I am new to Web Parts and I would like to know what software is needed to create web parts. Also what would be the best books on web parts. I am currently using Microsoft Visual Studios 2005. On the MSDN website there are web part templates, but they are not for my version of Microsoft...

I recently installed Business Objects Portal Integration Kit for Sharepoint. I am able to see Web Parts Reports To You which it says it is from Business Objects. It pastes sucessfully to the portal but I get the following message: Auto signon to the BusinessObjects Enterprise infrastructure...

I recently installed Business Objects Portal Integration Kit for Sharepoint. I am able to see Web Parts Reports To You which it says it is from Business Objects. It pastes sucessfully to the portal but I get the following message: Auto signon to the BusinessObjects Enterprise infrastructure...

Hi everyone, Does anyone have any examples of creating a webpart for Sharepoint (Crystal Reports)? Thanks, Rick

Hi everyone, I have tried to import Crystal v9 Server information to BO Crystal XI, the onle\y data that will move over is the sample information. Someone here has moved the data files from Drive C:\ to Drive F:\. Ho do I point to the correct information? Help Please Thanks in Advance Rick

Hello, I am new to Sharepoint and I would like to be able to view Business Objects Crystal Reports version XI inside of Sharepoint. Any Help would be appreciated. I have Sharepoint on 1 server FINAPP1 I have Business Object Report Server XI on 1 server FINAPP2 I have MS SQL 2000 on 1 server...

Hello, I am new to Sharepoint and I would like to be able to view Business Objects Crystal Reports version XI inside of Sharepoint. Any Help would be appreciated. I have Sharepoint on 1 server FINAPP1 I have Business Object Report Server XI on 1 server FINAPP2 I have MS SQL 2000 on 1 server...