I was talking to somebody a recently who mentioned it was possible to store reports created using Crystal Reports as XML files. Upon Googling this, I can't find anything suggesting that this is the case (using data stored in XML in a report, yes, but actually storing the report, the part stored by default as a .rpt file, no. Am I corre...
Hi stack overflow community, I would like to add graphing to my User Controls in ASP.NET MVC. I'm fairly new to MVC just jumped into it about 2 Weeks ago and was hoping for some ideas or a guide on how to approach this issue. I have searched around and found no helpful answers to resolve this issue. I was thinking of doing crystal report...
I've got a UI front end which talks to and manipulates a SQL Server database, and one of the things it can do is run reports on the data in the database. This UI can be installed on multiple computers, and so far I've just been keeping the reports in a folder with the install, but this means that any time a new report is added is has t...
We have a system that is used by a few hundred separate customers, at the end of the month the customer likes to generate a report of the activity with his/her clients. These reports are nothing special; they maybe contain a logo, address and a few lines of mathematical data. Currently we use Crystal Reports but that is just not a pleasa...
I have a report created in Crystal (the version that comes with Visual Studio 2005) that contains an IFieldObject that I want to use to display some rich text. I have set the TextFormat of the IFieldObject to crRTFText, however when I run the report the textbox displays all the rtf markup rather than actually displaying the formatted te...
I cannot for the life of me find an example of what I need. I have a report that is bound by xsd. How can I take this report in c#, and set the datasource to a new xml file? Every possible way that I've tried just throws me a nice logon screen. I know the files exists in the places that it is looking, and there is obviously no username ...
Hi there, Just wondering if anybody had working code example (in c#) for exporting a crystal report to excel from a .NET application without the report's page headers and footer's. I am using crystal reports v9 runtime. ...
I am trying to open a report in Crystal Report 11 Designer (product version 11.5.8.826), but it seems to freeze up. This report use to work fine, but today the client could not load the report. I also tried to open the report on another developer's workstation, with the same result. Has this happened to anyone else? ...
I'm creating a invoice crystal report for sage mas 500 AR module. In it, I'm attempting to add the tarinvoice.balance field with the following formula: if {tarPrintInvcHdrWrk.Posted} = 1 then ToText({tarInvoice.Balance}) I'm assuming that when the {tarPrintInvcHdrWrk.Posted} = 1 conditional statement holds FALSE, it doesn't att...
It is possible to display XHTML fully in Crystal Reports? I have a field which I set to display with HTML tags, but it ignores many of the tags I need, such as . It would be nice if the font was set by the XHTML as well. If not, is there a reporting tool with the features of Crystal Reports but is better at rendering XHTML? ...
I have a Crystal Report that looks like: Date | Person | Ticket | Summary Date | Person | Ticket | Summary Date | Person | Ticket | Summary I would like it to look like: Date Person | Ticket | Summary Person | Ticket | Summary Date Person | Ticket | Summary All values are pulled from a MS SQL 2000 database, the application t...
Hello all. I am working with Crystal Reports and MS SQL Server. I need to remap the crystal report to point to a different database on the same SQL Server. Is there an automated way of doing this, or do I have to remap for every single report? I am currently doing this by adding a new data connection, and then updating the stored proced...
Does anyone know of a way to represent a tree structure in Crystal Reports? My big issue is that I don't know the depth of the tree. It is represented in a database table with a simple "childId -> parentId" relationship. A perfect example would be to open Windows Explorer, and look at the directory tree on the left side. If anyone kno...
I'm porting an application from Crystal Reports 8 to Crystal Reports XI in Delphi 5, using the RDC/ActiveX interface. In Crystal Reports 8, I was able to bring up the crystal reports default report viewer window for a report like so: RptInvoicing.Destination := 0; // To: window RptInvoicing.Action := 1; // Execute However, this does ...
I have a problem with Crystal Reports 8. When exporting a report from my application, Crystal Reports sometimes freezes. The progress windows just stays, saying X of X records exported. Smaller reports with less data are more likley to freeze. Faster workstations (P4, Core2) tend to freeze much more often, sometimes every second try. O...
What I want to do is an outer join to a table, where I exclude records from the joined table based on matching a constant, however keep records from the main table. For example: SELECT a.id, a.other, b.baz FROM a LEFT OUTER JOIN b ON a.id = b.id AND b.bar = 'foo' Expected results: id other baz -- ---------...
I have a project with Crystal Reports files that doesn't seem to build correctly if I upgrade it to VS 2005 and .NET 2.0. I think the reason is that the new version of Crystal Reports is incompatible with the older report format. Since I am now running Vista, and .NET 2003 doesn't work correctly on Vista, I want to be able to build usi...
Im creating a report using crystal report in vb.net. The report contained a crosstab which I have 3 data: 1. Dealer - row field 2. Month - column 3. Quantity Sales - summarize field How can I arrange this by ascending order based on the Quantity Sales - summarize field? thanks ...
I need to create reports in a C# .NET Windows app. I've got an SQL Server 2005 .I want to display two more field to report(not available in data base table. I want to create these field by adding some data from existing field of data base table) ...
how can i group by two different fields in a crystal report. Foe ex : val1|val2|val3|val6 val1|val12|val3|val7 val11|val2|val3|val8 val11|val12|val3|val9 i want the report to look like val1 : val2 val3|val6 val12 val3|val7 val11 : val2 val3|val8 val12 : val3|val9 ...