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!

Grid Display method

Status
Not open for further replies.

OnDOT

Programmer
Jul 20, 2001
11
SG
hi,

I need some help here.

I have a simple table with the following fields and data:

Table Name: Bundles
BdlNo T W L Qty
----- --- --- --- ---
1 1 2 7 10
1 1 2 8 10
1 1 2 9 10
2 1 2 6 10
2 1 2 7 10
2 1 2 8 10
2 1 2 9 10
2 1 2 10 10



I would like to present this data in crystal report as such (in a grid like format):

(Length, L)
BdlNo T W | 6 7 8 9 10 FT Units
----- --- ---|
1 1 2 | 10 10 10 240 1.2378
2 1 2 | 10 10 10 10 10 400 1.9232

FT and Units are formulas that calculate based on the fields, T, W, L and Qty.

i.e I would like to group up bundles that have the same thickness(T) and width(W) and show its quantity with respect to lengths.

I can't really mnake use of cross-tabs as I am not able to insert the last two columns as formulas.


Thanks.

Eric Lye
 
Have you tried grouping on Thickness and width?
Sorry if it's a vague answer, bt I can't quite figure out what you are needing.
Justine.
 
Even if you say no, what you need is a cross tab with

No, t, w in rows and L in column...

I don't know if you're good with MS ACCESS but I take your infomations and reproduce what you want in ACCESS with a cross tab and I add two more columns for your formula and it works great...

Maybe you should pratice with ACCESS before you try in CR and Copy the SQL from ACCESS in CR for you SQL statement for your databse...


 
hi,

I tried using a cross-tab, I can get the desired outcome except for the last two columns of formula. i.e. To display the bundles by grouping up the T and the W, and the Qty with respect to the length.

So, how do you put in the last two columns into the cross-tab?

NB: if you do any processing in MS ACCESS, do let me know what it is. Thanks.

:)
 
Give me the two formulas you need on your two last columns and I'll try to do something and
I'll will send you back the SQL

Try to be very explicit for your formulas

(I'm french so sometimes I misunderstand some terms...)

I stopped working so I have 17 days before I go back to the university so it will be a pleausre to help you and it will help me not to forget... :)
 
ok. The two formulaes:

1) FT := Sum(L x Qty) for each bundle
(take it as each row as shown in grid)

2) Units := FT x T x W / 144 / 50

Thanks
 
Try a manual cross-tab. They allow you to add formula columns. They are described in my FAQ on common formulas. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB
 
FT := Sum(L x Qty) for each bundle

That's the real problem :)

Is "L" always the same ?
What I mean is : Does "L" always between 6 and 10 (or else)or it can be anything ?

 
I have something and I think that it's what you want... I need your email and I'LL send you the DAtabase.

I don't know what database format you're using for your reports but I hope it'll help

You'll need Ms ACCESS 2K to see, if you don't have that version tell me wich one you have and i'll convert mine.

I'LL wait for your email.
 
hi melginger,

To answer your first question:
"L" is not always the same, its dynamic.


My email is ericlye@yahoo.com

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top