In my report in section Details I use a formula field like this:
NumberVar A := A + ..Any Calculate..
it work great and another formula field in Report Footer with this:
WhilePrintingRecords;
NumberVar A;
and it work's!
How I get SubTotals in my Group Footer #1 from formula field in section...
with DAO, I want to save and read pictures.
I use this
CommonDialog1.Filter = "Bitmap (*.bmp)|*.bmp|Jpeg (*.jpg)|*.jpg|"
CommonDialog1.Action = 1
Image1.Picture = LoadPicture(CommonDialog1.FileName)
<< this work great >>
.......
<< but, when run this >>
MyDS.AddNew
MyDS!YourPic =...
I send a variable string from VB6 to a report made in Crystal 8.5
when I do this send me this message
"The matching " for this string is mising."
help me to fixed!!!
I have Win2000 and Panasonic Printer KX-P1150.
I'll have to print a voucher with this dimension:
width = 9 inches or 22.86 cm
heigth = 5.5 inches or 13.97 cm
I create a custom papersize in "Settings\Printers" on Windows, but, when I use in VB6
Printer.PaperSize = vbPRPSUser...
I use CRW 8.5
I have 2 tables in my report
TABLE 1 TABLE 2
ID ID
DATE DATE
ORDER ORDER
NAME AMOUNT
... ...
Links are (ID, DATE and ORDER), my report use all fields from Table2 and field NAME from Table1, when I do a preview, field NAME is blank.
How...
When I do
"SELECT SUM(Table1.Field1) as VariableSumField1 " _
& "FROM Table1, Table2 WHERE Criteria"
this work great!
Now I want use other fields from both tables. I try this
"SELECT SUM(Table1.Field1) as VariableSumField1, " _
& "Table1.Field2...
When I do this:
WhilePrintingRecords;
Numbervar Total:=Total + sum({field},{Group})* if sum({field},{Group})>120 then .01 else .02
Send me the follow error message after asignation
"A number is requiere here"
My formula simply multiply a sumarize field for 0.01 if sumarize field greater than 120 and multiply for 0.02 if sumarize field less or equal than 120.
I want totalize this formula field. How I do?
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.