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: *

  • Users: geestrong
  • Content: Threads
  • Order by date
  1. geestrong

    Subreports - how many in a report

    Hello, Crystal Report XI and Sql Server DB I have about 27 individual reports that need to be consolidated. Is it possible to place all these reports into one? Thanks
  2. geestrong

    Suppressing Quarters if not completed

    Hello I am using Crystal Reports XI and Oracle 9i database. I have created a report that is grouped by quarter. I am using two parameters(StartDate and EndDate). My Team Lead wants the report to suppress the quarter (i.e. 3rd Quarter) because it does not end until 9/30. I will place the...
  3. geestrong

    Folder labels

    I am using CR XI Oracle 9 DB Is it possible to import Avery Label Templates into Crystal Reports and if so where would the template be referenced? Thanks
  4. geestrong

    How to suppress this criteria?

    Hello, I am using CR XI and Oracle 9 DB I trying to figure how to suppress this criteria correctly. There are applications that come in. Based on the type of application, they go to certain agencies (ie Application Type 1 may go to agency1, agency2, agency3, agency4 or Application Type 2 will...
  5. geestrong

    Issue trying to sort on formulas

    Hello, Using CR XI with Oracle 9 I am trying to sort on two formula values. One formula (a running total) calculates the number of times an application has been put on hold and the other formula calculates the number of days the application have on hold. I am unable to use any of the...
  6. geestrong

    Dynamic Titles using the Report Title Special Field

    Hello, I am using CR XI with Oracle 9 DB. Is there a way to modify the Report Title special field in the Documents Property to append mm/yyyy date format dynamically? Thanks, Greg
  7. geestrong

    Restarting Schedule reports

    Hello, I am using Business Objects XI/ Crystal Reports Server XI. There was a networking issue and the scheduled reports did not run. I have log on to the server. In the Central Management Console, I selected the reports(33)and pressed the RUN NOW, and only one instances of the report runs. Why...
  8. geestrong

    Help with Increment counter.

    Hello, I am using CR XI and Oracle 9i I have been trying to get this counter correct. There are jobs that are approved or on hold. The analyst wants to count jobs that where on hold the previous month(i.e. Decement or prior) but may have been approve(January). If the report is ran for the...
  9. geestrong

    Help with parameter

    Hello CRXI with Oracle 9 I am trying to give the user to ability to pick from a drop down parameter list. The issue is that they only want projects that startwith "MP:". In the Select Expert, it is only selecting projects that start with "MP:". In the Parameter creator, I choose Action and...
  10. geestrong

    How to Handle multiple logins for same user

    I am using CRXI and Oracle DB 8 Hello I am trying to figure out how to combine two login for the same employee. There are several users on the system that have two logon. Example Joe Doe as JAD and JDOE log on. The user I am developing the report for only wants to see them one. I need to...
  11. geestrong

    Problem calculating dates from same field.

    Hello, I am using CRXI on Oracle 8 Here is my problem. I am trying to calculate the difference between two dates from the same field. If a Rep has to return a plan back to a customer it is giving a code To Applicant(i.e. agency>APP or agency-CALL) and the date is entered. When a plan is...
  12. geestrong

    The best why to process with this report one date two criteria

    Hello, CR XI and Oracle DB I have a report that will be using two selection criteria and one date range(Delivery Date). The report is supposed look at plans that are ASSISNED and COMPLETED plans within a particular range , usually a month or two, and plans that are PENDING. Pending means that...
  13. geestrong

    Distributing Reports

    Hello, Is there a third party product similiar to Crystal Server XI, that will run reports at a giving time? Security is no issues because the reports will need to run to a specific user printer. thanks, Greg
  14. geestrong

    Conditional Parameters

    Hello Using CR XI on Oracle 8 I am trying to create a conditional parameter that can select a single value or select all the value. I have come across one thread that had code. The thread was vague about where to place this code. Here is my code: If {?agency}<> 'ALL' then...
  15. geestrong

    Dealing with Null Dates (Minimum Function issue)

    Hello, I am using CR XI on Oracle ODBC I am having issue with null dates. Here is the situation. I have to choose between two dates depending on this citeria: Delivery Date and Start Date. One of these dates will be the IN DATE. The problem is using the the minimum function it returns the...
  16. geestrong

    Manual Running total problem

    Hello, Using: CR XI, Oracle DB My issue is that within the Group it is counting the multiple records. I need the formula to only count permit once. here how the data looks now Add# Type Permit Open 3336 (Group1) House number 12345 (Group2) permit number S-CAP CERT - 9Group3) agency "" or...
  17. geestrong

    Formula - flagging a certain group

    Hello, I have a formula that is flagging either YES or NO. Here it is below: @CheckPending If (GroupName ({PENDING_VIEW.PER_ACT_DECISION}) in ['APPR', 'APPR W/C','APPR W/P','APPROVED']) then // Activity Approved 'YES' Else // Hold Open 'NO' Im using this flag to help in calcalutions in other...
  18. geestrong

    Help with Getting median

    Hello, I am trying to get the Median based on certain criteria. I found these formulas on Business Objects website, and I am trying to modify them work for the report. I am using CR XI. Oracle DB. Here are the formulas: Note: the @BackLogResEval is a running total counting the records that...

Part and Inventory Search

Back
Top