Search results for query: *

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

CRXI; SQL Server; I have a main report with about 4 subreports. How can I place SubReport1 above SubReport2 without having the items in SubReport1 overlapping into the place of SubReport2. (Without inserting a new section) ?? I have 'Can Grow' for all SubReports; Sample Report: SubReport1...

Hello, problem with this formula.. The formula above worked very well until it has reached page 30 (out / 56 pages). Then I received an error of a character limit exceeding 65 thousand... It would only generate data up to page 30 (when it reached the limit.) Thanks again. c

Thank you so much gentlemen !! Well, This one is really bugging me, as I am sure it is the programmer and not the program. I have used the code above like this: whileprintingrecords; shared stringvar Phones_Title; Phones_Title:={@PhoneNumbersAndRole}; Phones_Title I put this formula in the...

yes, there are many more fields on each subreport or main report. I wanted to keep the forum as easy as I could. I wish I could add the contacts to the 1st subreport. However, the 1st subreport can have several different types of levels. Being that it is grouped by level - then my records...

Thank you All for your help. Here is what I am working with: Main Report: This report has the CompanyId and CompanyName. I have these fields in GH1. Subreport1: This report has information on the Contact related to the CompanyrID. It contains the ContactName, ContactLevel (Level1...