Search results for query: *

Hi, In my stored procedure, I am getting quantity field which I want to round up to the next increment of ten. If I use ceiling function it increments only to next numeric. For example, If the quantity is 23.3, then I would want it as 30 and if the quantity is 4, I would want it 10. There might...

Hi, In my VB application, I create crystal report through CRPEAuto.Application object. I have Crystal report version 8.5 and VB6. My problem is that it gets blank report. I am using the stored procedure. The crystal report passes two parameters. The crystal report works fine individually. But...

Hi I am creating a web application through VS.net 2003. When I put crystal report viewer control on my form, it gives me error "Specified cast is not valid". Anybody got idea what might be the problem? It was running perfectly in previous version. I tried to change the version information in...

Hi, I am creating different reports and want to export them programmatically to same pdf file. Suppose, if I have 10 reports, I want to export the first one to pdf and then append rest of 9 to same file. Basically, I want to make a big pdf of all different reports. Is it possible? I have crystal...

Hello, I am sending different reports(crystal reports) to the printer through my VB application. There are lot of small print jobs. It takes lot of time to print. I wanted to know if there is a way to combine all those small jobs in to one and then send it to printer. I use printer object to...

Hello, I am sending different reports(crystal reports) to the printer through my VB application. There are lot of small print jobs. It takes lot of time to print. I wanted to know if there is a way to combine all those small jobs in to one and then send it to printer. I use printer object to...

Hello, This forum is always a great help to me. I am hoping to get some tips on this one. My problem is I am sending different reports(crystal reports) to the printer through my VB application. There are lot of small print jobs. It takes lot of time to print. I wanted to know if there is a way...

Hi, I am sending different reports with different type of data to printer programatically. My problem is the printer gets very slow because of so many print jobs(about 2000). Is there any way I can consolidate those print jobs in to one and then send it to printer? This is the code... Public...

Hi, I am writing a macro in excel. I am looking through each row in a column for length and if it exceeds 50 characters then I move extra text to the line below. My problem is it breaks the ending word some times. For example if the sentence is.. "Check the length of the sentence to see if it...

Hi, I am doing a report where I put sub total in the group footer. I need to show the total only if there are more than one raw in the detail section otherwise suppress it. Can somebody suggest anything? Thanks in advance, ndp

Hi, I am customizing a macro in Excel spreadsheet. What I want to do is go through each row in a column, and find matching value from another spreadsheet. It's kind of look up table. I want to know if there is function for searching a perticular word in a column and can get the row number. I...

Hi, I am trying to customize macro in Excel sheet. The problem I have is when I try to use the function Split, it gives me error "Sub or Function not defined". Same code works at my home computer. The code is something like this... Dim aChars() As String if iComma > 0 then aChars() =...

Hi, I am new to sql programming. I have created a table tbl1 with 50 rows. I created another table tbl2 with 50 rows. Both tables have same structure but different set of data. I want to swap the column LastName from the two tables. This is I am doing for creating sample names. Is there any...

Hi, I have a parameter field called Param1 in my report. Later on I changed the stored procedure to add that same parameter in the stored procedure. Now in report I have same parameter with @Param name. I don't need the Param1 parameter. I removed all the references of Param1. But, when I tried...

Hi, I have created labels(5x2). This is kind of urgent! The problem is by mistake they got wrong labels. There are some other kind of labels which can be used. But, it is perforated on third row. Is there any way to print blank labels on every third row on each page? I would really appreciate...

Hi, I am developing an application which creates pdfs for several Crystal reports(version 8.5). It works fine. Only thing is I am passing parameters from VB code. If there is no record for that parameter, the reports still creates pdf. I want to know if there is any way in VB code, I can check...

Hi, I am creating an application which creates pdfs for Crystal reports in Visual Basic 6. The application works fine. The only problem is somehow the logo in the report comes out little fuzzy. I tried to set the adobe settings on my computer, but doesn't work. If I create pdf from Crystal...

Hi, I am creating pdfs for Crystal reports from my VB6 program. For some of the reports, I need to set up a custom paper size in my VB program. For example, 17x11 or 14x11. I can't find correct syntex to do that. Everything else is working good except this! Please, if anybody can suggest...

Hi, I am creating pdfs for Crystal reports from my VB6 program. For some of the reports, I need to set up a custom paper size in my VB program. For example, 17x11 or 14x11. I can't find correct syntex to do that. Everything else is working good except this! Please, if anybody can suggest...

Hi, I have created an application which creates pdf for the crystal reports. I am using vb 6. The application creates several pdfs from different reports and different parameters. It works fine. But, my problem is while running the application, all pdfs get opened one by one and doesn't get...