Click here to Skip to main content
15,892,059 members
Articles / Web Development / ASP.NET

Drilldown Report Writer with Charting

Rate me:
Please Sign up or sign in to vote.
4.38/5 (7 votes)
28 Feb 2010CPOL4 min read 31.4K   873   26  
This article describes a template-driven reporting tool which allows drilldown and charting.
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

/// <summary>
/// Summary description for ReporterHelpers
/// </summary>
public class CustomHelpers
{
	public CustomHelpers()
	{
		//
		// TODO: Add constructor logic here
		//
	}

    // try to match a parameter name using cookie, session, form, querystring
    public static string GetParam(string Name)
    {
        if (System.Web.HttpContext.Current.Request.Cookies[Name] != null)
            return (System.Web.HttpContext.Current.Request.Cookies[Name].Value);
        if (System.Web.HttpContext.Current.Session[Name] != null)
            return (System.Web.HttpContext.Current.Session[Name].ToString());
        if (System.Web.HttpContext.Current.Request.Form[Name] != null)
            return (System.Web.HttpContext.Current.Request.Form[Name]);
        if (System.Web.HttpContext.Current.Request.QueryString[Name] != null)
            return (System.Web.HttpContext.Current.Request.QueryString[Name]);
        return (null);
    }

    public static void CanAccess(string SPName)
    {
        // use your own rules to determine if this user can access this SP, take appropriate action if not (like redirect to a different page)
        bool AccessAllowed = true;

        if (AccessAllowed == false)
        {
            DBSwitcher.Disconnect();
            System.Web.HttpContext.Current.Response.Redirect("AccessNtAllowed.aspx");
            System.Web.HttpContext.Current.Response.End();
        }
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior)
Canada Canada
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions