• RELEVANCY SCORE 4.17

    DB:4.17:Apex, Changing Dropdown Boxes In Report 3d





    Hi,
    Im creating an application and I wish to create a report that changes its content depending on the input of certain dropdown boxes.

    Like
    Dropdown box1 :Name
    Dropdown box2: Location
    Dropdown box3: Time

    With a changing report below.

    The biggest problem is, the 3 "Dropdown boxes" need to change their content or possible selections in reference to each other.
    Like: There are only 2 names to select when location India is selected.
    While nothing is selected in Location you can select 15 names.

    Thanks for the reply

    Mathias

    DB:4.17:Apex, Changing Dropdown Boxes In Report 3d

    Yes I have found allot of information when I googled it.
    But I have heard that allot of methods dont work, and some are just a bit farfetched like the Ajax method.
    Can anyone give me a working comprehensive solution?

    Thanks

    Mathias

  • RELEVANCY SCORE 3.04

    DB:3.04:Apex Noobie px





    Hi, Im totaly new to Apex and am having difficulties, Id like to use dropdown boxes, can anyone tell me the property I need to look out for to be able to bind values from a table to the dropdown box?, also how I could I use the value selected from the dropdown box in a select query?

    DB:3.04:Apex Noobie px

    Hi,

    You can try some thing like below:

    1. Create a select list item (Px_DEPTNO) with page action to 'Submit Page' on value change.
    2. Use bind variable to use the return value of select list in the sql query like:
    select * from emp where deptno = :Px_DEPTNO

    There are many ways to implement what you want. Please go through the apex developer's guide.

    Regards
    Satty

  • RELEVANCY SCORE 3.00

    DB:3.00:Reset Pagination For Reports After Window Reload p3





    Hi friends,
    I have a apex report, whose content dynamically changes based on a drop down value. The issue is if i am in 3rd page for a selected dropdown value and then change the dropdown value, the report data for the newly selected dropdown value will be in page 3. is there any was to start from 1st page when a new value is selected form the dropdown.

    In my current implementation i have created a branch with a condition to navigate to the same page after hitting the submit button

    Below are the html elements on the screen

    1. drop down select box.
    2. submit button
    3. apex report.

  • RELEVANCY SCORE 2.87

    DB:2.87:Dependent Dropdown Boxes kd



    hi,

    I have four dropdown boxes. Starting from the second dropdown box, each dropdown depends on the value chosen in the previous one. can someone help me achieve this?

    Thanks,

    Priya

    DB:2.87:Dependent Dropdown Boxes kd


    you are welcome and if you have and dobuts , as you know SDN is there.

    Regards

    Raja

    if you are not aware of the contributor recognition program have a look at the following weblog.

    /people/mark.finnern/blog/2004/08/10/spread-the-love

  • RELEVANCY SCORE 2.84

    DB:2.84:Populating 2nd Dropdown Box According To Value Selected In First Dd Box ?? ad



    Hi,

    In our PCR Adobe forms we have two dropdown boxes, and our requirement is that if user selects a value in first dropdown box, second dropdown box should be populated according to the selected value.

    DB:2.84:Populating 2nd Dropdown Box According To Value Selected In First Dd Box ?? ad


    Hi,

    Updating this thread as I have recieved many offline queries regarding this.

    On triggering the event, the flow of BADi methods called are different. Please put a breakpoint in the metthods and check.

    Sorry, i forgot about this thread to update.

    Regards,

    Antony.

  • RELEVANCY SCORE 2.73

    DB:2.73:Apex 3.1.2 Interactive Report Bug 3m


    When you click on a column header of an Interactive Report, a dropdown menu appears which contains a text field that filters the list that is shown beneath it. When you TYPE some text into the field in Internet Explorer 7 and then select a value from the list beneath it with your mouse, the typed value is somehow remembered and reappears in the text field of other column header menus.

    I don't know whether this has been solved in 3.2.

    Andr

    DB:2.73:Apex 3.1.2 Interactive Report Bug 3m

    When you click on a column header of an Interactive Report, a dropdown menu appears which contains a text field that filters the list that is shown beneath it. When you TYPE some text into the field in Internet Explorer 7 and then select a value from the list beneath it with your mouse, the typed value is somehow remembered and reappears in the text field of other column header menus.

    I don't know whether this has been solved in 3.2.

    Andr

  • RELEVANCY SCORE 2.72

    DB:2.72:How To Create (Call ) Jasper Report In Apex . zp


    Dear Friend

    How to create (Call ) Jasper Report in Apex .

    Thanks

    DB:2.72:How To Create (Call ) Jasper Report In Apex . zp

    and this one runs the report inside the database http://sourceforge.net/projects/pljrxml2pdf/

  • RELEVANCY SCORE 2.72

    DB:2.72:Dynamically Creating An Apex Report z9


    Hi,
    i am new to Oracle Apex and having a problemwith creating a report.I have a drop down(Select List) item which will list all the table names.When i select a tablename all the fields in the tables must be displayed in a report and there must provision for deleting a row or editing or creating a row.Can i do this with a single report.Can i perform validations on the same page for all the table fields of the corresponding tablename selected from the dropdown box.Plz help

    Edited by: user8763204 on Aug 26, 2009 1:34 AM

    DB:2.72:Dynamically Creating An Apex Report z9

    In that case I would use ajax:

    http://deneskubicek.blogspot.com/2009/08/validations-using-ajax.html

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/training
    http://apex.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------

  • RELEVANCY SCORE 2.71

    DB:2.71:Setting Apexir_Num_Rows Before Report Runs.... ma


    Is it possible to set apexir_num_rows before the initial run in the Interactive Report in APEX 3.2?

    I want to default it to something other than 15, but it will tend to vary depending on the user.

    I've tried everything I can think of.. javascript and jquery... Just can't seem to find a good answer for this...

    Saw this, and with this I can Get, Remove, and Set which is selected in the DropDown, but it doesn't seem to effect the initial run of the report.

  • RELEVANCY SCORE 2.68

    DB:2.68:Does Apex Support Dynamic Dropdown List Without Refreshing The Page? xd


    Hi,

    When I got to a website, I choose an item on the first dropdown and the second dropdown dynamically displays the data that is related to the first dropdown without the page refreshing. Does Apex support a feature like this?

    Thanks.

    DB:2.68:Does Apex Support Dynamic Dropdown List Without Refreshing The Page? xd

    Did you look at the examples? They are both running queries from the database - that's what AJAX does. Makes a call to your database so you can retrieve data - if they are "static" lists, you can use regular javascript to link them and don't need an extra ajax call.

  • RELEVANCY SCORE 2.68

    DB:2.68:Wad - Web Items Alignment Problem ja



    Hi Gurus,

    I`m developing web template with checkbox and dropdown boxes which are responsible for report layout.

    To checkbox web item i assigned Key Figures from my query.

    Reason for this is to give users possibility to choose as many columns (Key Figures) as they want to see on the report.

    In Query Designer in every column of my query, apart from Key Figure, i also put two variables ( X and Y)

    Dropdown boxes have assigned these two variables (X and Y).

    Requirement is to get layout which should look like below

    Checkbox DropdownX DropdownY

    Checkbox DropdownX DropdownY

    Checkbox DropdownX DropdownY

    My problem is to align checkboxes with dropdown boxes.

    It would be much easier if i could assign each KF from my report to one checkbox and then put all elements (checkboxes and dropdown boxes) into HTML Table.

    Unfortunately when i assign KFs from query to checkbox, all KFs are available under one key.

    I changed height of my checkbox, but it didn`t help. Web item increased height but size of little squares for marks left the same and didn`t align with dropdown boxes.

    Do you have any idea how to overcome this problem?

    Thanks in advance

    Jacek

    DB:2.68:Wad - Web Items Alignment Problem ja


    You should use HTML controls like tables/DIV/SPAN, etc to control the alignment. Go to XHTML code and feel free to add your code around standard generated code....This works well and you can do highly formatted and totally controlled UI...

  • RELEVANCY SCORE 2.66

    DB:2.66:Populating Text Boxes Based Off Dropdown Selection zf


    using Jdeveloper10G

    A simple example would be great!

    DB:2.66:Populating Text Boxes Based Off Dropdown Selection zf

    Unfortunately, I am using 10G not 11G. I actually know how to use the valuechangeevent in 11g. Wish that would work for me now. :(

    I am stuck with bc4j view objects, uimodel.xml's and javascript. a even more sadder face. :(

  • RELEVANCY SCORE 2.66

    DB:2.66:Apex Question: Check Boxes sd


    How do you choose multiple check boxes from a set of them?

    DB:2.66:Apex Question: Check Boxes sd

    How do you choose multiple check boxes from a set of
    them?There is an apex forum you know...

    http://www.rittmanmead.com/2004/03/31/adding-checkboxes-to-report-rows-using-html-db/ will show you that behind the scenes APEX sets up a collection that you can inspect the members of in code.

    Niall Litchfield
    http://www.orawin.info/

  • RELEVANCY SCORE 2.66

    DB:2.66:Changing The Style Of The Dropdown Box On Fill-In-The-Blank Questions ps


    As the title implies, I just want to know how to change the style, or at least the font size in the dropdown boxes on fill-in-the-blank questions. The default ones have a tiny font that is difficult to read, as well as a blocky interface. Is there anything I can do to fix that?

    DB:2.66:Changing The Style Of The Dropdown Box On Fill-In-The-Blank Questions ps

    Hello,I'm very sorry, but this is not possible for the moment. If you please fill out a feature request (as I did already) to ask about a better way to format those dropdown lists?Lilybiri

  • RELEVANCY SCORE 2.66

    DB:2.66:Populating The Dropdown List ! j8


    Hi Friends,
     
    I am creating one page in which I have 2 dropdown list boxes. I should populate the second Dropdown based on the text selected in the first dropdown box. So for this what is the technique I should use. please help me out in this.
     
    Thank you,
    DotNetMate.

    DB:2.66:Populating The Dropdown List ! j8


    Hi dotnetmate,
    Next time if you got a problem about ASP.net, Recommend posting the question on the forum http://forums.asp.net, there ASP.NET experts can give you satisfying answers.  
    Thanks!

  • RELEVANCY SCORE 2.65

    DB:2.65:Dictate The Number Of Drop Down Boxes On A Row 9x


    I have noticed in SSRS 2008 that when you view a report it will only show 2 drop downs (parameters) per row at the top off the page. For example if you have the dropdown lists Date,Market, City, Zip then it lays them out as DATE MARKETCITY ZIPIs there a way to force it to put all of the dropdown boxes on one line likeDATE MARKET CITY ZIPThanksFrankFJK

    DB:2.65:Dictate The Number Of Drop Down Boxes On A Row 9x

    Hi Frank,As Josh mentioned, we can implement customized parameter interface using ASP.NET and then use Report Viewer to display the report to solve the issue. But, we can still use SQL Server Reporting Services reports.For more information, please see:ReportViewer Controls (Visual Studio): http://msdn.microsoft.com/en-us/library/ms251671(VS.80).aspxPlease feel free to ask, if you have any more questions.Thanks,Jin ChenJin Chen - MSFT

  • RELEVANCY SCORE 2.65

    DB:2.65:Template Changing And Learning xj


    Hi All APEX pros

    I am,still learning about apex and its features , dynamic action , themes and template.
    I want to learn How to change APEX theme or create your own theme , (starting Elementary 101)
    Like changing tabs to centered header , changing login page , making login box centered and fonts big , changing report style to show alternate color and different font.

    basically customization to MAX ;)

    i want to learn this in order to leverage better/unique GUI option

    Kindly guide me , where and how should i start CSS , HTML JAVA SCRIPT ???

    Thanks in advance

    DB:2.65:Template Changing And Learning xj

    Hi,

    I wrote a blog post a little while ago that describes the methods I use to overwrite the css shipped with APEX, it might help you when you start to understand css a bit more:

    http://paulbroughton.co.uk/2012/03/its-a-theme-changer/

    Thanks

    Paul

  • RELEVANCY SCORE 2.63

    DB:2.63:Changing The Default Apex Themes? 9d


    Hi
    Are there any good tutorials on changing the colors etc. in the default apex themes?

    regards
    Tony

    DB:2.63:Changing The Default Apex Themes? 9d

    Hi
    I have one tutorial that seems to be helpful. Any others are appeciated
    http://wiki.shellprompt.net/bin/view/Apex/ThemeTips

    regards
    Tony

  • RELEVANCY SCORE 2.62

    DB:2.62:Dynamically Changing Column Display Type 3f


    Hi,

    I have a report that gets generated every day with different column names. The report contains a decode statement that uses a row value to return using pictures. The problem I am running into is the column is being displayed as text and the value of the row is showing up as some html text instead of the picture. The default Column report in APEX 4.1 is for the report to be displayed as "Display as Text". I know the APEX team did this for security reasons. Is there any other way to display the column as "Standard Report Column".

    I want the report to be displayed as a "Standard Report Column" instead of me going in and changing it manually to "Standard Report Column".

    Any help in the right direction is appreciated.

    -Abe

    DB:2.62:Dynamically Changing Column Display Type 3f

    I have been trying to find the same solution... the ability to either default all my columns to "Standard Report Column" instead of "Display as Text" or to dynamically change them from code. Or it would even be great if the "Display As" value on report columns (both Classic Reports and Interactive, mine is Classic) was a column in the "Column Attributes" table on the "Report Attributes" page so that I could just change them all and hit "Apply" from that one page instead of having to go into each column's properties individually. (It's time consuming and tedious and easy to miss columns because I can't tell what I've changed.)

    If anyone has any thoughts, I'd love to hear them...

  • RELEVANCY SCORE 2.62

    DB:2.62:Bug Report: Report On App Home Page (4000:1) ak


    Came across a IMHO embarrassing bug in the Apex builder app home page (4000:1)

    When an application has page groups defined, the application's home page shows a dropdown list to filter by page groups as in http://screencast.com/t/reA59oSe

    Suppose I select the page group and click Go.

    Now I switch to an application that doesn't have any page groups defined. The page group dropdown is no longer shown (fine) but it's value is still used in the filter making it appear that the application has no pages! See http://screencast.com/t/ckurDoesDs

    Gave me quite a fright to see all my pages disappear like that. With visions of a database restore swimming in my head, I logged out and logged back in and everything was fine, whew.

    DB:2.62:Bug Report: Report On App Home Page (4000:1) ak

    Thanks, Vikas. That would be very alarming.

    These pages have all been re-done using interactive reports for 4.0, so this particular problem should be resolved.

    Scott

  • RELEVANCY SCORE 2.61

    DB:2.61:Dropdown Boxes Dont Dropdown In Firefox 5 71



    Since upgrading to Firefox 5, dropdown boxes on websites no longer dropdown. They work OK in IE, Chrome, Safari, et al and they worked in FF4 - just not FF5.
    This appears to happen on all websites but I can't believe that something this glaring hasn't been noticed by anyone else, so I'm guessing something peculiar to my setup.
    I can't fill in the "This happened" box - the dropdown won't work!

    DB:2.61:Dropdown Boxes Dont Dropdown In Firefox 5 71



    I had the same problem with FireFox 11.0 and Actual Window Manager 6.6 on Windows 7 x64.
    I found that drop down menus on a web-page displayed in FF stop to work if StartUp-MoveToMonitor option or Size-SaveSizeOnExit option of the AWM SpecificSetting for FF is activated. Finally, I solved the problem using the tip described by Pim Joosten here:
    http://www.actualtools.com/forum/read.php?FID=10TID=1642
    I.e., by disabling WindowClass option and defining the FF TargetWindow in AWM using WindowCaption-SubstringMatch option.

  • RELEVANCY SCORE 2.60

    DB:2.60:Report With Check Box j8


    Dear Friends,
    using apex 4.1.
    I have created form with report. On report I have defined column as check box. As many check boxes i have ticked and click on approve button.

    How i can execute my process and validation on approve button as many checkboxes i have ticked.

    Could you send me any tutorial or link where i can see how i can do this?

    Thanks Regards
    Vedant

    DB:2.60:Report With Check Box j8

    Vedant,

    Just to add to Samuitsu's solution above...

    Here's a link to the documentation that explains apex_application.g_f01 a little more.

    http://docs.oracle.com/cd/E10513_01/doc/apirefs.310/e12855/apex_app.htm#insertedID2|http://docs.oracle.com/cd/E10513_01/doc/apirefs.310/e12855/apex_app.htm#insertedID2

    Keith Malay

  • RELEVANCY SCORE 2.60

    DB:2.60:Pl Sql Code To Count How Max Checkboxes Are Checked In The Report Region 7a


    I am developing a APEX report where I put check boxes to row row of the report result . So I checked Some of this check box. Now I need a code to count how many checkboxes are checked during the runtime

  • RELEVANCY SCORE 2.60

    DB:2.60:Freeze Panes For Sql Report In Apex 38


  • RELEVANCY SCORE 2.60

    DB:2.60:Issue With Wad -Charts Columns 3d Please Go Throught Issue Description 7m



    Dear All,

    I have an Issue With WAD. I have Created a WAD report based on query and i used two charts in WAD i.e

    1. Charts columns 3D

    2. Pie chart for same query

    Here i have created variable selection for query. The same variables should show in the same Graph in result screen for user feasibility. (the user doesn't want to go back for variable selection or refresh the query). For this i used Dropdown Boxes for Variable selection in the WAD report itself. Here is the problem is... When i select any variable in the dropdown box, result graph is changing automatically to some other format of 3D columns and it is improper to what i created. For example i have taken 6 keyfigures in 6 categories. when i executed the report first time, it is giveing proper graph with only six columns. If i select any variable in dropdown then it is showing 6 categories and 2 series.. next variable it will change to different graph. For every selection in the every dropdown dropdown box it is showing different graph(3D) in resultant graph. The result has to shoew in those six columns and should'nt change the layout or format of graph.

    Please give me the solution ... Thanks in Advance

    Thanks Regards

    Venkat/Harsh

    DB:2.60:Issue With Wad -Charts Columns 3d Please Go Throught Issue Description 7m


    Dear All,

    I have an Issue With WAD. I have Created a WAD report based on query and i used two charts in WAD i.e

    1. Charts columns 3D

    2. Pie chart for same query

    Here i have created variable selection for query. The same variables should show in the same Graph in result screen for user feasibility. (the user doesn't want to go back for variable selection or refresh the query). For this i used Dropdown Boxes for Variable selection in the WAD report itself. Here is the problem is... When i select any variable in the dropdown box, result graph is changing automatically to some other format of 3D columns and it is improper to what i created. For example i have taken 6 keyfigures in 6 categories. when i executed the report first time, it is giveing proper graph with only six columns. If i select any variable in dropdown then it is showing 6 categories and 2 series.. next variable it will change to different graph. For every selection in the every dropdown dropdown box it is showing different graph(3D) in resultant graph. The result has to shoew in those six columns and should'nt change the layout or format of graph.

    Please give me the solution ... Thanks in Advance

    Thanks Regards

    Venkat/Harsh

  • RELEVANCY SCORE 2.60

    DB:2.60:How To Use The "Multi Row Update Process" On Apex sj


    Hi,

    I am trying to do a Multi Row Update process on an "updateable report" in Apex with a dropdown list to be updateable.

    I created the "Multi Row Update" process, yet don't know where to go next. Thanks.

    DB:2.60:How To Use The "Multi Row Update Process" On Apex sj

    Hi,

    I am trying to do a Multi Row Update process on an "updateable report" in Apex with a dropdown list to be updateable.

    I created the "Multi Row Update" process, yet don't know where to go next. Thanks.

  • RELEVANCY SCORE 2.59

    DB:2.59:Highlight Row In Sql Report ss


    Using APEX 3.2

    How can I highlight a row (either changing font colors or changing background color) on a sql report based on a value in one of the columns? If the column BALANCE_AMT is negative, I want to highlight the row.

    Thanks for any suggestions offered!

    Sandie

    DB:2.59:Highlight Row In Sql Report ss

    You're right. I had the field formatted so I just created a new field as a number which I did and used it. Works great unless I total by breaks and then for some reason it also highlights those rows. For now, I just removed the break totals :)

    Thanks for your help!

    Sandie

  • RELEVANCY SCORE 2.59

    DB:2.59:Apex. Calendar Es_Es Bug fj


    Hello,
    I'm not a parter of Oracle and I don't know how to report a bug so i put this here.
    After spending 5 hours on it I won't give more time to it.
    I've found a bug.
    Steps:
    put the locale to es_es en the web browser.
    create a page based on a calendar.
    Access to the calendar object and without changing anything press aplicar cambios (save changes).
    Be sure nobody is changing the object at the same time and repeat the last step.
    If the locale is changed to en-us the problem is solved.

    Occurs on Apex 4.0.*

    Salut!

    DB:2.59:Apex. Calendar Es_Es Bug fj

    Hi,

    I am able to reproduce to the issue. Please confirm the following steps to recreate is correct and also the error message which you should have seen

    1. Create a Calendar Page
    2. Change the Browser Language to Spanish [es-es]
    3. Goto Edit Page View
    4. edit the Calendar Region
    5. Click on Calendar Attributes and Click on Apply Changes button without making any changes.
    6. Throws the following error.

    ORA-20503: La versin actual de los datos de la base de datos ha cambiado desde que el usuario inici el proceso de actualizacin. total de control actual = "E32276E3A51E08AD9612CC159B97E66D" total de control de la aplicacin = "F3BC70FA0AB99968AAC29DD5A4D8056F"

    No se ha podido procesar la fila de la tabla WWV_FLOW_CALS.

    Volver a la Aplicacin

    Is the steps to recreate is right ? and also is this the error which you are getting ?

    Thanks
    JS

  • RELEVANCY SCORE 2.58

    DB:2.58:Region Advice For Dashboard Type Page 7z


    I am running APEX 4.3 and need to create a Dashboard type page. The page will have a employee name dropdown and then display some information in dial charts, static columns and interactive report (see sample layout below). I need some advice on best way to setup the regions to accomplish this. Emp Dropdown on far left, some static computed fields below in table format, charts to right (the 4 charts need to be displayed next to each other with no region separation between them) with an Interactive Report below. Any help/advice would be great. Should I use parent/child regions?Emp Dropdown Dial Chart1 Dial Chart2 Dial Chart3 Dial Chart4xxxxxxxxxxxxxxxxTotal 1st Half Year: xx Avg Sales Qtr1 Qtr 2Total 2nd Half Year: xx ---------------------------------- Dept1 xx xx Dept2 xx xx Dept3 xx xx Dept4 xx xxDate Transaction Type Details Comments-------------- ------------------------ --------------------- --------------------------------------------------------------------------------------------------------------------------------10/1/2014 Post xx xx11/1/2014 Post xx xx

    DB:2.58:Region Advice For Dashboard Type Page 7z

    1) Remember you're on a web page not Forms/Reports2) Try using theme 25 and play with the grid layout. Parent/child regions can help keep regions together, you might use a basic DIV regions as parent to keep it invisible from user.3) Build a basic example on apex.oracle.com and ask follow-up questions for any issues you have4) Check your apex version, probably 4.2.3, not 4.3

  • RELEVANCY SCORE 2.58

    DB:2.58:Editable Report? z9


    I was just wondering if there was an option in Apex to produce a report or all rows in a table, with the records shown as selectlists and text boxes so they can be edited?

    DB:2.58:Editable Report? z9

    You can do that with a standard report section. With the columns, you can select a different type off columns. They can be any type of control you want. But you need to program the saving processes yourself. Using tabular forms is easier, but less flexible. You can't do that if you must use more then a single table as source for your report. If you program it yourself, you have no limits like that.

  • RELEVANCY SCORE 2.58

    DB:2.58:Apex 4.2.1: Region Table Layout And Pagination s3


    See https://apex.oracle.com/pls/apex/f?p=57688:2

    Theme 24, table-based layout. Page template = One Level Tabs, Left Sidebar.

    All 4 regions are report regions using the report region and 2-column portlet as the region and report templates respectively.

    Regions 1.1 and 1.2 are supposed to be in the same row in different columns so 1.1 has New Grid=Yes and 1.2 has New Column=Yes. Ditto for 2.1 and 2.2

    1. Trial and error shows that simply changing the Pagination of report region 1.1 from None to Bottom-Right causes the layout to shift such that 1.2 moves to a grid row by itself! What is going on here? Surely a "trivial" change like whether pagination is displayed or not shouldn't cause such a major layout change. Am I missing something?

    2. Regions 2.1 and 2.2 stick together. How can we add some breathing room between them?

    3. If the page template is changed to One Level Tabs, No Sidebar, the behaviour changes. All the regions are rendered in 1 column, ignoring the New Column grid layout setting. Why is this?

    4. In general, with all the layout changes in 4.x, I was under the impression that, when using a HTML Table based page template, simply using the New Grid/New Row/New Column, etc attributes on the Region attributes would be sufficient to build pages with intuitive, declarative layouts with arbitrary "boxes" laid out on the page, regardless of the content/region type. But that doesn't appear to be the case.

    Can some CSS expert (here's looking at you, Paul) please share some insights on how all this works?

    Thanks

    DB:2.58:Apex 4.2.1: Region Table Layout And Pagination s3

    VANJ wrote:
    If this is the layout shown in your link above then I'm not reproducing it. Can you upload an export of your app and provide a link to it?See https://apex.oracle.com/pls/apex/f?p=57688:3 I copied the page and just changed the page template to One Level Tabs - No Sidebar.Yes, that's what I was seeing.

    Sorry, the grid layout is fine but notice how the 2 columns in the portlet are squished together? What's that about?The One Level Tabs, Left Sidebar page template has Region Table Attributes defined for HTML Table layout:
    summary="" cellpadding="0" border="0" cellspacing="0" width="100%"The One Level Tabs - No Sidebar template does not.

    In the One Level Tabs, Left Sidebar page, the ttwidth="100%"/tt attribute stretches the layout table to fill the width of the container. This means that the width of the columns in a 2 column layout is roughly 50% of the available space. The 2-Column Portlet regions fill this width, and the value heading column of the portlet utilises 80% of it:
    ul.uValuePairs li span.uValueHeading {
    width: 80%;
    }The value column is absolutely positioned against the right edge of the portlet:
    ul.uValuePairs li span.uValue {
    font-weight: bold;
    position: absolute;
    right: 0;
    top: 0;
    }In the One Level Tabs, Left Sidebar page, no width is set for the layout table. Its width is therefore determined by its contents, which with the data in this example is not very wide at all. For the heading width, 80% of not a lot is even less: insufficient for there to be any space between the heading and the value positioned at the right edge of a very narrow portlet. You'll see some difference if headings longer than "c1" are used.

    The fix is obviously to define the same Region Table Attributes Grid Layout property in the One Level Tabs, Left Sidebar template as is used in the One Level Tabs, Left Sidebar.

  • RELEVANCY SCORE 2.57

    DB:2.57:End User Can Save Interactive Report As Default Report Settings f8


    I am using APEX 3.1.2.00.02. I log in as an APEX user with end user role. I open an interactive report.

    In the "Save Report" dialog, there is a "Save" dropdown with an option to save "As Default Report Settings". The dropdown says "(Only displayed for developers)", but I am logging in as an End user. Why do I have this option and how to remove it from end users view?

    Thanks.

  • RELEVANCY SCORE 2.57

    DB:2.57:Apex Time To Load A Report d1


    Is there the way to get the time APEX needs to load and display a report???

    Regards
    Sebastian

    DB:2.57:Apex Time To Load A Report d1

    What is your pagination scheme?

    The extra time maybe the time it is taken to send the HTML for the report to your browser.

  • RELEVANCY SCORE 2.57

    DB:2.57:Dropdown Menu af


    Hello!

    I'm new in Apex and I have one question are dropdown menues already built-in in apex 4.1.1?

    Is there any option to use them?

    tnx

    DB:2.57:Dropdown Menu af

    Martin and Tony thank you for your answers! They are helpful!

    Regards,
    Dragan

  • RELEVANCY SCORE 2.57

    DB:2.57:Apex 4.1 Workspace Owner pz


    Hello Every Body
    I'have trouble with changing my APEX workspace Owner . any issues ?
    Thankyuo

    DB:2.57:Apex 4.1 Workspace Owner pz

    If you really want to get answers to your questions, You must to give enough information about you problem in order to someone to look at

    such as
    apex version
    your detailed problem
    any error information

    Thanks

  • RELEVANCY SCORE 2.57

    DB:2.57:Search By Column Name 3a


    I have a table with search and display boxes at the top created by APEX.
    I added another dropdown box for the search to do the search by column names.
    This dropdown is displaying numbers instead of column names.
    How would do I make this change so that the search can be done by a specific column?
    Thanks.

    DB:2.57:Search By Column Name 3a

    Click the arrow at the magnifier glass and you can select a specific column. Or click on the heading of a column to do the filtering there too.

    Or you can remove the "Allow Users To: Filter" checkbox from all the columns where you don't want to support search. If there is just one left only that one should be search with the general search field.

    Patrick
    --------------------------------------------------------------------------------------------------------------------
    *** New *** Oracle APEX Essentials *** http://essentials.oracleapex.info/
    My Blog, APEX Builder Plugin, ApexLib Framework: http://www.oracleapex.info/

  • RELEVANCY SCORE 2.56

    DB:2.56:Pulldown Menu cc


    Does any one know how to get the dropdown\pull down menu to work under apex 4.0 ?
    example: I created a list with pull down menu template. It has data ( page 100),report(page200). I would like to put this list under EMPLOYEE, so when users click EMPLOYEE, data and report will display.

    Any help will appreciate.

    Munshar

  • RELEVANCY SCORE 2.56

    DB:2.56:Plsql Command String Runs In Toad But Not Apex jf


    Hello there,
    I have to text boxes on has a "from" value and the other is a "To" value. I create a report to be based on these values with the following sql statement;

    DECLARE
    x varchar2(32767);
    begin
    x:=x|| q'! select flex_value_set_id,
    flex_value_id,
    flex_value,
    attribute1
    from applsys.fnd_flex_values where flex_value between P1_LOCATION AND P2_LOCATION. !';
    return x;
    end;

    It does not work. Sql failed to parse query. Could it be that the report is being rendered before the text boxes?
    Any help appreciated

  • RELEVANCY SCORE 2.55

    DB:2.55:Can We Create Editable Dropdown Boxes In Html df


    I need dropdown box that can be editable, if the required entries are not in the dropdown box.

    Is it possible in html.

    DB:2.55:Can We Create Editable Dropdown Boxes In Html df

    You can whip something up in JavaScript using a text entry box, and image and a div with the selections - but that's not really a Java question - if you want to use Java you could throw an Applet in there.

    Good Luck

    Lee

  • RELEVANCY SCORE 2.54

    DB:2.54:Generate Report Based On Select List 3k


    Hi , I have a drop down list those are the column names and a corresponding value i will enter in input text . so based on these two values how can i generate a report in Apex i am using apex 4.0.2.Means in where clause dropdown value will become column name and input text will become value for that column;Thanks Raghav

    DB:2.54:Generate Report Based On Select List 3k

    This gets complicated really fast.I'd use an Interactive Report.select * from empwhere (:P5_COLUMN_NAME='deptno' and deptno= :P5_COLUMN_VALUE) or (:P5_COLUMN_NAME='ename' and ename= :P5_COLUMN_VALUE)

  • RELEVANCY SCORE 2.53

    DB:2.53:How To Run Oracle Report On Apex dj


    can anyone help me how to run or call report in apex application

  • RELEVANCY SCORE 2.53

    DB:2.53:Report Viewer Using Dropdownlist x8


    I am building an ASP.NET2.0 web application that will access SQL Server, however I want the ability to design the report that will be generated by report viewer by using dropdown boxes. How can this be accomplished? I want the ability to choose from diferent drop down list in order to generate a report based on my selections. Also, I can get Grid View to export to Word and Excel, but not to PDF. Why is this so difficult?
     
    Thank you,
    Steve, B.S.I.T.

    DB:2.53:Report Viewer Using Dropdownlist x8

    I am building an ASP.NET2.0 web application that will access SQL Server, however I want the ability to design the report that will be generated by report viewer by using dropdown boxes. How can this be accomplished? I want the ability to choose from diferent drop down list in order to generate a report based on my selections. Also, I can get Grid View to export to Word and Excel, but not to PDF. Why is this so difficult?
     
    Thank you,
    Steve, B.S.I.T.

  • RELEVANCY SCORE 2.53

    DB:2.53:Changing Row Color Of Standard Sql Report z9


    Hi,

    I am trying to follow this post to change the color of a row in APEX SQL report. Change Colour of Row - Oracle APEX SQL Report

    It's a bit outdated, and trying to figure out how to get to this page: http://img7.imageshack.us/img7/4782/columntemplate.jpg in APEX 4.2 where I can conditionally set background color.

    I am using theme 13 (legacy) and made a copy of the report region. Edited it but cannot find an equivalent section of that apex 3.1 screenshot.

    Any help appreciated.

    DB:2.53:Changing Row Color Of Standard Sql Report z9

    Thanks. I implemented the jquery and works beautifully but will look to implement the way you showed as a long term solution.

  • RELEVANCY SCORE 2.52

    DB:2.52:Reaaranging The Parameter Dropdown Boxes In The Ssrs Report 3z


    hi,
    I have created an SSRS report with 10 parameters. Currently the parameter dropdown boxes get arranged in 2 columns and 5 rows. However I want them to be in 5 columns and 2 rows. Is there any way to do this in SSRS 2008?
    thanks in advance

    DB:2.52:Reaaranging The Parameter Dropdown Boxes In The Ssrs Report 3z

    hi,
    I have created an SSRS report with 10 parameters. Currently the parameter dropdown boxes get arranged in 2 columns and 5 rows. However I want them to be in 5 columns and 2 rows. Is there any way to do this in SSRS 2008?
    thanks in advance

  • RELEVANCY SCORE 2.52

    DB:2.52:Re: Changing Oracle Password From Apex 31


    No idea!!!!!!

    DB:2.52:Re: Changing Oracle Password From Apex 31

    I would definitely be interested in any documentation related to changing the password when logging into the Apex. Can you please email it to me?

  • RELEVANCY SCORE 2.52

    DB:2.52:Sharepoint 2010 Web Service Access Issue kx


    I have a web service that populates some text boxes, the service is called on a drop down changing.
    This works fine on my dev machine and another machine we tried but not on our test server.
    You can see in the fiddler results the first 4 lines are me manually going to the address.
    The next two lines are the call on the dropdown list changing.
    the last two are the call from the dropdown list changing on my dev machine.
    This seems to be to do with configuration of our test server, is thislikelyto be beSharePointconfiguration or ISS config?
    This looks to me like an access issue as the location that is being called is fine as it works manually?
    Is there a SharePoint service account that needs permissions on the test server maybe?

    DB:2.52:Sharepoint 2010 Web Service Access Issue kx

    Hi wez1987,
    So, first your development environment is working well. I think you should checking the following steps.

    Check your business, please ensure your address of web services is your test environment.You’d better debug it with yourself on yourself.Ensure the attribute of “AutoPostBack” set to true.

    Thanks,
    JackJack Gao
    TechNet Community Support

  • RELEVANCY SCORE 2.52

    DB:2.52:Frame Like Behavior In Apex cm


    hi all.
    i have a simple requirement that i dont know how to take care of in apex.
    there are 5 combo boxes on my page and two buttons. the functionality is that when user select any criteria and click on button one, respective report should show and when clicks button two second report for the same criteria should show up. now, i can do that by redirecting to two different pages but the requirement is that the reports show show up on the same page with combo boxes.

    its the same old concept of frames when one frame remains static or same and the content in other frames changes.
    any help would be appreciated.

    DB:2.52:Frame Like Behavior In Apex cm

    li For each of the report regions add the following to the region attributes (Edit Region - Attributes(Section) - Region attributes)
    style=quot;display:nonequot;This would hide them both when the page loads
    liAdd an id to your button, ( id ="MY_BUTTON" in button attributes, make sure that the button template using the subtitution string as mentioned here: {message:id=9464067} ).

    ----------------------------------
    Create a new Dynamic Action
    Event : Click
    Element: DOM Selector
    DOM selector : MY_BUTTON
    liTrue Event 1 : Execute PLSQL Code
    BEGIN
    NULL;
    END;--Important
    Items to Submit: ITEM1,ITEM2,ITEM3,ITEM4,ITEM5 (names of the items referred in the report - checkboxes,select lists etc)

    liTrue Event 2 : Hide
    Element: Region
    Choose Report region to be hidden when this button is pressed( so that the appropriate report is shown/hidden)
    liTrue Event 3 : Show
    Element: Region
    Choose Report region to be Shown when this button is pressed( so that the appropriate report is shown/hidden)
    liTrue Event 4 : Refresh
    Element: Region
    Choose Report region to be refreshed when this button is pressed

    --------------------------------
    Create another dynamic Action similarly for Button 2 ( you can copy Dynamic Action1 and modify it too)

  • RELEVANCY SCORE 2.52

    DB:2.52:Dropdown Boxes 3j



    how to setup and create dropdown boxes using webdynpro???

    regards

    DB:2.52:Dropdown Boxes 3j


    Hi,

    Please see the following links. Which contains sample codes and PDF.

    https://www.sdn.sap.com/irj/sdn/downloaditem?rid=/library/uuid/91c5e990-0201-0010-4981-9b2075751da5

    https://www.sdn.sap.com/irj/sdn/downloaditem?rid=/documents/a1-8-4/tutorial%20on%20internationalization%20of%20web%20dynpro%20applications.htm

    Kind Regards,

    S.Saravanan.

  • RELEVANCY SCORE 2.52

    DB:2.52:Tick All Boxes On *Item* Checkbox p8


    http://apex.oracle.com/pls/apex/f?p=56677:1
    workspace: SVK
    user:DEMO
    user:DEMO

    I want to create a dynamic action that ticks all of the values when the "Check All" button is pressed. I am speaking of an ITEM Checkbox here (and not the first column of a report). I am guessing that I will use javascript, but I am at a loss for how to do this. Thanks.

    DB:2.52:Tick All Boxes On *Item* Checkbox p8

    Thank You, Marko. This is exactly what I needed.

    Check ALL
    Action: Execute JavaScript Code:
    $(this.triggeringElement).closest('div').find('input[type=checkbox]').attr("checked", "checked");UnCheck ALL
    Action: Execute JavaScript Code:
    $(this.triggeringElement).closest('div').find('input[type=checkbox]').removeAttr("checked");

  • RELEVANCY SCORE 2.51

    DB:2.51:I'M Trying To Build A Simple "Build Your Own Custom Pc" Applet dx


    Is there a good writeup on how I can build popup/dropdown selection boxes?

    Like a box that said "Motherboard" with an arrow and if they clicked on it a dropdown box opened with different mobo options.

    then more dropdown boxes for cpu and memory and so on

    DB:2.51:I'M Trying To Build A Simple "Build Your Own Custom Pc" Applet dx

    Check the following URL - it should provide you a firm foundation for what you're after...

    http://java.sun.com/docs/books/tutorial/uiswing/index.html

  • RELEVANCY SCORE 2.51

    DB:2.51:Pdf Printing: Request For Help! pk


    Hi APEX Community,

    I have to create a PDF Report that contains:

    1) Data from several Tables
    2) JPEG Images retrieved from the Database
    3) 2 SVG Line Charts

    Here is my screenshot from my APEX Application of the report that needs to be converted to PDF Format:

    http://apex.oracle.com/pls/otn/f?p=123421:50

    Is this possible using the XSLT and FOP?

    The report needs to be very accurate and professional so quick solutions such as using a PDF Page Printer or Changing Mime type will not be sufficient.

    Thanks in advance,

    Immanuel

    DB:2.51:Pdf Printing: Request For Help! pk

    Hello,

    Yeah you could build that using the XSLT + FOP solution though it's not simple.

    The only real trouble your going to have is the maybe the charts but you should be able to get the URL's to the charts in your page and provide that as the URL src to include them in your PDF. The same with the images you just need to provide a URL that the server that render the FOP can access.

    Carl

  • RELEVANCY SCORE 2.51

    DB:2.51:Web Report a9


    I have a Dashboard and there is some dropdown boxes , when user change the value of dropdown box i want to show a progress message, is there any solution

    DB:2.51:Web Report a9

    Hi Hakan,If you are using portal to publish the reports in it from where the user is able to execute and view them, you can have a progress message placed in the portal directly with the help of portal guys. If you are not using portal, you can have this option by writing some Java code in WAD. If the message is common i.e., when user select the value from dropdown box, and if the message which is to be displayed is common, you can directly write the message in Web template itself.Assign points if this helps u...Regards,Koundinya Karanam.

  • RELEVANCY SCORE 2.51

    DB:2.51:F4 Dropdown In Salv Report d1


    Hi ,My report is simple. I am selecting data from joining two tables. After that I am showing data using SALV Objects. But none of the field in the report show value in F4 or dropdown list. For instance, fields like RFBSK, ERDAT and FKART. I have defined my internal table using same data dictionary field used in select statement. Following is the methods used after selecting data into table ts_output. Only posting status (RFBSK) show dropdown button but clicking on button does not show all defined value ranges. cl_salv_table=factory( IMPORTING r_salv_table = gr_table CHANGING t_table = ts_output ). gr_functions = gr_table-get_functions( ). gr_functions-set_all( abap_true ). gr_columns = gr_table-get_columns( ). gr_columns-set_optimize( abap_true ). gr_display = gr_table-get_display_settings( ). gr_display-set_striped_pattern( cl_salv_display_settings=true ). gr_display-set_list_header( 'Croatia - Reporting on Zero invoices' ). gr_table-display( ).Any Idea?Thanks and Best Regards,

    DB:2.51:F4 Dropdown In Salv Report d1

    You are welcome. Please debug the SALV_DEMO* report line by line to explore other details. Doing this would save time when you are dealing with same class next time.A tip for SCN. For the sake of maintaining a correct logical structure of discussion, you should use the correct reply button that is present next to every post/reply.When you scroll to end of a discussion, there a "Reply to original post" link that is used to reply to OP (original poster, the person who started the discussion).In this case, your reply is addressed to me, but structure wise it is addressed to Satish as his reply was last in the discussion.

  • RELEVANCY SCORE 2.51

    DB:2.51:Re: Apex Report Heading Problem xz


    I'm using Apex 4.2.2.Regards,Ivan

    DB:2.51:Re: Apex Report Heading Problem xz

    Yes, that's what I did. SR take too much time, and it's not a big deal.Thanks!Regards,Ivan

  • RELEVANCY SCORE 2.51

    DB:2.51:Pivot Table In Dashboard ka


    Hi,
    The pivot table report having following Columns.
    Customer_name,order_Qty,Shipped_Qty and amount Columns.
    Customer Name Column is moved to Pivot table prompts and remaining columns are in Row section.
    If i run the report then Customer Name crated as dropdown list,based on customer name data is changing respective column.
    so far every thing is good.Once i added the same report into dashboard section Customer Name coulmns dropdown list disable .
    kindly let me know the solution.

    Edited by: 867932 on Dec 11, 2011 11:28 PM

  • RELEVANCY SCORE 2.51

    DB:2.51:One Parameter Is Selected Hide Others ac


    Hi All,
    I have created a report using SSRS 2008. There are four drop down boxes(A,B,C,D) for separate parameters.
    There are two values for drop down box A. Cat1 and Cat2. What I want is when Cat2 is selected, other dropdown boxes(B,C,D) should be hidden. But still one of the values from each dropdown box is needed to be selected. Those remaining dropdown boxes has N/A
    value group. I want to select those N/A when Cat2 is selected.
    Can anyone tell me how to do this pls?
    Thanksshamen

    DB:2.51:One Parameter Is Selected Hide Others ac

    N/A should not be displayed.But it should be selected when Cat2 is selected. Eventhough N/A is selected from other drop down boxes, those boxes should be hidden only when Cat2 is selected.
    shamen

  • RELEVANCY SCORE 2.50

    DB:2.50:Email Report ax


    Hi all,

    How can I email report from Apex?

    Thanks

    DB:2.50:Email Report ax

    If you own BI Publisher you can have it deliver reports via email, fax, ftp, webdav, etc. With the latest release you can call a report via web services which should allow you to have a button on an APEX page that calls BIP via a web service and tells it where to email a report and in what format (PDF, Word, Excel, XML, etc).

    Tyler

  • RELEVANCY SCORE 2.50

    DB:2.50:How To Create Read Only Apex Items kz


    Hi,
    I'm creating a report using Apex items to display the result values inside editable text boxes. They are then referred by using APEX_APPLICATION.G_F02 etc.

    My requirement is to make the last row of this report (the values for "Total") as non editable or read only. Can anybody help me with the code that i would need to add in the query? The query goes something like this:
    apex_item.text(7, TO_CHAR(nvl(year_4,0),'999,999,999'), 12, 12, 'style="text-align:right;font-weight:bold"',ROWNUM) "YEAR_4", ..

    DB:2.50:How To Create Read Only Apex Items kz

    Hi Ben,
    Thanks for the really simple answer! And I cant take offence at all coz I din't know about this tag...:)
    Its now working exactly the way it should..

    Karan

  • RELEVANCY SCORE 2.50

    DB:2.50:Changing Single Row View Columns Order Using Apex 4.1 ss


    Hi All,

    I tried changing the order for single row view (Interactive report), I have noticed that its missing the icon used to change the order of columns which is there for APEX 4.0 Is any one have idea , how to change the order of columns for Single row view.

    Thanks in advance.

    DB:2.50:Changing Single Row View Columns Order Using Apex 4.1 ss

    Hi All,

    I tried changing the order for single row view (Interactive report), I have noticed that its missing the icon used to change the order of columns which is there for APEX 4.0 Is any one have idea , how to change the order of columns for Single row view.

    Thanks in advance.

  • RELEVANCY SCORE 2.50

    DB:2.50:Need Help With Refreshing Report Without Refreshing The Page. zm


    Hello,
    I'm using Apex V3.0 for my development.
    I've written javascript to toggle display of two regions based on dropdown selection. The problem is, when I change the selection in dropdown, I'm making changes in tables dynamically(through an application process named "initializeServiceCompReq") but that change isn't getting reflected in the region report.

    function getDeploymentType() {
    var mySwitch = 'OFF';
    var deploymentTypeObj = document.getElementById('P53_SERVICE_DEPLOYMENT_TYPE');

    if (deploymentTypeObj.value == 'Multi Node' ) {
    mySwitch = 'ON';
    }

    if (mySwitch=='OFF') {
    // Single Node
    document.getElementById("REGION_THREE").style.display = "none";
    document.getElementById("REGION_SIX").style.display = "";
    }
    else {
    // Multi Node
    var ajaxRequest = new htmldb_Get(null,APP_ID.,'APPLICATION_PROCESS=initializeServiceCompReq',0);
    ajaxRequest.add('P53_REQUEST_ID',document.getElementById('P53_REQUEST_ID').value);
    var ajaxResult = ajaxRequest.get();
    ajaxRequest = null;

    document.getElementById("REGION_SIX").style.display = "none";
    document.getElementById("REGION_THREE").style.display = "";
    }

    }

    What may be the reason? Without refreshing the whole page, can I refresh the particular region before setting display style in Apex3.0 ?
    Really appreciate any help.

    Regards,
    -Pranay.

    DB:2.50:Need Help With Refreshing Report Without Refreshing The Page. zm

    Hi

    This may help..

    [http://munkyben.wordpress.com/2009/05/10/flexible-ajax-calls-1/]

    Cheers

    Ben

  • RELEVANCY SCORE 2.50

    DB:2.50:Apex Session State And Bi Publisher xm


    I have a page containing several check boxes (which are not database items).
    The user clicks the check boxes and then a button to confirm. This puts the values of the checkboxes in to session state (either a 1 or a 0).
    The user then clicks on another button to run a BI Publisher report.
    My problem is that I need to refer to the check box values in my BI report.

    I know that I can do this user Apex report queries in the shared components, but I would like to do it directly in a BI Publisher report, as I find the report queries open a lot slower than the straight BI reports.

    Any help would be appreciated

    Gus

  • RELEVANCY SCORE 2.50

    DB:2.50:Apex Cache Report Region Page dk


    Morning guys,

    I have an interactive report that takes about 5 seconds to generate and was wondering if I could cache this?

    The user simply clicks a record in the report which take them to page 2. They then click the back button to return to page 1 but the report re generates even though the data is not really changing.

    Any help would be excellent.

    PS: I have tried page caching but this makes the template go all dodgy.

    Apex 4.0

    Thanks in advance...

    Edited by: Spam on Oct 14, 2010 10:57 AM

    DB:2.50:Apex Cache Report Region Page dk

    Perhaps you could post the query and explain plan?

    Cheers

    Ben

  • RELEVANCY SCORE 2.49

    DB:2.49:Interactive Report Dropdown List Pagination Scheme xj


    I designed an interactive report which will display around 4000 customer records in a web page in my Apex 4.2.0.00.27 website. I am paginating per 100 records. Unfortunately the default pagination styles available in interactive report doesn't have the dropdownlist option whereby the user can jump to say, page 40 straight away. {Pagination Scheme : Row Range X to Y of Z with pagination}.I saw the below article by Jari Laine which seems to offer the solution to me, but i haven't tried it myself.http://dbswh.webhop.net/apex/f?p=BLOG:READ:0::::ARTICLE:41900346848694Before trying it, does anyone know of any in-built solution in Apex 4.2? The above article seems to be written a while ago (probably during 3.2 days) and i am expecting for such a simple feature to be already available in Apex 4.2. I am fairly new to Apex myself. I couldn't find anything else after searching for a while.

    DB:2.49:Interactive Report Dropdown List Pagination Scheme xj

    it seems that this issue seems to be also in the apex feature request section (row key: ACK2) Description "Same pagination for IR en Classic Reports"Any ideas when this will be implemented? like in apex 5.0 ? Few other people in community forums have had the same issue. Plenty of end users seem to notice this pagination schema and ask for the same pagination style available in classic reports. It is inconvenient. Meanwhile i am yet to try/implement the custom pagination in my application.

  • RELEVANCY SCORE 2.49

    DB:2.49:Bug Report: Irr Heading Substitution In 3.1.1 k9


    Hi,

    it looks like that the substitution of page items in the heading of an IRR column has been fixed in 3.1.1, but the substitution isn't done in all areas.

    When the column name/heading is displayed in the dropdown list for the search field or where you can select a column (eg. Action/Select Columns) it shows the column name without the substitution.

    That's very confusing for end users, because the columns are named different in some dialogs then they appear on the report.

    Thanks
    Patrick
    --------------------------------------------------------------------------------------------------------------------
    *** New *** Oracle APEX Essentials *** http://essentials.oracleapex.info/
    My Blog, APEX Builder Plugin, ApexLib Framework: http://www.oracleapex.info/

  • RELEVANCY SCORE 2.49

    DB:2.49:Column Formating pd


    hello
    I am making a report that has a column with 3 check boxes. the width of the column is the width of the column heading. how do i make the column width wider with out changing the column heading is there a property for this? it keeps wrapping the check boxes because the column is too narrow

    DB:2.49:Column Formating pd

    Hi there,

    what you can do is put spaces in de column header. That way you can easily adjust the width of the column. You can use 'regular' spaces, but that doesn't always display properly. If you use the 'nbsp;' tag, it works perfectly!

    Good luck,
    -Peter-

  • RELEVANCY SCORE 2.49

    DB:2.49:Comparing Two Checkboxes In A Sql Based Report md


    Hi,

    I have a SQL report using two apex_item.checkbox and I want to toggle between the two check boxes so only one is checked per row. Any pointers on how to achieve this would be great.

    Using Apex 4.02 on 11.2 DB.

    Regards
    SJC.

    DB:2.49:Comparing Two Checkboxes In A Sql Based Report md

    Sounds more like a use case for radio buttonsmdash;where mutual exclusivity is inherent and handled automatically by the browsermdash;than checkboxes.

    If the report is displaying fewer than 50 rows per page you can use ttapex_item.radiogroup/tt to create the radio buttons, with one radiogroup per row determined by the ttp_idx/tt parameter.

  • RELEVANCY SCORE 2.48

    DB:2.48:Positioning Screen Components j1


    Hello All.

    I am using APEX version 2.2.1.

    Would someone please offer me words of wisdom as to how best to position
    report regions and individual fields (check boxes, text items, radio items, etc.)
    on an APEX page.

    I enjoy using APEX but find it maddening trying to position items on screen.
    The page that popsup giving where certain screen regions are located is
    not helpful. At times I long for the GUI interface of a frontpage or dreamweaver
    with respect to positioning components.

    And so, any tips on this mater would be really appreciated.

    Thank you.

    Elie

    DB:2.48:Positioning Screen Components j1

    Hello,

    That's a pretty expansive question with all sorts of answers. It totally depends on what sort of layout that you are looking for what items you need what your page template is and on and on. If you have a specific layout example your need it's much easier to help you out.

    1: I try to never put items in a report region I create a holder region above it for controls or I use the trick of splitting my region templates into a top and bottom portion to give me greater layout options (example http://apex.oracle.com/pls/otn/f?p=11933:86)

    2: In most forms put textarea's as the last items and put a start stop table item before the first textarea

    3: During development just put outlines around your #REGION_POSITION_N# substitutions it makes it much easier than guessing then take them out when you don;t need them anymore http://apex.oracle.com/pls/otn/f?p=11933:9

    4: I guess my best words of wisdom is leave your layout till the end of your development. Build all your forms get all your branches validations main navigation and logic working then work on the layout and look.

    I have yet to find a layout I can't produce sometimes it take a couple hoops to jump through but thats pretty much any project or technology.

    Carl

  • RELEVANCY SCORE 2.48

    DB:2.48:Open Rtp Report From Apex sj


    Hi ,

    Is this possible to open rtp report(oracle report), by pressing button in apex.

    Thanks,
    Sachin

    DB:2.48:Open Rtp Report From Apex sj

    Try this link
    http://www.oracle.com/technetwork/developer-tools/apex/howto-integrate-oracle-reports-097845.htmlGus

  • RELEVANCY SCORE 2.48

    DB:2.48:Re: Changing Color Of A Single Cell In A Report j1


    Tyler's blog post here http://tylermuth.wordpress.com/2007/12/01/conditional-column-formatting-in-apex/ is the best way to achieve this in my opinion. Should be easy to follow. Let us know if there's something not clear in these instructions.

    Regards,
    Jon.

    DB:2.48:Re: Changing Color Of A Single Cell In A Report j1

    I tried concatinating the HTML tag conditinally. In this case I need to set the value which on save firing the error below.

    Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-20001: Current version of data in database has changed since user initiated update process. current checksum = "B72FD7452BD831DC7909236056741DEB", item checksum = "52B3C6B1F1B95881B65FAEFB7D7CC55A"., update "DSMPLAN"."DSM_LOCDATES" set "ID" = :b1, "ORDERBY" = :b2, "LOC_LOCATION" = :b3, "LOC_STARTDATE_ACTUAL" = :b4, "LOC_ENDDATE_PLANNED" = :b5, "LOC_ENDDATE_ACTUAL" = :b6, "LOC_TYPE" = :b7, "REF_ID" = :b8, "CREATED_ON" = :b9, "CREATED_BY" = :b10, "CHANGED_ON"

    Edited by: PRASANTH on Nov 19, 2010 10:02 PM

  • RELEVANCY SCORE 2.48

    DB:2.48:Calling Developer61 Report From Apex fd


    Hello

    I want to call developer6i reports from APEX. Can anybody tell me the procedure?

    Thanx
    Apex Learner

    DB:2.48:Calling Developer61 Report From Apex fd

    Hello

    I want to call developer6i reports from APEX. Can anybody tell me the procedure?

    Thanx
    Apex Learner

  • RELEVANCY SCORE 2.48

    DB:2.48:Jcombobox Bug? m1


    I have noticed that if you addItem items with the same name in a JComboBox such as
    JCBox.addItem("qwerty");
    JCBox.addItem("asdf");
    JCBox.addItem("jkl");
    JCBox.addItem("asdf");
    you get both "asdf"s in the dropdown but when you getSelectedIndex() you get a 1 for both selections.

    qwerty = 0
    first asdf = 1
    jkl = 2
    second asdf = 1

    Is this a bug to report?
    This doesn't work this way with AWT Choice boxes.

    DB:2.48:Jcombobox Bug? m1

    Thanks guys,
    It was just a quirk I found while playing with Swing.
    SqueetoThe same quirk as this;-
    String myString1 = "hello world";
    String myString2 = "hello world";
    if( myString1 == myString2 ) System.out.println("Gosh, how can that be?");

    I'd blame java and Swing if I were you as well.

  • RELEVANCY SCORE 2.48

    DB:2.48:How Come Apex Function For Dropdown In A Report Can't Work? sc


    Hi I have a report of rows of data and each row has a dropdown. However the dropdown for each item is quite large and Apex errors out. I have used POPUP FROM QUERY, however what if I were to ask to use dropdown? Should I say Apex can't handle it? Thanks.

    Edited by: Jacky411 on Sep 22, 2009 3:34 PM

    DB:2.48:How Come Apex Function For Dropdown In A Report Can't Work? sc

    Hi,

    There are limits to the amount of text that can be handled when creating a select list. But, there are ways around this. Have a look at: Re: Huge select box fails.. - this creates a javascript array using PL/SQL code and then transfers the array into the select lists. This assumes that the lists would all contain the same list data.

    Andy

  • RELEVANCY SCORE 2.48

    DB:2.48:Pagination - Javascipt In "Execute When Page Loads" Stop Working 3s


    I'm using APEX 4.0.
    I have a standard report region on a page. In the page's JavaScript - Execute When Page Loads area, I put some javascript code there to initialize hover event handlers for dropdown menus inside the report. It works fine when the report is genarated.
    But it stop working when a pagination performed. For example, after clicked 'next" or any number form the pagination dropdown list.

    Please advice how to fix it. Thanks.

    Shiofan

    DB:2.48:Pagination - Javascipt In "Execute When Page Loads" Stop Working 3s

    Hi, Peter:
    Thanks for the quick reply. That is appreciated.

    My code involves only CSS and JQuery.

    I have found out the reason. It is because "Enable Partial Page Refresh" was set to Yes. ( that is the default by APEX, isn't it? ). After I reset it to No, the dropdown menu does work fine after pagination.

    I don't know how APEX pagination work together with report attribute "Enable Partial Page Refresh". To me, no matter what, the style sheet, the JavaScript put in page template/page header should always be included since they are common to the page. Can we say this is an APEX bug need to be fixed?

    Thanks again.

    Shiofan

  • RELEVANCY SCORE 2.47

    DB:2.47:Send The Id From Search Results To Another Page zs


    New to Apex.

    Have created a search with text boxes at the top and a report region below that provides the results of the search. Would like to click on one of the search rows, and have the id populate back into the text box that is part of a form on another page in the same application.

    Any suggestions on how to do this?

    Appreciate any ideas.

    Thanks,

    Jeff

    DB:2.47:Send The Id From Search Results To Another Page zs

    Hi,
    it depends whether you want to navigate to that another page with the form or not

    In case you navigate to that page:
    In Report Attributes choose the column what will set the item
    Define:
    Link Text
    Target - Page in this application, Page - your form page
    Item 1 - the iem from your form page
    Value - should exist in your report

    In case you do not want to navigate to your another page (I do not see why you wanted this), you can specify as a Target the current page and set another page item
    or use javascript that will execute Ajax call and set your item there.
    In this case use Target - URL, specify your javascript call in URL field.

    Hope this helps a bit.

    Regards,
    Oleg

  • RELEVANCY SCORE 2.47

    DB:2.47:Tlelerik Report + Apex 7s


    Good day. Is it possible use Telerik Report with APEX? And if yes, than how?

    DB:2.47:Tlelerik Report + Apex 7s

    So can anyone say me that the think what I want is impossible? If no, then say how can I do that.

    Thank you TexasApexDeveloper, I didn't know about JasperReports.

  • RELEVANCY SCORE 2.47

    DB:2.47:Apex Changing Execution Plan? jd


    Hi,

    We have a query, which we run in Toad / SQL*Plus, takes ~20 seconds to run and returns ~800 rows

    When we run it in APEX (both as Interactive Report and standard report) it takes over 20 minutes! We've looked at the execution plans for both queries and they are completely different.

    Why would they be different?

    Thank you,

    Martin

    -----
    [http://apex-smb.blogspot.com/]

    DB:2.47:Apex Changing Execution Plan? jd

    Hi Iulian,

    Thanks for you advice. We've already done the tests in v$sqltext and v$sql_plan. We have taken the debug query from APEX (so not the source query) and we've also taken the query visible in the Oracle session. The thing that has us scratching our heads is that when we take the exact same query that APEX is using (the one in debug mode) it goes from 20 seconds to 20 minutes... We're only returning ~750 rows so we can't find any logical reasons for this.

    We're currently in the process of putting a trace on our sessions to see what exactly is happening. I'll keep you posted.

    Martin

    -----
    [http://apex-smb.blogspot.com/]

  • RELEVANCY SCORE 2.47

    DB:2.47:How To Make Multi Select List As Dropdown?? m9


    Hi friends,

    using apex 4.0
    i want to make multi select list as dropdown,how can i do this??

    thanks in advance.. :)

    DB:2.47:How To Make Multi Select List As Dropdown?? m9

    mn123 wrote:

    using apex 4.0You MUST include the following information with every question:

    liFull APEX version
    liFull DB version and edition
    liWeb server architecture (EPG, OHS or APEX listener)
    liBrowser(s) and version(s) used
    liTheme
    liTemplate(s)
    liRegion/item type(s)

    This cuts down on the need for a lot of follow-up questions or second-guessing. Appropriate solutions may differ according to any of these variables.

    i want to make multi select list as dropdown,how can i do this??Please define exactly what you mean by "multi select list" and "dropdown".

    Do you mean displaying a multi-select enabled select list as a drop-down list rather than as a list box? If so, this is not possible using standard APEX/web browser controls.

  • RELEVANCY SCORE 2.47

    DB:2.47:Changing Font In Apex! ap


    Hi ALL!

    Do you know how to change font in all pages of APEX application ?

    Thanks,
    Roman

  • RELEVANCY SCORE 2.47

    DB:2.47:Wad Problem With Web Template Item d9



    Hello,

    I have a web template with two dropdown boxes and three functions in JavaScript in order to control the behavior of the boxes.

    The problem appears when I put this template in another template via WEB TEMPLATE ITEM. I get a runtime error if my web template Item has the "Generate title" property unchecked and I try to navigate in the report let say hiding or showing a navigational block or showing/hiding the entire table.

    Any idea??

    Regard,

    Jose

    DB:2.47:Wad Problem With Web Template Item d9


    Hi,

    I'm sorry I don't understand your issue.

    Do you mean you're creating a new web template and want new dropdown boxes there?

    I would definitely try to save a copy of the first web template and then change the data origin (the query or queries that feed the web template).

    Maybe this link can help you:

    https://websmp105.sap-ag.de/~sapdownload/011000358700000556672004E/HowTo_dynamic_ddbox.pdf

    Regards,

    David.

  • RELEVANCY SCORE 2.47

    DB:2.47:Re: Changing The Flash Chart Content Based On Ir Report Filter Criteria 11


    Hello , I did some research how to achieve this , one way is to get the IR report dynamic sql using APEX_IR.GET_REPORT package and apply the same sql for the chart so that the chart representation will match with the IR report data, But the challenge is as i am using the APEX 4.0.0.00.46 version, the APEX_IR package is not available in that version , Any other way we can achieve this in Apex 4.0??Thanks -raj

    DB:2.47:Re: Changing The Flash Chart Content Based On Ir Report Filter Criteria 11

    Hello,I have 2 regions on the same pageInteractive Report Chart (Flash Chart) This is a sub region of the aboveNow the requirement is when user applies a filter to the interactive report I would like to apply the same filter criteria to the flash chart so that data representation in flash chart matches with the IR report content. I am fairly new to the Apex, apologies if used any apex terminology in correctlyAppreciate if you can point me in the right directionThank you-Raj

  • RELEVANCY SCORE 2.47

    DB:2.47:Renaming Primary Report In Ir In 4.2 sk


    Hi,

    How can I rename primary report in 4.2? I was using the following code below which I found at another OTN Apex forum post:

    $(document).ready(function() {
    changeIRText('Customized Report');
    }); // end of ready function
    function changeIRText(pText){
    $('select#apexir_SAVED_REPORTS').find('option').each(function(index,elem) {
    $(elem).text(function(i, text) {
    return text.replace('1. Primary Report', pText);
    }); // end of changing text
    });

    }Problem is that if you flick to another private report it will revert the report name back to "Primary Report"

    Many thanks.

    DB:2.47:Renaming Primary Report In Ir In 4.2 sk

    Marko,

    How exactly did you change the name then: through shared components? I agree it is a good way if you'd want to rename the primary report for all IRs in an application, but not so much when you want a more specific naming per IR.

  • RELEVANCY SCORE 2.46

    DB:2.46:Passing Checkbox Selection To Url Another Form. jx


    Hi
    I interactive report with checkbox item created using apex_item.checkbox and hidden values as Primary key.. When user selects these check boxes and press a button, I want to send the delimited string of the IDs to next form. How do I achive this. I am quite new to this APEX development so pls help.

    Sushil

  • RELEVANCY SCORE 2.46

    DB:2.46:Print Tool In Apex ax


    Hi !
    Is it any tool, that can print complex report in APEX ?

  • RELEVANCY SCORE 2.46

    DB:2.46:Toolstripmenuitem Dropdown Painting x3


    Good day.
     
    How do I turn off/disable the gray boxed area to the left of all the dropdown items in my dropdown menu?
    I have tried changing the background color to my color of preference, but the small square area to the left of my actual menu still remains gray.
    I have played with setting .DisplayStyle to just text, but the box still appears.
    I don't want to 'color match' the background of my menu to the box just to give it the appearance of the whole dropdown menu item being the same color, but rather wonder what property this area is associated with.
     
    I have already overridden the paint method (I have inherited from DataGridViewTextBoxCell) so can do some magic in there if required, but don't think it is going to be much help as it is the dropdown of the MenuStrip that needs its appearance changed, not the cell. 
     
    A sample of what I have is as follows:
    I set the background color of my menustrip containing my dropdown to be blue as well as setting the .DropDown.BackColor member to the same blue.
     
    It appears like this when not clicked:
    Options
     
    When the mouse is over it it gets the typical blue selection rectangle common to menu items.
     
    When I click the Options button and the dropdown opens, the Options menu becomes a light grey, the dropdown items in the list are started with a slightly darker grey box followed by the text and color I choose for the dropdown backcolor.  Similar to the following (the actual greys are lighter in my app):
     
    Options
        Option 1
        Option 2
        Option 3
     
    I would like to control the color of both the selected Options menu item (lighter grey above) and the subsequent dropdown item grey boxes (darker grey above), ideally making them all the blue color I have chosen for the text, or better yet, just hide the grey boxes displayed with each dropped down item.   At first I thought the grey boxes were placeholders for an image, but as mentioned above, I have the DisplayStyle member set to text only.
     
     
    Best Regards,
    DOD.

    DB:2.46:Toolstripmenuitem Dropdown Painting x3

    Good day.
     
    How do I turn off/disable the gray boxed area to the left of all the dropdown items in my dropdown menu?
    I have tried changing the background color to my color of preference, but the small square area to the left of my actual menu still remains gray.
    I have played with setting .DisplayStyle to just text, but the box still appears.
    I don't want to 'color match' the background of my menu to the box just to give it the appearance of the whole dropdown menu item being the same color, but rather wonder what property this area is associated with.
     
    I have already overridden the paint method (I have inherited from DataGridViewTextBoxCell) so can do some magic in there if required, but don't think it is going to be much help as it is the dropdown of the MenuStrip that needs its appearance changed, not the cell. 
     
    A sample of what I have is as follows:
    I set the background color of my menustrip containing my dropdown to be blue as well as setting the .DropDown.BackColor member to the same blue.
     
    It appears like this when not clicked:
    Options
     
    When the mouse is over it it gets the typical blue selection rectangle common to menu items.
     
    When I click the Options button and the dropdown opens, the Options menu becomes a light grey, the dropdown items in the list are started with a slightly darker grey box followed by the text and color I choose for the dropdown backcolor.  Similar to the following (the actual greys are lighter in my app):
     
    Options
        Option 1
        Option 2
        Option 3
     
    I would like to control the color of both the selected Options menu item (lighter grey above) and the subsequent dropdown item grey boxes (darker grey above), ideally making them all the blue color I have chosen for the text, or better yet, just hide the grey boxes displayed with each dropped down item.   At first I thought the grey boxes were placeholders for an image, but as mentioned above, I have the DisplayStyle member set to text only.
     
     
    Best Regards,
    DOD.

  • RELEVANCY SCORE 2.46

    DB:2.46:Adding Chack Boxes To Each Row In A Report With Apex_Item.Checkbox kj


    I tried to do it, like in the 2 Day Apex Developer's Guide. I put in the region source, in the SELECT part: "apex_item.checkbox(1,c.ID) inv", where c is the name of the table, and inv is the name that I want for the checkbox in each row, but it shows an error, it shows ORA-00904: "APEX_ITEM"."CHECKBOX" not valid identifier
    Thanks

    Vctor Carmi Lara

    DB:2.46:Adding Chack Boxes To Each Row In A Report With Apex_Item.Checkbox kj

    Hello Scott,
    I'm using Application Express 2.1.0.00.39, but anyway it worked, thank you! it helped me so much.
    Vctor Carmi Lara

  • RELEVANCY SCORE 2.46

    DB:2.46:Changing Parameters In Dropdown List Produces No Report And A Javascript Error cc


    I have a report already made in SSRS 2008. I'm using the Report Viewer 9.0 to render that report in a webpage. Now the report renders fine initially. But If I change the parameter to any other value in the dropdownlist, the report goes completely blank
    and I get this javascript error: Line: 292
    Error: 'document.getElementById(...).ParametersController' is null or not an object. I'm using IE8 but it happens whether I'm in standards mode or compatibility mode.

    DB:2.46:Changing Parameters In Dropdown List Produces No Report And A Javascript Error cc

    Fixed it. I didn't realize that ReportViewer 9.0.0.0 is for SSRS 2005. So once I removed those references from the web.config, then added the 10.0.0.0 references back to the solution. Everything worked fine.
    Needed things added to web.config:

    httpHandlers
    remove verb=* path=*.asmx/
    add verb=* path=*.asmx validate=false type=System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35/
    add verb=* path=*_AppService.axd validate=false type=System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35/
    add verb=GET,HEAD path=ScriptResource.axd type=System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35 validate=false/
    add verb=* path=Reserved.ReportViewerWebControl.axd type = Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a /
    /httpHandlers

    assemblies
    add assembly=System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089/
    add assembly=System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35/
    add assembly=System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089/
    add assembly=System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089/
    add assembly=System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A/
    add assembly=System.DirectoryServices.AccountManagement, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089/
    add assembly=Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A/
    add assembly=Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A//assemblies

  • RELEVANCY SCORE 2.46

    DB:2.46:Drop Down Combobox With Check Boxes kp


    How can i implement a combobox whose elements are check boxes i.e a dropdown menu with checkboxes.

    DB:2.46:Drop Down Combobox With Check Boxes kp

    Thanks...atleast you gave me something helpful..

  • RELEVANCY SCORE 2.45

    DB:2.45:How To Create Updateable Interactive Report In Apex 3.2.1.00.11 j7


    I have an interactive report and am asked to add few more user defined columns, some of them should be free text input box type and couple of others are dropdown list (with Y/N options). I can do that if that was just a SQL report but with interactive report, I am not much aware of if it can be done. I know a way to work around this though - like create a link to direct to a new form page and update there but that is not what I wanted. I need to have those columns in the interactive report itself and should be updateable as well. Is this possible?

    Oracle DB 11g
    Oracle APEX 3.2.1.00.11

    Thanks,
    Sam

    DB:2.45:How To Create Updateable Interactive Report In Apex 3.2.1.00.11 j7

    Hi,

    This might help
    http://dbswh.webhop.net/htmldb/f?p=BLOG:READ:0::::ARTICLE:137800346674748

    I hope this do not come too late

    Regards,
    Jari
    -----
    My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
    Twitter: http://www.twitter.com/jariolai

  • RELEVANCY SCORE 2.45

    DB:2.45:Clear Text Boxes First Time... aj


    New to Apex. Have seen other threads about this but can't get it working.

    Have a form with some columns on top for a search, and then a report below for the results of the search.

    I'm trying to have the text boxes cleared each time I load the page the first time. Whatever I try doesn't seem to get rid of the previously entered data.

    Any suggestions? Thanks,

    Jeff

    DB:2.45:Clear Text Boxes First Time... aj

    Hi,

    you need to note from where your page is loaded. All Lists, Nav Bars and other links.
    Then in those places (if it is apex standard feature) specify that your destination page cashe is cleared

    This can be achieved also with url link if you have some links created in html code yourself
    Example:
    http://localhost/pls/apex/f?p=4000:4150:8090820532853366::NO:1,4150
    Means that pages 1 and 4150 cashe is nullified.

    Of course if your page can be just navigated from url from anywhere you need to use some kind of Before header process
    but be "Careful with that Axe Eugene"
    You need programmatically then decide when you clear your Search or not. Otherwise you have No data in your report.
    Of course, you can use other hidden items to help you.

    regards, Oleg

  • RELEVANCY SCORE 2.45

    DB:2.45:Trouble Changing Column Order On An Interactive Report 1x


    I am relatively new to Apex and am having trouble with ordering the columns on my interactive reports. I have tried to edit it in the report attributes tab and have also tried changing the order that it appears in the actual region source code. Any suggestions would be appreciated.

    DB:2.45:Trouble Changing Column Order On An Interactive Report 1x

    Thank you very much. I had changed the order using the "select columns" before but I did not know how to save it. Thanks again.

    Message was edited by:
    micah

  • RELEVANCY SCORE 2.45

    DB:2.45:Calling Oracle Discoverer Report From Apex ma


    How to call Oracle Discoverer Report from apex application?

    Thanks!

    DB:2.45:Calling Oracle Discoverer Report From Apex ma

    The report is on a different data base ... need to create a process to get the data into the view behind the report and then materialized view in Apex etc .Then recreate the same report in Apex. But I am trying use the disc report url to invoke the report directly from apex.

    Any suggestions or thoughts are greatly aprreciated.

  • RELEVANCY SCORE 2.45

    DB:2.45:Highligh Current Row Not Working For Classic Report In 4.1 cj


    Hello experts,

    One of our customers is migrating applications from APEX 3.0 to 4.1.
    All their applications use classic reports because interactive reports didn't exist in 3.0.

    The end users of the applications like the row color changing when they hover there mouse over the rows (highlight current row) and they insist on keeping this "functionality" in the applications.
    For some reason, this "functionality" doesn't work anymore after the migration to APEX 4.1.

    I thought it was something theme related so I created a new application with a classic report, tried some APEX built-in themes, and with none of them, I manage to get the highlight current row working.
    For interactive reports it is not an issue.

    Is this an undocumented no-longer-available feature of APEX 4.x or has there changed something which caused this functionality to stop working??

    Regards,
    Bart

  • RELEVANCY SCORE 2.45

    DB:2.45:How To Show Sp Liste Items In Dropdown List With Check Boxes kz


    Hi,
    I have the requirement to show the Sharepoint list items in a dropdown list with check boxes for multiple selection,i just able to show the list items in dropdown,how can we add checkboxes to listeitems

    DB:2.45:How To Show Sp Liste Items In Dropdown List With Check Boxes kz

    Change the column to a multiselect with check boxes and then use JQuery / JavaScript to format (probably an outer DIV). It appears that this plugin might do it for you:

    http://www.givainc.com/labs/mcdropdown_jquery_plugin.htm-James
    MCPD: SharePoint Developer 2010
    Posting is provided AS IS with no warranties, and confers no rights.
    Please mark as answer or helpful as appropriate

  • RELEVANCY SCORE 2.45

    DB:2.45:Re: Changing Alignment In Apex sf


    What theme are you using?

    DB:2.45:Re: Changing Alignment In Apex sf

    Thanks, Arie!
    It's realy work!

    Regards,
    Roman.

  • RELEVANCY SCORE 2.45

    DB:2.45:Using Javascript Onclick jj


    I have a select box where the user chooses a value from a dropdown list. Depending on that value, I want to automatically populate 5 items (text boxes). I would like to use the javascript onclick option to execute a PL/SQL procedure or PL/SQL anonymous block to populate the 5 items. I am completely ignorant on using javascript. Worse, I am using APEX 3.1.

    DB:2.45:Using Javascript Onclick jj

    Thanks to both responders. The javascript recommendation worked fine. However, the last recommendation appears to require APEX 4 which we don't have; we are using APEX 3.1

  • RELEVANCY SCORE 2.45

    DB:2.45:"In" Clause d9


    hello all,
    i have a report A with a check box and a text item. i want to run another report B in the following page based on the previously selected check boxes.

    thing is, i cant use the "in list" (comma separated values) in the query for report B because the condition:

    where field in (:p12_ins) doesn't parse very well and i cant blame apex...

    i hope its clear, any suggestion is appreciated.

    bye guys!

    DB:2.45:"In" Clause d9

    thanks a lot jarola, i solved it with

    in (select c001
    from htmldb_collections
    where collection_name = 'SELECTED_VALUES')

    its was really easy once i figured it out...

  • RELEVANCY SCORE 2.45

    DB:2.45:Changing Row Color Of A Report ff


    Apex version 4.1,

    Hi Experts,

    I have a simple report and one column holds a flag value (either 1 or 0). all the rows which has the flag value as 1 should be displayed in different color on the report. How can i do this custom row coloring ?

    Really appreciate if someone can help me on this,
    Thanks guys.

    Kurubaran.

    DB:2.45:Changing Row Color Of A Report ff

    Apex-Ape wrote:

    Really appreciate if someone can help me on this,You can help yourself on thismdash;and most other questionsmdash;by searching the forum before posting to find the numerous previous answers, such as +{thread:id=2292619}+

  • RELEVANCY SCORE 2.45

    DB:2.45:How To Put Check Boxes In A Sql Report? a3


    Hi All,

    I have a SQL Report in my application. I want to put check box for each row of the report. How can I achieve that in APEX?

    Here is my application page.

    http://apex.oracle.com/pls/otn/f?p=20420:4:

    Under the "Select" column heading I want to add the check box for each row of the report.
    So that User select that row and when he clicks on Generate report It should generate its report.
    The report should generate if user selects multiple rows also.

    Workspace : alaka
    username : alunew@yahoo.co.in
    Password : earth

    Thanks
    Alaka

    DB:2.45:How To Put Check Boxes In A Sql Report? a3

    Hi All,

    Please help me in the above issue..

    Thanks
    Alaka

  • RELEVANCY SCORE 2.44

    DB:2.44:Dynamic Dropdown Boxes ak



    Dear All,

    How can I create dynamic dropdown boxes?

    When I select a tab, It will generate dropdown boxes dynamically.When I select one option in that dropdown box, once again it has to generate one more dropdown box.

    Values for these dropdown boxes are coming from RFCs

    Thanks

    Rajani

    DB:2.44:Dynamic Dropdown Boxes ak


    Try this code:-

    Create a static node in the componenet controller and map with the views and set the cardinality to 1..n.(say static node is--calculation_col)

    theDropDownCalc = (IWDDropDownByKey) view.createElement(IWDDropDownByKey.class, null);

    secondAttInfo.addAttribute("write the any dynamic attribute namesay XXX","the datatype say string/boolean/integet");

    theDropDownCalc.bindSelectedKey("calculation_col.the name of the static node created above"+""XXX);

    theTabContainer1.addChild(theDropDownCalc);//Add the child to teh containier

    wdContext.nodeCalculation_col().currentCalculation_colElement().setAttributeValue(XXXattribute name,"Blank");//Set teh default value as blank

  • RELEVANCY SCORE 2.44

    DB:2.44:Apex Report Views cs


    How to see the activity / view frequency of the apex reports ?

    Yogesh

    DB:2.44:Apex Report Views cs

    Hi,

    Have you check ready application reports ?
    HomeApplication BuilderApplication xxxApplication ReportsActivity
    http://download.oracle.com/docs/cd/E14373_01/appdev.32/e11838/bldapp.htm#BABFEAHD

    Also this might help
    http://download.oracle.com/docs/cd/E14373_01/appdev.32/e11838/advnc.htm#sthref2148

    Br,Jari

    Edited by: jarola on Jan 28, 2010 1:48 PM

  • RELEVANCY SCORE 2.44

    DB:2.44:Interactive Report Column Search Not Working d9


    Hi,
    On Apex 4.01 and discovered that when using the individual column search functionality (clicking on the column label), the search on a column for a userid, the dropdown listing is not showing all userids that are clearly listed in the report. For example, the dropdown only shows up through IDs starting with 's--------' so when I search for an ID with 'vm' it does not show it, yet I can do a sort and go down the rows on the report and find it. Is there a limit to the dropdown list? Or is this a bug?

    Pat

    DB:2.44:Interactive Report Column Search Not Working d9

    Hi,
    On Apex 4.01 and discovered that when using the individual column search functionality (clicking on the column label), the search on a column for a userid, the dropdown listing is not showing all userids that are clearly listed in the report. For example, the dropdown only shows up through IDs starting with 's--------' so when I search for an ID with 'vm' it does not show it, yet I can do a sort and go down the rows on the report and find it. Is there a limit to the dropdown list? Or is this a bug?

    Pat

  • RELEVANCY SCORE 2.44

    DB:2.44:Bug Report: No Branch Error After Changing Authentication Scheme 1x


    Hi,

    there seems to be a small bug in the APEX Builder when changing the current Authentication Scheme.

    1) Go to Shared ComponentsAuthentication Schemes
    2) Switch to the "Change Current"
    3) Select a new authentication scheme
    4) Press the big "Run Application" button

    =
    ERR-1777: Page 829 provided no page to branch to. Please report this error to your application administrator.

    Tried on apex.oracle.com with version 3.0.1.00.07

    Patrick
    ----------------------------------------------------------------------------------------------------
    My APEX Blog: http://inside-apex.blogspot.com
    The ApexLib Framework: http://apexlib.sourceforge.net
    The APEX Builder Plugin: http://sourceforge.net/projects/apexplugin/

    DB:2.44:Bug Report: No Branch Error After Changing Authentication Scheme 1x

    Scott,

    I had this error on apex.oracle.com. I even tried it several times and was always able to reproduce it.

    I tried it now from my home PC and wasn't able to reproduce it anymore. I will try again tomorrow in the company, but can not really imagine what should be different.

    Seems to be a false alarm, but I'm absolutely sure what I saw. Maybe it pops up again some time.

    Patrick
    ----------------------------------------------------------------------------------------------------
    My APEX Blog: http://inside-apex.blogspot.com
    The ApexLib Framework: http://apexlib.sourceforge.net
    The APEX Builder Plugin: http://sourceforge.net/projects/apexplugin/