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)
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
------------------------------------------------------...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.