Search results for query: *

Reebo, As you mentioned earlier, this worked well if the Total length of all DetailLines ( in yr example SetVar) is less than 255. wait, I think I got the solution. Put the child columns in a sub report and place the subreport and remarks column of master table in Group footer of Receiptno...

ItemNo - Integer 4 Description - Varchar (100) Qty - Decimal (9,0) Wt - Decimal (9,2) Number of items per receipt between 1 to 10 and Remarks - Varchar (200)

Thanks for the reply, I am using CR 8.5

Customer Name, Receipt no, Remarks are part of master table. Item No, Description, Qty, Wt are part of child table. Due to existing pre-printed form, I want/have to print Remarks next to the details as shown below. I have to format the remarks as Can grow - unlimited. The problem is: It is...

replace @dt with the column nameselect convert(datetime, substring(dt,4,2) +'/'+left(dt,2)+ '/' +substring(dt,7,2) + right(dt,9)) as date, datepart(dw,convert(datetime, substring(dt,4,2) +'/'+left(dt,2)+ '/' +substring(dt,7,2) + right(dt,9))) as dw from dttbl result is date...

declare @dt varchar(25) set @dt = '20/02/03 02:20:16' select convert(datetime, substring(@dt,4,2) +'/'+left(@dt,2)+ '/' +substring(@dt,7,2) + right(@dt,9)) as date the result is date ------------------------------------------------------...

Since starttime is varchar, rearrange in mm/dd/yy format and convert.

If you know all the AttributeNames in advance (even if you have not used that attribute for a particular object) this may work. select dfl.objectid, max(dfl.sqft) sqft , max(storetype) storetype, max(state) state from ( select objectid, avalue as sqft, '' as storetype, '' as state from oa...

Every time I search the index topic "Code Window" (Code window, shortcut keys) in Visual Basic Documentation VB6, I find 1 or 2 key board short cuts which are very useful.

In Crystal report, go to the Set Location menu and select the table, and remove the database reference to the table. Now this rpt should work either you connect to Database a or Database b.