Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JanetStackpole

    SSAS front end tools

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

    Distinct counts in SSRS Report Builder 3.0 with cube

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

    Calculate percentage change from two years

    I ended up doing in data. I understand 2008 makes it easer to accomplish this
  4. JanetStackpole

    Calculate percentage change from two years

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

    thread68-1457325 xls data import not working

    That worked...thank you so much!
  6. JanetStackpole

    thread68-1457325 xls data import not working

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

    thread68-1457325 xls data import not working

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

    Arithmetic overflow error converting varchar to data type numeric

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

    Arithmetic overflow error converting varchar to data type numeric

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

    Excel - Checkbox alternative

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

    Excel - Checkbox alternative

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

    Displaying count of detail records in Record Header

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

    Displaying count of detail records in Record Header

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

    shtml

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

    CR 9 - Using Next function in a grouped report

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

    Crystal Reports 9 - Drilldown problem

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

Part and Inventory Search

Back
Top