Crystal Reports :: Crossing Sessions / Not Working On Multiple Machines
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
An instance of the shopping cart is created like this:
If HttpContext.Current.Session("ASPNETShoppingCart") Is Nothing Then Instance = New ShoppingCart() Instance.Items = New List(Of CartItem) HttpContext.Current.Session("ASPNETShoppingCart") = Instance Else Instance = CType(HttpContext.Current.Session("ASPNETShoppingCart"), ShoppingCart) End If
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.
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
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.
Is that possible to open three reports in the same window ? Can be using the group tree or the tabs beside the MainReport.
The reports used to be open in excell and the file has three worksheet, now we want to change them for Crystal Reports, thats why were created three reports, but it must be open the same was the excell format, with three worksheets.
We are developing the asp.net in VS2010 with the CR2010.
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.
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.
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.
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'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.
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..
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#.
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.
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.
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?
I have a report displaying the data for an employee. If I wish to generate report for 2 employee, how I can do to make a single report contains both the data? (e.g.: 1st page display data for 1st employee; 2nd page display data for 2nd employee and so on) I need them to be in the same report/pdf file.
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.
I just started playing around with crystal reports. I created a report crystareport1.rpt and from the data base fields section I dragged and dropped empid, empname into details section. I want the report to show
empid empname 1 a 2 b 3 c
Like this . But now it is displaying
empid empname 1 a empid empname 2 b empid empname 3 c
Like this how can i get the desired out? One more thing on the button click I wrote
Response.Redirect("~/CrystalReport1.rpt");
But I am unable to open the report what should I do to see the report?
I need to display a header and details. What's the recommended way to do this? 2 separate datasets/tables, or 1 dataset with 2 datatables in it? I can't get the second set of data to display.
I need help writing a class that will contain three values per item. I'll be passing parameters to a report: Parameter Name, Data type (int, string, date, etc), and Value. When I pass those values to the report using the class they should be in original form (i.e. an integer should be a numeric, a string should be a string, etc.).
I can do it converting the data's value to strings on one end, and reconverting to the original data type on the other, which seems like a lot of runaround. Is there a simple way? Also, if I'm able to store & retrieve the data in it's native format I don't need the "Data type" stored.
I have been creating asp.net application for accessing data from multiple service references, is it possible to access it with same namespace in Reference.cs file