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...

Hey Lisa :-D! that's great! [2thumbsup] IT WORKS! And it was so simple [surprise]... Thank you, thank you!! ________________ Magda Banuet

no, refnbr is a string field made of a letter and a numeration, by example: A00000123, A00000526 and my report should print on the page header a legend like: "Documents from A00000123 to A00000526" I can print the first record: "Documents from A00000123" but I'm having trouble getting the last...

Yes, with a parameter for the document dates. By example, all the documents from 01/01/2004 to 31/01/2004 ________________ Magda Banuet

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...

When I had this problem, I found out that I got the error when I tried to set the connection password a second time. So, with my previous code posted, I did this: If (pedidos.Database.Tables(1).TestConnectivity) Then 'ok Else Set ConnectionInfo =...

Thanks a lot. I cleaned the tape drive with the cleaning cartridge and the job is executing fine... [ponder] :-D ________________ Magda Banuet

I can start the job from QA but it fails with the same error. ________________ Magda Banuet

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...

I don't link them because I would have a very complex statement (I do a lot of filtering on each separate select) and I prefer simple and fast queries vs huge join statements that sometimes doesn't return the result I expect it to or takes too long to run for the number of records I have to...

I definitely think it is a better solution and easier to understand (I found the cursors to be a headache when trying to fetch next record succesfully). I think I will change it all to work this way: I would do an insert on the temp table and update it with the results from further selects...

Interesting what hmscott says... but I'm not sure if I can do that for my case. You know, the 2 tables are not equal. I loop because I have to select data from the first table, store it on variables so I can use it to select more data from another 3 tables and then, when I have the data for all...

Hi!, Well OPEN PARTIDAS was a misprint :) I use a cursor because I don't know how many rows I will have and I have to do an insert for every row readed. (I'm using a while loop) How can I read one record, assing the variables for that record, do the insert and move to the next record without...

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...

Yeap, I'm using CR ODBC driver... I also think it has to do with the connection. Thanks a lot for everything :) ________________ Magda Banuet

I'm using ODBC on CR and SQL Server 2000. I added the statement you told me. When I ran the query on SQL Server I noticed better performance and my apps weren't affected. However, when I added the stored to my CR report, my application was blocked again. I guess I will deliver the report...

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...

Ohh Thank you very much :D Magda ________________ Magda Banuet