I have an 'Estimate.rpt' as main report, and also i have a subreport 'Note.rpt'
I want to exlude deleted notes from the report. I put in subreport whereclase:
------------------------------------------------------------
WHERE Note.DeletedBy is NULL or Note.DeletedBy = ''...
I display the report in crViewer control, and if you Put the mouse cursor to any text - it displays a code text.
Click on any text - the red frame appears around.
How to hide the frame and code text(it's like tooltipstext in VB)?
Thanks in advance.
One of the our customers has this issue: When he try's to print an Invoice,it will print out the text backwards.
What's might be wrong with that???
Thanks in advance.
I have few invoices for the customer in History Talble In report i need to display only customer with balance due.I group all records by customer ID.Now i can calculate all total for the custome and everything works correct.
The problem is: i can not sort all customers alphabetically.
How i...
I have two kind of customers: 1.Busuness and 2.Personal
in the report Customer List i need to sort all customers by The LastName and BusName.In the report on 'Change Group' I selected Customer.NameLast in ascending.
BUT report dispalay buss customer name(Bob's......) and then
Personal...
the behavior of the report is really viard just yesturday this reports run perfect but totay report crashes.whith the message: 'String Length is less than 0 or not in integer'
i guess i have bug or incorrect data in DB.
What might cause the problem?
thanks in advice...
I need to display every customer record on separate(new) page.I calculate the total payments of the customer using fields from another tables.I need to Suppress whole page(report) and Display just list of the Customers which are appropriate to the business rules.
How i can supppres whole...
I Need to get all customers within DateRange
it's vb app,i use DTPicker to get the dates.
Here is code:
mobjReport.RecordSelectionFormula = "{ERCHistory.CreateDate} in Date(" & DateFrom & ") to Date(" & DateTo & ")"
What's wrong with that?
What's really...
I need to display every customer record on separate(new) page.I calculate total payments of the customer using fields from another tables.I need to Suppress whole page(report) and send to the printes just list of the Customers which are appropriate to the bus rules.
How i can supppres whole...
I need to show Customer with the list belonding to him vehicles.Each vehicle has number of invoices.I need to calculate total of all invoices. that's why i load all invoices for the vehicle, but i need just show one, MOST RESENT Invoice.
How i can select one, most resest invoice, that was...
I need to display list of customers and each of them shoul be printed on own page.I used 'New Page After' to start new page for each cust, and i have last page blank.how i can avoid this issue
thanks for help.
My goal is---- When user closes the report i want him to get back on the same form where he called reports from.
I put crViewer on the same modal form(ListofReports) and tried to use 'crViewer_CloseButtonClicked' method to close just viewer,I set 'EnableClosebutton'property = TRUE in design...
I used crViewer to display report.But i had a problem with
modal form wich contains list of reports.I placed crViwer on another form and when i call method to load the form with a viewer i got a err.message "The Form can not be loaded, because modal form is loading"
what should i...
I put crViewer on the same form where user enters a parameters and after report has been displayed can I close close this report not leaving the container form??
I tried use CloseButtonClicked event of crViewer.I set 'EnableCloseButton' = true in design time,but at run time this close button...
Ivoice has 1 to x payments.I grouped payments by InvoiceID
I want to display the first payment in the same line with invoice info.now it looks like...
InvNumber InvTotal PaymentType AmoudPaid
123 $200.00
Cash $100.00...
I Created report based on two tbls(Invoice,Payment),I need to show Invoice and all payments of the invoice each payment has an invoiceID.In the last Column i need to display Total of Invoice from Invoice table.
If three payments were made for this Invoice I have three records and TotalInvoice...
I created report based on SP, which takes two params,(FromDate ----TODAte)Could anybody give me an example how to send paramenters from vb.
Thanks in advance..
I want to show all customers with their vehicles, grouped by customerID. I'm able to display total of 'ServiceCharges' field( based on group selection) in group footer.But I want to display the total in Group Header, how i can do that?
thanks for any help
here are a steps how i Created report.
open new blank report and in Data Explorer:
1.ModeDataSoure
2.Microsoft SQL Server
3.DiaogBox appeared, i entered Servername and UserId and chouse the database name.
4 Drag and drop fields on the report.
In run time(vb6) I need to relogin to completely...
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.