Search results for query: *

and to Bong, Thank you again for your help in this matter. I really appreciate when a person offers a possible solution. In this case it was exactly what I needed.

Dear SkipVought, I'll just assume that you don't really know how to read or comprehend words on a page. If you did, you would recognize that I did thank Bong for his post. Furthermore, what business is it of yours. You seem to be all in everyone's post without ever offering anything of any...

Thanks Bong that worked like a charm. do you know if there is a function that I can use to remove the blank rows that are left behind.

Also if you read the original post it clearly states "What I need to have happen is that Choice 1, 2, and 3 should appear on row 1 in the same column because those options are apart of that requirement row." I also answered the question in my reply to your initial reply "The data is...

The three values need to be in the one cell because it is a part of the requirement. 1 requirement should not be split accross multiple rows. Are you able to recommend a solution for the issue? Is something that can be accomodated in excel via VB code or macro or not?

The data is software requirements. The three choices are merely a part of the requirement. that should be displayed in the same cell for row 1 and column 3. Yes this is the only data in the sheet. There are additional informational columns but this is the jist of it. The additional columns...

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

thanks madawc, I had thought about that and modified the caluclations to use rounding but the problem persisted. After hours of troubleshooting and research I learned that the JRC does not support original order sorting for group which is what I was using. Once I remove the original order...

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

thanks LBass. This is working perfectly

The selected time interval doesn't necessarily relate to the date. The end-users just want to have the ability to select pre-defined ranges of dates that they can select quickly with out entering the range manually. They also want to be able to at times go out side of the pre-defined ranges...

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

nevermind, I figured it out. What a long way critical thinking goes. I figured I just needed to use a weighted average. This gives me exactly what I need.

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.

thanks kskid! works like a charm

am I creating 2 formulas or just the one?