Calendar with Drill Down Report

I am new to Application Express.
Please any one tell me step by step how to make calendar with drill down report.
Waiting for valuable reply.


Not sure if this is what you wanted, but I have links on a calendar, and when you click them, it branches to another page with details about the event.
To do this, create a calendar region. The SQL statement should have at least 2 columns: The date of the "event", and the text to display as a link. You should also choose a primary key that you want to pass to the drill down report when the user clicks. Something like this:
select hiredate date_scheduled,
          ename display_column,
   from empIn the calendar attributes of that region, there is a place to designate which column is the date, and which should be displayed. Go down a little further and set the column link. Put the page you want to show the drilldown report on, and set any variables you need to.
Hopefully that helped. Its pretty simple once you play around with it - start simple and then once you get the hang of it, make it more complex.

Problem with Drill down reports demo

Hi, Did somebody successfully installed the drill down demo. I am not able to get the results here getting some javascript error "object expected". I have created a schema, also the cgicmd.dat report variables attahced the rep_util file. I could

IS it possible to save drill down report in a html file?

Hi all, My client is looking for a html file of a drill down report. Is it possible to save the report in html format with the drill down feature in it? Please help. Thanks, KarthickHI imansyah, Can you try doing what you want in first instance and t

How to call a drill down report using hyperlink ?

Can anyone please give an example to call a drill down report using hyper link in Reports 10g ? Regards Capri !!!Hi, I've been using this approach in a couple of reports and it works great with one problem. Even if I include the srw.set_hyperlink_att

Drill down report in HTML DB

Cannot get the drill down report working. Have created 2 pages first one with master table and second page containing detail information. Further i have created an item to hold the value on page two. Now when i go to the Query definition to give a co

Drill Down Report FI, GL Balance Display

Dear Expert,   I am creating report with form using Drill Down Report GL Balance in FI using FIG1,2,3....   I added formula column, in this formula column, I try to put variable inside the formula, but system always said:      <<<Incorrect formul

Agregated value in original report in not same as the drill down report

Hello experts, I have a issue with the drill down reports. Agregated value in the main report is not equal to the agregarated value in the drill down report. In my report I have a sales for jan 2011,feb 2011 so on For jan 2011 it is some thing $56000

Drill Down Report issues in VS 2010, CR viewer 12

We are using VS 2010, Crystal Reports 12 with Crystal Viewer 12 control called from a C# programmed page frame.  Several Drill Down reports are developed with CR 12 service pack 1 and then deployed onto the server.  These Drill Down reports work grea

Fi drill down reporting

HI sap guys, Let me know  fi drill down reporting configuration(with one example) regards srinivaswelcome to SCN!!!!!! check the below thread. Drill down ReportingRead other 2 answers

Drill Down Reports - Very Urgent

I have the following situation. I want to create a drill down report and pass parameters from the master report to the detail. I built 2 simple tabular reports Drill1 (master) and Drill2 (detail). I have placed a button in the repeating frame of the

New to Application Express - Drill down report question

Good evening group. I'm new to this Application and DB but can't find quite the correct answer. QUESTION 1 - I have found and successfully used the "Drill down report example". However, I am only able to do it from a brand new application. That

How to create drill down reports

pelase help me step to create drill down reports Find the manager and their employees Manager names are abc, def employees are abc manager employees are john, lilly. def employees are mark,syam How can i acheive below format. abc-manager John lilly D

Drill down reports from Before Report Trigger

Hallo, I am using reports 6.08 and I want to run several subreports from the parameter form of a master report. However when I call srw.run_report() from the Before Report Trigger with batch=no I get the error message ... When I use batch=yes I canno

Customized drill-down report cannot go to line item level (FGI4 and FGI1)

Hi Expert, I created a customized drill-down report using New GL features, as follows: FGI4 create form, with reference to form: 0SAPBLNCE-01 FGI1 create report for the form created. After that I set some things like characteristic, variables, and ou

How to group by a number of visible rows in drill down report

hi, i have a drill down report with no detail row.  I need to control the number of rows shown on the page based on a variable that a user supplies, however it  needs to be only visible rows. if I add an outmost group based on an expression like this

Adding a characteristics to AR Drill down report for line items

I have raised an OSS note on this, but they deem this to be consulting. I have an AR drill down report for line items It calls the structure RFRRD20. I need to add a value into the characteristics so I can use it in the drill down report. I have appe

Drill Down Report to Summary Report Page Navigation

Hi, I need technical input. I have 1 summary report, which is having two columns i.e. Name, ID.Name having hyperlink which navigates to drill down level report. How to go back from drill down level report to summary report. Note : Using IE back butto

Drill down report on Report Server

How to run a drill-down report on Oracle report Server? The drill-down report works fine in Client Server. When the same report is tried on Web (Run a reoprt on Web using Oracle Report Server - Oracle Report 6i) it do't work. The problem is: 1)The dr

How To Create Drill down report in oracle report 6i version

HI, I have one table having dept no , emp_no ,Sal like field. I want drill down report master column dept_no. i want one click on dept_no & i want to see detail of emp & Sal on it How can i do this please guide me. Thanks in advance RahilHi One si

Drill down report update

Hi, How to add several currency value (USD, LKR) in drill down report - in Due Date Analysis for open Item report (S_ALR_87012168) Thanx.Hi, How to add several currency value (USD, LKR) in drill down report - in Due Date Analysis for open Item report