NAME

C4::Reports - Module for generating reports

SYNOPSIS

  use C4::Reports;

get_report_types(): This will return a list of all the available report types
get_report_areas(): This will return a list of all the available report areas
get_all_tables(): This will return a list of all tables in the database
get_columns($area): This will return a list of all columns for a report area
build_query($columns,$criteria,$orderby,$area): This will build the sql needed to return the results asked for, $columns is expected to be of the format tablename.columnname. This is what get_columns returns.
get_criteria($area,$cgi);: Returns an arraref to hashrefs suitable for using in a tmpl_loop. With the criteria and available values.
save_report($sql,$name,$type,$notes): Given some sql and a name this will saved it so that it can resued
create_compound($masterID,$subreportID): This will take 2 reports and create a compound report using both of them
get_column_type($column): This takes a column name of the format table.column and will return what type it is (free text, set values, date)
get_distinct_values($column): Given a column name, return an arrary ref of hashrefs suitable for use as a tmpl_loop with the distinct values of the column

Chris Cormack <crc@liblime.com>

Hey! The above document had some coding errors, which are explained below: