Search results for query: *

Hey guys, 1. I have a date field (Date1). I use a running total with a type of summary set to "Maximum" to obtain the most recent date(MostRecentDate1). 2. I also have another date field (Date2). 3. I then use a formula to obtain the difference in days between MostRecentDate1 and Date2...

Hi guys, I'm new to Oracle; but not Crystal Reports. In the past, we've used SQL Server to create stored procedures and then called them into Crystal Reports. No problem there. We are now transitioning to Oracle and I needed some help. I have a simple SQL stored procedure which I'd like to...

What is the syntax for specifying a date to a variable without the year? For example, I have a parameter of @YEAR and I want the @STARTDATE variable to always be '1/1/@YEAR'. Thanks

Hey guys, I've searched all over and can't seem to find my answer. I've developed a report using Crystal 2008 and would like to embed something (formula, parameter, whatever) to force the report to print 2 copies. This is for a client, so I can't set the default printer (since I don't have...

Good morning, I'm using CR2008 and have embedded a formula into an OLE Object which points to the location of a picture. When I run the report in CR, the picture shows perfectly in Preview mode. However, when I run the report from our software, the Crystal Viewer leaves that section blank...

Hello all, Is there a way to display a textbox on a report, but prevent it from printing? For example, when the report is generated, the textbox would give a brief description of the report; but when the user goes to print the report, that textbox would be left off the printout. Thanks for...

Hello, I have a database with payment information and I'm trying to do the following: FeeAmount - FeePaid = Balance Due The report is grouped by PayType (Cash, Check, Credit Card) and then by user and then by Invoice. I then list the individual FeeName, FeeAmount, AmountPaid, and BalanceDue...