Crystal Reports :: Storing Multiple Data Types In A Class?
Aug 31, 2010
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.
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 have a report which is runnin fine as it is using singe table Dataset(.xsd) . I want to expand the report and use more tables in it to show more information .
How can I do so. I am attaching my present code with this.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim stdate, enddate As Date Dim sql As String start_date.Text = Session("startdate") end_date.Text = Session("endate") Dim dt As DateTime = DateTime.Parse(start_date.Text, System.Globalization.CultureInfo.GetCultureInfo("en-gb"))
I am just starting with Crystal Reports and have been scanning articles on the web. I'm using the Push model so need to connect to a DataSet. All the articles I'm reading talk about creating a Crystal Report, for example, myCrystalReport.rpt. I have done this, connected my DataSet schema (.xsd file) to the report and actually get a pretty well formatted output in the Report Previewer in VS 2008. The problem is that in order to actually connect data to the report, I need to instantiate a myCrystalReport object. In the examples I've seen, there appears to be an autogenerated .cs class like code-behind for myCrystalReport. I do not get that, only the .rpt file. Is there something wrong with my VS configuration or do I need to take specific action to get
My Crystal Reports works perfectly when I have it on my local host, once I upload it to the server I get the error listed below. I ran the following MSI on the dedicated server: CRRedist2008_x86.msi.. If it is a permission issue, I am using Plesk Panel so there is no ASPNET user, it is different users, what user and what specific folder do I have to give permissions to? Retrieving the COM class factory for component with CLSID {5FF57840-5172-4482-9CA3-541C7878AE0F} failed due to the following error: 80070005.
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.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {5FF57840-5172-4482-9CA3-541C7878AE0F} failed due to the following error: 80070005.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user. To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.
I have an application that allows admins to add types such as document types and training types that are in seperate tables with a foreign key in a transaction table.
When structuring my class I decided to go with an abstract-like pattern (without the factory methods though). So I have a Type abstract class that defines my Save, Delete, and GetList methods. I have a training type class that inherits this class. The thing is all types have 3 main properties - defined in the abstract base - but have different source tables and thus different store procedures in my DbCommand object. So basically I repeat setting up the same parameters on all the derived classes. I would like to implement the common stuff in the base but I am getting thrown off by the difference in data sources.
Retrieving the COM class factory for component with CLSID {4DB2E2BB-78E6-4AEA-BEFB-FDAAB610FD1B} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).
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'm new to Crystal Reports and am just trying to add some simple reports to my web application. In the non-report pages I've been using SqlDataSources to retrieve data from the database and would like to do the same for the report pages. I saw a tutorial that indicated I could do this by explicitly setting the data source for the report in the Page_Load callback of the ASPX page as shown below:
[code]...
Is there a way to create "bound" fields w/o a database, since I'll be specify the database at runtime? Or is there a way to create the ".rpt" file w/ unbound fields, that get "bound" at runtime?Or is there a better way to do this altogether?
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#.
I have an application that uses Crystal Reports downloaded from SAP for Visual Studio 2012.
When I debug the software in Visual Studio it works perfectly fine, but when I deploy it and want to view the Crystal Report, I get the following error:
Server Error in '/' Application.Retrieving the COM class factory for component with CLSID {4DB2E2BB-78E6-4AEA-BEFB-FDAAB610FD1B} failed due to the following error: 80040154.
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 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 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
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
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.