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

    Setting up email delivery for scheduled reports

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

    Crystal chart problem

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

    Capturing wrong manually entered dates without crashing

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

    Capturing wrong manually entered dates without crashing

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

    Reports on IT security and risk associated with IT processes

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

    Running a Crystal Report at a pre-set time

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

    Running a Crystal Report at a pre-set time

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

    Text file as Datasource

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

    Text file as Datasource

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

    Export to ODBC - "no valid data source for this report" error

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

    Can an E-mail sent from BOE based on results from a report

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

    Selecting multiple values for a parameter created in command object

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

    Selecting multiple values for a parameter created in command object

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

    Selecting multiple values for a parameter created in command object

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

    Selecting multiple values for a parameter created in command object

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

    Writing to a MS Access table through Oracle SQL script

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

Part and Inventory Search

Back
Top