Search results for query: *

Example: I have data that is being exported from a requiremnts management system into excel. the problem that I am up against is as follows column1 column2 column3 Req ID Author Requirement row 1 FR123 JUser There are 3 choices row 2...

Crystal 11 I am attempting to created a backlog report that captures the following Created Closed Backlog 1/1 10 5 5 1/7 15 10 10 1/14 20 25 5 The report is grouped by opendate. the problem is that I need to be able to add...

Crystal XI IBM DB@ JRC 2.0 We are having a strange problem with sorted columns and grouping when rendering reports in CR4E (v2.0) on IE 7 with reports created by Crystal XI. Basically, when certain columns are selected to sort in the parameterized view(the sorts are parameterized group...

Crystal 2008 DB- SQL I have a field called 'FiscalYear' the field type is number. I created a parameter based on this field but when the parameter is displayed the year shows as 2,008 rather than 2008. I have changed the Report options number formatting to display without the thousands...

Crystal Reports Dev. v11 IBM DB2 I have a report where I need to give the client to select the date ranges in 2 different ways. The first way is a predefined date parameter: {?Time Period}- the values are 'day', 'week','month', or 'year' They also want to have the ability to select a...

Crystal XI IBM DB2 I am trying to test for duplicate values and then perform a count, however when I try to summarize the formula that i created, I get an error that the field can not be summarized. The formula I created is below sample data ID Pax Time @duplicate 1A 23y 10:05 1...

Crystal Reports XI IBM DB2 I am trying to create a formula to calculate an average from which I can graph from base on 2 time fields on change of urgency. I cannot use the built in summary options because there was a need to eliminate duplicate data at the report level. example...

Crystal Reports Developer v11 IBM DB2 I have a field that has unwanted characters in the string. I want to remove those unwanted characters. ex. The field value= lbzds01:TEP I want to remove everything after the colon.

Crystal Reports ver 11 IBM DB2 I have a Timestamp field that is in string format. I need to convert to a date time example 10810021400000 should be 10/02/2008 2:30 PM please help

Is there a way to update a field on a form with the current time based on the value of another field. I have a field called [Status] and [DateDelivered], I need the [dateDelivered] field to be updated when the [Status] field changes to 'Complete' I've tried to make an expression that reads...

DB=IBM DB2 Crystal Reports Developer v11 I have a field that stores values for various properties and those values contain both numeric and string values. I need to perform a calculation of the the numeric values and also return the string values as well I've been playing around with a...

Sorry for posting 2x but there is additional info. Crystal Reports ver11 DB-IBMDB2 I have a report that I need to display 3 values for by ServerName. Currently the report looks like: Server-LBDDEV25 Resource Property Value Partion0 freespace 37 Partion0...

Crystal Reports ver11 DB-IBMDB2 I have a report that I need to display 3 values for by ServerName. Currently the report looks like: Server-LBDDEV25 Resource Property Value Partion0 freespace 37 Partion0 totalspace 64 Partion0 mountpoint...

Crystal Developer ver 11 DB-IBM DB2 ----------------------------------------------------------- I have 4 columns base off of the date field in order to get 4 columns, 1.day, 2.month, 3.week, 4.year The formulas that populate these colums look like the following. if {startdate}...

Crystal Developer v11 DB-IBM DB2 I have a parameter that allows the user to select the column that they want to sort the report. Is there a way to allow them to select the sort direction as well. Right now all of the sorts a being sorted descending and I need to allow the functionality of...

Crystal Report XI Developer Database : IBM DB2 I have a report that has 3 on demand subreports that I have created parameters for.Then main report is a summary report and the sub reports provides details. When I refresh the main report, It displays all of the parameter values for each sub...

Crystal Reports XI DB-IBM DB2 I have a report that has an on demand sub-report. I would like to be able to give the user the ability to sort the sub report based on the field heading. The report is designed so that if the end-user clicks the Day(on demand sub report) the details for the day...