Search results for query: *

Pete, thanks for helping me out again. The formula works and gives me the last two full months when I put it in the Report Selection Editor with one change to get two full months of data. When I incorporate this into a formula to get an try to get a distinct count of records for the full...

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

Pete, Thanks this solved the problem. You helped me out with a similar one of these about a month ago and I thought that would work here. Both of these are being used in Sub reports. I appreciate the assistance.

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

Thank you Pete. This worked.

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

Pete, I think you are on to something here!!! I kept thinking it was a fault in Crystal. I'm using Remote Desktop to work on a server and I do have a separate monitor connected to my laptop. I'm finding that moving the mouse around to different areas in the Sections Area gives me...

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

Thanks LB. Worked perfectly.

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

Thank you LB. Worked perfect.

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

Perfect. Thanks Pete

Pete, It worked perfectly. What is the [/li] supposed to do or is this a reference? I did not include this and it worked fine. Thank you Ed

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

Skip, Thanks for clarifying that for me. I erroneously was using CSV as a general term. My export indeed needs to be just a text file full character spacing only.

Thank you for the help. It works great.

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

Pmax, Thank you. That solved my issue.

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