Recent content by ndp

Thanks a lot! That works great! I will give you a star!! ndp

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, Finally, I made it work. It is not perfect solution, but kind of workaround. So, I am not really excited. I removed my else statements and used union statements and put parameters in CR. Based on the parameter, CR would select only those records. Still the my question is open. Why it...

Thanks Dave, I really appreciate your effort. You are right about putting another else at the end for @County_Shipment_Type. I did that. About the second part of your suggestion, orPackingList is a view and it uses different tables than my ELSE statements. The view uses District table where...

Ok, I checked everything. Everything matches and still it doesn't work. I don't see any reason. It still doesn't like else part of my stored procedure. The code works fine if I remove else part from stored procedure. I am posting the whole stored procedure here if somebody can figure out the...

Thanks Dave, This is excellent suggestion. I am still checking the columns as you suggested. I found one field name different and changed it. But, the report still doesn't show up in my application. I am still checking each field data type. I am sure it must be something as you mentioned above...

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

Thanks so much, Actually I have written an application which creates pdfs throurh vb6. Can you give me idea how can I combine all pdfs? Thanks, ndp

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

Please somebody help me with this! There has to be a way to do this! Thanks, ndp

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