不在水晶报表中显示数据 [英] do not appear data in crystal report

问题描述

大家好！

我的报告有一点问题，问题是我有一个
datagridview中的数据.然后我将这些信息导入到
水晶报表，但时间数据未出现在相应的列中.

让我给您看一个图像来说明这种情况:




我使用的代码是:

1)将datagridview源分配给全局数据集变量:

this.dataGridView2.DataSource = detaDs.Tables["dt"];
dataReport = new DataSet();
dataReport = detaDs;

2)单击"Imprime"按钮，然后打开带有报表对象的Windows窗体，并执行所有操作以将数据导入报表.

new TarjeteroSharp.Form3(this.dataReport).Show();

Hello everybody again!

I have a little problem with my report, the problem is that I have a
data in a datagridview. and next I import this information in to a
Crystal report but the time data do not appear in the repective column.

Let me show you a image to illustrate this case:




the code that i use is:

1) asign the datagridview source to a global dataset variable:

this.dataGridView2.DataSource = detaDs.Tables["dt"];
dataReport = new DataSet();
dataReport = detaDs;

2) Click button "Imprime" next I open a windows form with the report object and i make all operations to import the data into a report.

new TarjeteroSharp.Form3(this.dataReport).Show();

public Form3(DataSet myData)
        {
            InitializeComponent();
            myDataGlobal = myData;

            object result = TarjeteroSharp.WaitWindow.Show(this.workerMethod2);
            try { System.Console.Out.WriteLine(result.ToString()); }
            catch { System.Console.Out.WriteLine("No se puede imprimir result2"); }

            this.crystalReportViewer1.ReportSource = rpt1;
            this.crystalReportViewer1.Refresh();
            myData.Dispose();
            myDataGlobal.Dispose();

        }

        private void workerMethod2(object sender, TarjeteroSharp.WaitWindowEventArgs e)
        {
            this.showInfo2(myDataGlobal);
        }

        private void showInfo2(DataSet myData)
        {

            /*PREPARANDO LA DATA ANTES DE ASIGNARLA:*/
            myData.Tables[0].TableName = "tarjeta1";
            rpt1.SetDataSource(myData.Tables["tarjeta1"]);
        }

您可以看一下我有一个"tarjeta1"是一个data_set此数据中的列
set是datagridview中的同一列

请告诉我 rpt对象(水晶对象)是否具有属性和特征
格式化单元格以允许时间数据.因为就我而言，该数据未显示在报告中.

在此先感谢.

You can look I have a "tarjeta1" is a data_set the columns in this data
set is the same column in the datagridview

Please tell me if a rpt object (crystal object) have a properties and features
that formatting the cells to allow time data. because in my case this data dont appear in the report.

Thanks in advance.

推荐答案

尝试一下

Crystal报表中的时间转换 [ Crystal报表中的格式化日期 [

Try this

Time Conversions in Crystal Reports[^]


If it''s a Datetime field you can format that by below way
Formatting Dates in Crystal reports[^]
[/EDIT]

我找到了解决方案！!!!

问题是我没有很好地将数据集映射到ADO对象.
特别是列的名称.

例如:

I found the solution!!!

The problem was I don''t made a good mapping from the dataset to ADO object
specifically in the name of column.

for example:

sqlqwery="select vuelta,linea.linea,salida,vsalida as ver,R1,M1,AT1,AD1,R2,M2,AT2,AD2,R3,M3,AT3,AD3,R4,M4,AT4,AD4,R5,M5,AT5,AD5 from deta_tarjeta,linea where deta_tarjeta.cod_tar=''"+tarjeta.cod+"'' and deta_tarjeta.cod_lin=linea.cod order by vuelta asc"; 



conexion con = new conexion();
            detaDs = con.consulta(sqlqwery);

            this.dataGridView2.DataSource = detaDs.Tables["dt"];
            dataReport = new DataSet();
            dataReport = detaDs;


myData=dataReport;
tarjetero1 rpt1 = new tarjetero1();
myData.Tables[0].TableName = "tarjeta1";
rpt1.SetDataSource(myData.Tables["tarjeta1"]);
this.crystalReportViewer1.ReportSource = rpt1;
this.crystalReportViewer1.Refresh();
myData.Dispose();

sql查询中的名称必须与图片中显示的xsd对象相同，然后有一个良好的映射，数据就会出现在报告中.

感谢您的关注.

问候，

Leo

the names in the sql query must be same than the xsd object showing in the picture, then there are a good mapping and the data is appear in the report.

thanks for your atention.

Regards,

Leo

我只是怀疑这可能是报表中日期字段的列大小.您可以增加宽度并查看是否可行吗?

I just suspect it might be the column size of the date field in report. Can you increase the width and see if it works?

这篇关于不在水晶报表中显示数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！