2. PHPRunner General questions
  3. Easy drill down from one report to another
This topic is locked

Easy drill down from one report to another

 		5/4/2009 10:58:06 AM
PHPRunner General questions
V
 voicemagic author

I created a very simple summary only "report #1" that is grouped by year/month & contains calculated fields.
Example . . .

2009-01 followed by two calculated fields

2009-02 followed by two calculated fields

2009-03 followed by two calculated fields

etc.
I would like to create a "report #2" & then switch to it, by just clicking on any of the year/month "group by" fields (i.e. 2009-02) listed on "report #1" and display detail records & more calculated fields that are associated with the year/month selected.
I mainly selected "report" because it seemed easier to insert & total calculated fields, & it seemed cleaner.
Is this possible to use "report" in a drill down manner like this?

Or, is "list" a better method?
Thanks,
Dave
J
 		Jane 5/5/2009

Hi,
what PHPRunner version do you use?
V
 		voicemagic author 5/5/2009

PHPRunner 5.1
J
 		Jane 5/5/2009

Hi,
here are some tips:

  1. proceed to the Visual Editortab, click on the group field and switch to HTML mode, then find this code:
    {$FieldName_grval}



and replace it with this one:

{$FieldName_value}


2. set up this field as custom on the "View as" settingsdialog on the Visual Editortab.

Here is a sample:

$value = "<a href=\"anotherreport_report.php?recordid=".$value."\" target=_blank>".$value."</a>";


3. check passed value in the After table initialized event on the Eventstab:

global $gsqlWhereExpr;

if (@$_REQUEST["recordid"])

$gsqlWhereExpr = "FieldName='".$_REQUEST["recordid"]."'";
V
 		voicemagic author 5/19/2009

Hi,

here are some tips:

  1. proceed to the Visual Editortab, click on the group field and switch to HTML mode, then find this code:
    and replace it with this one:
  2. set up this field as custom on the "View as" settingsdialog on the Visual Editortab.

    Here is a sample:
  3. check passed value in the After table initialized event on the Eventstab:


Can you tell me which report each of your items 1, 2 & 3 refer to?

I want to click on & pass a grouped by field in report #1 to report #2.

Also, on item #3, which "action" should I choose?

Please advise.
J
 		Jane 5/20/2009

Hi,
points #1 and #2 are for the first report. Event from point #3 is for the second report.