Solved DYNAMIC REPORT FROM CROSSTAB QUERY (1 Viewer)

[I am alive]

Your Report will not work using the method you are suggesting.

If you want it to be dynamic and only show those subjects which are active then you cannot use a Crosstab and the subjects would have to be displayed Vertically.

There is an error also in vertically. If a student drops a subject how can I remove that Subject without interfering with subjectID? Kindly help me

 

[theDBguy]

There is an error also in vertically. If a student drops a subject how can I remove that Subject without interfering with subjectID? Kindly help me

Hi. I've been following this thread for a while because I really want to help; but I must say, after over 49 posts, I still don't understand what you are looking for. I downloaded your last sample db and can't see what is wrong with it. Using an unbound Textbox filled with "This will be populated... (something like that)" doesn't help me understand where that info will come from or what it's supposed to look like. As soon I have an idea what you're really asking, I will try to suggest something.

In the off chance this might help, take a look at this simple function.

Code Snippets

 

[mike60smart]

In the attached look at the new Report created called rptStudentsMarks.

This is just a basic Report and in the Subjects table I have added a field named "Active"

If you make any of these Subjects "Inactive" then the Subject does not appear on the Report.

 

[arnelgp]

do you need All students in report or just the 1 on the Form?

 

[I am alive]

Students with marks. Thanks in advance

 

[I am alive]

Students with marks. Thanks in advance

Should be the ones populated when you enter their marks

 

[arnelgp]

Students with marks. Thanks in advance

so only 1? the one currently in display in the form?

 

[I am alive]

so only 1? the one currently in display in the form?

All of them with marks please

 

[mike60smart]

Is this Report layout better??

 

[arnelgp]

here is my version of your report.

 

[I am alive]

here is my version of your report.

Perfect. Exactly what I wanted. God bless you for doing extensive research.

 

[arnelgp]

btw, the paper size is A3 and there are only 24 subjects that can fit on report.
you can delete any course on the subject table and the report will adjust.

 

[I am alive]

btw, the paper size is A3 and there are only 24 subjects that can fit on report.
you can delete any course on the subject table and the report will adjust.

Genius. Microsoft should employ you. You are really talented. God bless you so much.

 

[mercystone]

here is my version of your report.

I am using your approach. Thanks. Question- i want a code which will hide subjects if it has no mark. E.g if English has no marks or isnull hide it. Only subjects with marks to be shown.

 

[arnelgp]

ok, it will hide those subjects that has no marks.
see the report again.

 

[mercystone]

Exactly what I wanted. Is there any way I could change the subjects to be selected to be 11? Your labels has 24. I wish to be 11 but the subjects should not be deleted. To be hidden just like what you have done but those to be printed are only 11. I believe those 13 labels and there values should be deleted and enlarge the printout.

 

[mercystone]

If there is a code to hide subjects with no marks then I believe there should be a code to delete the hidden labels with no values and show only those with values. Please help me on this

 

[mercystone]

Subjects to be 11

 

[arnelgp]

here again setting the backstyle and borderstyle appropriately.

 

[mercystone]

here again setting the backstyle and borderstyle appropriately.

Thank you so much.