2. PHPRunner General questions
  3. How To: Add Date Range to Reports
This topic is locked

How To: Add Date Range to Reports

 		7/7/2010 9:50:20 AM
PHPRunner General questions
J
 jansgroup author

I have the Enterprise version of PHP Runner 5.2.
i built a simple report that shows
Username | Sale Date | Sale Type | Sale Amount
-------------
i built the report using the internal report builder in phprunner, and then again using the web report builder.

The web report builder looks better. Both function well. I know that i can do a date range via the Advanced Search option in

either of the created reports, which nearly solves the issue. On the report created by the internal PHPRunner, i would like to know

how do i edit the way Advanced Search looks? On the report created from the web report builder, same question - how do i edit the way the Advanced Search looks?

On the web version, i cant even seem to limit the fields that are displayed.
My thoughts are i can make a link that opens to "Orders_Report_search.php", i can customize the look/feel of this page so that when the user look at it he/she knows they need to select a date range and then hit "Search" to see the desired report for the specific date range. I would like to be able to do this for both the internal PHPRunner generated report as well as the online Web builder report version.
OR is there an easier way to go about creating a report that prompts the user to select a date range ##/##/#### - ##/##/ ##### ?
With Date range i could easily find out all sales that where generated from starting date through ending date. Example How were sales last week?

currently i am also able to select it by Username (optional) which i think it perfect - Allowing me to know how many sales did "Sally" make last week, or from this starting date though this ending date.
Username | Sale Date | Sale Type | Sale Amount
Any advice, any help on this? I know i have thought of a few ways to make this happen, however im always open to better ideas.
A
 		ann 7/7/2010

Hi,
you can edit the output of Search page on the Visual Editor tab.

To edit webreport's output proceed to the Style Editor page.
To create a link to the Search page use Menu Editor dialog on the Visual Editor tab.

To prompt the user to select date in some format choose add Custom expressionin the Validate as option in the Edit as settings dialog on the Visual Editor tab.

More detailed here:

http://xlinesoft.com/phprunner/docs/validation_types.htm
J
 		jansgroup author 7/7/2010



Hi,
you can edit the output of Search page on the Visual Editor tab.

To edit webreport's output proceed to the Style Editor page.
To create a link to the Search page use Menu Editor dialog on the Visual Editor tab.

To prompt the user to select date in some format choose add Custom expressionin the Validate as option in the Edit as settings dialog on the Visual Editor tab.

More detailed here:

http://xlinesoft.com/phprunner/docs/validation_types.htm


Ok, so 3 questions.

1 on the webreports - where do i go to edit the output of the "Advanced search", the report itself is defined in the Style Editor and honestly - i have that just the way i want it.


2 on the webreports - where do i put in a custom SQL query i built outside of the system?


3 on the date range aspect, what would i put in the Custom expression that would prompt a date range dialog box?
A
 		ann 7/8/2010

Hi,
please see my comments:

1)2) unfortunately, you can't edit webreports in that way.

3) sorry for misunderstanding. For usual report:

proceed to the Menu Editor dialog on the Visual Editor tab. Then change link which points to the reports to the link which points to the Search page of the report. Use search page in order to define date range. To do it in the webreport you need manually chooseAdvanced search and pick a date range.
J
 		jansgroup author 7/8/2010



Hi,
please see my comments:

1)2) unfortunately, you can't edit webreports in that way.

3) sorry for misunderstanding. For usual report:

proceed to the Menu Editor dialog on the Visual Editor tab. Then change link which points to the reports to the link which points to the Search page of the report. Use search page in order to define date range. To do it in the webreport you need manually chooseAdvanced search and pick a date range.


OK, This is basically what i assumed from start, i would love to see the future versions/builds of the "webreports" with A.) the ability to add custom SQL queries. B.) Also the ability to edit the Advanced Search is rather important, as currently webreports doesn't even allow you to even limit the fields displayed in the Advanced Search, if i had known this pitfall upfront i most likely would not have elected for the Upgrade to ENTERPRISE, i figured from the demo the ability was locked out for security reasons. Oh well, thanks anyway.
IF there is any way to accomplish #1 or #2 via the generated files on the server and with manual edit via a text editor - please let me know.