Crystal Reports VsS 2008 [英] Crystal Reports VsS 2008

问题描述

我有一个使用数据集的项目，该数据集是使用SQL查询从DataContext动态填充的.除Crystal Report之外，一切都按预期工作.

该报告完美地显示了所有数据，但日期"(这是我的组"字段)与表中存储的实际日期相差一天(-1).

我一直是FoxPro程序员，尝试切换到Visual Studio 2008，并且一直为Crystal Reports奋斗.一切都很简单，但总会有不妥之处.

I have a project using a dataset that I fill dynamically from a DataContext using a SQL query. Everything works as expected except for the Crystal Report.

The report shows all the data perfectly, but the Date (which is my group field) is off by one day (-1) than the actual date stored in the table.

I have been a FoxPro programmer trying to switch to Visual Studio 2008 and I have struggled with Crystal Reports for ever. Everything is simple but there is always SOMETHING amiss.

推荐答案

请参考:
水晶报表:Visual Studio 2008 [使用其功能组逐步创建Crystal Report，图形，交叉表和子报表 [ ^ ]
使用带有数据集的C#创建Crystal报表 [ ^ ]
使用C#的动态Crystal报表 [动态Crystal报表查看 [创建报表(如何在Visual Studio的Crystal报表中) [ ^ ]
ASP.NET中的晶体报告 [ .NET中的Crystal Reports简介 [如何在Crystal Reports中创建SQL命令 [

Please refer:
Crystal Reports: Visual Studio 2008[^]

These CP article will surely help you out:
Step by Step Creation of Crystal Report using its Features Group, Graph, Cross-Tab and Sub Report[^]
Creating Crystal Reports using C# with Datasets[^]
Dynamic Crystal Report with C#[^]
Dynamic Crystal Reports Viewing[^]

Some more links for reference:
Create a Report (How Do I in Crystal Reports for Visual Studio)[^]
Crystal Reports in ASP.NET[^]
Introductions to Crystal Reports in .NET[^]

Have a look on this video:
how to create a SQL command in Crystal Reports[^]

Andrew，打开"Group Expert"窗口，选择您的组(schDate )，然后按选项...".在常用"选项卡上，选择将打印该部分:"下的组合框，将其值设置为每天".
希望它能解决您的问题.

Andrew, open "Group Expert" window, select your group (schDate) in right panel, then press "Options..." On Common tab select combobox under the "The section will be printed:" to value "for each day."
I hope it will solve your problem.

请检查将显示结果的SQL查询.
例如

Please check SQL Query which will show results.
For example

SELECT name,id,dt_loss
  FROM [trial_Data]
  where dt_loss ='2012-03-01' and dt_loss='2012-03-06'
group by name,id,dt_loss

或

OR

SELECT  name,id,dt_loss
  FROM [trial_Data]
  where dt_loss between '2012-03-01' and '2012-03-06'
group by name,id,dt_loss

还请告诉我，您指的是某天的日期是显示错误的日期(少于实际存储在db中的日期)或显示的总数据少于一天的时间

Also Tell me that what u mean date off one day is it shows wrong date(less than actual stoted in db) or total data displayed less than one day less

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