Crystal Report With Error: A Number Range Is Required Here

Dec 29, 2010

I am using the crystal report, in that i am using code like below to show the SQL data into the crystal report,

string req = "{View_EODPumpTest.ROId} IN " + str + " AND " + "({View_EODPumpTest.RecordCreatedDate}>=date(" + fromDate.Year + " , " + fromDate.Month + " , " + fromDate.Day + ")" + "AND" + "{View_EODPumpTest.RecordCreatedDate}<=date(" + toDate.Year + " , " + toDate.Month + " ," + toDate.Day + " ))";
ReportDocument rep = new ReportDocument();
rep.Load(Server.MapPath("PumpTestReport.rpt"));
DateTime fromDate = DateTime.Parse(Request.QueryString["fDate"].ToString());
DateTime toDate = DateTime.Parse(Request.QueryString["tDate"].ToString());
CrystalReportViewer_PumpTest.ReportSource = rep;
//CrystalReportViewer1.SelectionFormula = str;
rep.RecordSelectionFormula = str;
CrystalDecisions.CrystalReports.Engine.TextObject from = ((CrystalDecisions.CrystalReports.Engine.TextObject)rep.ReportDefinition.ReportObjects["txtFrom"]);
from.Text = fromDate.ToShortDateString();
CrystalDecisions.CrystalReports.Engine.TextObject to = ((CrystalDecisions.CrystalReports.Engine.TextObject)rep.ReportDefinition.ReportObjects["txtTO"]);
to.Text = toDate.ToShortDateString();
//Session["Repo"] = rep;
CrystalReportViewer_PumpTest.RefreshReport();

after running my application it executes fine with no exception but such error i am getting, A number range is required here. Error in File

C:DOCUME~1DelmonLOCALS~1TempPumpTestReport {14E557A7-51B3-4791-9C78-B6FBAFFBD87C}.rpt: Error in formula . '{View_EODPumpTest.ROId} IN ['15739410','13465410'] AND ({View_EODPumpTest.RecordCreatedDate}>=date(2010 , 12 , 1)AND{View_EODPumpTest.RecordCreatedDate}<=date(2010 , 12 ,25 ))' A number range is required here. error.

View 1 Replies


Similar Messages:

Crystal Reports :: Error In Crystal Report When Using Windows Server 2008 R2 And IIS7?

May 29, 2010

Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off". Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL. ----------------------------------- This error will be display when I am try to show the Crystal Report. Can anybody tell me what Property I have to ser in Windows Server 2008 R2 or in IIS7???

View 1 Replies

Crystal Reports :: Error In Crystal Report For Load File Or Assembly?

Mar 19, 2011

i upload my site on server but there is error in crystal report web.comfig there is error as belowParser Error Message:Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

[Code]....

View 2 Replies

Crystal Reports :: Error Displayed When Printing Crystal Report Using ActiveX

Aug 9, 2010

ent system (Windows 7 x64) and live system (Server 2008 x64), and both with IIS7 I receive the following error message, after clicking the "Print" button in the printer selection popup."An error occurred on the server. Printing will be stopped. Would you like to view the error information?"If I click "y

View 1 Replies

Crystal Reports :: Migrate Vs2005 To Vs2010 Having Error Of Incorrect Crystal Report References

Apr 2, 2011

We have migrate from VS2005 to VS2010. CR2010 installed too.

We have 1 website and class project in one solution.

The assembly of web.config has point to new version of CR ver13 and also checked that the references is ver13 too.

WEB CONFIG:

[code]....

However in code behind, when "Go To Definition" the imported CrystalDesicions Namespace, it go to CR version10 location.

The class project has references to correct ver13.

In the end we get error of :

Error 17 The project currently contains references to more than one version of CrystalDecisions.CrystalReports.Engine, a direct reference to version 10.2.3600.0 and an indirect reference (through 'Web_cl.clsAccountRpt.GetAccountStatementSummaryRptDoc')
to version 13.0.2000.0. Change the direct reference to use version 13.0.2000.0 (or higher) of CrystalDecisions.CrystalReports.Engine. D:ProjectWebGlobal 4.0Web_developCpAdminReportFormAccountReportModule.aspx.vb 40 28 D:...Web_develop

The function in class has return ReportObject back to the website, because of the website reference did not really point to new version has causes this error. I have checked all references in web.config and project properties all is point to new version, but in program it seems still point to old one.

View 5 Replies

Crystal Reports :: How To Pass Date Range From Text Box To Crystal Date Range Parameter

Sep 25, 2010

I has developed a crystal report, which display the records from a table and filters them based on a parameter( date range parameter). now I has integrated the report into a asp.net page using c#, but when I am running the asp page it is not promption for the date range values, it used to prompt for date range when I run the report in crystal report.

View 2 Replies

When Run Crystal Report Get Error, Requested Report Requires Further Information

Feb 1, 2010

when i run the crystal report , there is message "The report you requested requires further information."For dataset , it requires username and passwordI cannot login the report page.....

View 9 Replies

Crystal Reports :: Crystal Report Login Error?

Feb 26, 2011

