Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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