Skip to Content
author's profile photo Former Member
Former Member

Getting fields to display only what another field contains

Post Author: Travis

CA Forum: Data Connectivity and SQL

Hi all,

I'm sure the title is confusing, but I am trying to create a report that shows all the information about computers checked out to a certain area in our company.

To break it down...Areas is a field. (I havn't put it in the report yet)

Type is a fieldBrand is a fieldModel # is a fieldBar Code is a fieldSerial # is a fieldName is a fieldCheckout location is a field.

I want the above 7 fields to display that information for Area A of the Areas field. (The Areas field contains a huge list of areas and I want the 7 fields to display the information for just Area A)

I'm not sure what to do.

I hope this makes sense. If you have questions or I need to be more clear about something please let me know.

Thank you for taking the time to read and respond.

-Travis

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 13, 2007 at 02:18 PM

    Post Author: foghat

    CA Forum: Data Connectivity and SQL

    If you only ever want Area A, simply add in the Record Selection Formula Editor (Report --> Selection Formulas --> Record): = 'A' Alternatively, if you need to select different areas, you could create an Area parameter and instead of above, enter: = {?area_parameter}Now when you run the report it will ask you to enter/select an area. Good luck

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2007 at 07:31 PM

    Post Author: Travis

    CA Forum: Data Connectivity and SQL

    foghat:

    If you only ever want Area A, simply add in the Record Selection Formula Editor (Report --> Selection Formulas --> Record):

    = 'A' Alternatively, if you need to select different areas, you could create an Area parameter and instead of above, enter: = {?area_parameter}

    Now when you run the report it will ask you to enter/select an area.

    Good luck

    Thank you for the response! What you have said would of worked if it wasn't for the data entry being somewhat screwed up. It's really too long to explain here, so I'll just say that I am moving in a different direction with this.

    I still want to only display the items for Area A, but because I can no longer use the field "Area A" I have to go by the project number. There is an "Assets" section in my database where I am pulling the Brand, Type, Model, etc fields from. My problem now is I want to display only the assets that are checked out to the project number XXXXXXX (which is in a field called "Efforts"), but if I put any field in other than a field from the "Assets" section, the whole report blanks out. I have no idea why, either.

    If anyone could provide some insight into this it would be greatly appreciated! I'm closing in on my deadline and it's getting hairy!

    Thank you,

    -Travis

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.