Highlighted

Group output with all values in 3 diferent fields

Explorer ,
Jul 06, 2015

Copy link to clipboard

Copied

Hi,

I am trying to write a query with the results going to a report builder report. One student can have up to 3 records. Each record contains a code and a boolean field or a date field. If these records are present I want to show the results on one line in the report.

Input:

A HI 1

A PD 0

A JP date

B PD 1

C HI 1

C JP DATE

Output desired (each in it's own field):

A 1 0 date

B '' 1 ''

C 1 '' date

TOPICS
Database access

Views

258

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Group output with all values in 3 diferent fields

Explorer ,
Jul 06, 2015

Copy link to clipboard

Copied

Hi,

I am trying to write a query with the results going to a report builder report. One student can have up to 3 records. Each record contains a code and a boolean field or a date field. If these records are present I want to show the results on one line in the report.

Input:

A HI 1

A PD 0

A JP date

B PD 1

C HI 1

C JP DATE

Output desired (each in it's own field):

A 1 0 date

B '' 1 ''

C 1 '' date

TOPICS
Database access

Views

259

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jul 06, 2015 0

Have something to add?

Join the conversation