ashrobo

this doesn't work, what i got to achieve is to put the total quantity on the first line of the items.

thanks hog, i'll try that soon (after i clear the mysterious bug that i had introduced when messing around the report) :)

i've tried printing a crystal report to a dot matrix printer and it works fine..

try adding a XML Schema (NOT XML File), you should be able to drag the table over now. -ashrobo

i've generated a running total (DeliveryQty) for my report but i cant get it to display the way i wanted it to. DeliveryQty = Sum of Quantity of the same item with different PONo here is the pic of the report that i currently have now.. columns: ItemNo LotNo PartNo PONo Quantity DeliveryQty http://lyfe.dysorder.org/work/report.gif for the first row of Item 1, the DeliveryQty (the rightmost row) should display just 20,000, instead of 18,000 and 20,000. this is what i've designed to get the above image, after reading the MSDN.. http://lyfe.dysorder.org/work/report%20design%20copy.gif all help will be appreciated! -ashrobo p/s: hope the pictures are useful..

a search in google can get you a couple.. here's one http://www.yesky.com/20011018/jt-2001-10-18-6-image001.gif

a name that says it all.. watch the printer

really? i could just drag the table over without any errors..

urmm, i am able to display the invoice headers based on the steps that you've listed out, Madz.. it's the Invoice Details that are not coming out now.. fields such as "Invoice.InvoiceNo", "Invoice.InvoiceDate", etc are fine. however, if i add the field "InvOrders.ItemNo", the error will occur but if i add the field "InvOrders.InvoiceNo", no error. :confused: -ashrobo

in fact, i only managed to get it going after following Madz's steps.. hog, i thought Madz's steps were similar to yours. he has a XML schema file while you have a dataset and dataadapter. thanks guys/gals, - ashrobo

a million thanks to you, madz.. :) finally, i'm able to create a report for 1 record. now the problem is the "details" which in my case, is invoice details, cannot be displayed. i dragged the field "itemno" down onto the report and when i run it, i get "query engine error". - ashrobo

i'll be more than glad if someone bothers to suggest efficiency improvements for my program.. -ashrobo

i tried it but it didn't work as i thought it would.. when the crystal report viewer was loaded, it loads the crystal report which in turn asked me about the logon details. any clues? -ashrobo

thanks a bunch, hog! but how do i add the dataset's fields into the report? -ashrobo

sorry for digging up an old thread. whizkid123, i'm facing the same situation as you. have you managed to solve the problem? i've looked at the example but it's a tad simple.. -ashrobo

piggybacking on this thread.. do we have to add the dataset and dataadapter from the toolbox or can we declare them in the code? really confused now.. :-\ -ashrobo

ah, okay.. i didn't know the allocation was not enough..

quoted from http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcn7/html/vaconstringlength.asp In Visual Basic .NET, you cannot declare a string to have a fixed length unless you use the VBFixedStringAttribute Class attribute in the declaration. You declare a string without a length. When your code assigns a value to the string, the length of the value determines the length of the string, as in the following example: Dim Name As String ' ... Name = "Name is now 30 characters long" ' Length can be changed later.

and i did a silly thing.. my own form has the same layout as the inputbox. :rolleyes: -ashrobo

i have 256MB RAM and the paging file size is 192MB-400MB.

just something to add, i am using a lot of self created sql statements, and putting the data into datareaders. when i need to save the data back, i create more sql statements.. will this in anyway affect the performance? any clues? -ashrobo

i've found another piece of code that does autocomplete. :)

i kept getting the lack of virtual memory error message. could i be coding the wrong way all along (i.e. hogging memory throughout the program) ? i haven't got any clue on how to solve it.. :confused: :( -ashrobo

hey rainesv, i am currently trying to get the autocomplete combobox working. what is DB.tblNameRow used in the code? Dim recName as DB.tblNameRow -ashrobo

roger that.. ;)