Search results for query: *

Thanks, kray4660. It's tricky since it's a range. I'm creating formulae, breaking down each piece w/left and mid functions (and of course days could be one or two chars so must allow for that). Just looking for a more elegant approach than mine :) I'll give your ideas a try! hmax

Crystal Reports 10 MS SQL Server 2008 R2 How do I convert a database date range field (format mm/dd/yyyy-mm/dd/yyyy) to display as, e.g., October 24th through November 4th, 2016 Thanks in advance!

NickieP: Thanks for getting back to me. Just reading your response now. Normally I receive an email when a response post appears - unfortunately I must have missed it this time around. Truly appreciate your feedback. I will have to test out the scenario, but as you suggest, it's near enough...

Thanks, Pete! So Crystal Reports 2016 has addressed the issue. Great. Otherwise Ken Hamady's solutions for earlier versions, e.g., creating 2 arrays for codes and descriptions plus a For Loop. Good for fairly short lists; tricky when the list is long, but do-able, I guess. Appreciate the...

The following arrays work for the local report parameter that allows multiple values. 1. //join({?ParameterName},",") //Show list horizontally 2. //join({?ParameterName},', '+ Chr(10)) //Show list vertically However, these only display the parameter default values (matching the codes...

Crystal Reports 10 MS SQL Server 2008 R2. Two Show/Hide Headers are in the main report, grouped by XX. Header 1 shows for page 1 for each new subject in group, else hidden. Header 2 shows for all additional pages for each subject in group, else hidden. E.g., Header 1 Group XX, A subject...

Thanks, Charliy!

Thank you, Ken. Good to know this might be possible in CR 2016.

Crystal Reports 10.05.1609 SQL Server 2008R2 Crystal Reports - multiple drop-down parameter, create new code to group several drop-down codes together. Example: Parameter Multiple drop-down Code Description AA Language A1 TQ Lanugage A2 WR Language A3 SP...

Crystal Reports 10 MS SQL Server 2008 R2 This works when presenting array results for parameter default values: Join ( {?YourCharPrompt} , ', ' ) Is it possible to also include the parameter descriptions along with the default values? E.g.: Default Value / Description A / Andes...

Hi, tomcat24! Thanks for your response. Unfortunately, in this scenario, we are not using stored procedures, but instead Command statements. So, the parameters are created at the Command level, too. Appreciate your feedback.

Thanks, Charliy: That works for regular parameters. Unfortunately, this must be a Command Parameter, so it's a different scenario. Thanks for your feedback, though!

Crystal Reports 2013 Oracle 11g Parameters within the Command statement Goals: 1. Create a parameter or parameters that allow(s) retrieval of (a) results that exist in the values; and (b) results that are like those that exist in the values (wildcard). 2. Parameter entry is optional for...

This works below: I am now able to retrieve, in the Command statement, two parameters with multiple values (both of string type), set as Static parameters. The same table.field is the dependency for both params, {?ProgCode} and {?ProgCode1}. The client manually enters the params (there is no...

Crystal Reports 2013 sp 5 Oracle 11g Crystal Command Parameter Range Dates from Field1 or Field2 For example, Start Date >= Table.Field1 or Start Date >= Table.Field2 and End Date <= Table.Field1 or end Date <= Table.Field2 Can this be handled programmatically to avoid creating 4 separate...

PeterDimitrov, apologies for not responding sooner. Good idea for small LOV, and I'll keep this in mind for such a scenario. Unfortunately, the LOV is large, and would also require manual updates, so I'll have to keep hunting for an alternative solution. Appreciate the feedback!

Charliy, thanks for responding. That makes sense, because "like" will search the pattern in every single instance anywhere within the pattern, whereas "startswith" will only search for those that start with the pattern. However, creating the dynamic parameter at the level of the report (not in...

Crystal Reports 2013 Oracle - using Command in Crystal to retrieve dataset 1. In a dynamic parameter, when we choose to filter on the available values, is there a way to use a wildcard? I've tested in the Record Selection Criteria where table.field = {?parameter} table.field like...

Crystal Reports 2013 Oracle - using Command in Crystal to retrieve dataset 1. In a dynamic parameter, when we choose to filter on the available values, is there a way to use a wildcard? I've tested in the Record Selection Criteria where table.field = {?parameter} table.field like...

No, problem, Dell. Thanks so much for your help!