I have recently tried to develope a crystal report using a clss file, like passing the class variable into report file. Passing the values and displaying was successful but when i click on the printer button or Export button in Crystal report viewer in my Aspx page, It is asking for Database name,Suser id and password for the Class file and which i never assigned and no there is no database to the class ... It is not allowing me to take the print out of the page..

View 6 Replies

Getting An Error When Trying To Generate Report Through Crystal Report ?

Dec 2, 2010

some i am getting a error when trying to generate report through crystal report.the error is

--------------
Error Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

Error System.IO.FileNotFoundException: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

File name: 'CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' ---> System.IO.FileNotFoundException: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0,
Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

File name: 'CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'

WRN: Assembly binding logging is turned OFF.To enable assembly bind failure logging, set the registry value [HKLMSoftwareMicrosoftFusion!EnableLog] (DWORD) to 1.

Note: There is some performance penalty associated with assembly bind failure logging.To turn this feature off, remove the registry value [HKLMSoftwareMicrosoftFusion!EnableLog].

at EOD_Schedular.frmMain.GenerateReport(Boolean ViewOnly)
at EOD_Schedular.frmMain.Generate(Boolean ViewOnly)


Method Name: GenerateReport
Line: 0
Column: 0
Sql: Not Found

View 2 Replies

Check The Range And Number Of Records In That Range Without Using Cursor?

Jan 13, 2010

I have a table "RANGES" with the following columns

LowRange as int
HighRange as int
with the data similar to below
select * from Ranges
LowRange HighRange
1 100
101 200
201 300
.
.
.
901 1000

And another table "infoDetails" with the following columns

Range as INT
amount as money
with the data similar to below
select * from infoDetails
Range Amount
23 34.00
235 44.00
345 34.00
678 100.00
555 100.00
530 100.00
510 100.00
I need one report with the following format without cursor.
LowRange HighRange Count Amount
1 100 1 34.00
101 200 0 0.00
.
.
501 600 3 300.00
601 700 1 100.00

View 1 Replies

Crystal Reports :: Getting Error"Invalid Report File Path" When Binding A Report

Mar 2, 2010

Have an asp application and getting: "Invalid Report File Path" when binding a DataSet.

[Code]....

View 2 Replies

Error On Server When Trying To Show Crystal Report " Access To Report File Denied"

Sep 17, 2010

I am getting below error while generating report using crystal report:

Error in File C:WindowsTEMP
epEnquiry {095737EB-07B4-437D-9E86-85780B7417B0}.rpt:
Access to report file denied. Another program may be using it.

For this i did google and found some solutions but still its not working:
what i tried:
-given full access to aspnet and network services on my root directory and reports folder and then restarted iis.

OS:windows server 2008(64)
vs2008 application.

but still getting same error.

View 1 Replies

Crystal Reports :: Error VS2010 / An Error Occurred During Local Report Processing

Aug 16, 2010

i write a site and get this error, i using VS2010.

An error occurred during local report processing.

The definition of the report 'ModulesReport1.rdlc' is invalid.

An unexpected error occurred in Report Processing.

Could not load file or assembly 'Microsoft.ReportViewer.ProcessingObjectModel, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

i try run on my machine its all work fine, but when i complier and run it on Window server 2008 get this error.

I read [URL] I install the ReportViewer.exe but still cannot find the Microsoft.ReportViewer.ProcessingObjectModel.dll, however I got find it Microsoft.ReportViewer.ProcessingObjectModel in C:Windowsassembly and is not a dll file.

View 1 Replies

Crystal Reports :: An Error Occurred During The Processing Of A Configuration File Required To Service This Request

Apr 1, 2010

I am create a simple report in visual studio 2008 by using crystal report. when I am run locally its work fine but when i copy web site and run this report its show following error.

Server Error in '/xyz' Application.

Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. review the specific error details below and modify your configuration file appropriately. Parser Error Message: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

Source Error:

[Code]....

[Code]....

View 3 Replies

Crystal Reports :: An Error Occurred During The Processing Of A Configuration File Required To Service This Request

Jun 24, 2010

I have a ASP Web App that has been fine when deployed but now I've introduced Crystal Reports to it and is fine when testing.

On my Web Setup Project Ive right clicked, Add, Assembly and included:-

CrystalDecisions.Reportsource.dll

CrystalDecisions.Shared.dll

CrystalDecisions.web.dll

Ive run the setup on an pc away from the development environment but when connecting I get:-

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

Source Error:
[Code]....

Source File: C:inetpubwwwrootMala_Ordersweb.config Line: 52 Assembly Load Trace: The following information can be helpful to determine why the assembly 'CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' could not be loaded.

[Code]....

View 1 Replies

Crystal Report Error In Web Application?

Jan 27, 2010

I have used crystal Report in my asp.net application .but when i installed this application in another machine then it will give,error like this :

The type 'CrystalDecisions.Web.CrystalReportViewer' exists in both 'c:WINDOWSassemblyGACCrystalDecisions.Web9.1.5000.0__692fbea5521e1304CrystalDecisions.Web.dll' and 'c:WINDOWSassemblyGAC_MSILCrystalDecisions.Web10.2.3600.0__692fbea5521e1304CrystalDecisions.We b.dll'
[code].....

