Crystal report returns no result data

Question

Hi,

When running the crystal report I get no data. I see this error when debugging:
Referenced assembly 'C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.ReportingServices.Interfaces.dll' targets a different processor than the application.

Could anybody help me please?
Thanks.

Nel · Answer

I solved the problem. Create a new report, new dataset and now everything is ok:)

Nel · Answer

And here is my code: string brdok = this.textBox2.Text; SqlConnection connection = null; ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["Blagajna_JSPTURS.Properties.Settings.blagajna_jspturs"]; if (settings != null) { string ConnectionString = settings.ConnectionString; connection = new SqlConnection(ConnectionString); } alatkiDAC dac = new alatkiDAC(); SqlCommand command=new SqlCommand(); command.Connection = dac.GetConnection(); string comstring1 = "SELECT Valuta.id, Valuta.Valuta, Vidpodatok.idpod, Vidpodatok.vp,blagajna_jspturs.brdok,blagajna_jspturs.data, blagajna_jspturs.datafra,blagajna_jspturs.vp,blagajna_jspturs.Imeprezime, blagajna_jspturs.Iznos, blagajna_jspturs.valutaid, blagajna_jspturs.valutakurs, blagajna_jspturs.iznosden, blagajna_jspturs.br_fra, blagajna_jspturs.br_fra, blagajna_jspturs.br_patna_ska, blagajna_jspturs.osnov, blagajna_jspturs.br_kas_izvod from Valuta, Vidpodatok, blagajna_jspturs where blagajna_jspturs.brdok=@brdok"; command.CommandText = comstring1; command.Parameters.AddWithValue("@brdok", textBox2.Text); BlagajnaDataSet dataSet2=new BlagajnaDataSet(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(); dataSet2.Clear(); sqlDataAdapter.SelectCommand = command; sqlDataAdapter.Fill(dataSet2); ReportDocument Rpt = new ReportDocument(); Rpt.Load(@"the path \CrystalReport7.rpt"); Rpt.SetDataSource(dataSet2); crystalReportViewer2.ReportSource = Rpt; Rpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait; crystalReportViewer2.Refresh();

Nel · Answer

Thanks Murali, I changed the CPU but still the problem exists:(. I still can not retrieve data from the database in the crystal report. It gives only the first row with the head row, but no data after that. All the fields in the report are empty.

Muralidharan Deenathayalan · Answer

Try to change the target of your application and try it once. To set the Target CPU property With a project selected in Solution Explorer, on the Project menu, click Properties. Click the Compile tab. Click the Advanced Compile Options button to open the Advanced Compiler Settings dialog box. Choose a CPU type from the Target CPU drop-down list, and then click OK. Refer : http://stackoverflow.com/questions/3244464/how-to-solve-warning-referenced-assembly-targets-a-different-processor-than-the Hope this helps you.

Crystal report returns no result data

Answers (4)