Crystal Reports Question

[Electric Amish]

Is there a way to format data left to right instead of top to bottom?

I want to make a report that basically looks like a spreadsheet.

tia

amish

 

[waylman]

yeah, just don't ask me how.

 

[Electric Amish]

Originally posted by: waylman
yeah, just don't ask me how.

hehe...unfortunately that's the useful part.

amish

 

[Electric Amish]

UP

 

[Electric Amish]

Originally posted by: Electric Amish
UP

 

[ndee]

Originally posted by: waylman
yeah, just don't ask me how.

lol

 

[Scarpozzi]

Greetings Junior ATOT Member!!!

Thanks for coming to the AnandTech Off Topic Forums. Please post this and other 'software' related topics here.

 

[vi edit]

You can try using the "cross tab" function. That should do it.

 

[KidViciou$]

there is a way, but unfortunately, i dont have crystal on my computer. try looking through the help file though

 

[Scarpozzi]

Another suggestion would be to try ExpertsExchange.... They are a set of forums for tons of different computer programs/operating systems/network issues.... There is a whole section devoted to Crystal Reports. 😉

 

[Electric Amish]

Originally posted by: vi_edit
You can try using the "cross tab" function. That should do it.

But that gives you totals in the interior of the spreadsheet. Is there a way to display data rather than calculations there?

amish

 

[vi edit]

Which version of crystal are you using?

 

[Electric Amish]

Originally posted by: vi_edit
Which version of crystal are you using?

8.5

 

[vi edit]

does this do what you want?

 

[Scarpozzi]

Hmmm... Good find vi...

Amish, check out ExpertsExchange if you get a chance. They have a lot of good searchable posts that I use for many things when I'm searching for answers. Just a place to check in the future....

 

[vi edit]

I just did what they described in that help file on my version of 8.5 and it works like a charm.

 

[Electric Amish]

Originally posted by: vi_edit
does this do what you want?

I've tried it several times and can't get it to do what I want.

The problem is probably the way the database is setup. Each piece of data is in a row that has the same name (DisplayValue), even though each piece of data is the result of a different test referenced by another row (Paramid).

example-

ParamId= CU mean Displayvalue= 98.7
ParamId= RSD.........Displayvalue= 4.1
ParamId= 30min Disso mean.....Displayvalue= 87.0

I don't know that there's a way to get around this in CR. 🙁