Presentation (Custom Tables or Report)

[Ron0z]

Could I have some advice on how to use SPSS to present data in a visually
pleasing manner?

I prepare a monthly report and Access has been a key part of the process.
For various technical reasons that has now become difficult. I’ve been
trying to replicate the report using SPSS Custom Tables and SPSS Report,
without too much success.

The attachment shows (1) an example of what I’m trying to achieve. I’ve been
experimenting (2) with Custom Tables and I can get something similar, but I
can’t figure out how to get the Department title above the course
information. Then (3) I tried Report but that still has the same problem in
that I can’t seem to get Department sitting above Course Title.

This not about the numbers, but about the positioning of the elements of the
report.  Any advice would be welcome.

SPSS_report_examples.pdf
<http://spssx-discussion.1045642.n5.nabble.com/file/t340795/SPSS_report_examples.pdf>  



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Ki Park]

Hi,
You could use "DISPLAY=NONE" (in the Vlabels) and add a title for the table.
I am not sure if this will be closer to what you want.
A code like this:

CTABLES
  /VLABELS VARIABLES=var1 var2 DISPLAY=NONE
  /TABLE var1 [COUNT F40.0] BY var2
  /CATEGORIES VARIABLES=var1 var2 ORDER=A KEY=VALUE EMPTY=INCLUDE
MISSING=EXCLUDE
  /TITLES TITLE = "Bussness Tour & Acc 3840: title text here".

If you are generating many tables (e.g. few hundreds) like this, there is a
way to use macro and 'feed' the TITLE code, but for 4 tables you could add
the titles manually.

Also, if you want to generate the tables as you are showing, you could
choose a different table format under File/Options/Pivot Tables.

Next time, if you add a sample data and your code as a starting point, you
may get better answers.

Thanks.

Ki




--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Ki Park]

Please add  "total=YES" to "CATEGORIES VARIABLES", so you can get the total
n.

Ki



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD