Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. azaveri

    Running total inside of a Running Total?

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

    Running total inside of a Running Total?

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

    Oracle Stored Procedure and Crystal Reports - Need Help

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

    Simple Date Question in SQL

    fantastic! Thank you!!
  5. azaveri

    Simple Date Question in SQL

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

    How to print multiple copies of the same report

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

    How to print multiple copies of the same report

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

    Dynamic OLE Object Doesn't Display in Viewer

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

    Dynamic OLE Object Doesn't Display in Viewer

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

    Display a textbox but don't allow it to print

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

    Display a textbox but don't allow it to print

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

    Display a textbox but don't allow it to print

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

    Fees Paid -> Balance Due

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

    Fees Paid -> Balance Due

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

Part and Inventory Search

Back
Top