Skip to Content
0
Former Member
May 02, 2016 at 12:36 PM

Error while export report with subreports to PDF (NET 4.0, C#) - Database Vendor Code: 201

338 Views

Here is my code

bool exportToPdf(int id)
        {
            var rdoc = new ReportDocument();
            ParameterFieldDefinitions parmFields = rdoc.DataDefinition.ParameterFields;
            int idx = 0;
            try
            {
                rdoc.Load(HostingEnvironment.MapPath(string.Format("~/App_Data/Reports/{0}", "Rep1.rpt")));
                rdoc.SetDatabaseLogon("sa", "SA PASS", "127.0.0.1", "TestTb", true); 
                foreach (ParameterFieldDefinition def in parmFields)
                {
                    if (!def.IsLinked())
                    {                        
                        switch (def.ValueType)
                        {
                            case FieldValueType.StringField:
                                rdoc.SetParameterValue(idx, "");
                                break;

                            case FieldValueType.NumberField:
                                rdoc.SetParameterValue(idx, 0);
                                break;

                            default:
                                rdoc.SetParameterValue(idx, null);
                                break;
                        }

                    }
                    idx++;
                }
                rdoc.SetParameterValue(0, id);
                rdoc.ExportToDisk(ExportFormatType.PortableDocFormat, "D:\\report_" + id.ToString() + ".pdf");
                return true;
            }
            catch (Exception ex)
            {
                Console.Write(ex.Message);
                return false;
            }
        }

On method ExportDoDisk i get error:

Failed to retrieve data from the database. Cannot export report. Error in file Rep1.rpt. Details: Database Vendor Code: 201

(in Polish: pobranie danych z bazy danych nie powiodło się.\rNie można wyeksportować raportu.\n\rBłąd w pliku Rep1.rpt. Pobranie danych z bazy danych nie powiodło się.\nSzczegóły: [Kod dostawcy bazy danych: 201).

If I preview report in Crystal report designer, there is no problems to generate report.

Crystal lib: 13.0.2000.0

Please help.