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