|
Home > Archive > Programming with dBASE > November 2005 > Having Fields on the Left in a Grid
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Having Fields on the Left in a Grid
|
|
| Sam Onabanjo 2005-11-14, 9:23 am |
| I have a file with about 200 fields which stores several years financial records of companies. In order to display the information meaningfully, e.g. the way excel will display it using "freeze window pane", I wonder if there is a way to have the field na
mes on the left, as opposed to the top, in a Grid. This would enable one to view say ten years information of Sales, Profit Before Tax, Profit After Tax, etc. on a single row and, while freezing the years at the top of the grid, one can scroll down to see
other information for the same number of years.
| |
| Todd Kreuter 2005-11-15, 9:23 am |
| Sam Onabanjo wrote:
>
> I have a file with about 200 fields which stores several years financial records of companies. In order to display the information meaningfully, e.g. the way excel will display it using "freeze window pane", I wonder if there is a way to have the field
names on the left, as opposed to the top, in a Grid. This would enable one to view say ten years information of Sales, Profit Before Tax, Profit After Tax, etc. on a single row and, while freezing the years at the top of the grid, one can scroll down to s
ee other information for the same number of years.
Sounds like you need to rotate the grid on its right side ;-)
I think you would have to create a temporary table structured the way
you want to display the data. This is a farily simple and quick process.
--
Todd Kreuter [dBVIPS]
| |
| Sam Onabanjo 2005-11-15, 11:23 am |
| Todd Kreuter Wrote:
> Sam Onabanjo wrote:
d names on the left, as opposed to the top, in a Grid. This would enable one to view say ten years information of Sales, Profit Before Tax, Profit After Tax, etc. on a single row and, while freezing the years at the top of the grid, one can scroll down to
see other information for the same number of years.[color=darkred]
>
> Sounds like you need to rotate the grid on its right side ;-)
>
> I think you would have to create a temporary table structured the way
> you want to display the data. This is a farily simple and quick process.
>
> --
> Todd Kreuter [dBVIPS]
Thanks for the response, but:
> Sounds like you need to rotate the grid on its right side ;-)
How do you rotate a grid on its right side? I can't seem to find how in the GRID class! I use dbPlus 2.21.
> I think you would have to create a temporary table structured the way
> you want to display the data. This is a farily simple and quick process.
>
What I want is to be able to hold, say, Turnover on the left side of the grid and show data for 10 or more years on the same line. Ditto for, say, Profit Before Tax, Taxation, Profit After Tax, etc.
What seems fairly simple to you (a dBVIPS) could be terribly daunting to advanced novices like me.
Please expantiate and thanks.
| |
| Todd Kreuter 2005-11-15, 11:23 am |
| Sam Onabanjo wrote:
>
>
> How do you rotate a grid on its right side? I can't seem to find how in the GRID class! I use dbPlus 2.21.
I was not serious. There is no way to turn the grid on its side.
> What seems fairly simple to you (a dBVIPS) could be terribly daunting to advanced novices like me.
Provide more details about the table structure. What does each record
represent?
--
Todd Kreuter [dBVIPS]
| |
| Sam Onabanjo 2005-11-15, 1:23 pm |
| Todd Kreuter Wrote:
> Provide more details about the table structure. What does each record
> represent?
>
I have attached a .dbf named samon.dbf which contains only 22 fields. The real thing has about 200 fields in both character, numeric and boolean types. It is supposed to hold financial information of quoted securities over a period of years for investme
nt analysis.
I hope the info provided in the attached file would be of enough help.
Best regards.
| |
| Todd Kreuter 2005-11-15, 8:23 pm |
| Sam Onabanjo wrote:
>
> I have attached a .dbf named samon.dbf which contains only 22 fields. The real thing has about 200 fields in both character, numeric and boolean types. It is supposed to hold financial information of quoted securities over a period of years for invest
ment analysis.
>
> I hope the info provided in the attached file would be of enough help.
Well, maybe not as simple as I made it out to be...
I've posted a sample in the binaries news group for you. It offers some
flexiblity in that you can select the fields from the source table to
include in the data view.
--
Todd Kreuter [dBVIPS]
| |
| Sam Onabanjo 2005-11-17, 9:23 am |
|
> Well, maybe not as simple as I made it out to be...
>
> I've posted a sample in the binaries news group for you. It offers some
> flexiblity in that you can select the fields from the source table to
> include in the data view.
>
GREAT!!!
It worked exactly how I want it. How I wish I could pass a network cable from me to you to 'tap your brain'. I would then have become an SdBVIPS (Super dBVIPS).
Thanks a million. I will shout again if I have any other pressing problems.
Sam Onabanjo
| |
| Todd Kreuter 2005-11-18, 9:23 am |
| Sam Onabanjo wrote:
>
> GREAT!!!
>
> It worked exactly how I want it. How I wish I could pass a network cable from me to you to 'tap your brain'. I would then have become an SdBVIPS (Super dBVIPS).
>
> Thanks a million. I will shout again if I have any other pressing problems.
You're welcome, Sam. Glad you could use it.
--
Todd Kreuter [dBVIPS]
|
|
|
|
|