By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,409 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

Report!!!!!

P: 10
Hi,

In reoprts when we put a bonded control (say a Text Box) in the Detail section, it gets auto generated based on the number of record in the record source property of the report.

Is there any way we can stop this auto generation of controls in the Detail section.

Soonest reply will be highly appreciated

Thanks

Keyur
Jan 9 '08 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
I'm not really sure what you're asking! When you place a bound (not bonded) control on a report or form, it's going to generate one for each record in the underlying record set. There's no way to prevent this, nor should there be! Maybe if you re-word your question we'll be able to provide you with the help you reuire.

Welcome to TheScripts!

Linq ;0)>
Jan 9 '08 #2

P: 10
I'm not really sure what you're asking! When you place a bound (not bonded) control on a report or form, it's going to generate one for each record in the underlying record set. There's no way to prevent this, nor should there be! Maybe if you re-word your question we'll be able to provide you with the help you reuire.

Welcome to TheScripts!

Linq ;0)>
Hi,

here is what i am looking for.

I am creating a dynamic report using VBA code based on a query. The query has following type of data

EmpName EmpTeam Month Amount
xxxxx yyyyy November 500.00
aaaaa bbbbb November 250.00
xxxxx yyyyy December 1000.00
aaaaa bbbbb December 750.00

I want to show output of above query in below given format, through VBA code.

EmpName EmpTeam November December
xxxxx yyyyy 500.00 1000.00
aaaaa bbbbb 250.00 500.00

I want this output without using the crosstab query. Is it possible to do this through VBA Code?

Thanks

Keyur
Jan 10 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.