Search results for query: *

Thanks, that simple trick did it.

Hi, I'm using CR 2011. I have a table containing a string field with comma separated values. Data could look like this: RecordString 1StringA 2String A, String AB 3null 4StringAB 5StringB I want to suppress all records where {Table.String} contains 'StringA'. I can't use 'StringA' in...

Hi, I'm using CR developer 14.0.4. I have a free text field in my report. There is text imported to the field multiple times and these inputs are delimited with a comma. Aaaa, Bbbb, Cccc However, most of the time these text inputs are just a copy of the previous. Aaaa, Aaaa, Aaaa So my...

Hi, Using Crystal report 2011 I need to link two views by one field. The field type however is different in both views, so I am not able to link them. I have VWSCHEDULEVOLUNTEER.VOLUNTEER_KEY with numbers from 1 to ... I have VWSRVOLUNTEERDEMOGRAPHICS with strings like VRN-1 to VRN-... I...

Thanks MCuthill, I tried your second approach another time and it seems that I did something wrong the first time as it was working fine. (Only MAX should be MAXIMUM) I did the same to become the first user (MINIMUM). greets

Hi, Thanks both for the reply. MCuthill: it seems that I'm indeed getting the Maximum {Table.Date} in the group footerbut not the corresponding Status. Lbass: I was getting there using your formula. However an other problem was raised. The report is to be viewed by the person(s) who...

Hi, I'm using CR developer 2011 (version 14) I have a database view with query information. I have made a group for each query number. In details I have the following fields: {Date}// The date a change has been made {user}// who made the change {Status}// Query status [OPEN, ANSWERED, REISSUE...

That is working fine. I had to add IF isnull({Exclude_from_period}) then 0 because is has some null values in it. And then the event wouldnt show up. Thank you Nils

Hi, I have a reportdesign like this: Group 1 {Period} Group 2 {Event} Details {Exclude_from_Periods} A period can be numbered from 1 up to .... Every period has multiple events. These events can be excluded for 1 or more periods. But all events will always show up for each period. It could...

It seems now that I did not explain well. What I want to copy are not only values but is almost an entire report. Using headers, several groups and details. So I figure I will not be able to do so in a crosstab. I can't use subreports either if that would be a solution. because I might add a...

Hi, I have data which I would like to see repeated for several periods. I only have the maximum number of periods (as a data field). How should ik copy the data the number of times I have. for instance with the next data: Value1 Value2 Value3 Max n° Periods= 2 I should become: period 1...

Hi lbass, Sorry for the late reply. I'll try to make it more visual what I want to do: I have two tables. The first one containing a field called {Panel} and a field called {test}. In a report it would like this: Group: PanelA Details: test 1 test 2 test 3 Group: PanelB...

Is there a way that I could make an array that contains all the values? Nils

Hi, I need to split a string into multiple fields. The string contains multiple values and looks like this: {String}: Value 1, Value 2, Value 3, ... The maximum number of values is pretty much unlimited but I had never had more than 5 values up to now. How can I split it looking like this...