help!! how do I change the way a cross-tab looks..??? 2

[JSeidel]

Here's the format I have in details mode:


date/time findingName value
data data data
data data data

this is what I need:

date/time1 date/time2 date/time3
finding name value data value data value data

it's sort of like a cross tab, but I don't want the value data summarized -- i need the raw data - help!! i've been working on this for weeks and can't seem to figure it out..

 

[cmpgeek]

what version of CR are you running?

have you tried the cross tab wizard?

... always in a state of ...
inspiring to some day experience ...

 

[JSeidel]

yes and it makes me summarize a field in order to execute..

 

[cmpgeek]

sorry - i read it wrong... <smack>

what about grouping by finding name...
and then subgrouping by date/time?

... always in a state of ... inspiring to some day experience ...

 

[JSeidel]

no - still doesn't work because I would have to group dates by a defined interval and I need each date/time entered showing up on the report

 

[cmpgeek]

you can group by each day, thereby listing everything that was entered...

... always in a state of ... inspiring to some day experience ...

 

[JSeidel]

still doesn't help because I need to have the d/t go across the top not down the side...

 

[cmpgeek]

this link should take you to a page from crystaldecisions.com where i found some information - i havent read through all of it yet; but wanted to send you links first...

you forgot to tell me what version you are running; so i am pasting all the links that look as if they may help you:

CR 6

http://support.crystaldecisions.com/library/kbase/articles/c2001736.asp

CR 8.5

http://support.crystaldecisions.com/library/kbase/articles/c2010952.asp

CR 9

http://support.crystaldecisions.com/library/kbase/articles/c2006953.asp

hope you will be able to find something at one of these sites...

good luck

... always in a state of ... inspiring to some day experience ...

 

[cmpgeek]

ok - i just tried it in a sample report of my own.. (i am using 8.5 by the way)

you right click on the details and choose FORMAT SECTION

it will open the section formatting window with the details option already highlighted...

at the bottom of the list of formatting options on the right hand side you will see &quot;FORMAT WITH MULTIPLE COLUMNS&quot;

when you check that box a LAYOUT tab will appear behind the COMMON and COLOR tabs on the top right of the window...

there you choose how far apart you want the fields and then
ACROSS THEN DOWN or DOWN THEN ACROSS for how the details print out...

hopefully this will do the trick for you!

good luck, and please let me know if this helps...



... always in a state of ... inspiring to some day experience ...

 

[cmpgeek]

i played with it a little more... you can place the data field right below the date/time field , and then sort by date and i think that should give you what you want...

(i love learning while <hopefully> helping someone else)

... always in a state of ... inspiring to some day experience ...

 

[JSeidel]

it actually worked almost perfectly - it gave me the columns I need..but heres my next issue: if I have more than 8 columns it wraps them under

so I get

dt dt dt dt dt

dt dt dt

for the second row, I need it to go to another page with the page header that corresponds to that account - how can I do that? ie: if dt >=8 (whatever the upper limit is on how much I can stuff in the page) then create new page with the header for same account...and do this till done? any ideas?

 

[cmpgeek]

is the account and the finding name the same? i am thinking the only way to get the account number to follow is if it is grouped that way; and without knowing the specs of what the report is for, i wont know if grouping by account is feasible...

as for the other part... if your dt fields and the data fields underneath it are going to stay the same size (which they should), what i am thinking (and guessing truth be told) is that you would just set up your vertical spacing so that there is only room for one line of details per page... ex if you are using letter size paper, start your vertical spacing at 8&quot; and see if that pushes the next line of details far enough.. if not adjust it as needed...

i am fixin to leave for home; but i will keep thinking about it... hopefully that will do the trick, although i prefer a more definite means of spacing (like seperate sections etc)...

keep your chin up - we are almost there...
i look forward to checking in tomorrow and seeing if this helped any...

as always - good luck

... always in a state of ... inspiring to some day experience ...

 

[Reebo99]

If you just want 8 records per page then goto section expert and in details click on the x2 by the side of New Page After.

Enter this:
int(recordnumber/8) = recordnumber/8

Save and close.

This will give you a new page afer every 8th record.

Reebo
Scotland (Sunny with a Smile)

 

[JSeidel]

ok - I&quot;m still having a problem....

if I have many findings for one account I need to display it like this:

Finding one:

d/t1 d/t2 d/t3 d/t4
value value value value

finding 2

d/t1 d/t2 d/t3 d/t4
value value value value

and d/t1 must be the same for F1 and F2 and if there is not d/t1 the same then it should shift over to a new column...make sense?
ie:

F1
jan-2 jan-3 jan-4 jan-6
val val val
F2
jan-3 jan-6
val val

 

[kenhamady]

If the same date needs to be a column, then you DO need a cross-tab. For the summarized field use your &quot;value&quot; field, but use the MAXIMUM operation, which will just show the value for that date. You can suppress the row and column totals, which you don't need.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[JSeidel]

it worked in giving me proper format but how do I create a report that will give me a crosstab per account (which will likely be per page....). The cross tab merges into the header and I need it separated by group..

 

[JSeidel]

actually - I think I've figured out the answer to my last question - I put it in the group header....now next question: how do I supress the total column?

 

[cmpgeek]

its been a while since i have done one, but i think suppression in a cross tab works the same as any other field

right click on the field -> format field -> supress is on
the first tab...

... always in a state of ... inspiring to some day experience ...

 

[kenhamady]

Go into the Cross-tab design window and it is the 3d tab of options.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[JSeidel]

Ken - perfect!! thanks a million.

cmpgeek - thanks too - some of the info you gave was real helpful.

I think this report will be good to go! thanks to all who have tried to help me out - really do appreciate it!