Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nilsbinnemans

    Compare against all single values of a comma delimited string

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

    Remove duplicate substrings out of a comma delimited string

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

    Inlude a formula in sql command

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

    get the wright value in group header or footer

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

    Suppress when Group 1 is not in detail field values

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

    Repeating details X times based on a max (=x)

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

    Split String with X values

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

Part and Inventory Search

Back
Top