View 8 Replies

Not Able To Take Print From Crystal Report - Getting An Error?

Apr 7, 2010

I have bind crystal report using crystal report viewer in my asp.net page

We are using secure site https, & when we click on export or print button from crystal report toolbar, it opens a window for pages selection option, In any options from pdf, word or crystal report, i choose and select All & click Ok nothing happens. just ok button gets disable, sometimes shows error

"Internet explorer can not donwload page from site

Internet Explorer was not able to open this Internet site, The requested site is either unavaliable or cannot be found. Please try again later"

View 3 Replies

Crystal Report Error In Web.Config File?

Jan 26, 2011

I have a project in asp.net 2, and I use Crystal Reports in this project.when I run project in visual studio it works fine... but when I want to install my project in windows server IIS 6.0 the page return this error:escription: An error occurred during the processing of a configuration file required to service this
request. Please review the specific error details below and modify your configuration fileppropriately. Parser Error Message: Could not load file or assembly 'CrystalDecisions.Web, ersion=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies The system cannot find the file specified.

[Code]....

View 2 Replies

VS 2005 - Crystal Report Toolbar Error

Jul 7, 2011

I am having this problem in the production server regarding crystal report toolbar.

All images in production server were crossed out and its functions not also working.

View 3 Replies

Crystal Reports :: Error 43 - The Report Definition Is Not Valid

Apr 27, 2016

Error 43  The report definition is not valid. 

Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded.    
C:UsersUserDocumentsVisual Studio 2010WebSitesWebSite4CpanelReportspay.rdlc    1  

View 1 Replies

Crystal Reports :: Paging Error - No Valid Report Source Is Available?

Aug 14, 2013

i have a load report on asp page

i have load report on button click

but when i click on next navigation button 

then it gives me error with popup

"No valid report source is available."

my code is:

protected void Button1_Click(object sender, EventArgs e) { GetData();
}
private void GetData() {
SqlConnection connection = new SqlConnection(strcon); SqlCommand command = new SqlCommand("Select * from demoforreport WHERE role='" + TextBox1.Text + "'", connection); SqlDataAdapter adapter = new SqlDataAdapter(command); DataSet dataset = new DataSet(); adapter.Fill(dataset, "demoforreport"); ReportDocument CustomerReport = new ReportDocument(); CustomerReport.Load(Server.MapPath("CrystalReport.rpt")); CustomerReport.SetDataSource(dataset.Tables["demoforreport"]); CrystalReportViewer1.ReportSource = CustomerReport; CrystalReportViewer1.DataBind(); }

View 1 Replies

Crystal Reports :: VS2008 Crystal Reports - "Load Report Failed - Error"?

Jul 25, 2010

I'm getting the "Load Report Failed" Error.

I have a web application designed using VS2008 & Crystal Reports for VS2008 (Ver. 10.5.3700). I'm using Framework 2.0 for deployment.

My development system is WinXp and my deployment system is Win2003 Server.

Here is what i have done -

1) Added a Crystal Report to my project "rptReport.rpt"

2) Added a Crystal Report Source (crSource) to my .aspx page.

3) Added Crystal Report Viewer to my page, with crSource as its Report Source.

This works fine when i run it on my development machine. But Gives a "Load Report Failed" error on my deployment machine.
This is what i have already tried doing on deployment server:

1) Giving IIS_WPG full control to temp folder.

2) Publishing with "Allow this precompiled site to be updatable." checked/unchecked.

View 1 Replies

Web Forms :: Crystal Report Error While Deploying Website On Remote Server

Jun 22, 2012

I have deployed ASP.net WebSite on Remote Server ....

It gives the Following Error when i tested by typing URL in IE ....

(The URL is college.desiresoftech.com)

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.Source Error:

[Code] ....

WRN: Assembly binding logging is turned OFF.

To enable assembly bind failure logging, set the registry value [HKLMSoftwareMicrosoftFusion!EnableLog] (DWORD) to 1.

Note: There is some performance penalty associated with assembly bind failure logging.

To turn this feature off, remove the registry value [HKLMSoftwareMicrosoftFusion!EnableLog].

How can I solve it, i searched on net and the answer was server has no cr Runtime, install CR Runtime on server or Copy the .dll Files in Bin Folder, I downloaded the 10.5.3700.0 CR Runtime bt it is giving error when i try to install it...

View 1 Replies

Using Required And Range Validator But Not Working?

Dec 2, 2010

I have created one page where i am using Required and Range Validator and i am using java script also. But it is not working.And when i am trying only validator it is working. How should i run both the things

View 3 Replies

Web Forms :: Missing Parameter Error On Online Server For Loading Crystal Report

Oct 23, 2012

LinkButton lnkHistory = (LinkButton)sender;
int ID = Convert.ToInt32(lnkHistory.CommandArgument);
ReportDocument rp;
DataSet ds = new DataSet();
SqlConnection con = new

[Code] .....

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved