Crystal Reports in ASP.NET

[tedmanowar]

Hello,

I am trying to add some reporting features to a quite large asp.net web application. I have created a webform that contains a few fields for filtering data to be displayed in a Crystal Report.

I have created a sample report that has a few parameters but I cannot get any data returned to me if those parameters don't have values.

Is there a way for Crystal Reports to ignore parameters that don't have a value specified?

Or alternatively, is there a way to just change the set of data (maybe with the use of a System.DataSet) that the report displays at run-time?

This is the code that i am using in order to pass the parameter values. If there is no value specified I use a different report that doesn't expect parameters simply because I get an error if I don't...

CrystalReportVi ewer1.Parameter FieldInfo.Clear ();
if (docNumTxt.Text .Trim().Length > 0)
{
CrystalReportVi ewer1.ReportSou rce = Server.MapPath( "ReportWithPara m.rpt");
ParameterFields ParamFields = CrystalReportVi ewer1.Parameter FieldInfo;
ParameterField p_docID = new ParameterField( );
p_docID.Name = "p_DOC";
ParameterDiscre teValue p_docID_Value = new ParameterDiscre teValue();
p_docID_Value.V alue = docNumTxt.Text;
p_docID.Current Values.Add(p_do cID_Value);
ParamFields.Add (p_docID);
}
else
{
CrystalReportVi ewer1.ReportSou rce = Server.MapPath( "ReportWithoutP aram.rpt");
}

Thanks in advance, I know my knowledge on the subject is sub-standard however I have a very important deadline coming up and I really need some help.

TedManowar

[tedmanowar]

Hello again,


I believe that I have solved all my problems with Crystal Reports with a pretty easy solution. Instead of creating parameters for the reports i simply change the report query (using CR syntax) on runtime depending on what the user has filled in.

This is the code which I recommend to anyone that wants to filter the report data. It is the easiest way...

CrystalReportVi ewer1.Parameter FieldInfo.Clear ();

CrystalReportVi ewer1.ReportSou rce = Server.MapPath( "DocumentReport .rpt");

if (docNumTxt.Text .Trim().Length > 0)

{

CrystalReportVi ewer1.Selection Formula = "{DOCUMENT. DOC} = " + docNumTxt.Text. Trim() + "";

}

CrystalReportVi ewer1.RefreshRe port();

TedManowar



PS: Crystal Reports are by far the most frustrating reporting tool that I have ever used... I have learned other reporting tools for .NET e.g. telerik Reporting, within minutes...