Search results for query: *

Thanks for the reply. I ended up getting assistance from one of our developers who showed me how to program it directly in SQL.

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...

fantastic! Thank you!!

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

That sounds good and I'll give it a shot; but here's a small caveat. If the paytype is "Cash", they want 2 copies; otherwise they want 1. So how would I accomplish that? I should have mentioned that earlier. Thanks for the feedback!

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...

Thanks for the heads up. I'll give it a try and let you know how it works out. Thanks again.

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...

I must have been unclear. Users don't have Crystal Reports on their computers. They're accessing the reports through our software using the Crystal Reports Viewer. So they won't have access to Design / Preview modes. Thanks.

That's a good idea; but the answer will always be "no" since the textbox only displays the description of the report and doesn't need to be printed. The flipside is then they won't be able to see the textbox at all when they run the report. I wonder if this has ever come up before...

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...

Thanks for the reply and sorry for the confusion. What was happening is the Fee Amount and Balance due were coming out incorrect. What's happening is we start off with a fee amount. a payment is then made and a balance is left. that balance should now be the new fee amount. another payment...

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...