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...
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...
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...
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 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. ...
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. ...
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...
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. ...
We can set grow property of a field so it will grow with vertical wtith the content, How can we grow it in horizontal. ...
What could be its reason I am using ASP.Net 1.1 ...
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...
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) ...
How do I insert an image in a database and retrieve the image in Crystal Reports using a C# WPF Application? ...
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...
Looking for a way to center a report within the .NET Crystal Reports viewer control when the containing form is maximized. ...
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 ...
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...
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. ...
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...
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...