Search results for query: *

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

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

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

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

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

I am having some difficulty working with drill downs. I have three groups: Group 1 Department - footer has dept operational cost Group 2 Vehicle Classification - footer has operational cost Group 3 Individual vehicles - footer has operational cost Details (individual cost months) at this level...

Hello, I am new to Crystal 9 from Oracle Discoverer. I have a parameter list from a table. It is pulling from a year field. When I declare it as a number I get 2,006 for the year. Is there a way to format this to display 2006?