def sql_report_csv(request, report_id): '''View a single sql report.''' extuser = request.extuser report = SqlReport.objects.get(id=report_id) whereclause = util.get_whereclause(request.GET) cols, data = report.get_data({"whereclause": whereclause}) return format_csv(data, cols, report.title)
def sql_report(request, report_id, template_name="sql_report.html"): '''View a single sql report.''' extuser = request.extuser report = SqlReport.objects.get(id=report_id) whereclause = util.get_whereclause(request.GET) table = report.to_html_table({"whereclause": whereclause}) return render_to_response(request, template_name, {"report": report, "table": table})