Have you considered Report Builder in SSRS? Our staff have been using for a number of years and really like it. PowerPivot is also a good option, but only works for the Enterprise version of SQL.
I am migrating several cubes from from SQL Server 2005 std to 2008 enterprise and am running into a problem. All of our cubes have a distinct client count measure. In the 2005 version, the row and column totals remained distinct. In 3.0, the totals default to the sum function. As a result it...
I am trying to create a report in SQL Server Reporting Services 2005 that compares a count of people served each month to the previous year:
Service Month
Service Year 1 2
2010 1,456 1,502
2011 1,712 1,692
% Change 18% 13%
My difficulty is in creating the percentage of...
Thanks your getting back with me.
These have been set up for a while. I tried talking the dept into changing, but they would like to keep it. The 2nd workbook pulls pivot data a number of different source workbooks. Oddly enough, it used to work with no problem. The deptarment recently got...
I found the above thread..and am having the same problem.
I have two xls workbooks, 2003 version, located on a file server.
1. A source xls workbook that refreshes data from SQL Server into a pivot table.
2. A workbook that is used to import the data from the pivot table from the 1st...
Thanks for the quick response. The error indicates it is at the truncate table line. This does not seem to make sense.
I did check the tables to make sure the datatypes did not change. The source table is all varchar and the destination table is correct.
Hello,
I am getting the following error when executing a stored procedure in MS SQL 2005. This procedure executes correctly in 2000. Any assistance would be greatly appreciated. I have included the SP
error message
Msg 8115, Level 16, State 6, Procedure CMP_11_ADD_BH_ADMIT, Line 35...
Sorry,
I guess I should not use the word form. It is a spreadsheet for users to request ftp account access. I have a series of columns to indicate the folders the user should be permitted to access. The spreadsheet is not a true form. They will just submit the spreadsheet via email. I am...
Hi, I have an Excel form in which I would like to have fields completed with checkmarks. There are quite a few so I am trying to avoid checkboxes. I have searched the web and found that some use the 'a' in Marlett font to create a checkmark. Is there a way to force this character using a...
Thanks lbass. That worked for the count. Any suggestions for calculating the total file dollar amount? This report contains two sub reports that pass the dollar amount for each detail record to the main report. As expected, it displays correctly for each detail record. As I stated earlier, I...
Hello,
I am using CR 9 with MS SQL. I am writing a report that creates a flat file to be uploaded for billing. I have created the individual record strings, but am having trouble with the header line. In this line I need to include the total file dollar amount and the total number of...
I have been asked to redesign a site that uses shtml. I have used server side scripting before, but not shtml. What are the benefits of using? I googled on this topic; it looks like it is easier to make changes and has the functionality of frames, but there can be a performance hit. Any...
I have a report listing fuel transactions grouped by vehicle id . It has the following columns
Vehicle id | fueling date | gallons | cost | odometer | miles between fueling |
I am using {odometer} - Next({odometer})to calculate the miles between fueling. This works very well until the vehicle...
I posted this earlier but am still having some difficulty working with drill downs. I have three groups:
Group 1 Department - header has dept operational cost
Group 2 Vehicle Classification - header has operational cost
Group 3 Individual vehicles - footer has operational cost
Group 3...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.