fixed positions on a report

[sven2]

Hello,

I want to build a report with fixed positions. I have a queryresult that gives personnumber, ID and results and it looks like:

Pnr ID Result
11 1 A
11 2 AA
11 3 AC

Now I want to place these result fixed on a report. It can be so that personnumber 12 only has ID 1 and 3. So ID 2 should be null.

So I want to display the result for each ID on a fixed position next to some text.

How can I do this?

Thanks in advance,
Sven.

 

[vbaInet]

I'm having difficulty understanding your requirement. Please give a screenshot of your desired outcome.

 

[sven2]

Hello,

I have made an example.

As you can see, I want the scoreID on an fixed position and not underneath eachother.

Best regards,
Sven.

 

[vbaInet]

A screenshot would have been better for this sort of thing. It takes longer to open a database just only to view a report.

Your request still isn't clear. If you want them fixed isn't that a matter of putting them on one line? Please elaborate.

 

[sven2]

Hello,

the question is when I put a field score on a report and I have 9 scores with a different ID I get 9 lines! I want to put eacht score on a fixed position depending the ID.

Sven.

 

[vbaInet]

I think what you're saying isn't about fixed positions. Basically you want to have all the scores on one line correct?

So using the records you posted in your first post, the report for Pnr 11 will be

11
        A, AA, AC

Sounds about right?

 

[sven2]

Hello,

no, I don't want the scores on 1 line.
I want the scores on serveral lines.

So for employee 11 it should be:

scoreID1: score scoreID2: scores
scoreID3: score

Best regards,
Sven

 

[vbaInet]

In that case look into a multi-column subreport.