Click here to Skip to main content
15,902,299 members
Please Sign up or sign in to vote.
1.67/5 (2 votes)
See more:
there are two tables

1. mfpopulation
2. vvmaster

1. table contain->a.vid as primary key
b. vname

2. table contain-> ppl_id as primary key
b. tlplf
c. tlplm
d. tlpl
e. vdate as date time

Ihe data from crystal report is vname ,tltpl,tlplm,tlplf and vdate

I am using crystal report for make report using data betwwen two date selected by two datetime pickrs i.e datetimepicker1 and datetimepickr2

I make two parameters fromdate and todate in crystal report
the code is

C#
private void button1_Click_1(object sender, EventArgs e)
{
   // CrystalReport3 cr = new CrystalReport3();
    ReportDocument cryRpt = new ReportDocument();
    //crystalReportViewer1.ReportSource = cr;
    cryRpt.Load(@"E:\\grabone1\\grabone1\\CrystalReport3.rpt");
   TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
    TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
    ConnectionInfo crConnectionInfo = new ConnectionInfo();

    Tables CrTables;
    ParameterFieldDefinitions crParameterFieldDefinitions;
    ParameterFieldDefinition crParameterFieldDefinition;
    ParameterValues crParameterValues = new ParameterValues();
    ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();

    crParameterDiscreteValue.Value = dateTimePicker1.Text;
    crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
    crParameterFieldDefinition = crParameterFieldDefinitions["fromDate"];
    crParameterValues = crParameterFieldDefinition.CurrentValues;
    crParameterValues.Clear();
    crParameterValues.Add(crParameterDiscreteValue);
    crParameterFieldDefinition.ApplyDefaultValues(crParameterValues);
    crParameterDiscreteValue.Value = dateTimePicker2.Text;
    crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
    crParameterFieldDefinition = crParameterFieldDefinitions["toDate"];
    crParameterValues = crParameterFieldDefinition.CurrentValues;
    crParameterValues.Add(crParameterDiscreteValue);
    crParameterFieldDefinition.ApplyDefaultValues(crParameterValues);
    crConnectionInfo.ServerName = "localhost";
    crConnectionInfo.DatabaseName = "childbelfare";
    crConnectionInfo.UserID = "sa";
    crConnectionInfo.Password = "sa";

    CrTables = cryRpt.Database.Tables;
    foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
    {
        crtableLogoninfo = CrTable.LogOnInfo;
        crtableLogoninfo.ConnectionInfo = crConnectionInfo;
        CrTable.ApplyLogOnInfo(crtableLogoninfo);
    }
    crystalReportViewer1.ReportSource = cryRpt;
   crystalReportViewer1.Refresh();
}


Problem is after running the programe the cystal viewer show message "no data is loaded"
Posted
Updated 28-Jan-10 17:58pm
v4

1 solution

Are you able to verify that the query you are using to extract data into the report really gives you any data?
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900