Search results for query: *

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!

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

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

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

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

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

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

Actuate BIRT Designer Professional Version: 11.0.4 Build id: 20121023 Select statement - need to retrieve field results based upon two "like" scenarios. E.g,. Select Table1.Field1, Table2.Field2, Case If Table1.Field1 like ('%pass%') then "PASS" If Table1.Field1 like ('%fail%')...

SAP 3.1 Webi Oracle Is there a way to show Crosstab columns when there are no results? Thank you.

SAP BO 3 Webi Oracle I have names that are the same, creating the #MULTIVALUE error in my cross-tab. I have created a variable for Name + ID so results are unique. How do I hide the ID so just the name appears in the report? Thanks!

Crystal Reports 2008 Oracle 11g Notes field contains pattern like "*AB*" followed by a series of numbers and/or letters, maybe or maybe not a "/", a "-", and/or text, inconsistent length. For example: Item, Company AB9000 IDU 1W Item Type, AB9200 Item, Company AB7000S IST w/123H ABC w/o DVD...

Crystal Reports 2008 Oracle 11g If most recent Table.CreationDateField, then show Table.PersonField. Thanks! hmax

Oracle 11g Crystal Reports 2008 How do we determine, on the database, which reports are calling a particular View, please? Isn't there a job that can be run to provide this detail? Thank you, hmax

Crystal 2008 Oracle 11g Hi: I need to capture the following ... Last Month First Full Week (Mon-Sun) or part thereof Last Month Second Full Week (Mon-Sun) Last Month Third Full Week (Mon-Sun) Last Month Fourth Full Week (Mon-Sun) or part thereof Also, This Month First Full Week (Mon-Sun) or...

Crystal Reports 2008 Oracle 11g Hi, I have created a formula to retrieve Group results for @SiteType (5 results). I now need the results to show in a specific order, rather than defaulting to alpha sort. How do I do this, please? Thank you.

I need to create a formula that captures the following: {table.field} >= datediff({table.fieldA},{table.fieldB}) where the datediff result is a range of 2 days before and 2 days after. Thanks, hmax

Crystal Reports 2008 Oracle 11g Notes field contains, e.g.: "Person Name:John Company Name: CompanyABC Call back number: 999 999 9999 Site ID: XYZ1234 Begin Time: Description: This is what happened Open Hours: 5:00am-12:00am 3:54 PM 3/30/1930 took this action 4:02 PM 3/30/1930 took...