×
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

Placing different data fields into the same location at the Details section

Placing different data fields into the same location at the Details section

Placing different data fields into the same location at the Details section

(OP)
Hello to all gurus there,

I am using CR 2013 linking to an SQL 2016 database as well as doing OLE DB (ADO) connection to multiple excel workbooks.

We have main data coming from the SQL database but we still have to keep some of the specific data in different .xlsx spreadsheets.

These are spreadsheets that contain additional information for different types of crimes that are not stored at the SQL database and need to pull one of the comments fields to the CR report based on the crime type.

I can successfully link and display the field for a specific type of a crime but is there any way that I can do it at the same Details section anchoring for different types of crimes:

As an example:

Crime Type Address Date Misc Info
Robbery 123 Main St 08/01/18 Susp wearing black mask (This info coming from Robbery excel spreadsheet)
Burglary 555 Central Ave 08/02/18 Broken in at night, cigarettes stolen (This info coming from Burglary excel spreadsheet)
Stolen Vehicle 12 Something Ave 08/02/18 Susp took car with keys in ignition (This info coming from Stolen Vehicle excel spreadsheet)

In all of the cases, I want the Misc Info to display in the same location at the report even though that info is coming from multiple separate spreadsheets

Thanks for any assistance

S.E.

RE: Placing different data fields into the same location at the Details section

Please use TGML to format. I’m using the PRE code...

Crime Type     Address          Date     Misc Info
Robbery        123 Main St      08/01/18 Susp wearing black mask (This info coming from Robbery excel spreadsheet)
Burglary       555 Central Ave  08/02/18 Broken in at night, cigarettes stolen (This info coming from Burglary excel spreadsheet)
Stolen Vehicle 12 Something Ave 08/02/18 Susp took car with keys in ignition (This info coming from Stolen Vehicle excel spreadsheet)
 

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Placing different data fields into the same location at the Details section

(OP)
Thank you,

will do

RE: Placing different data fields into the same location at the Details section

Create a formula use your database fields and excel locations to replace my text

This assumes there is a one to one link from DB to Excel records

@Misc

If {CrimeType} = 'Burgulary' then {burgularyExcel} else
If {CrimeType} = 'Robbery' then {RobberyExcel} else
If {CrimeType} = 'Stolen Vehicle' then {StolenVehicleExcel} else
whatever your default is

Ian

RE: Placing different data fields into the same location at the Details section

(OP)
Thank you

appreciate the tip

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! Already a Member? Login

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