Search results for query: *

HI! I have an SSRS 2005 Reporting Services report with a table that has a drill down group. The report opens with the group details suppressed. The report also has interactive sorting set on a couple of column headings. But, when you drill down to the details on a group and then sort one...

Hi! I have a Business Objects 6.0 report with two data providers on it. I need to actually remove one of the data providers, but I can't see any kind of remove or delete capability when it comes to removing a data provder from a report. If you can tell me how to do that, I'd appreciate it...

Hi dgillz, I hope you see this post! Could you please indicate which product at gainfocus was available for $40. I looked at Visual Cut, and it sells for $250 from the milletsoftware site. But $40 would be acceptable, if you could please tell me which package you were referring to...

Hi! I need to export a Crystal Report into multiple worksheets within a single Excel workbook based on the report's highest level grouping. Crystal's only published option is to do this manually by exporting each group to individual workbooks and combining them. That's not an acceptable...

Hi! We receive a 2-page pdf invoice by email from UPS each week. I need to convert that to two jpg files. I need to do this programmatically, not by physically opening the file and doing a 'save as'. Can I execute Acrobat 6 from some kind of command line prompt and tell it to open the...

Hi! Here's my problem: Each week, my company receives two emailed files from UPS. One is a PDF, usually two pages, that is an overview of their weekly invoice. Then, we receive a flat file containing the details of the shipments included on the invoice. I load that data up into SQL and...

Hi! Thanks for all your answers! I'd thought about just merging the output to a single PDF, but that doesn't help when someone wants to just open up the report itself. I really want the PDF to display correctly on the first two pages and be able to be exported from that to a single PDF...

Hi! Here's my problem: Each week, my company receives two emailed files from UPS. One is a PDF, usually two pages, that is an overview of their weekly invoice. Then, we receive a flat file containing the details of the shipments included on the invoice. I load that data up into SQL and...

Hi! I need a little guidance. Each week we receive an invoice in a text file from UPS via an email link. Our AP Clerk has to click on the email link and download the file. Then, she clicks on a little program I created that imports the UPS flat file data into SQL and prints a report I...

Hi! I have a VB.Net program that currently exports a report to a pdf file. The problem is that it comes out funny looking. For some reason the export capability for PDF files just isn't quite perfect yet. However, when I manually print the report to a pdf file using the "Adobe PDF"...

Okay, so I turned custom error messages 'off' in WebConfig. Now I actually see an error message that might mean something to someone: "Get page number for group failed" This happens when I'm choosing to display a particular page. What I did was run the report, use the group tree to move to a...

Hi! Sorry, but I can't seem to get any help with this on the Crystal Reports web site, so I'm hoping someone here can help. I have a Web Page which gathers parameters for a Crystal Report, stores them in the web session, and then does a redirect to a page that has on it two objects only...

Hi! Just wanted to add a quick note concerning the web service I described above: What's unusual about this web service is that I'm not getting data FROM the service, I'm sending data TO the service, so it can be updated on the Oracle box. That confuses the heck out of me, since it's...

Hi! I hope someone can help! At work, I manage a SQL server. We also have an Oracle box. I have data in a SQL database that needs to be updated to a database in Oracle. Basically, I need to insert 250 records (four fields each) from a table in the SQL table into an already existing table...

Hi! I have a DTS package that imports an Excel spreadsheet into a SQL table (and then executes a stored procedure to massage the data, moves it into other tables, etc.). However, it is possible that someone may be in the spreadsheet updating the information when the package runs. Right...

Hi! I am trying to import several tables from a Timberline database into a SQL Server 2000 database using DTS. The tables import well, except when a table contains a blob (memo) field. When DTS runs, the step (task) fails and I get an error message that says "Cannot instantiate storage...

Hi! I am trying to import several tables from a Timberline database (which uses a version of pervasive sql) into a SQL Server 2000 database using DTS. The tables import well, except when a table contains a blob (notes) field. When DTS runs, the step (task) fails and I get an error message...

Hi! I'm having precisely the same problem! The issue seems to be that the SQL Server Service account doesn't have rights on the networked drive. Additionally the service account has to be in the local admin group on its own server, and have full rights to the C: drive and to the folder...

Hi! I'm trying to use the Opendatasource command within a stored procedure to access data from a spreadsheet on another networked drive. The SQL Server Service account does not have rights on this networked drive, which is why the command won't work. They don't want to set that up for us...

Hi! Thanks for the suggestion! Yes, we've considered it. It's not that we can't do that. We can if we have to. It's just that this should work. What's happening now is this: I've indexed the view on the primary key. But when we re-link the view and try to update the data in...