Search results for query: *

I have a stored procedure where I'm trying to gather top 10 percent, top 20 percent, top 30 percent, etc. of activity in one year to compare with same grouping in another year. I'm using this to populate charts that have previously been populated manually. How can I make sure that my top 10...

Hi, I'm being asked to set up a linked server where there are both SQL Server 2000 and 2005. I've been successful with just 2000 servers but cannot see the 2005 servers. Will this need to be done on the 2005 server in order to work? The 2000 server will be upgraded in a few months to 2005...

We have a Web server with many CR8.5 reports accessed via an Intranet using .asp access. CR8.5 is installed on the web server. Now we are trying to access some reports that were created in CR10.0 and getting .dll related error messages. We also want to upgrade to CR10.0 on the server, but not...

Hi all! I'm trying to read data like... Company State Sales ABC MA 20000 ABC RI 3500 ABC IL 650000 XYZ VT 4500 XYZ FL 75000 XYZ CA 55000 and want the result to be... ABC MA, RI, IL 673500...

I am trying to add grouping to a multi column that was developed in CR8.5. I am using CR10. When I open the report in CR10, the option to "Format Groups with Multiple column' is not there. I have made other changes to this report already. Any help would be appreciated, since I don't want to...

I am reading a table that has multiple formats in it. It was imported as a text file which originated on our mainframe as a report file and I need to extract data from it to be used in SQL Server. The data looks like this: row1: dept 1 tran 020 row2: dept 1 tran 020 row3: totaltrans...

I have created a pie chart where the components are based on volume. The legend shows what percent of the total volume each piece of the pie makes up. I'm trying to flip it so that the pieces of the pie show the percent (this is no problem) and the legend shows the volume for each piece of the...

Hello all, I have a DTS package that imports a series of tables (from a third party application) into SQL Server. A few months ago, the format of some of the input tables was changed as a result of an application upgrade. Fields added, fields deleted, etc. My package continued to work, but I...

Hi all, I have an application where I'm extracting data from a SQL Server db and building a series of Excel spreadsheets. Several of the dates in the db are in the 1800's and are being dropped when I bring them into the xls. I don't have the ability to change formats in the db, but need to...

I have written a CR 10 report with multiple charts. The report is for retirement planning and shows both the possible and probable dates for all fulltime employees to retire. From this data I have created 3 charts: one line chart to show the spread of 'probable' departures by retirement year...

I have a DTS package that I run from my PC that imports data from ServerA (SQLBase) to ServerB (SQL Server). It involves over 20 tables. I am trying to automate this procedure so that it can be scheduled to execute during off hours. What do I need to have in place on ServerB? Can the...

Hi all, I am trying to print shipping labels using CR9. The labels can have anywhere from 4 to 8 lines of print. The data source will always have 8 fields. Those that shouldn't get used will be null. I've tried using grouping with multiple detail lines and then 'suppress blank section' but the...

Hi all, I have a CR9 report that uses primarily Arial 9 for font and size. It is being exported to MS Word to then be used as part of a formal report, goes via Quark, then to an offsite printer. The export seems to run OK, but in the Word document the fontsize has been changed to 8.5, changing...

I am looking for a tool that will help us track and control changes to SQLServer applications. The applications are primarily made up of SQL databases, SQL Stored Procedures, Visual Basic, and Crystal Reports. We currently have 2 environments, production and development. We probably need a...

I have a scheduled DTS package that imports 15 tables from SQLBase to SQL Server. It runs biweekly with no problems. I have an email sent to me at the end of the process. There are optional emails within the process if errors occur. Is there a way in the final email step that I can send the...

I have an existing 7 page report (actually a letter with 3 attachments) to which I need to add 1 page that is currently a separate report using the same data. I know that I can add a detail, but need to know the best way to copy? the page in. It contains all the basic working data that was used...

Is it possible to create and replace a table as a result of a view? I have a view that does what I need, but cannot be exported as .txt as needed by the next user of the information. It is to be uploaded to a mainframe for use in their application. Or will I need to create a table and update...

I have created a view and need to export it to a text file to send to another application. When I try to use DTS, my views do not appear on the selection dropdown, only my tables. Is there something that needs to be changed in my permissions that will allow views to be shown and selected...

I'm trying to import several tables from an SQLBase database (one at a time) and have been unsuccessful. Has anyone else needed to do this and had success? I'm trying to get away from creating .csv files using Crystal reports and then importing them. Hopefully I can automate the procedure...

I am getting an error 'invalid table name' when I add a third table to my link since upgrading to Win2000 (worked fine with WinNT). The table names are valid. I was using CRGUP13.dll (version 3.11.00.12) from Intersolve, dated 6/21/1999, with no problems. It seems to have been replaced with...