Crystal Report : Report Is Not Being Able To Connect To The Database As Assigned.
Mar 9, 2011
We have deployed our ASP.NET application on the target machine. The application contains some crystal reports (rpt files) and while invoking we pass on the database connection details. It is working fine on the test server. But on the target server, the crystal report while being invoked asks for the database connection details. It asks four parameters as Server, database, user id, password. Out of these, the first two text boxes are disabled. The Server editbox shows the ip of the server that I passed. But the database parameter is shown blank. I was expecting the initial catalog that I set in the connection string. user id is showing the user id I passed.
The config file has the connection string like:
[code]....
View 1 Replies
Similar Messages:
Jun 8, 2012
in my web Application, i have set the Connection String in Class as Follows :
public
class
clsConnection
{
publicSqlConnection con = newSqlConnection(@"server=desire5SQLEXPRESS;uid=sa;pwd=desire;database=DesireSchool ;"
);
}
Now i want to use this Connection String for Crystal Report,i have tried by using Object of this classHow can i Use this Connection String For Crystal Report .
View 1 Replies
May 22, 2010
how to connect asp.net Crystal report with mysql database. like sql server database connection .is there any connector available to do this..
View 1 Replies
Sep 4, 2010
i have adynamic dataset wuch i create and not from sql or access table.i have acrystalreport and i want to connect the report to the dataset
View 1 Replies
Jul 23, 2010
I got a code from internet for creating Crystal reports in Visual studio 2008 .net. It shows on how to pass parameters from web form to Crystal reports. Everything is ok, except the report crystal report viewer. How can I declare and assign report crystal report viewer manually in Visual studio .net?.
[Code]....
View 9 Replies
Feb 24, 2014
Is it possible to show 3 "Crystal Report" in single "Report Viewer Control" page??My current code for 1 Crystal Report and 1 Report Viewer control Page is below:Below code Page name is "JpsCrystalReport.aspx"
using CrystalDecisions.CrystalReports.Engine; //for crystal report
using CrystalDecisions.ReportSource;
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConnectionString"].ConnectionString);
[code]...
I want that when i click on button it redirects to "JpsCrystalReport.aspx" page as per condition given. Then on "JpsCrystalReport.aspx" page it should execute the 3 crystal reports as per conditions given on button click.Or I had to create 3 different "JpsCrystalReport.aspx" pages (that contains Report Viewer control) to show 3 Different Crystal Reports as per condition on button click?
View 1 Replies
Feb 12, 2010
I have an ASP.Net (.Net 2.0) application that creates Crystal Reports (version 11.5) and shows them with CrystalReportViewer control. For some reason the control isn't showing the logo image in the header of the report. It renders the following html
<img width="320" height="76" alt="Imagem" src="CrystalImageHandler.aspx?dynamicimage=cr_tmp_image_e47fba99-96fc-471b-ab11-06fd2212bbdd.png" border="0"/>
I already included the aspnet_client folder in my Virtual Directory in IIS.
View 1 Replies
Nov 16, 2010
using crystal report in VS 2005 C#. I want to print multiple copies(3) of a same report in a single page. Is is possible.
View 1 Replies
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
Jan 28, 2011
I need textbox values to crystal report so that i can print customised report;
View 1 Replies
Feb 3, 2011
In my project I have to create crystal report which includes subreport ,
the data of subreport must be linked with the field of the main report...
Language is C#.net
Web App.
View 2 Replies
Jul 23, 2010
Im implementing crystal report which is builtin in visual studio 2008. When i create my crystal report and check its preview it shows me the data but when i call it on my abc.aspx page report doesnt load and gives error 'Load report failed'.
This is my Code
[code]....
what may be im doing wrong. This report also accept 4 parameters and im not setting them anywhere. Also one thing i want to mention if i make another simple project and do the same thing it runs perfectly and give me the output.
View 1 Replies
Nov 28, 2010
My report does not use data from a database. It uses a code generated dataset. How do I give crystal reports the necessary logon data to avoid database logon failures.
View 1 Replies
Feb 1, 2010
im using asp.net crystal report......i just upload the crystal in server and comiled i got error like"The maximum report processing jobs limit configured by your system administrator has been reached".then i just used
protected crysview_Unload()
{
report.close();
report.dispose();
}
then i did'nt got error but when i open this in second time it cant open the crystal report.
View 1 Replies
Mar 21, 2011
I want to print the crystal report with out previewing the report first?
Edited.
note that :
I want the client to print the report from his machine not from the server printer.
View 1 Replies
May 25, 2010
1. i have one problem on clicking print button in toolbar of subreport itz again come back to main report...
so, how to take the print of subreport...?
2. I have 10 pages in sub report ... Now i want to take print of 5 page .... ? How to do so ??
View 1 Replies
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
Oct 21, 2010
How can add database field dynamically into Crystal report using C#.
I want to get change crystal report with respect to Database field.
View 1 Replies
Mar 2, 2010
Have an asp application and getting: "Invalid Report File Path" when binding a DataSet.
[Code]....
View 2 Replies
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
Mar 25, 2011
normal way i can create crystal report in asp.net. but its making me problem when i create for asp.net. if a going to see the particular report with particular conditions. in the same way if the another user want to see the same report in other conditions then its making problem. the two reports display the same. conditions as follows:
user 1: want to c report Zone wise sales status
Zone : ABC
User 2: want to c report Zone wise sales status
Zone : CDB
in the web its not working properly, last conditions will be integrated with the two users
View 1 Replies
Mar 17, 2011
I've inherited an ASP.NET web application which displays reports using Crystal Reports. I wanted to add some new fields to one .rpt, but noticed that my changes were not being displayed when the report was called.
Thinking that maybe my changes were to blame, I merely changed some label text on the original; yet my changes were still not reflected in the report displayed by the site.
I have tried:
Resetting IIS
Moving/Renaming the .RPT file (and the site is still able to load the old report) This is mainly what leads me to think I'm confused here.
Starting/Stopping the site
Recycling the App Pool
Deleting ASP.net temp files
Setting Content Expiry on the rpt inIIS
I've only found one (unanswered) similar question here.
I don't know if maybe I'm just not understanding how the report is called, so here is the relevent portion of the code calling BookstoreReport.rpt.
[code]....
View 1 Replies
Jul 24, 2010
I have got a desktop application which was build in vs2005, now i am doing conversion of it to web application (vs2008). i have got around 40 crystal reports in it (desktop application).
tell me can i use them (rpt files) directly in web application or i will have to create all new reports?
View 1 Replies
Dec 16, 2010
I am retrieving connection string based on value stored in cookie.NowI am making crystal report. I cannot hard code server credential. I have to get these credential from connection string from web.config. so that i can pass these credentials to my crystal report .
ConnectionInfo reportConnectionInfo = new ConnectionInfo();
reportConnectionInfo.ServerName = connection string server name from web.config
reportConnectionInfo.DatabaseName = connection string database name from web.config
reportConnectionInfo.UserID = ...;
reportConnectionInfo.Password = ...;
View 1 Replies
Nov 6, 2010
Our heavily-used VS2005 application uses CR (10.2) for an MSWord-formatted stream to a webservice, and for printing from a CRViewer. We continue to get "Failed to open report" or "The maximum report processing jobs limit configured by your system administrator has been reached". Once the error starts, the only remedy is recycling the application pool, disconnecting current users.
I have used the proper ReportDocument Close() and Dispose(), and even GC.Collect(), in Page_Unload. I upped the Print Job Limit from 75 to 300. After recycling I delete temp files.
1) Is there any way to monitor the use of the CR resources, to see when they increase and get close to the limit?
2) Is there any way to free them without having to disconnect users?
I suspect users are simply closing their browser after printing from an open CR Viewer. It would still go through Page_Unload, right? So maybe I would benefit from closing and disposing the CR Viewer in Page_Unload as well as the click that returns them to the application.
I had assumed that to permit users to page through the report, the CR Viewer had to have ViewState enabled, and remain open through Page_Unload.
View 2 Replies