Search results for query: *

In some cases trip_external_id is only 7 characters, so I would need to incorporate something like the code below in the select case statement. if len({Command.trip_id_external})<8 then {Command.trip_id_external} else left({Command.trip_id_external},len({Command.trip_id_external})-3) How can...

//Command.trip_id_external is a 10 digit string. //For example for the first Case Command.trip_id_external = '2293098000'. //How can strip off the last 3 digits of Command.trip_id_external in the select {Command.trip_id_external} statement below? //I need the trip_id_external string...

How do you automate a report to query records for a specific time interval?

Sorry I meant: I need a report or two reports that is scheduled to run from InfoView at 9:30am and 6:30pm every day.

I need a report or two reports that is scheduled to run from InfoView at 9:30am and 6:30am The Schedule report that runs at 9:30am would only pull records from 6am to 9am. The Schedule report that runs at 6:30pm would only pull records from 3pm to 6pm Below are two forumulas I used to Schedule...

I am trying to get the bottom 5 routes of the attached report based on "Ontime Percentage" I have attached the *rpt file. Thanks for any assistance.https://files.engineering.com/getfile.aspx?folder=aaa29915-9250-4e57-a592-1d1c035af463&file=SummaryByRoute_bottom_5.rpt

IBass this works great!!! Thanks tdr

I could adjust the Date-Time range to query a Maximum of a 1000 records if necessary. Thanks for your help on this!

Maximum number of records would be 5000 records

Thanks Ibass! I don't need to highlight the first row in which it occurs, just the rows afterward. Since I cannot change the sort, how would I use variables to determine whether all the variables on any given row in the data-set recur. Is it possible to flag, highlight, or identify records...

The two records in the attached spreadsheet should be highlighted in Crystal Reports, but nothing is highlighted. Can someone explain?https://files.engineering.com/getfile.aspx?folder=f3d9e931-7e70-462b-af3b-77590cdb1890&file=BRT_Detail_MissingData_040318_v2.xlsx

Thanks Ibass! The formula works now, but it does not highlight any records where duplicates are found.

Thanks Ibass! I went to the section expert->detail->color tab->x+2 and enter a formula with the following syntax: I get the error "A Boolean Is Required Here". What am I missing here? ( If not onlastrecord and {command.transit_date_time}=next({command.transit_date_time}) and...

Using Crystal Reports, how can I highlight any record in a data-set in which several fields within the record is duplicated, but not all fields. For example in the attached spreadsheet the fields listed below are duplicated, but not all fields within the record are duplicated. If the fields...

In my SQL Query Command the Order By clause has the "decode" function. Can someone explain what this function does to the "Sort" below? ORDER BY cmta.vw_headway_data.signid, cmta.vw_headway_data.direction, Route, cmta.vw_headway_data.serviceid, trapeze.linestop.sequence...

LB Thanks For looking into this! -tdr

Details unsuppressed and transit datetime widen. Reports Attached. Thanks Ibass for any help with this.https://files.engineering.com/getfile.aspx?folder=0efe18df-85f1-464a-b6db-a0f2fd554ea0&file=SummaryByRoute_unsuppressed.rpt

Details unsuppressed and transit datetime widen. Reports Attached. Thanks Ibass for any help with this.https://files.engineering.com/getfile.aspx?folder=fb238f78-33d2-4e77-9690-cdf3a9ec7121&file=SummaryByRoute_TimePeriod_notSuppressed.rpt

Did not see the Report by Route attached. Here it is.https://files.engineering.com/getfile.aspx?folder=eb50f681-3871-427c-a992-eb9686155b4b&file=CMTA_MetroRapid_OTP_SummaryByRoute_hdwyPercent_Apr18.rpt

Crystal Reports by Route and by Route and Time-Period are attached. The driving force behind the reports is the Order By/Sort that's built into the "SQL Command". As you can see when I use Group Expert to group by "Peak" this throws the sort out of whack and therefore the numbers for both...