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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ahlone

  1. ahlone

    Browser compatible issues with PHP program..

    Hi, I have a PHP program working with mozilla firefox & netscape browser but when tested in internet explorer, it's not working. This website is converted from Oracle IAS to PHP, and using javascript to submit the form. So, could someone pls. advise or guide me to have this php program...
    • ahlone
    • Thread
    • Replies: 1
    • Forum: PHP
  2. ahlone

    Reportnet Report Is Very Slow

    Hi, Most of the reports are completed within 1-2 minutes, but, I have a report which is taking about 15 minutes to complete. Could someone pls. tell me how to find out why it's taking too long, &, how to fine-tune the report. HERE IS THE MAIN SQL STATEMENT...
  3. ahlone

    What prompt to use for condition 'LIKE'

    (?Material1?||'%') concatenate works. Appreciate all your helps.
  4. ahlone

    What prompt to use for condition 'LIKE'

    I finally got it working, by using the filter as "[PA Purchase Order Detail].[Material].[Material Identifier] like (?Material1?)". And, when running the report, let's say I want all the material start w/ 06, then, I would run the rpt, with '06%' on this text box prompt. Thanks ......
  5. ahlone

    What prompt to use for condition 'LIKE'

    Thanks KingCrab,& Draoued for the response. "Select & Search Prompt" won't work for me because the list of material start with 06% will be over 1000, &, I will be getting this oracle error. That's why I am trying to use the 'like' statement instead of 'in'. KingCrab, What I meant on my previos...
  6. ahlone

    What prompt to use for condition 'LIKE'

    Thanks KingCrab, I changed the filter to: "[PA Purchase Order Detail].[Material].[Material Identifier] like (?Material1%?)" And, try using text box prompt, but, it doesn't seem to be working, becasue, I tried running the report with 06, 01, 95 in the text box prompt, and, the result is always...
  7. ahlone

    What prompt to use for condition 'LIKE'

    In ReportNet, I am currently using the "Select & Search Prompt" for filter material "[PA Purchase Order Detail].[Material].[Material Identifier] in (?Material1?)" instead of "in", I would like to use like condition. It would be "[PA Purchase Order Detail].[Material].[Material Identifier] like...
  8. ahlone

    oracle-01795: maximum number of expressions in the list is 1000

    shwetabh, How do I check the governor setting for the model?
  9. ahlone

    oracle-01795: maximum number of expressions in the list is 1000

    Thanks JGirl, I checked with Oracle database side, &, they said that is the limit. material select statement has dictinct selection as below: ************************************************************* select distinct Material.MATERIAL_ID as Material_Identifier...
  10. ahlone

    Creating primary key on the existing table with data

    Hi, Currently, I have a table with no primary key, but, data are already loaded. So, I am trying to create the primary key on one of the columns with Enterprise Manager, but, no luck. Right now, it's allowing duplicate records to be inserted to the table. Thanks
  11. ahlone

    oracle-01795: maximum number of expressions in the list is 1000

    Thanks for the quick response, KingCrab. Actually, we just implemented Cognos ReportNet a couple of month ago. &, consultants are gone, and, I am pretty new at this, but, I have some experience with the oracle report. And, I am not sure why so many records are in the drop-down list. Currently...
  12. ahlone

    oracle-01795: maximum number of expressions in the list is 1000

    Hi, In ReportNet, I have a report, which has the "select & search prompt" prompt for material. And, it has 97,000 records for material downdown list, and, when the report is run with the option of "select all" for material start with 06%. Then, the number of rows for material is over 3000...
See more

Part and Inventory Search

Back
Top