In Crystal Report 9 what is the correct syntax for using if then statement such as the following
IF (addresstype) IN {'Home', 'Busin','VacaHome','School'} THEN
"City = "&addresscity...
On my client I have installed Visual Studio 2005 and Crystal Reports XI Developer. On the Server there is installed Crystals Reports Server XI on Win 2003 Server with IIS 6.0.
Now, I wanted t...
I have Business Objects XI installed on a server that does not have email program installed on it. My company uses Lotus Notes which is hosted on another server. I have enabled email on the C...
Hi,
In crystal report 11, when I tried to refresh report data based on a certain database, I got message:
-----------------------------------------------
failed to load database informat...
My first venture into ASP.
Trying to send parameters to Crystal Report 9 Report.
The problem: If the report uses information from the database AND I pass in parameters to the report fro...
I am having a problem sorting on a summarized field. Currentlly I am sorting by grouped name, but want to change it to the total expense for that group. Problem is I do not see the summarized ...
I'm trying to get the CR .NET redistributable loaded up on our new ITSM (by FrontRange) server so that the built in reports work.
The documentation says it's looking for v 10.033, but I can...
I have a Oracle Stored Procedure that has 6 parameters. Several of which require a comma separated list of values that would be included in a where clause. The values are generally quite cr...
I'd like to schedule a report to run weekly that has the beginning and ending parameters change from week to week without having to open the schedule instance to change the parameters manually...
I downloaded the redistribution package (cr9netredist.zip) from
http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr9netredist.zip.asp
and installed the assemblies, but...
I have a report that includes data and shared variables from several subreports. I have all of the individual formulas working correctly, but I need to do some total fields in the report foote...
Hi Experts,
my user was in the process of Printing Reports and was printing them off one by one, after the Seventh Report we got this error:
System.Exception: Load report failed. ---> S...
Greeting,
I have the following data in field1: Y, N,M,K, NULL. I want all the records has field1 is NOT Y.
If I use formula: ({field1}<>'Y' or IsNull({field1}) I got records with N,M...
i am developing a Crystal Report and I want to be able to provide the following function, but I need help writing this function in VB.
groupcountnumber = 0
if( {Command.Status} <> "PRS...
I've gone through multiple KB articles and tried everything I can think of, but I cannot get a client machine to load the "Crystal Smart Viewer for ActiveX" using CR XI on a windows 2003 web s...
Hi, I am new to crystal reports, so please help.
I am trying to create a formula in crystal that will use 2 recordset fields (category and total), and based on the category will return a corr...
I am trying to pass a parameter value in from a textbox - right now am tryign to settle for hardcoding the param value and getting the report tp pick it up - here is the code that I am using n...
Error:599 Cannot open SQL server
Execute <PEStartPrintJob>.
I use Delphi5 Enterprise (Update pack 1 and Delphi 5 ADOExpress Update Pack 2 are installed) and the Crystal Reports VCL v. 7.5....
My business has been using a custom written program for order entry. This program runs an embedded Crystal Report viewer. We have been using this program for roughly 5 years, and it has not ...
Hello Experts,
I am somewhat new to Crystal Reports. I am using version 8.5, standard.
I need to create a report that lists the total sales by customer (invoiced orders + open orders) fo...
Hello guys,
I have a solution (.Net Framework 2.0 Windows forms application) where I use Crystal Reports 10. It is running just fine on every x86 machine we have tested until now, using Cry...
I have three fields I developed with formula editor name #countd ,#countd2, and #countd3 how do I use the sum() function to add a field in my report to display the total.
Hi:
I am currently trying to get a count of records submitted in Dec 07. My code excludes the count for the last day of the month (12/31/07). How should I fix the below?
Thanks,
URJ
Hello!
I just started using Crystal Reports.
How can I use this SQL-Query in Crystal Reports: (in VB6 it works fine)
SELECT COUNT(Firstname) AS FN FROM MyTable WHERE Firstname = "Joe"...
Hi there,
I am trying to use a Case Statement to filter some records. For example here is what I want to accomplish..
1] I want to set prompts for a field "Company". This company field h...
