Current Position:Home > How to create dynamic ed flash charts based on user selected fields in Orac

How to create dynamic ed flash charts based on user selected fields in Orac

Update:11-30Source: network consolidation
Advertisement
Hi all,
Can any of the experts please tellme "how to create dynamic ed flash charts based on user selected fields in Oracle apex".
Thanks
Manish

The Best Answer

Advertisement
Hello,
Lots of different ways to do this, I blogged about one way (using a Pipelined function) here -
http://jes.blogs.shellprompt.net/2006/05/25/generic-charting-in-application-express/
Other options include using a PL/SQL function returning the string to use as the dynamic query etc.
Hope this helps,
John.
Blog: http://jes.blogs.shellprompt.net
Work: http://www.apex-evangelists.com
Author of Pro Application Express: http://tinyurl.com/3gu7cd
REWARDS: Please remember to mark helpful or correct posts on the forum, not just for my answers but for everyone!
  • How to create dynamic ed flash charts based on user selected fields in Orac Update:11-30

    Hi all, Can any of the experts please tellme "how to create dynamic ed flash charts based on user selected fields in Oracle apex". Thanks ManishHello, Lots of different ways to do this, I blogged about one way (using a Pipelined function) here -

  • Dynamic bar chart based on LOV selected Update:11-30

    Apex 2.1 with XE : running on windows xp. I am trying to create charts based on selected criteria such as level 1, level 2 and level 3. If the user selects level 1 chart is expected to group level 2 and level 3 parameters else if the user selects lev

  • Dynamically set flash chart height? Update:11-30

    Hi, I have a flash chart that includes a selector that alters the query for the chart. Depending on what the user selects, the chart shows a different number of rows (this happens to be a stacked horizontal bar chart, but this could apply to any char

  • How to show the columns dynamically in OBIEE report based on the selection? Update:10-11

    Hi, I have a requirement where the columns should be dynamically shown in report based on what we select in propmt page. I'm creating a report in OBIEE where i want to give an option to the end user to select the columns whichever he wants to see in

  • Help Creating Dynamic Stacked Column Chart with Multiple Criteria Update:10-11

    Hi all. Im new here and hoping you can help.  I have a dashboard Im trying to rebuild from scratch (our computer had a meltdown and we lost all our files). I did not build the dashboard initially so Im trying to recreate it from the flash file we wer

  • How to create dynamic table using POJO based DataControl Update:11-30

    Hi, I'm using JDeveloper 11.1.1.5.0. I'm not using ADF BC. I've a requirement to display the Dynamic table in my search page. In our product we are using POJO based Data controls. I created a task-flow and page fragment. I tried to create the dynamic

  • Dynamically refresh Flash chart in 4.2 Update:11-30

    In my Apex 4.2 app I have a chart region that I want to refresh whenever a radio button group has changed. My radio button group P2_RG_DEPTNO returns static values 10 and 20. I created a dynamic action on the group to refresh the chart region when th

  • Is it possible to size a flash chart based on the amount of data returned? Update:11-30

    My chart is based on a date range. If a user enters say a range of one year, I need the line chart to be rather large so show all the data points. Though if they select just a week, then the chart can be much smaller. I only see the hard coded values

  • Syntax for creating Dynamic Time Filtersin Universes based on SAPBW Update:11-30

    Hi there. My customer has a requirement for having a series of dynamic filters available in a Universe Based on a Bex Query. In the Univers the BO report Developper will be able to choose from different filters to make the appropriate query for the r

  • Cannot create dynamic page with cursor based on linked table Update:11-30

    I get the following error when i try to create a dynamic portal page that uses a pl/sql cursor: ORA-06550: line 1, column 24: PL/SQL: ORA-00980: synonym translation is no longer valid ORA-06550: line 1, column 24: PL/SQL: SQL Statement ignored (WWV-1