using a connection string in web.config for crystal report
- by zombiegx
I`m having problems between two servers, wich use differente odbc dsn.
My apps work great but crystal reports uses the original odbc connection, how can I fix this?
I'm thinking of using the same connection string in the web.config, but I don't know how.
found this but is too confusing for me
this is an example of my code, its a aspx file that loads as a pdf
protected void Page_Load(object sender, EventArgs e)
{
try
{
var par = Request.QueryString;
int pidmun = 0;
if (!string.IsNullOrEmpty(Request["id"]))
{
pidmun = int.Parse(Request["id"]);
}
string pFechaIni = Request["fi"];
string pFechaFin = Request["ff"];
string pTipo = Request["t"];
string pNombreMunicipio = Request["nm"];
var pos = Request.Form;
if (string.IsNullOrEmpty(pFechaIni))
{
pFechaIni = "01/01/2010";
}
if (string.IsNullOrEmpty(pFechaFin))
{
pFechaFin = "01/01/2010";
}
if (string.IsNullOrEmpty(pTipo))
{
pTipo = "FOLIO";
}
if (string.IsNullOrEmpty(pNombreMunicipio))
{
pNombreMunicipio = "NombreMunicipio";
}
ReporteIngresos report = new ReporteIngresos();
TextObject nom;
TextObject periodo;
nom = (TextObject)report.ReportDefinition.ReportObjects["TxtNombreMunicipio"];
periodo = (TextObject)report.ReportDefinition.ReportObjects["TxtPeriodo"];
nom.Text = "Ingresos Municipio de " + pNombreMunicipio;
periodo.Text = "Periodo del " + pFechaIni + " al " + pFechaFin;
report.SetParameterValue("pidMun", pidmun);
report.SetParameterValue("pFechaIni", pFechaIni);
report.SetParameterValue("pFechaFin", pFechaFin);
report.SetParameterValue("pTipo", pTipo);
MemoryStream oStream;
oStream = (MemoryStream)report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
Response.Clear();
Response.Buffer = true;
Response.AddHeader("CustomHeader", "ReporteIngresos");
Response.CacheControl = "No-cache";
Response.ContentType = "application/pdf";
Response.BinaryWrite(oStream.ToArray());
Response.End();
}
catch (Exception ex)
{
ExBi.log(ex);
throw ex;
}
}
thanks.