This is a convoluted solution to a temoprary issue so I don't want to use a stored procedure for it although I may have to.
I have 2 different sub reports the first which gives me how many people are in attendance and the second showing me the ones who are in a certain room. I used a shared variable in the first report
whileprintingrecords;
shared numbervar Place := maximum({location.placenumberid});
and in the second report I used
whileprintingrecords;
shared numbervar Room := maximum({location.roomnumberid})
this appears to reset fine in the main report and count fine but in the report footer I used the following formulas
whileprintingrecords;
shared numbervar Place;
shared numbervar cnt;
whileprintingrecords;
shared numbervar Room;
shared numbervar cnt;
They are both counting the same fields and I'm wondering how to go about counting these two sub reports seperately. I am thinking that I haven't declared the variables appropriately but I need a bit of help (or maybe a lot)
Any help you can provide I appreciate greatly.
I have 2 different sub reports the first which gives me how many people are in attendance and the second showing me the ones who are in a certain room. I used a shared variable in the first report
whileprintingrecords;
shared numbervar Place := maximum({location.placenumberid});
and in the second report I used
whileprintingrecords;
shared numbervar Room := maximum({location.roomnumberid})
this appears to reset fine in the main report and count fine but in the report footer I used the following formulas
whileprintingrecords;
shared numbervar Place;
shared numbervar cnt;
whileprintingrecords;
shared numbervar Room;
shared numbervar cnt;
They are both counting the same fields and I'm wondering how to go about counting these two sub reports seperately. I am thinking that I haven't declared the variables appropriately but I need a bit of help (or maybe a lot)
Any help you can provide I appreciate greatly.