crystal-reports

Retrieving cached data from existing Crystal Reports file

Is there any way to retrieve the cached data from a previously refreshed report and say, dump it to a file? Basically, I'm looking for the dataset that is being used by the report, and hand-dragging each field onto the canvas or even exporting the file doesn't quite get me where I want. I'm not particular to a specific solution, be i...

Else part never getting executed in crystal report formula field

I have a simple formula in crystal syntax which looks something like this : if isdate(totext({Absence Details.Return to Work Interview Date})) = true and {Absence Details.Return to Work Interview required} = true then 1 else 0; This is the actual code of the formula but the else part is never getting executed, when the cond...

Formatting of the caption of a chart

Does anyone of you know a way to format the caption of a chart in Crystal Reports? I have a number that stands for a specific year, this number is 4 digits long. I wnat the caption to be shown like: 2009 But the current way its shown is 2.009 EDIT: The years are dynamically load from the database and in the DB they are stored...

Set programmatically papersize to A4 in CrystalReports viewer

Howdy, what I see in CrystalReports designer differs from what I see in CrystalReports viewer when I load a report programmatically. This is because in the designer I chnaged papersize to A4, while in the viewer it is Letter by default. So, how can I change in code (c#) default paper size to A4. ...

I need help in crystal report with vb.net 2008

I had been asked to build crystal reports for an application, i used the Microsoft Report Viewer control from the Tools, and could build a report which get data from datasource according to a parameter and view it in the report viewer, i need to know if i'm doing right or not? is this crystal report? and if not where can i find it. ...

CrystalReportViewer with ASP MVC

Although I have seen vague references to it here, has anyone actual managed to get the CrystalReportViewer to work with the ASP MVC framework? If so can you please give some more detailed info on how you did it. I am struggling currently. ...

Using a Crossjoin in Crystal Reports

Hello, I've got a problem with trying to translate a dataset into a more useable format. I have one that is currently outputting fields such as this. PersonID Year Sales A 1 5000 A 2 2000 A 3 3000 B 1 5000 B 2 600 B 3 200 n.. I would like to translate it...

.net passing data into Crystal Report

What's the lightest method to pass data into a Crystal Report in an ASP.NET site? I've pushed custom collections and datasets. I have a advanced custom collection and I really need to only pass in two fields. ...

Crystal Report grow horziontal

We can set grow property of a field so it will grow with vertical wtith the content, How can we grow it in horizontal. ...

Method not found: System.IO.Stream CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType).

What could be its reason I am using ASP.Net 1.1 ...

Crystal Report

I am preparing a crystal report for library system... two tables.. 1)BookIssueDetail: fields : grno ,bookno,issuedat 2)studentMaster fileds: grno,stdename,(and lots more)..only these filed are req to display... now i have made a dataset : "bookissuedataset" which have two table which are assign above. these is my code on print butt...

HowTo Bind Crystal Reports to Entity Framework ?

How can one bind Crystal Reports to Entity Framework Entities? I did find no workaround yet. (And I have not enough points yet to vote on existing questions) ...

WPF Application with Crystal Reports

How do I insert an image in a database and retrieve the image in Crystal Reports using a C# WPF Application? ...

Crystal Reports - very large database, very long processing time

I'm really at a loss as to how to procede. I have a very large database, and the table I'm accessing has approx. 600,000 records. This database is accessed using an accounting application, which provides the report with the SQL query by which this report accesses the database. My report has a linked subreport which has restrictions t...

Crystal Report: Centering reports within report viewer control

Looking for a way to center a report within the .NET Crystal Reports viewer control when the containing form is maximized. ...

How to get the name of a subreport from a Crystal Report in C#?

How do i get subreport name in C# ? i have one main report and one subreport.In my C# code i need to get the subreportName. rptDynamicReport rpt = new rptDynamicReport(); // CrystalReport //i need somethig like this string reportName = "Multiple";// Where multiple is the sub report name ...

Asp.Net Crystal report

I am working in visual 2008 with sql server 2005 as the back end. I am trying to create a crystal report with xsd file.This is what i did. I created an empty xsd file from "Add New Items".i dragged the stored proc from the server explorer from the database which i want to attach to the crystal on to the xsd. Created an empty crystal re...

Crystal: TOC add dots

I try to add dots between the page title and the page number in Crystal Reports for a table of content. I found http://www.tek-tips.com/viewthread.cfm?qid=1545153&page=1 in the web, but I wonder if there's a more simple and direct way to get the same result. I'm using CR shipping with VS 2008. ...

Assign multiple values to a parameter in Crystal Reports

I have added a parameter to my report with the option "Allow Multiple Values" checked. This is a status column (IE, Proposed, In Progress, Completed, Canceled), and I want the user to be able to select which (and how many) different OrderStatus to report on. How I normally set parameters is: report.SetParameterValue("@dtBegin", dtBegi...

How to suppress a subreport in crystal reports version 10.0 ?

I need to suppress a subreport. I have a parameter field named "TransactionType"; only if TransactionType is "Multiple" do I need to show the subreport option; otherwise, it should show blank. I have checked suppress option in subreport. I need a formula for suppressing a subreport if transactiontype is Multiple then show subreport or...