0

check ur parameter names in code and in crystal report....it shud be the same.....

fromdate
todate

also check the dateformat in SQL database the date datatype saves in yyyy-MM-dd format.....

make use of date format only in SQL database and when creating a parameter use a string...it worked for me....

Edited by poojavb

0

Poojavb:
Ok The problem is :
1]Its not showing any report if I click on Button. The button is where all the above codings are done.
2]So,I connected Crystal Report to Crystal Report Viewer i.e. the connection is done through the small arrow we can see on the crystal report viewer.
3] I run the form and both the form and the Crystal Report pops up.
Crystal Report directly asks to choose the frmdate and todate and after choosing it does'n show any result,it closes that box.
4] On the form,Where the 2 datetimepickers and button and crystal report viewer are shown:
Here after clicking on button there is no result.

0
<?php echo "hai"?>



<html>
sdfs
</html>



Imports System.Data.SqlClient
Imports CrystalDecisions.Shared
Imports CrystalDecisions.CrystalReports.Engine
Public Class dani

Edited by Bhuvanes144: jst modifyed

0

you had said that u

connected Crystal Report to Crystal Report Viewer i.e. the connection is done through the small arrow we can see on the crystal report viewer.

actually that is not needed....

in ur rpt files.....there are two tabs....below....

  1. Main Report Preview
  2. Main Report....

Check whether u r able to get the report in ur Preview window....if yes means crystal report is correct and ur vb.net coding is wrong....

0

Ok its stil not working.
Poojavb
I just thoguht to ask u for confirm ,the fromdate and todate in crystal report should be discrete values or multiple values or range values?

0

from date and two date will be the two parameters in crystal reports in which ur crystal report will show the data in that range.....

0

Poojavb I know that will show the dates range.
While creating parameter and its datatypes in crystal report there will be 3 options discrete values ,range value,all multiple values.
I tried with all options but none showed the expecting result.

0

You dont have to make any changes there...

while creating parameters....just enter the parameter name and the datatype type...and nothing....

Still in the Value options if you want the values
Allow discrete values - > True
allow range value -> false
allow multiple values ->false

0

Ok I had used only discrete values too but it din't work out

0

Hello
i've developed a desktop database application and i've created several reports. i view the reports on a crystalreportviewer embedded on a different form. viewing the reports and exporting works fine in the vb2010. but when i deploy the application and click on the export button on the crystalreportviewer i get an error saying
method not found:
'CrystalDecisions.ReportAppServer.DataDefModel.PropertyBag
CrystalDecisions.ReportAppServer.ReportDefModel.ISCRExportOptions.get_ExportOptionsEx()'

am using
Crystal Report for Visual Studio 2010
VB2010 target framework = .NET Framework 4
Windows 8.1 64bit
MS Access 2013

Please help ASAP.
Thanks

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.