×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Tweaking Page Header

Tweaking Page Header

Tweaking Page Header

(OP)
hello everyone!
can someone suggest on how to setup a report where one of data entry would be placed at pageheader and allow it to be viewed and works just like what it is in detail band? say for example,i have a table with the following data entries:


Account name JEV 1 JEV 2 JEV 3
CTC 50 105 320
PERMIT FEES 850
BUSINESS TAX 190
GARBAGE FEES 200 500 500

where, account name is field 1 and jev is field 2

my question would be: is it possible that we could spread the jev entries field at the pageheader band?
since it is required in the report that it is to be placed at the top of the report. im just curious and
i dont really have any idea about it.
Thanks a lot in advance....

RE: Tweaking Page Header

Hello to you too

Could you 'draw a picture' of what you want, because I am not quite following your query.

You can put fields in your page header or report title groups. Generally, they might only come from one record, but it is perfectly possible
to use a UDF to create a custom 'block' in a text field, or series of text fields...

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

RE: Tweaking Page Header

(OP)

what i would like to drive here is that can i possibly spread horizontally jev field entries (jev1,jev2,jev3) in page header?

Account name JEV 1 JEV 2 JEV 3
CTC 50 105 320
PERMIT FEES 850
BUSINESS TAX 190
GARBAGE FEES 200 500 500

RE: Tweaking Page Header

If you want captions, you simply use labels. But the report driving cursor always drives the detail band. If you want to print in the top section of the page, simply shrink down the header to zero size and detail band printing starts at the top of the page.

Bye, Olaf.

RE: Tweaking Page Header

Your question is still unclear. Are Jev1, Jev2 and Jev3 three different fields? Or have you got one field with three different values (in different records)? If the former, are there always exactly three, or can you also have Jev4, Jev5, ...? And how are these fields connected to Account Name? From your text, it looks like they are instances of the account name, but in your first post you suggest that they are separate fields.

If Jev1, Jev2 and Jev3 are three fields, what do you want to show in the page header? The values of those fields in the first record? Or the first record on each page? Or what?

I'm sure it will be easy to achieve your goal, but you need to describe your date more clearly.

Also, when posting data from a table, please use the [code ][/code] tags. These will enable you to provide the proper spacing for your columns, and so make the data much clearer.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: Tweaking Page Header

For that, where you have a variable number of columns and a variable number of rows, I would go for Excel automation.

That would give you a matrix that would probably support your needs - although it is limited to (I think) a few hundred columns and 65K rows most likely.

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close