Search results for query: *

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

Thanks so much Nelviticus. I did it the way you suggested and it works. I was also trying to use InstrRev function which gives position of the character from the end, but I have Excel 97 and it doesn't work with that. Thanks again and really appreciate your help. ndp

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

Thanks all of you. I also tried something and it worked. I did distinct count of one of the field in detail section and suppressed if it was less than 2. This is the place where I always get my answers. I really appreciate it. Thanks very much. ndp

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

Thanks everybody, Finally I used .Find function which Nikki suggested. It seems to be working. Thanks Nikita for giving me code example too which saved lot of my time searching syntex. Thanks again, ndp