Crystal Reports :: Refresh On Runtime Not Working
Nov 14, 2010
I generate report using parameters.I pass parameter on run time & report is generated. For Example: At first i am displaying A list of customers having SEX = MALE. Than I enter SEX = FEMALE. But it still displaying the MALE list Results. If i rebuild my webform and than put parameter FEMALE then it displays. So, If i generate a report once. I dont want to rebuild my webform to pass new parameter. . How it should be Done. I added one line code CrystalreportViewer1.RefreshReport(); but it did not work for me. I am using VS 2010..
View 1 Replies
Similar Messages:
Dec 28, 2010
Design and runtime problem in crystal report?
View 6 Replies
Oct 29, 2010
how to create CRYSTAL REPORT by pulling values from database ,processing them (applying percentage,averages ,decisions )
View 1 Replies
Apr 13, 2013
I have master page, menu on master page, i use asp roles and trim menu item based on user roles and rights this process is working fine.
Now i have to create some reports based on user roles, and responsibility in a company like country head will view country wide reports, manager region will only view regional report and rest will view reports related to them.
How can i achieve this efficiently using asp roles.
View 1 Replies
Feb 24, 2011
I am trying to use crystal report for my project. I have made .rpt file as instructions in the tutorials now the problem is with crystal report viewer control... i hav set its its report source to the one that i have made using its properties.. but still its not working..I am using professional edition of visual studio 2008 with .net frameowrk 3.5
View 3 Replies
Feb 24, 2010
I have created a crystal report application using VS 2005 on my Dev machine, it worked correctly.On another machine where VS 2005 is also installed, it is not working.
The DLL that is giving error is:
<add
assembly="CrystalDecisions.ReportAppServer.ClientDoc,
Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
If I search for this DLL on my Dev machine, I can't find it.
View 1 Replies
Aug 5, 2010
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
View 2 Replies
Mar 5, 2010
i am facing an issue with crystal report when i deploy my web application in client side. I have a web application developed in visual studio 3.5. Our build machine contains crystal report version 10.5, we have published the web application and created the build to deploy in the client machine IIS. We have installed the redistribution of crystal report 11 in the client machine. we have currected the config file and all based on this. but we are getting a runtime error when the application try to load reports.
View 1 Replies
Jun 10, 2010
I am running into this strange Cyrstal Report runtime error. To give a bit of a background I am deploying my web application on a 64 bit Windows 2003 server using Crystal Report 11.5.3700.0 where the IIS 6.0 is running under 32 bit mode as one of the forums mentioned that this version of Crystal report can only run under 32 bit mode.So as expected all works ok under the development environment but when I open the reports on to the production server error It recieve this error at the following code line.No error.Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Runtime.InteropServices.COMException: No error.Source Error:
[Code]....
Line 66: document.DataSourceConnections[0].SetConnection(Globals.GlobalSettings.DATABASE_SERVER, Globals.GlobalSettings.DATABASE_NAME, false);
Line 67: document.DataSourceConnections[0].SetLogon(Globals.GlobalSettings.DB_USERNAME, Globals.GlobalSettings.DB_PASSWORD);
Line 68: document.VerifyDatabase();
Can you can see, the error message itself says no error which of no use to me. Has anyone encountered this problem before. I am using Visual Studio 2005, ASP.NET 2.0. .NET 2.050727.No error.No error. Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: No error.Source Error:
[Code]....
Line 66: document.DataSourceConnections[0].SetConnection(Globals.GlobalSettings.DATABASE_SERVER, Globals.GlobalSettings.DATABASE_NAME, false);
Line 67: document.DataSourceConnections[0].SetLogon(Globals.GlobalSettings.DB_USERNAME, Globals.GlobalSettings.DB_PASSWORD);
Line 68: document.VerifyDatabase();
View 2 Replies
Nov 3, 2012
i am getting this error when i try to load crystal report ,..
View 1 Replies
Aug 5, 2010
The problem is in the crv.js, at
Sys.Application.notifyScriptLoaded();
when I try to open a report is shows Microsoft JScript runtime error: 'Sys.Application' is null or not an object
If I click Ignore or Continue, it's show the report properly, but when I deploy it to the development server it does not work.
At this time I am trying to open a simple report with the date and page number.
there is a CrystalReportViewer at the Default.aspx page.
the code is
[Code]....
View 3 Replies
Nov 2, 2010
I am working with crystal reports. I created a button on crystal report viewer toolbar using the following code protected void Page_Init(object sender,
EventArgs e)
{
Control ts = CrystalReportViewer1.Controls[2];
if (ts.ToString().Contains("ViewerToolbar"))
{
ImageButton BtnExport =
new
ImageButton();
BtnExport.ID = "BtnExport";
BtnExport.ImageUrl = "images/pdf.png";
BtnExport.Click += BtnExport_Click;
ts.Controls.Add(BtnExport);
}
UpdatePanel UpdatePanel1 =
new
UpdatePanel
();
System.Web.UI PostBackTrigger trigger =
new System.Web.UI.PostBackTrigger ();
trigger.ControlID = "BtnExport";
UpdatePanel1.Triggers.Add(trigger);
}
My problem is whenever I click the button to export the report, it shows an error like below: Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled.
Details: Error parsing near .....
View 7 Replies
Jun 13, 2010
I'm new to Visual Studio.NET . I need to integrate the crystal reports into an ASP.NET application. I generated Crystal report with the help of crystal report XI developer edition(Stand alone version and NOT from the one which comes from visual studio).
How to integrate this report with the web application.
View 1 Replies
Jul 16, 2010
We have quite a few reports which were developed earlier in Crystal Reports 8.5. We are now planning to use these reports in our web application developed in VS 2008 (C#).
What dlls are needed for calling 8.5 in the application and how should they be added to the application while shipping it to the client?
They are also struggling to get the code running. Would also need the code to call the report with parameters.
View 9 Replies
Sep 6, 2010
I've just upgraded a visual studio.net 2003 project (asp.net 1.1) to visual studio.net 2010 (asp.net 4.0). I'm encountering a problem with viewing Crystal reports. I'm using Visual Studio Development Server as a Web Server.
When I try to create a new report (via code that worked fine previously) the line below causes the webserver40.exe to crash.
Protected WithEvents MyRep As New CrystalDecisions.CrystalReports.Engine.ReportDocument
I've got Crystal Reports 11 installed.
View 1 Replies
Mar 12, 2010
I'm using vs2005 asp .net using c#and i using the crystal report viewer to create my report and preview the report using crystal report viewer. When i run the application, i can preview the report well in the form, but when i click any button of th tool bar then a blank page is getting displayed.
View 5 Replies
Apr 6, 2010
I have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.
View 3 Replies
Dec 17, 2010
My report is displayed without any problem. However, when I click on the button from my crystal report viewer toolbars I get the error. Note : the toolbars is working fine on my local machine.
Error message : Logon failed. Details: mscorlib : Could not find a part of the path 'C:Documents and SettingschiaMy DocumentsVisual Studio 2008WebSitesSafety Permit System
ptLoad_ConfineSpace_Summary.xml'. Error in File C:WINDOWSTEMP
ptPrintSummaryConfineSpace
{965CF937-D48C-483A-AC32-198A790880A6}.rpt: Unable to connect: incorrect log on parameters.
View 14 Replies
Dec 29, 2010
Everythings working fine on my PC but when I deployed my application on server, Print and export are not working. Even the toolbar images were not displaying on the report. So I added them manually to my application.
Is there some folder missing?
View 2 Replies
Mar 25, 2010
I'm running CR XI, and accessing .RPT files through a ReportViewer in my ASP.NET pages. I've already got the following code, which is supposed to set the Report Datasource dynamically.
rptSP = New ReportDocument
Dim rptPath As String = Request.QueryString("report")
rptSP.Load(rptPath.ToString, 0)
Dim SConn As New System.Data.SqlClient.SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings("MyConnectionString").ConnectionString)
rptSP.DataSourceConnections(SConn.DataSource, SConn.InitialCatalog).SetConnection(SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password)
Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo
myConnectionInfo.ServerName = SConn.DataSource
myConnectionInfo.DatabaseName = SConn.InitialCatalog
myConnectionInfo.UserID = SConn.UserID
myConnectionInfo.Password = SConn.Password
'Two new methods to loop through all objects and tables contained in the requested report and set
'login credentials for each object and table.
SetDBLogonForReport(myConnectionInfo, rptSP)
SetDBLogonForSubreports(myConnectionInfo, rptSP)
Me.CrystalReportViewer1.ReportSource = rptSP
But when I go into each .RPT file, and open up the Database Expert section, there is obviously still servernames hardcoded in there, and the code listed above doesn't seem to be able to change the servernames that are hardcoded there.
I say this because I have training and production environments. When the .RPT file is hardcoded with my production server, and I open it on my training server with the code above (and the web.config has the training server in the connection string), I get the ol:
Object reference not set to an instance of an object.
And then if I go into the .RPT file, and change over the datasource to the training server, and try to open it again, it works fine. Why doesn't the code above overwrite the .RPT files datasource?
How can I avoid having to open up each .RPT and change the datasource when migrating reports from server to server? Is there a setting in the .RPT file I'm missing or something?
View 2 Replies
Apr 22, 2010
I wrote the following code for my report
[Code]....
But i am getting the follwing exception: Access is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Access is denied
I am having 'Full permission' to E:Documents and Settings hiru.TECH27SYSTEMSLocal SettingsTemp IIS is not installed in my system. Visual studio is installed in E: My project is in D: what should i do?
View 5 Replies
Mar 29, 2010
I wrote a crystal web server using asp.net security. i have multibple reports in a few different directories, and i have a report viewer form in each secured directory. when i load a particlular report on one machine's web browser, if i go to another machine and launch that report, the report instantly shows up with the parameters selected from the other machine. it's like after the report launches, the next request for that report just dishes out the previously built page.
I have not experienced this before, and makes my report site kinda useless. why these reports aren't treated as separate sessions?
*here is the markup for the frmReportViewer.aspx page:*
<form id="form1" runat="server">
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"
AutoDataBind="true" BestFitPage="False" Width="1100" Height="680"
ReportSourceID="CrystalReportSource1" BorderColor="#000099"
BorderStyle="Inset" PrintMode="ActiveX" />
<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
<Report FileName=""
</Report>
</CR:CrystalReportSource>
</form>
*here is the vb code for the frmReportViewer.aspx page:*
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Me.CrystalReportViewer1.HasCrystalLogo = False
If Not IsPostBack Then
ReportName = Request.QueryString("reportname") & ".rpt"
Me.CrystalReportSource1.Report.FileName = ReportName
DBConnectionForReports(CrystalReportSource1.ReportDocument)
End If
end sub
Public Function DBConnectionForReports(ByRef rpt As ReportDocument) As Boolean
Dim logonInfo As New TableLogOnInfo
'Dim table As System.Web.UI.WebControls.Table
Dim srptServer As String
Dim srptUN As String
Dim srptPass As String
Dim crConnInfo As New ConnectionInfo
Dim subRepDoc As New ReportDocument
Dim table As Table
For Each table In rpt.Database.Tables
srptServer = "calp"
srptUN = "cdiappsro"
srptPass = System.Configuration.ConfigurationManager.AppSettings.Item("OraclePassword").ToString
logonInfo = table.LogOnInfo
logonInfo.ConnectionInfo.ServerName = srptServer
logonInfo.ConnectionInfo.UserID = srptUN
logonInfo.ConnectionInfo.Password = srptPass
logonInfo.TableName = table.Name
table.ApplyLogOnInfo(logonInfo)
Next table
End Function
View 5 Replies
Sep 27, 2010
I am using crystal report with ASP.NET 3 web application.
I am facing an issue with the default search functionality of the crystal reports.
When typing a word and hit enter, it searches only in the column headers, title, footer, summary columns, . Not searching in the data field in the details section.
But in the sub reports, everything is fine, searching in all the fileds.
View 2 Replies
Jan 4, 2011
In my system Visual studio 2008 with sp1 and Crystal Reports XI Release 2.In Visaul studio 2008 ,while adding add reference it showing crystal reports version 10 instead of 11.How to solve the version problem.
View 1 Replies
Feb 15, 2010
I am considering using Crystal Report 2008 as my tool of creating reports on my webpage.The only problem which I'm facing is that I have no control of the remote server which hosts my site (besides uploading files). I can't run a MSI to deploy the CR runfiles.I can't find anywhere in the CR user manual of how to deploy the runtime files without running the msi, and I'm not even sure it's possible.Have anyone deployed CR 2008 without running the MSI and without having to register any files?
View 8 Replies
