We have released a beta version of Online Report Builder.
http://demo.asprunner.net/andrewsamoilov...2/webreport.phpUse admin/admin to login.
Feel free to create or edit reports. Each report can be either private or public. Public reports can be seen by everyone.
Currently we are working on adding group based security and Online Chart Builder. Chart Builder will include the latest version of AnyChart
Flash Charts 4.0.There is a good chance Online Report and Chart Builder will be a part of Enterprise edition of ASPRunnerPro/PHPRunner that we are hoping to release this summer.
As usually your feedback is appreciated.
I have the shopping cart template and really need to do some creative reports that list the students with thier parents and their purchase history. And make it all fit on 8.5 x 11 paper.
My tables are linked by user_id ... the main table is USER - that user is the "Registration Management User", is just tracked the log-in but it's the master ID of everything. -- then the parents addresses and phone are in user addreses, then I added a table for students (linked by user_id like user_addresses) .. then I have the regular shopping card.
I'm trying with a regular report, but I have way too much to work out. I have to move all the Yes/No answers around. I am in the ADMIN (folder) part of Shopping Cart .. so it has access to all records.
Can Report Builder help with this? Is there an add-on that I can by to manage these things?
Thanks!
Bob
I have DreamWeaver and tried to Wysiwyg this, but I keep losing the GROUPS and some of the If/Thens.
Any ideas are appreciated.
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=32332&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />
[codebox]<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>user_students Report</TITLE>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"><LINK
href="include/style.css" type=text/css rel=stylesheet>
<META content="MSHTML 6.00.6001.18099" name=GENERATOR></HEAD>
<BODY topMargin=5
{$onload}>{$includes}{include_if_exists file="include/header.php"} {literal}
<STYLE>
table.report { border-collapse: collapse}
table.report td {
padding: 2px;
border-width: 1px;
border-style: solid;
border-color: #cccccc;
}
td.group_1
{
background-color: CCFFCC;
}
td.group_2
{
background-color: CCEEFF;
}
td.nbgroup_1
{
background-color: CCFFCC;
border-style:none;
}
td.nbgroup_2
{
background-color: CCEEFF;
border-style:none;
}
td.header_1
{
background-color: ADD8AD;
}
td.header_2
{
background-color: ADCAD8;
}
td.pagesummary
{
background-color:#ffffbb;
}
td.globalsummary
{
background-color:#ffe0b0;
}
</STYLE>
{/literal}
<TABLE cellSpacing=0 cellPadding=0 width=1045 align=center border=0>
<TBODY>
<TR>
<TD>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
<TBODY>
<TR>
<TD class=headerlistup_left vAlign=middle align=middle width=7 height=31></TD>
<TD class=upeditmenu_gif style="PADDING-TOP: 2px" vAlign=middle align=middle height=31> <!-- login/logout -->Logged
as <B>{$userid}</B> <INPUT class=button onclick="java script:window.location.href='login.php?a=logout'" type=button value="Log out">
<!-- change password--><!-- Advanced search-->{if $allow_search}
<INPUT class=button onclick="java script:window.location.href='_user_students_Report_search.php'" type=button value="Advanced search">
{/if} {if $allow_export}
<INPUT class=button onclick="window.open('_user_students_Report_print.php','wPrint');return false;" type=button value="Print this page">
<INPUT class=button onclick="window.open('_user_students_Report_print.php?all=1','wPrint');return false;" type=button value="Print whole report">
{/if} </TD>
<TD class=headerlistup_right vAlign=middle align=middle width=7 height=31></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD>
<TABLE class=main_table_border2 cellSpacing=0 cellPadding=0 width="100%"
align=center border=0>
<TBODY>
<TR>
<TD>
<TABLE class=main_table cellSpacing=0 cellPadding=10 width="100%"
align=center border=0><!-- menu block -->
<TBODY>
<TR>
<TD vAlign=top width=200>
<TABLE cellSpacing=0 cellPadding=0 width=200 border=0>
<TBODY>
<TR>
<TD>
<TABLE cellSpacing=0 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD class=menuup_left vAlign=middle align=middle width=2></TD>
<TD class=menuup vAlign=middle align=middle> </TD>
<TD class=menuup_right vAlign=middle align=middle width=2></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD vAlign=top width="100%"><!----menu search---->
<TABLE class=menu_table cellSpacing=0 cellPadding=2
width="100%" border=0><!-- list of tables -->
<TBODY>
<TR>
<TD style="PADDING-LEFT: 20px" vAlign=middle width=200>
<TABLE cellSpacing=0 cellPadding=0 width=200
border=0>{if $allowuser_students_Report}
<TBODY>
<TR height=30>
<TD><IMG src="include/img/arrow_search2.gif"
border=0> </TD>
<TD> <A class=highlight-tablesearch
href="_user_students_Report_report.php">user_students
Report</A></TD></TR>{/if}{if $allowuser_students}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="_user_students_list.php">Choristers</A></TD></TR>{/if}{if $allow_user_students_export}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="user_students_export_list.php">Student
Export</A></TD></TR>{/if}{if $allow_users}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="users_list.php">Users</A></TD></TR>{/if}{if $allow_users_files}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="users_files_list.php">Family
Info</A></TD></TR>{/if}{if $allow_sales_order_admin}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="sales_order_admin_list.php">Orders</A></TD></TR>{/if}{if $allow_admin_inventory}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="admin_inventory_list.php">Products</A></TD></TR>{/if}{if $allow_inventory_receipts}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="inventory_receipts_list.php">Quick Add
Products</A></TD></TR>{/if}{if $allow_categories}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="categories_list.php">Categories</A></TD></TR>{/if}{if $allow_emails}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="emails_list.php">Emails
Templates</A></TD></TR>{/if}{if $allow_states}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="states_list.php">States</A></TD></TR>{/if}{if $allow_countries}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="countries_list.php">Countries</A></TD></TR>{/if}{if $allow_ship_via}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="ship_via_list.php">Ship Via</A></TD></TR>{/if}{if $allow_shipping_settings}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="shipping_settings_list.php">Shipping
Settings</A></TD></TR>{/if}{if $allow_shipping_rates}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="shipping_rates_list.php">Shipping
Rates</A></TD></TR>{/if}{if $allow_pay_types}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="pay_types_list.php">Payment
Types</A></TD></TR>{/if}{if $allow_card_types}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="card_types_list.php">Card
Types</A></TD></TR>{/if}{if $allow_currency}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="currency_list.php">Currency</A></TD></TR>{/if}{if $allow_paypal_info}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="paypal_info_list.php">Paypal
Info</A></TD></TR>{/if}{if $allow_gateways}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="gateways_list.php">Gateways</A></TD></TR>{/if}{if $allow_global_settings}
<TR height=30>
<TD><IMG src="include/img/arrow_search.gif"
border=0> </TD>
<TD> <A class=tablelinkssearch
href="global_settings_list.php">Global
Settings</A></TD></TR>{/if}
<TR>
<TD width="100%" colSpan=2 height=15
bdcolor="white"> </TD></TR></TBODY></TABLE></TD></TR></TD></TR></TBODY></TABLE>
<TABLE class=menu_table2 cellSpacing=0 cellPadding=0
width="100%" border=0>
<TBODY>
<TR>
<TD>
<TABLE class=menu_table1 cellSpacing=0
cellPadding=5 width="100%" border=0>
<TBODY>
<TR>
<TD class=blackshade2 align=middle
height=23>Groups per page: <select
onChange="java script: document.location='_user_students_Report_report.php?pagesize='+this.options[this.selectedIndex].value;">
<option value="1" {$gpp1_selected}>1</option>
<option value="3" {$gpp3_selected}>3</option>
<option value="5" {$gpp5_selected}>5</option>
<option value="10" {$gpp10_selected}>10</option>
<option value="50" {$gpp50_selected}>50</option>
<option value="100" {$gpp100_selected}>100</option>
<option value="-1" {$gpp0_selected}>All</option>
</select>
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD>
<TD vAlign=top align=middle>
<TABLE class=list_table1 cellSpacing=0 cellPadding=0
width="100%" border=0>
<TBODY>
<TR>
<TD>
<TABLE class=list_table cellSpacing=0 cellPadding=0
width="100%" border=0>
<TBODY>
<TR>
<TD>
<TABLE class=report
style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid"
cellSpacing=0 cellPadding=1 width="95%"
align=center border=0><!--{foreach from=$rowinfo item=row}--><!------------------------------------- group headers -----------------------------------------><!--{if $row.newgroup_user_id}-->
<TBODY>
<TR>
<TD class=header_1 colSpan=100>user_id:
<FONT style="FONT-WEIGHT: 900">{$row.1user_id_grval}</FONT></TD></TR><!--{/if}--><!--{if $row.newgroup_id}-->
<TR>
<TD class=header_2 colSpan=100>id: <FONT
style="FONT-WEIGHT: 900">{$row.1id_grval}</FONT></TD></TR>
<TR>
<TD class=blackshade>first</TD>
<TD class=blackshade>middle</TD>
<TD class=blackshade>last</TD>
<TD class=blackshade>email</TD>
<TD class=blackshade>main_address</TD>
<TD class=blackshade>class</TD>
<TD class=blackshade>campus</TD>
<TD class=blackshade>grade</TD>
<TD class=blackshade>birthdate</TD>
<TD class=blackshade>ethnicity</TD>
<TD class=blackshade>date_joined</TD>
<TD class=blackshade>school_city</TD>
<TD class=blackshade>family_id</TD>
<TD class=blackshade>paycode1</TD>
<TD class=blackshade>paycode2</TD>
<TD class=blackshade>status1</TD>
<TD class=blackshade>status2</TD>
<TD class=blackshade>medical_ok</TD>
<TD class=blackshade>physician</TD>
<TD class=blackshade>ph_phone</TD>
<TD class=blackshade>date_last</TD>
<TD class=blackshade>dentist</TD>
<TD class=blackshade>de_phone</TD>
<TD class=blackshade>ortho</TD>
<TD class=blackshade>or_phone</TD>
<TD class=blackshade>insurance</TD>
<TD class=blackshade>ins_address</TD>
<TD class=blackshade>ins_phone</TD>
<TD class=blackshade>ins_policy</TD>
<TD class=blackshade>ins_payerid</TD>
<TD class=blackshade>medical_summary</TD>
<TD class=blackshade>ms_asthma</TD>
<TD class=blackshade>status</TD>
<TD class=blackshade>ms_hosp</TD>
<TD class=blackshade>ms_seiz</TD>
<TD class=blackshade>ms_appendi</TD>
<TD class=blackshade>ms_tuber</TD>
<TD class=blackshade>ms_diabetes</TD>
<TD class=blackshade>ms_add_adhd</TD>
<TD class=blackshade>ms_head</TD>
<TD class=blackshade>ms_prosth</TD>
<TD class=blackshade>ms_fainting</TD>
<TD class=blackshade>ms_bleeding</TD>
<TD class=blackshade>ms_tonsil</TD>
<TD class=blackshade>ms_wearscontacts</TD>
<TD class=blackshade>ms_other</TD>
<TD class=blackshade>ms_operations</TD>
<TD class=blackshade>ms_recentexp</TD>
<TD class=blackshade>ms_underdr</TD>
<TD class=blackshade>ms_aware</TD>
<TD class=blackshade>ms_explain</TD>
<TD class=blackshade>ma_pen</TD>
<TD class=blackshade>ma_latex</TD>
<TD class=blackshade>ma_foods</TD>
<TD class=blackshade>ma_bee</TD>
<TD class=blackshade>ma_animals</TD>
<TD class=blackshade>ma_other</TD>
<TD class=blackshade>ma_further</TD>
<TD class=blackshade>ma_life</TD>
<TD class=blackshade>ma_epin</TD>
<TD class=blackshade>ma_epin_explain</TD>
<TD class=blackshade>ma_epin_train</TD>
<TD class=blackshade>ma_diet</TD>
<TD class=blackshade>ma_diet_explain</TD>
<TD class=blackshade>ma_hay</TD>
<TD class=blackshade>ma_bee_kit</TD>
<TD class=blackshade>mm_medications</TD>
<TD class=blackshade>mm_tylenol</TD>
<TD class=blackshade>mm_chlora</TD>
<TD class=blackshade>mm_sucrets</TD>
<TD class=blackshade>mm_neo</TD>
<TD class=blackshade>mm_suda</TD>
<TD class=blackshade>mm_antidi</TD>
<TD class=blackshade>mm_cough</TD>
<TD class=blackshade>mm_pepto</TD>
<TD class=blackshade>mm_bena</TD>
<TD class=blackshade>mm_mm</TD>
<TD class=blackshade>mm_hydro</TD>
<TD class=blackshade>mm_aleve</TD>
<TD class=blackshade>mm_robo</TD>
<TD class=blackshade>mm_tums</TD>
<TD class=blackshade>mm_tinactin</TD>
<TD class=blackshade>mm_advil</TD>
<TD class=blackshade>mm_caldryl</TD>
<TD class=blackshade>mm_motrin</TD>
<TD class=blackshade>mm_auth_ok</TD>
<TD class=blackshade>mm_auth_name</TD>
<TD class=blackshade>conclude</TD>
<TD class=blackshade>add_date</TD>
<TD class=blackshade>printed</TD>
<TD class=blackshade>finance_code</TD>
<TD class=blackshade>sign_section_efg</TD>
<TD class=blackshade>sign_conduct</TD>
<TD class=blackshade>sign_media</TD>
<TD class=blackshade>sign_medical</TD>
<TD class=blackshade>sign_name</TD>
<TD class=blackshade>charms_active</TD>
<TD class=blackshade>charms_update</TD>
<TD class=blackshade>charms_date</TD>
<TD class=blackshade>charms_id</TD></TR><!--{/if}--><!------------------------------------- data -----------------------------------------><!--{if $row.havedata}-->
<TR>
<TD class=data>{$row.1first_value}</TD>
<TD class=data>{$row.1middle_value}</TD>
<TD class=data>{$row.1last_value}</TD>
<TD class=data>{$row.1email_value}</TD>
<TD class=data>{$row.1main_address_value}</TD>
<TD class=data>{$row.1class_value}</TD>
<TD class=data>{$row.1campus_value}</TD>
<TD class=data>{$row.1grade_value}</TD>
<TD class=data>{$row.1birthdate_value}</TD>
<TD class=data>{$row.1ethnicity_value}</TD>
<TD class=data>{$row.1date_joined_value}</TD>
<TD class=data>{$row.1school_city_value}</TD>
<TD class=data>{$row.1family_id_value}</TD>
<TD class=data>{$row.1paycode1_value}</TD>
<TD class=data>{$row.1paycode2_value}</TD>
<TD class=data>{$row.1status1_value}</TD>
<TD class=data>{$row.1status2_value}</TD>
<TD class=data>{$row.1medical_ok_value}</TD>
<TD class=data>{$row.1physician_value}</TD>
<TD class=data>{$row.1ph_phone_value}</TD>
<TD class=data>{$row.1date_last_value}</TD>
<TD class=data>{$row.1dentist_value}</TD>
<TD class=data>{$row.1de_phone_value}</TD>
<TD class=data>{$row.1ortho_value}</TD>
<TD class=data>{$row.1or_phone_value}</TD>
<TD class=data>{$row.1insurance_value}</TD>
<TD class=data>{$row.1ins_address_value}</TD>
<TD class=data>{$row.1ins_phone_value}</TD>
<TD class=data>{$row.1ins_policy_value}</TD>
<TD class=data>{$row.1ins_payerid_value}</TD>
<TD class=data>{$row.1medical_summary_value}</TD>
<TD class=data>{$row.1ms_asthma_value}</TD>
<TD class=data>{$row.1status_value}</TD>
<TD class=data>{$row.1ms_hosp_value}</TD>
<TD class=data>{$row.1ms_seiz_value}</TD>
<TD class=data>{$row.1ms_appendi_value}</TD>
<TD class=data>{$row.1ms_tuber_value}</TD>
<TD class=data>{$row.1ms_diabetes_value}</TD>
<TD class=data>{$row.1ms_add_adhd_value}</TD>
<TD class=data>{$row.1ms_head_value}</TD>
<TD class=data>{$row.1ms_prosth_value}</TD>
<TD class=data>{$row.1ms_fainting_value}</TD>
<TD class=data>{$row.1ms_bleeding_value}</TD>
<TD class=data>{$row.1ms_tonsil_value}</TD>
<TD class=data>{$row.1ms_wearscontacts_value}</TD>
<TD class=data>{$row.1ms_other_value}</TD>
<TD class=data>{$row.1ms_operations_value}</TD>
<TD class=data>{$row.1ms_recentexp_value}</TD>
<TD class=data>{$row.1ms_underdr_value}</TD>
<TD class=data>{$row.1ms_aware_value}</TD>
<TD class=data>{$row.1ms_explain_value}</TD>
<TD class=data>{$row.1ma_pen_value}</TD>
<TD class=data>{$row.1ma_latex_value}</TD>
<TD class=data>{$row.1ma_foods_value}</TD>
<TD class=data>{$row.1ma_bee_value}</TD>
<TD class=data>{$row.1ma_animals_value}</TD>
<TD class=data>{$row.1ma_other_value}</TD>
<TD class=data>{$row.1ma_further_value}</TD>
<TD class=data>{$row.1ma_life_value}</TD>
<TD class=data>{$row.1ma_epin_value}</TD>
<TD class=data>{$row.1ma_epin_explain_value}</TD>
<TD class=data>{$row.1ma_epin_train_value}</TD>
<TD class=data>{$row.1ma_diet_value}</TD>
<TD class=data>{$row.1ma_diet_explain_value}</TD>
<TD class=data>{$row.1ma_hay_value}</TD>
<TD class=data>{$row.1ma_bee_kit_value}</TD>
<TD class=data>{$row.1mm_medications_value}</TD>
<TD class=data>{$row.1mm_tylenol_value}</TD>
<TD class=data>{$row.1mm_chlora_value}</TD>
<TD class=data>{$row.1mm_sucrets_value}</TD>
<TD class=data>{$row.1mm_neo_value}</TD>
<TD class=data>{$row.1mm_suda_value}</TD>
<TD class=data>{$row.1mm_antidi_value}</TD>
<TD class=data>{$row.1mm_cough_value}</TD>
<TD class=data>{$row.1mm_pepto_value}</TD>
<TD class=data>{$row.1mm_bena_value}</TD>
<TD class=data>{$row.1mm_mm_value}</TD>
<TD class=data>{$row.1mm_hydro_value}</TD>
<TD class=data>{$row.1mm_aleve_value}</TD>
<TD class=data>{$row.1mm_robo_value}</TD>
<TD class=data>{$row.1mm_tums_value}</TD>
<TD class=data>{$row.1mm_tinactin_value}</TD>
<TD class=data>{$row.1mm_advil_value}</TD>
<TD class=data>{$row.1mm_caldryl_value}</TD>
<TD class=data>{$row.1mm_motrin_value}</TD>
<TD class=data>{$row.1mm_auth_ok_value}</TD>
<TD class=data>{$row.1mm_auth_name_value}</TD>
<TD class=data>{$row.1conclude_value}</TD>
<TD class=data>{$row.1add_date_value}</TD>
<TD class=data>{$row.1printed_value}</TD>
<TD class=data>{$row.1finance_code_value}</TD>
<TD class=data>{$row.1sign_section_efg_value}</TD>
<TD class=data>{$row.1sign_conduct_value}</TD>
<TD class=data>{$row.1sign_media_value}</TD>
<TD class=data>{$row.1sign_medical_value}</TD>
<TD class=data>{$row.1sign_name_value}</TD>
<TD class=data>{$row.1charms_active_value}</TD>
<TD class=data>{$row.1charms_update_value}</TD>
<TD class=data>{$row.1charms_date_value}</TD>
<TD class=data>{$row.1charms_id_value}</TD></TR><!--{/if}--><!------------------------------------- group summary -----------------------------------------><!--{/foreach}--></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><BR>{$pagination}
<BR><BR></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD>{include_if_exists file="include/footer.php"}
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD class=headerlistdown_left vAlign=middle align=middle width=8 height=15></TD>
<TD class=downeditmenu vAlign=middle align=middle height=15> </TD>
<TD class=headerlistdown_right vAlign=middle align=middle width=8 height=15></TD></TR></TBODY></TABLE></TD></TR></TD></TR></TBODY></TABLE></BODY></HTML>
[/codebox]