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

    Count Formula with Group

    CR 11.5 I need a method in Crystal (perhaps a formula) what will produce the same number of records that my below SQL statement does: ----- select caseid from schema.view where status = 4 group by caseid ----- Basically, i want a total count of 'caseids' with a 'status' equal to 4. The records...
  2. rbh123456789

    Field not displaying all of the string

    CR 11.5 This is really strange. I have a view that i am working with in CR. This report is very very simple. I essentially started with a new report, and brought in my view. The issue i am facing is that a certain field (string) is being cut off at the last few characters. I have already...
  3. rbh123456789

    adding missing dates to a range

    CR11.5 I have a View that looks like this: User | eventtype | date user1 | sickday | Dec 1 2011 user1 | meeting | Dec 1 2011 user2 | vacation | Dec 3 2011 user3 | | user4 | sickday | Dec 1 2011 this report is supposed to: -list each user -display the event -display...
  4. rbh123456789

    Passing Parameters to a Stored Procedure

    CR 11.5 and SQL Server 2005 I have a Stored Procedure located on our database. I created a new report, and through the Database Expert, added a 'Command' as: EXEC [DBO].[GetAvailabity] @Start_Date = N'2012-09-06', @End_Date = N'2012-09-07', @Period = N'AM', @Name = N'ALL' The report will...
  5. rbh123456789

    Show Individuals NOT in criteria

    CR 11.5 I have 2 tables: 1) out_of_office_table 2) vacations_table 3) staff_table The out_of_office_table has a list of out of town events that are booked. the tables contains a unique ID for each entry, start date, end date, and the person who is away (1 person). The vacations_table has a...
  6. rbh123456789

    Logic when displaying a date through formula

    CR 11.5 I have a formula (thanks to lbass in this original post, http://www.tek-tips.com/viewthread.cfm?qid=1645788) which creates a preferred hierarchy of dates, shown below: //This formula checks to see if date1 exists, if it doesn't date2 is shown, if date1 and date 2 are null, date3 is...
  7. rbh123456789

    Calculate Percentage with Running Total

    CR 11.5 I have a crosstab which the columns are summarized by a date(month), and there are 2 summarized fields 1. Number of Applications Received //the CT performs a DistinctCount on the CaseID (aka ID), which tells you how many applications were received 2. Number of Applications...
  8. rbh123456789

    Formula to SUM distinct records

    CR 11.5 //@formula if isnull({temp_rep_app.represent_TYPE}) then 1 else if {temp_rep_app.APP_ID} <> {temp_rep_app.REP_ID} then 1 // The above formula contains the logic of which records i want to qualify for the count. Each of the records have a CASEID, which is the main link between all the...
  9. rbh123456789

    Group On One, Sort on Other

    CR 11.5 I have a bit of an issue right now. I'm pretty sure i know the answer, but need a fresh perspective. Currently, I am Grouping my date on some CaseID's. The problem is that i need to order the records by the Date field of the record. There are multiple dates per CaseID. I am using a...
  10. rbh123456789

    Show 'This date' if 'other date' doesnt exist

    CR 11.5 The subject line kind of summerizes what i need to do. Essentially: I have 'Order Date', 'Delivery Date' and 'Installation Date' dates that I am working with. Some records have orders with an Order Date, wbut ith no Delivery or Installation Date. Some Have an Installation Date without...
  11. rbh123456789

    Grouping Formula

    CR 11.5 I am trying to accomplish something that is easy in theory, but is proving to be very difficult. - i have a group - that group is grouped by individual - inside that group i have a summary COUNT to calculate how many Cases each person is assigned to What i want to know is 'of those...
  12. rbh123456789

    DateDiff Help

    CR 11.5 //MyFormula located in the Details section DateDiff('y',{View_2.CLOSED},CurrentDate) This formula calculates the difference between the two fields, and displays the results as a number. When the MyForumla equals 365 and above, i want want Years to be displayed, followed by the days...
  13. rbh123456789

    Export to PDF - Hyperlink

    CR 11.5 I have a report which conains a field in the db table. This specific field contains the path to a document on our file server (P:\Public\Document\UniqueDoc1.doc, P:\Public\Document\Unique2.doc, P:\Public\Document\Unique3.doc etc) I inserted a hyperlink on the field. When i export to...
  14. rbh123456789

    Resize Field by Condition

    CR 11.5 I have no idea whether this is possible or not. I have searched through Google and couldnt find any solutions. My report has a {?param} which suppressess/shows a specific field (field A). I want the field next to field A to expand horizontally to fill up the area in the report when...
  15. rbh123456789

    Multiple Columns

    CR 11.5 I have a report that has one field in the details section. There is lots of data, so the report ends up being over 200 pages. How do i format the report so i can have that one field changed from this: 1 2 3 4 5 6 7 8 9 to this: 1 4 7 2 5 8 3 6 9
  16. rbh123456789

    Parameter Searching 2 Columns

    CR 11.5 Hello all, The below Record Selection statement works perfectly well. However, i want the {?respsearch} parameter to query the{view.respname} column, AND an addional one named {view.othername} What would the syntax be? ( ( {?compsearch} <> "" and {view.compname} like "*" +...
  17. rbh123456789

    Can Grow Subreport

    CR 11.5 I have a subreport which contains a crosstab in the report header, which spans 2 pages in length. When i view the subreport through my main report, it does not expand, and i cannot see half of the supreport. The 'Can Grow' option for the subreport in the the main report is checked...
  18. rbh123456789

    Record Selection Formula

    CR 11.5 //This is my record selection forumula {RPT_R_MONTH.PreviousDate}<= {?date_end}; {RPT_R_MONTH.ID} <> 432; There is a record (432) that i want to exclude from Crystal. When '{RPT_R_MONTH.ID} <> 432;' is in the formula, it stops the '{RPT_R_MONTH.PreviousDate}<= {?date_end};' parametre...
  19. rbh123456789

    Parameter with Wildcard?

    CR 11.5 Hey guys, Here is my record selection formula: if {RESPONDENT_LOOKUP.respname} = {?respsearch} then true; What happens: When i am prompted with the {?respsearch} parameter, i would type in, for example, City of Toronto or Microsoft Inc. The search results bring back the EXACT...
  20. rbh123456789

    Limiting a Duplicate Record

    CR 11.5 Hello, I have a crosstab which counts the number of records with a value of '3' for each month (3 represents a string in another table) If there are 3 records in a month with a value of 3, then the CT will display '3' for the month. Is there a way to limit Crystal to only pull a...

Part and Inventory Search

Back
Top