Click here to Skip to main content
Click here to Skip to main content

Programmatically Pass Parameters into Crystal Reports from ASP.NET (C#) - Part 2

, 25 Feb 2010
Rate this:
Please Sign up or sign in to vote.
How to programmatically pass parameters into Crystal Reports from ASP.NET, using C# - Part 2.

Introduction

This is the second part of my article: Programmatically Pass Parameters into Crystal Reports from ASP.NET (C#) - Part 1.

Using the code

We use the filters variable which is declared as a ParamType class:

public class FilterType
{
  public const string DateTime = "DateTime";
  public const string MultiSelect = "MultiSelect";
  public const string String = "String";
  public FilterType()
  { 
  }
}

public class ParamType
{
  private TextBox[] datetimeFilters = new TextBox[100];
  private xMilk.DropCheck[] multiselectFilters = new xMilk.DropCheck[100];
  private TextBox[] stringFilters = new TextBox[100];
  public string[] filterType = new string[100];
  private int index = -1;
  public ParamType()
  { 
  }
  public void AddDateTimeFilter(TextBox myTextBox)
  {
    index += 1;
    filterType[index] = FilterType.DateTime;
    datetimeFilters[index] = myTextBox;
  }
  public void AddMultiSelectFilter(xMilk.DropCheck myDropCheck)
  {
    index += 1;
    filterType[index] = FilterType.MultiSelect;
    multiselectFilters[index] = myDropCheck;
  }
  public void AddStringFilter(TextBox myTextBox)
  {
    index += 1;
    filterType[index] = FilterType.String;
    stringFilters[index] = myTextBox;
  }
  public string GetParamTextByIndex(int i)
  {
    string returnText = "";
    switch (filterType[i])
    {
      case FilterType.DateTime:
        returnText = datetimeFilters[i].Text;
        break;
      case FilterType.MultiSelect:
        returnText = multiselectFilters[i].Text;
        break;
      case FilterType.String:
        returnText = stringFilters[i].Text;
        break;
    }
    return returnText;
  }
  public string GetParamTypeByIndex(int i)
  {
    return filterType[i];
  }
}

Snapshots

launch.jpg

filters.jpg

In this sample, when the user clicks on report1 which uses four parameters (two DateTime, and two multiselect type), the ReportView.aspx page will be dynamically created. The datetime picker has a simple client-side JavaScript which was added as an attribute in the AddDateTimeFilter() method. The multiselect filters use a special DropCheck webcontrol which is not a standard built-in webcontrol, but can be downloaded as a DLL.

Summary

There is a known small bug in this sample and I'm hoping to get an answer here. The bug: when you click on report1, everything goes fine, but after that, if you click on report2, the ReportView.aspx page does not refresh. The second report has only three parameters, but the first report's parameters are coming in again, and this is really annoying.

I hope you found this article useful, and if you have any questions, please let me know.

License

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

About the Author

Mihaly Sogorka
Website Administrator
Hungary Hungary
Working with Microsoft Dynamics NAV since 2007.

Comments and Discussions

 
GeneralPublishing OK, but JScript doesn't appear to run PinmemberMember 173821517-May-10 16:18 
GeneralRe: Publishing OK, but JScript doesn't appear to run PinmemberMihaly Sogorka17-May-10 21:26 
GeneralRe: Publishing OK, but JScript doesn't appear to run [modified] PinmemberMihaly Sogorka17-May-10 21:54 
GeneralPublishing Woes PinmemberMember 173821516-May-10 18:57 
GeneralRe: Publishing Woes PinmemberMihaly Sogorka16-May-10 21:42 
GeneralDTP closer PinmemberMember 173821516-May-10 15:55 
GeneralRe: DTP closer PinmemberMihaly Sogorka16-May-10 21:47 
Generalcalendarsetup Application setting PinmemberMember 173821513-May-10 15:02 
GeneralRe: calendarsetup Application setting [modified] PinmemberMihaly Sogorka13-May-10 22:02 
GeneralMy vote of 1 PinmvpDave Kreskowiak26-Feb-10 1:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 26 Feb 2010
Article Copyright 2010 by Mihaly Sogorka
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid