C++ Reports Help

[ctid]

Hey,

I'm trying to make a report in C++ get information on how many videos have been rented from a database, and put the records into a report. However, my report only puts the first record into there. Does anyone know why it isnt working?

My OnClick code is:

void __fastcall TMainForm::Button8Click(TObject *Sender)
{
        TADOQuery *activityQuery = new TADOQuery (this);
        if(activityQuery)
        {
                activityQuery->Connection = DataModule1->ADOConnection1;
                activityQuery->SQL->Text = "SELECT * FROM accounts ORDER BY may DESC";
                activityQuery->Active = true;
                if(activityQuery->Active)
                {
                        ActivityReport->CustomerNameLabel->Caption = activityQuery->FieldByName("contact_name")->AsString;
                        ActivityReport->VideosRentedLabel->Caption = activityQuery->FieldByName("may")->AsString;
                        ActivityReport->Preview();
                }
        }
}

My report layout is:



Thanks

[skuzgib]

Would you not need a for loop from 0 to the number of records -1? ATM it looks like its only doing one record.

EDIT and then navigate to the next record before going into the next iteration.

[ctid]

I tried that, but it was just overwriting the one set of labels that are there, rather than creating new ones.

[TheAnimus]

yeh thats probably to do with how your usign AcitivityReport. Don't you need to create a new one for each 'row'?

[ctid]

yeh thats probably to do with how your usign AcitivityReport. Don't you need to create a new one for each 'row'?

You mean create a new set of labels for each row? The problem is that the amount of records that it returns is dynamic. There is a way to make C++ clone the labels for how many records there are, but I can't remember how you do it. I think it has something to do with the bands though.