Crystal Reports VsS 2008

Question

0.00/5 (No votes)

See more:

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.

Posted 2-Jun-12 10:17am

Andrew Alix

Add a Solution

4 solutions

Solution 2

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[^]

Posted 3-Jun-12 19:31pm

Prasad_Kulkarni

Comments

Andrew Alix 4-Jun-12 20:13pm

Done all of the above already. The sql query I use displays correctly in a datagriview with the proper date. See my comment in Solution 1 and the code in solution 3 that clarifies the problem and the work around I used. This didn't solve the problem. It just worked around it. Thanks for you help though.

Solution 1

Please check SQL Query which will show results.
For example

SQL

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

SQL

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

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

Posted 3-Jun-12 19:12pm

Suresh Shewale

Updated 3-Jun-12 19:17pm

v2

Comments

Andrew Alix 4-Jun-12 20:14pm

Using your example, I group by dt_loss. The date from the database is for ex. #05/28/12#, but displays on the form as #05/27/12#.

Using the same query for a datagriview, it displays the date correctly as #05/28/12#, not #05/27/12# as the form shows.

There is a work around that I have found. See the code in my answer in solution 3.
Thanks for your reply.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raimis9 · Accepted Answer · 2012-06-05T03:23:00

Solution 4

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.

Posted 5-Jun-12 3:23am

Raimis9

Comments

Andrew Alix 6-Jun-12 13:20pm

Thank you. It worked perfect. That was irritatingly simple. It seems that you have to jump through a lot of simple hoops to get Crystal reports to work the way it should. FoxPro reports were a lot more simplified and versatile.

Andrew Alix · Accepted Answer · 2012-06-04T14:35:00

VB

Private Sub Form1_Load(ByVal sender As System.Object, _
                       ByVal e As System.EventArgs) Handles MyBase.Load

' The following works perfectly. The only problem is that CrystalReportViewer1
'     uses a Group #1 Name (Group on schDate) yet it displays one day less 
'     than what is actually in the database. Ex. #May 28, 2012# displays as
'     #May 27, 2012#
'
'     Displaying Group #1 Name (schDate) and the schDate field beside one another
'     on the report, I get #May 27, 2012#, and #May 28, 2012# in each field
'     respectively. The solution was simple. Delete the Group #1 Name from the 
'     report and use schDate field in its place. The report still groups by
'     Group #1 Name but doesn't display it.

' Would still like to know why it does this though

        Dim db As TM_SchoolDataContext = New TM_SchoolDataContext
        Dim ds As New ReportDataSet 'the report I created

        Dim t As DataTable = ds.TmsSchedule 'Data table 1
        Dim s As DataTable = ds.School      'Data table 2 
        Dim sc = From tms In db.TmsSchedules _
                 Join sch In db.Schools On sch.SchoolDate Equals tms.schDate _
                 Where tms.schDate >= firstDate And tms.schDate <= lastDate _
                 Select tms.schDate, tms.schHlights, tms.schT1, tms.schT2, _
                        tms.schT3, tms.TMSReview, _
                        sch.SchoolDate, sch.HLights, sch.T1, sch.T2, sch.T3

        Dim r As DataRow
        Dim rs As DataRow

        For Each dr In sc
            r = t.NewRow()    'Start a new DataRow in ds.TmsSchedule
            r("schDate") = dr.schDate
            r("schHLights") = dr.schHlights
            r("schT1") = dr.schT1
            r("schT2") = dr.schT2
            r("schT3") = dr.schT3
            r("TmsReview") = dr.TMSReview

            rs = s.NewRow()
            rs("SchoolDate") = dr.SchoolDate
            rs("HLights") = dr.HLights
            rs("T1") = dr.T1
            rs("T2") = dr.T2
            rs("T3") = dr.T3
            t.Rows.Add(r)
            s.Rows.Add(rs)
        Next

        Dim objRpt As New rptSchoolReport
        objRpt.SetDataSource(ds)
        CrystalReportViewer1.ReportSource = objRpt
        CrystalReportViewer1.Refresh()
    End Sub

Crystal Reports VsS 2008

4 solutions

Solution 2

Solution 4

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us