Hello, Everybody. 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. Thanks Rahul
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,
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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