Search results for query: *

CR 2016 SQL Server I am extracting phone numbers from a text field. The phone numbers are in varying formats with spaces, dashes, slashes, etc. ExtractString function works most of the time but sometimes there will not be a specific character following the phone number, so there would be a...

CR 2016 SQL Server I'm writing a report will I will have two columns of summary line items of the last two complete months I'm using lastfullmonth for "last month" or I can also use this: {date_field} in datevalue(year(currentdate),1,month(currentdate)) to currentdate-day(currentdate)...

CR 2016 SQL Server Trying to only display groups with more than one report number I am reporting traffic accidents in a city based on the number of accidents by location Most locations only have one report for my time period. I do not want locations with only one report to display Each...

Using CR 2016 SQL database Trying to show 4 or more arrests per person. Dataset is comprised of booking records of arrested individuals over a two year period throughout the whole county. There are over 1 million arrests per year in this county. Some people have 50 or more arrests. Most have...

Crystal Reports ver 2016 Applies to all data sources Windows 10 This has been an ongoing issue. It used to resolve itself by closing all reports, and restarting Crystal. Now it's permanent. In the Sections Area to the left in both Preview and Design, when right clicking a mouse, the menu...

CR 14 SQL Server I'm working with street addresses. Need to remove apartment numbers if one exists. # precedes an apartment number. example: N MAIN ST #A I need to remove # and everything afterwards. My formula removes #, but I'm not sure how to get rid of what's to its right...

CR 11 Oracle Server I need to compare values this year YTD though last complete month to the same period last year. I'm having trouble writing the date range formula for last year. I would need it to cover LastYearYTD to the last day of the matching complete month last year (13 months...

CR 2011 Oracle DB I am counting police incidents (or calls). Lets assume there are 1000 incidents in a one month period. My cross-tab rows are hours-of-day increments so there are 24 rows. A formula counts how many calls fall withing an hourly time period. 00, 01, 02, 03.....all the way to...

CR2011 SQL db I need to export a text field for use in a CSV file that is fed into another databae. It needs to be 38 characters. Easy enough using left({Permit_Main.DESCRIPTION},38) However I need to fill in with character spaces if the field has less than 38 text characters. Can someone...

CR XI I am trying to set the TopN in the Group Sort Expert to return the top 5 records with ties. But I don't want groups with single records (or counts of 1) because there are several of these. In other words I want group record counts greater than 1. Can someone suggest a formula that...

CR XI, ODBC Oracle db My report is grouped by a Case Number, followed by details. The case number is a 9 digit string which looks like this 120012345. The first two digits represent the year. Creating a parameter and placing it into the report selection editor where the user simply enters...

CR XI Oracle DB ODBC Novice user. I am looking for a solution to cut down on the number of formulas I am creating for a manual cross tab. I am using a manual cross tab for this because I need Monthly side-by-side columns for the current year and last year. I also need to format this table for...

CR11 ODBC Oracle I created a manual crosstab and drew lines to create rows and columns It seems that every time I make on of these, the lower right corner will be white where the lines intersect. It seems like CR wants to leave the curser there. I am not using boxes, just lines. Any...

CR 11 Oracle db I want to limit selections in my dynamic drop list to only names associated with a specific case number. I am using two tables for this report. For the purpose of this thread I will call them Table.case.information and Table.InvolvedPersons. The common field is called...

CR XI Oracle DB Problem: I have a field that is calculated in the db to create what is called a split dateTime. This is calculated from two other fields StartDateTime and EndDateTime. The ranges between these fields can last several days. When I try to use the split date time (in...

CR XI Oracle db SQL syntax experience = weak Crystal syntax experience = competent I am trying to write a SQL Command with a union to combine a two similar fields from two tables. I need both fields in one table for my report. The field is called charge (which contains various arrest charge...

CR XI Oracle db For this question I have four non-numeric fields {Incident_Number} - unique ID for each incident {Level} - level of incident is F or M {Employee1} Employee ID number {Employee2} Employee ID number I am creating a report that will tell you how many F and M incidents...

CR XI I have a date field that has numeric formatting (something a dba did in another dept). The dates look like this: 20100922 Can someone give me a formula to properly turn this into a date field in CR until I get the dba to change it. Thank you.

CR XI Oracele db I have a report that determines if an employee handled one or more calls during a period of one day. Basically this determines if they were at work as they always handle at least one call during a shift. A distinct count summary is grouped by employee ID. The summary is...

CR Ver 11 Does anyone know if there is a keyboard shortcut available to open the Record Selection Formula Editor? This would be rather than making three mouse clicks to open it via: Report -> Selection Formulas -> Record.