There are certain Crystal Reports features that cannot be combined in the same report, for example SQL command objects and server side grouping. However, as far as I can find, the built-in help doesn't seem to clearly document these conflicts. For example, checking the help page for either of those features doesn't mention that it doesn'...
Hello all. I have 2 details section on my report (Datails a and Details b). Fields i both sections can grow up to 10 lines. How to force CrystalReport that both section must be printed on one page. Currently CrystalReport on bottom page print section "Details a", but section "Details b" print on next page. How to prevent this behavior...
We have been using .Net and Visual Studio for the last six years, and early on developed a number of web based reporting applications using the .Net version of Crystal Reports that was bundled with Visual Studio. My overall opinion of that product has been, to say the least, rather unimpressed. It seemed to be incredibly difficult and ...
I'm working on an existing report and I would like to test it with the database. The problem is that the catalog set during the initial report creation no longer exists. I just need to change the catalog parameter to a new database. The report is using a stored proc for its data. It looks like if try and remove the proc to re-add it ...
I'm using the Crystal Reports included with VisualStudio 2005. I would like to change the image that is displayed on the report at runtime ideally by building a path to the image file and then have that image displayed on the report. Has anyone been able to accomplish this with this version of Crystal Reports? ...
Hi I have an Image column (Allow Null = true) in SQL Server 2005. I am using Crystal Reports designer (ver 10.5) that comes with Visual Studio 2008. Crystal sees the column as blob field and puts an image object for the column. When I am trying to limit the record selection by using NOT ISNULL({Employee.Picture}) as Selection Fo...
I'm using Crystal Reports 9.0. It has a subreport which is shared by 2 master reports. I modified the subreport as a result of fixing one of the master reports. When I try to re-import that subreport into my 2nd Master report I'm getting the error: Access denied then Re-importing the subreport failed. Does anyone know what the proble...
We have been designing our reports around Crystal Reports in VS2008 for our web application and I just discovered the Microsoft provided ReportViewer control. I've searched around a bit but cannot find a good breakdown of the pros and cons of each method of producing reports. I'm looking for pros and cons regarding: Ease of developme...
We are using the MVC framework (release 5) and the CrystalReportViewer control to show our reports. I cannot get any of the buttons at the top of the report viewer control to work. If I'm working with the report 'HoursSummary'. If I hover over any of the buttons on the report viewer in IE the displayed link at the bottom of the pages ...
We're using Crystal 11 through their webserver. When we run a report, it does the Sql query and displays the first page of the report in the Crystal web reportviewer. When you hit the next page button, it reruns the Sql query and displays the next page. How do we get the requerying of the data to stop? We also have multiple people run...
I would like to create a Crystal Reports report using pre-existing LINQ classes that live in a different project than where the report lives. I can't find a way to do this. I'm using VS2008. Whenever I expand the "Project Data" tree, I see only classes in my current project. The "History" tree shows me the last 5 class in the OTHER p...
I'm trying to create a Crystal Reports formula field (to calculate the percentage change in a price) that will return "N/A" if a particular report field is null, but return a number to two decimal places using accounting format (negative numbers surrounded by parentheses) if it is not. The closest I have been able to manage is this: If...
I need to create reports in a C# .NET Windows app. I've got an SQL Server 2005 database, Visual Studio 2005 and am quite OK with creating stored procedures and datasets. Can someone please point me in the right direction for creating reports? I just can't seem work it out. Some examples would be a good start, or a simple How-to tutorial...
How can I redistribute crystal report with an xml dataset in a windows application. I want to be able to use the same xsd and a new xml file every time. When I load the RPT file from inside my application using the code below on a computer other than my own it looks for the xml and xsd. Is there any way I can strip this information from ...
Recently I was working with generating a PDF from Crystal Reports through a webform. It was failing, which I determined to be caused by the permissions settings on the c:\windows\temp dir. I gave the Network Service account full access to this folder, which promptly fixed the issue. But is there a reason the Network Service account ...
Which of Crystal Reports and SSRS (SQL Server Reporting Services) is better to use? ...
I am looking to integrate Crystal Reports 2008 into a Windows Forms application. I would like to avoid direct connections from my client application to the database, while giving the user the "complete" report experience. Is it possible to for Crystal Reports 2008 to execute a report on a server into a client-side Windows Forms client co...
Can someone please explain how to remove the background/borders off an embedded CrystalReportViewer control in Visual Studio 2008. I'm trying to remove the light gray (below the "Crystal Report" heading) and then the darker gray underneath that. I want to be left with only the white box and the report inside this. This is the output I'...
I have a C# application where I create a Crystal Reports ReportDocument, with the line CrystalDecisions.CrystalReports.Engine.ReportDocument document = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); This line takes 3-4 seconds to execute. This seems very slow, especially since the document.Load(fi...
I have been trying to get around this error for a day now and have not had much luck. I have a VS 2008 project that uses the embedded Crystal Reports which of course runs fine locally, but when deploying to my remote server the reports will no longer run. I gathered that it was because I didn't have the right Crystal Reports component...