Search results for query: *

Good day to you ! I am setting up a SAP BO Enterprise XI site for a demonstration. I had set it up successfully except for the email delivery. I am still unsuccessful to send the email out. This is set up on my work PC running on Windows 7. I have local admin rights and i am trying to use my...

Hi, It seems the structure is ID,Jan,Feb,Mar... Use the UNION operator as shown below and you will get the result set as ID,Month,Value. SELECT ID,Month,Value FROM ( SELECT ID,Month='January',Value= Jan FROM table WHERE ID=selectedID UNION SELECT ID,Month='February',Value= Feb FROM table...

Hi, Thank you for the reply and my apologies for the late response. I use TOAD and tried to run the modified script (I took out "where example_number = 2;" ). But it is asking for a value for :In_Date_Time and I provided a date. The script is running but how can I get the results out ? I...

Hi, DBMS Oracle 9i, Reporting tool Crystal Reports XI In my warehousing system, the DateTimes the trucks unload items are manually entered, in order to compare against other system generated DateTimes. But the dates are not always correctly entered in the proper format. When I tried to use...

I do Reports Development with Crystal Reports, Excel & host of other tools. Recently I am asked whether I am experienced in; "Extracting information and building reports on IT security and risk associated with IT processes and procedures" Could some expert in IT security advise me as what type...

Thanks MJRBIM, Is there any book I can use to practice developing this using .NET SDK ? SenaMuna

Hi, I use CR XI/ Windows XP. We do not have Crystal Enterprise. I need to run a production statistics report at 7.00 AM every day. Is there a way to schedule the report to run at the pre-set time ? I tried to use the built in scheduler in XP. But it only opens up the report. I need to...

Thanks lbass, That should do it. Do I need Crystal Enterprise ? Regards, SenaMuna

Hi, Can a list of values in a .txt or.xls file be used as parameters for a report ? I need to lookup hundreds of order numbers to check order status. Currently, IT staff has to run a query for the customer service team. I use CRXI with Oracle & DB2 databases. Thank You SenaMuna

Hi, I Use CR XI. I am trying to export a Crystal report to an Access database. I have set up the data sources, but when I try to export, I get the error "Failed to export the report. There is no valid datasource for this report. ODBC export cancelled". Then I tried to export to other ODBC...

We are implemetning BOE to deliver scheduled reports by E-mail. Rather than always sending the full report, is here a way to send an e-mail if an exceptional condition occurs only ? For example there is a report checking for deliverieds not invoiced. Is it possible to dispatch report only if it...

Hi Synapsevampire, Sure. That's the shortest solution. Unfortunately, I only have read-only rights to the database.

Thanks to all who tried to help me. I figured out how to achieve what I wanted. 1. Use "all read" login. Create SEPERATE reports for each database picking tables in Crystal and having multiple value parameter. Suppress all except details section. 2. Create a main report with "all read" login...

Thanks Ken, I am using UNION clause in the command object to access records from 6 identical databases. Therefore, I cannot use tables on Crystal side.

I want to select multiple values for selection criteria. I am using command object in CR XI. Database is Oracle 9i. The parameters created at command object are visible in Field Explorer. But the "Allow multiple values" option is grayed out. I cannot create the parameter in Field Explorer...

I am generating reports off an Oracle 9i database of an warehousing application. I have only read rights. The database only records the last status of an order and the date/time last modified. I need to store a snapshot of order status when the shift changes, so that I can use that data to...