Hi I am using Cystal Reports 2008 with Visual Studio 2008 web express and SQL server 2005. While calling crystal reports from my asp.net application I get database login prompt which I want to get rid off. Can someone help me in this. I have created file DSN and given all username pws infomation in that. My code in aspx file is as follows
protected void Page_Load(object sender, EventArgs e)
{
ArrayList arrayList = new ArrayList();
arrayList.Add(Session["BLNumber"]);
ParameterFields parameterFields = CrystalReportViewer1.ParameterFieldInfo;
SetCurrentValuesForParameterField(parameterFields, arrayList);
}
private void SetCurrentValuesForParameterField(CrystalDecisions.Shared.ParameterFields parameterFields, ArrayList arrayList)
{
ParameterValues currentParameterValues = new ParameterValues();
foreach (object submittedValue in arrayList)
{
ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue();
parameterDiscreteValue.Value = submittedValue.ToString();
currentParameterValues.Add(parameterDiscreteValue);
}
ParameterField parameterField = parameterFields[PARAMETER_FIELD_NAME];
parameterField.CurrentValues = currentParameterValues;
//DatabaseLogon_RD() ;
}