Recent content by schusser

Sure here goes...based on 542 companies Company As % of running grand total running % 542 revenue total of total 1 .2 883,243 15,898,502 5.56 2 .4 1,377,281 15,898,502 8.66 3 .6 1,852,106...

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

Thanks JayKusch, I think I'm convinced that the way to go with this is to set up the linked server from the 2005 server to the 2000 server. It should also be an easier change once the 2000 server is upgraded. The next glitch is that the 2005 server uses windows authentication and the 2000...

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

Were you opening a report that was created in CR8.5? If I open a new report or if I open a report that was created in CR10, it is there, but the report I'm trying to add grouping to was created in CR8.5. Thanks

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 have the same situation. What if the sp resides on server 1 and needs to call server 2? Thanks in advance.

AA, This worked great! Tweaked it a little for my real data and now it's doing exactly what I needed. Thanks!

Hi AA, Row1 and Row2 (detail lines of a report) will always have the same dept value, but may have different tran codes. Unfortunately there is nothing in Row3 (the subtotal line of a report)that I can key on. The Dept is not carried there. And the transaction counts are not carried on the...

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

Thanks Rosemary, I was afraid I might have to do it this way, but was hoping there was something easier. Wonder what we're in for with CR11. Thanks again, schusser

I'm on Version 10.

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