crystal-reports

What version of Crystal do I need?

I am getting the following error after deploying my web application to a 2008 server... Parser Error Message: Could not load file or assembly 'CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified. Crystal is not installed on the...

Crystal Report: Change ODBC connection to use dynamic dataset from csv file?

Hi All, The Problem: I currently have a few hundred crystal reports which get populated via an ODBC connection. I have to programmatically change this so I can populate a DataSet from a csv file and then populate a report based on the dataset. The main aim is to do this without actually modifying any of the reports (as that would mean...

Is Crystal Report 9 compatible with MS server 2008?

Hi all, I am going to pay for some classes to learn MS SQL server 2008. To prepare for the classes, I need to install MS SQL server 2008 in my home PC so that I can do some self-learning myself after each lesson. I came a cross a PC store that got a few second-hand copies of SQL server 2008 and as they (the shop keepers) said, if I bou...

How to prevent from cutting string field values in a crystal Reports8.5 report?

Hi First, sorry for my poor english writing. there is an old application written with Vb6.0 and crystal reports8.5. One of the reports (for example report1) has used active data method for retrieving data from SQL server. It contains a field named "description" that has 500 character at most. The problem is that the field (decription) c...

Make Setup of Desktop APplication Built in .Net

I have made Desktop application.. and in other PC i have not installed .net Framework so i want to make setup which automatically install framework first then install my desktop application and also reports of CRYSTEL REPORTs so guide me step by step Tutorial for it Thanks in advance ...

Crystal Reports Exporting to Excel with Can Grow

Using Crystal Reports 2008, Visual Studio 2008 with C#. Build the report in Crystal with multiple columns, some of which are narrative and can be quite lengthy. Using the “Can Grow” option on all fields. Have a web page that displays the report through the viewer, looks great. Web Page / Crystal Viewer Date Narrative ...

Label Printer with Crystal Reports

I have an Epson TM-L60 Label printer and I'm trying to make it cut the paper after printing a report label made in Crystal Reports (from Visual Studio). I have to do it programatically because it's an old printer and driver settings do not allow me to set options like "single label cut". Is there perhaps a command I can use? But how do...

Crystal Reports formula method, GroupName

I am fixing some old reports and have come across the method GroupName. I cannot find exactly what it does and am coming for support. For that matter, is there an online reference that contains a list of the built it methods in CR, parameters, etc.? ...

Does Crystal report open handle to default printer even if no printing is done

Does Crystal report open handle to the default printer when a report is run? even if the result report is never printed? Thanks in advance, Su ...

Crystal Reports and Viewer

Hey, So my problem is I have created a report which is grouped by Dealer number. Within this group I have created running totals to summarize the volume of each dealer, then just display their total volume. I reset all my variables to 0 in the group header. When I look at the report in CR it looks fine. But through the viewer or exporte...

Crystal Reports SQL Server Multiple tables and Outer Join

Hi, I am trying to make a report which will show products bought by customers. I have Products, TransDetails, TransHeaders, Customers tables and i have to pick all products and for each product i have to show sales for each customer. if customer has not bought any particular product it should still be visible on report with 0 sales. user...

Security Issues with MVC app and Crystal reports

Hi Overflowers, Hope somebody can help this poor distraught noob. I have inherited another devs app and I'm trying to add some much needed functionality to it. The issue in question is creating an Invoice from a crystal report that can be downloaded as a pdf. I got the code working in Visual Studio (It's a C# MVC application, built on...

Crystal Reports User Parameter To Query

I'm trying to develop a Crystal Report that passes the user executing the report as a parameter to the report query. I'm using Business Objects Enterprise, executing the reports through InfoView which I would assume uses the Crystal "Special Fields" Current CE User Name, I just can't figure out how to link that to the query. Am I think...

Installing Crystal with my app - What's involved?

We've written a C# app that will display Crystal 2008 reports in the .NET Crystal viewer. Can anyone tell me what's required for installing the Crystal runtime files on each client machine to support this? ...

Crystal report licencing with vs 2008

If I sell my application which is develop in VS 2008 which contains some crystal reports too then Do I need a Crystal Reports license? If Yes then what would be the price? ...

Crystal Reports Selection Formula

Does anyone know how/if you can use a MIN() in selection formula for a Crystal Report? Im wanting to do this: Dim sql As String = "" Dim startDate As Date = CDate(_startDate.ToString(_dateFormat)) Dim endDate As Date = CDate(_endDate.ToString(_dateFormat)) sql = "min({" & tableName & "." & dateFieldName & "}) <= " & st...

Do Crystal Reports or Reporting Services support themes in Visual Studio 2010?

Do Crystal Reports or Reporting Services support themes in Visual Studio 2010? So that different reports share common attributes, the same way css works for web pages? I know they didn't in earlier versions and wondered if they added this support. While at it, any .NET reporting tools which support themes? ...

Crystal Reports 2008 - Problem with Parameter Type

I have a Crystal 2008 report hitting a SQL Server 2008 database using a stored procedure. The stored procedure takes a parameter of type Date (new to SQL Server 2008). When Crystal automatically creates the parameter for me in the report, it makes the parameter a type of String. I don't want a type of String because then the user is re...

Crystal Reports toolbar is gone after upgrading from VS2008 to 2010

I converted our web site to asp.net 4.0 in VS 2010. Crystal reports (version 10.5.3700.0) renders the reports, but the toolbar will not display (so the print/change page functionality is gone). I have set AspCompat="true" in the page that hosts the viewer, and tried just about every combination in the properties for the viewer, but the t...

crystalreportsviewer [Crystal Reports 2008] - free resources

Is there any way to close the IEnterpriseSession that is used in the crystalreportsviewer? I've googled and googled and for the life of me I just cant seem to find a clean way to do this. The problem is that once the user closes the brower window displaying the crystal reports viewer, the web session (on tomcat) times-out but the sessi...