Recent content by ccding

Thanks gang !

I am sorry about a second post. I thought of rephrasing the issue may get a clearer understanding. Thank you for your responses in above though !!

SQL Server DB; Hi all, can anyone help me with this SQL Select statement? I have a Srring Array field named: Region. (The array can contain up to 4 elements.) What is the SQL code to select records that are IN a specific region? Example of Current output: CompName Region CompA NA...

SQL Server DB; Hi all, can anyone help me with this SQL Select statement? I have a Srring Array field named: Region. (The array can contain up to 4 elements.) What is the SQL code to select records that are IN a specific region? Example of Current output: CompName Region CompA NA; Europe...

Oh Yes, sorry. Trying to simplify. Yes I tried to illustrate table.field by terming in table1.propertyvalue. ------------

Yes, parameter is created, named: Region. I updated the SQL command to: select cast(table1.propertyvalue as varchar) as Region from table1 where table1.propertyvalue like '%'+'{?Region}'+'%' ___________ Same error. I thought perhaps to change the datatype of PropertyValue to varchar. Though...

Thanks LB. In command my code is: select table1.propertyvalue as Region from table1 where table1.propertyvalue like '%'+'{?Region}'+'%' --- I am then prompted to enter value, however I then get the error: 'Argument data type sql_variant is invalid for argument 1 of like function.' I need to...

Crystal Reports XI; SQL Server DB; I need the T-SQL code to select all companies that are IN certain Regions. Keep in mind that the field, Region, is an array and holds more than one region. EXAMPLE DATA for the 2 fields below: CompanyA Region Comp1 Europe; Asia; Comp2...

Thanks LB. The priority Level field is a VarChar field type.

Actual name for the first Group Field is PriorityLevel.(PrioLVL1, PrioLVL2, PrioLVL3, PrioLVLOther) Then Grouped by CustomerID. Rule of which group the customer appears in : (If customer is in a priority level (1, 2, or 3) then "PrioLVL1" or "PrioLVL2", or "PrioLVL3", else "Other"

That's Great!! I think that will work!! Thank you both for your kind help !!

oh right -- sorry about that one ! Thanks K !

Thanks LBass !!This may be difficult for me to explain in a forum. First Question: There are 2 main groups. Each group is correct. I have a GroupA and if the Customers fall in GroupA..Sort Ascending. Then there is GroupB - Customers that fall in GroupB.. Sort Ascending. But, if Customers...

thanks k - but would I still have the same problem with SubReport 4?

Thanks K for you reply ! Ahh, good point,, however ... If I insert a new section below... then how do I fix the problem when Subreport 3 or Subreport 4 grow to variable lengths? The section with SubReports1, 3, and 4 grow to the necessary length. So when Subreport 4 reaches its end, then the...