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

    Excel combine multiple rows to one row

    Can anyone help with this please? I used to generate the results by SQL queries, but the trouble is performance issue because of so many join statements. I am trying to pull the data from database and manipluate the data on Excel. Thanks, Melissa
  2. windbellca

    Excel combine multiple rows to one row

    Parenthess / pipe is not included. This is the way I tried to explain the layout. Sorry to confuse you even more. The purpose is to send students the list of transfer credits have been granted so that there are limits for the number of institutions and the number of credits will be granted...
  3. windbellca

    Excel combine multiple rows to one row

    Sorry, I am trying to get the output like this IDNUM LASTNAME FIRSTNAME INSTITUTION (UP TO 4 INSTITUTIONS) COURSE (COURSE1, COURSE2 UPTO COURSE14) ADDRESS 123 Harris Jane ABC college WRS UNIVERSITY | MINOR SOCIOLOGY(course1 from ABC college) Religion & Modern Thought(course2 from ABC...
  4. windbellca

    Excel combine multiple rows to one row

    I am using Excel 2010 and it is not one time thing. Each idnum could have up to 14 courses. One row for each idnum contains those info as above. I am tying to cobmine those rows to one row and each "data item" being in it's own cell so that a person merges this excel file to a word doc. I...
  5. windbellca

    Excel combine multiple rows to one row

    Hi there: The rows in Excel sheet like this: IDNUM Lastname Firstname Institution COURSE Address 123 Harris Jane ABC college MINOR SOCIOLOGY 164 Firefox RD 123 Harris Jane ABC college Religion & Modern Thought 164 Firefox RD 123 Harris Jane WRS UNIVERSITY PSYCHOLOGY 164 Firefox RD 123 Harris...
  6. windbellca

    How to deploy .rpt file to the Crystal report server 2011

    I wrote a report in Crystal report 2008 and want to publish it to the Crystal report server 2011. I followed the above steps,it works!!! Thank you so much, Melissa
  7. windbellca

    How to deploy .rpt file to the Crystal report server 2011

    Hi, I am new to the crystal report server. I am trying to publish my report .rpt file to the tomcat web server. I don't see anything like called "report upload wizard". I looked tomcat server it asks .war file to upload. I checked wdeploy and copied .rpt file workdir under wdeploy directory...
  8. windbellca

    Report services 2000 format numeric data

    The data stores in format: 5.00 2.50 1.25 0.50 I am trying to format data as 5, 2.5 1.25 0.5 I've tried to convert or drop the zeros by formatting the expression ="#,#.##" The numbers become 5, 2, 1, 0 Any suggestions would be greatly appreciated. Thank you.
  9. windbellca

    Create a 100% stacked bar chart for Survey data

    I have configured it out by myself. Solution: Create a pivot table that the contents need to be in Category group and counts for "Strongly disagree, disagree, neutral, agree, Strongly agree" are row records.
  10. windbellca

    Create a 100% stacked bar chart for Survey data

    Hi All: I have a few questionnaires with all the answers "Strongly agree, agree, neutral, disagree and strongly disagree". I need to make each questionnaire as a bar and the answers show the stacked percentages. I only could make a chart for each questionnaire. I want to combine those charts...
  11. windbellca

    Additional info about RIS

    Sorry, I forget to mention I am using Windows 2003 server and upload the image that is Windows XP sp2 with a bunch of applications. The new image has a different NIC driver. Is it a problem? Thanks, M
  12. windbellca

    The RIS 2003 images get messed up

    Before I upload the new images, all other images word fine. After the upload, the images seem messed up. When I click an old image to download to a PC. It showed error messages, and it looked like the old image was corrupted. Are there any ideas about this? Thanks, M

Part and Inventory Search

Back
Top