资料栏位 [英] Data fields

问题描述

嗨 我有一个应用程序，它通过C#应用程序使用Crystal Reports编写许多报告，并生成一个pdf文档作为输出.我正在尝试添加新报告.报告的数据来自一系列的csv文件.

我已在详细信息部分的字段中添加了内容，但是报告误解了某些字段的数据类型.它以地址为数字，时间字段为数字，数字为字符串.

如何手动更正字段类型.我在任何菜单或属性窗口中都找不到任何选项.我不敢相信此选项在某处不可用.

感谢

Hi I have an application that writes a number of reports using Crystal Reports through a C# application and produces a pdf document as the output. I''m trying to add a new report. The data for the reports comes from a series of csv files.

I''ve added in the fields in the details section, however the report has misinterpreted the data types of some of the fields. It''s taken an address as a number, a time field as a number and a number as a string.

How can I manually correct the field type. I can''t find any option in any of the menus or property windows. I can''t believe this option isn''t available somewhere.

Thanks

推荐答案

Crystal Reports尝试将DataSchema保留在Typed DataSets(.xsd文件)中.您可以打开XSD文件并更改数据类型.

Crystal Reports tries to keep DataSchema in Typed DataSets (.xsd files). You open XSD files and change the data types.

Crystal报表将数据模式保存在XSD中，通常在同一文件夹中.

我知道可以肯定的一种方法是:
1.您可以将数据从CSV加载到DataSet(有关CSV文件的connectionString，请参阅connectionStrings.com).
2.然后在数据集上导出模式以获得模式.
3.将架构更新为XSD文件中的数据类型.
4.在报表中使用XSD作为数据定义.请参阅 http://www.c-sharpcorner.com/UploadFile/rsubhajit/CrystalReportwithDataSet03012006060655AM/CaspalReportwithDataSet. [ ^ ]有关如何使用XSD开发报告的信息.

A Crystal report keeps Schema of data in XSD, Usually in same folder.

An approach which i know works for sure is that:
1. you can load the data from CSV to DataSet (see connectionStrings.com for connectionString for CSV files).
2. Then do export schema on dataset to get schema.
3. Update the schema to your data types in XSD file.
4. Use XSD as data definition in your reports. See http://www.c-sharpcorner.com/UploadFile/rsubhajit/CrystalReportwithDataSet03012006060655AM/CrystalReportwithDataSet.aspx[^] on how to develop reports using XSD.

感谢

(找不到如何回答第一个答案)

您是在说Crystal Reports在内部将所有内容都保留为xml吗?即原始的CSV文件翻译成XML? xsd文件存储在哪里，我找不到任何地方?

Thanks

(can''t find how to reply to first answer)

Are you saying that Crystal Reports internally keeps everything as xml? ie the original csv file is translated into xml? Where is the xsd file stored, I can''t find one anywhere?

这篇关于资料栏位的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！