Search results for query: *

Hi, I have some reports that are too "heavy" and they take long to generate when big periods of time are given to them. I'm running this reports when the users need them but eventually there will be a program where users will be able to run the reports without asking me to do it. The thing is...

I have this report that prints a list of documents (most of them invoices) on a given period, ordered by a reference number (refnbr). Now they want me to print on the Page Header a legend like this: "Documents from refnbr1 to refnbr2" where refnbr1 and refnbr2 are each the first and last...

I have several reports made in CR9, I Changed the datasource to OLEDB (ADO) for SQL Server (I used ODBC before) and then, on another computer with CR9 installed, every time I open a report and try to preview it, I'm prompted for the OLEDB type (I have to choose again SQL Server), the server name...

Hi! I have a server that runs under W2K and SQL Server 2000. I have a job that creates backups to a tape and it was running fine until recently when it started to fail with this error: The job failed. The Job was invoked by User PNL\Administrador. The last step to run was step 1...

Hi, I have to make a report of all the articles that didn't have sales on a given period of time. Each article is located on different sites: InvtID Site QtyAvail art1 1 311 art1 5 0 art1 6 0 art2 2 500 art3 1 450 The sales are grouped also by site like this: InvtID Site Date art1 1...

Please please help!! I have a stored procedure that inserts records on a table based on the records inserted on a table from another DB. It executed from a VB application. Inside the SP I declare a cursor like this: DECLARE LINES CURSOR FOR SELECT MESTR_FOLIO, PRSTR_COD, MPINT_PARTIDA...

Hi, I have a SQL Server Stored Procedure for a very complex select statment which involves the union of 3 select statements. The query result for a 10 days period is between 50,000 and 80,000 records, which I have to group and sum (I do that on CR). Everything is fine except that when I run...

Hi! I have a report on CR 8.5 with 3 groups. On group 1 I set the "Reset page number after" on so the Page Number would reset every time a new group is printed. I wanted the total fields to print everytime at the end of group 1, so I placed them on the Page footer instead of placing...

Hi! Please Help! I'm using the RDC component on VB6, when I launch my report the first time it runs ok, when I call it a second time I get this error -2147417848. Here is my simplyfied code: Option Explicit Dim pedidos As New CrystalReport1 Dim lConnCtrlPed As ADODB.Connection...

I'm modifying this report which has become very complex. My user has made me modify it lots of times since he always finds some calculation wrong. It worked fine until he told me he rather prefered it grouped by article id (which was on a details section) instead of order number, which was...

Hello! I'm using this line to print and save current time: vlSHora = Str(Time) It gaves me a string like: 09:53:54 p.m. What I need is the 24 hour format (I've read that I can do that with short time). I need the hour to look like: 21:53:54 I can't seem to find a way to...

Please please! someone help me... I have a report for an invoice. I need to print at once 4 copies of the invoice marking each copy as "ORIGINAL", "CLIENT", "ACCOUNTING", "FILE". I did this creating a blank report and then inserting 4 copies of the...

Hello, I have a DB in SQL Server and one in Access. My problem is that when I sort records in Access, Access uses a diferent way to sort in a manner that the records look like this: ACEIMPVERLASERCTA ACO000OFSM553 ACO000OFSM-553 ACUC06BACCARTON When I sort the same records using SQL...