A small Data Report prob.

[goatsaregreat]

Is there any way to manually insert data into a Report's label? There is not a function for the procedure I need, so I want to code it on a main form, and send the value to the Data Report. Any help would be appreciated. TIA for your speedy answers.

 

[varnit]

hi..

as much i know... u can only rename a label at run time which are already listed in the list box....

like report title, date etc... and nothing more than that...
coz ive spend around 1 month on data reprots for finding an alternative for this.....

bye.. Good Luck
Varnit

 

[goatsaregreat]

Thanks, I guess I could write the data that I want shown to a table in the DB, and access it that way.

 

[VBmim]

this is what you are looking for

datareport.section("section_name&quot.controls("label_name&quot.caption = "data you want to put in"

voila, this realy works

greetings

mim

 

[goatsaregreat]

Hey VBmim,
Thanks, but I can't seem to get that to work. I works OK up to the .caption part. Where ever I put that, I get an error message, and there is no drop down list like there usually is for the commands that are being recognized. The .section and .control part are in a drop-down, but there is no drop-down for the .caption. I am trying to get a label on this Data Report that uses the caption of a label on one of my main forms. Any further help is apprectiated.

 

[VBmim]

oopsy, my mistake

it should be:
datareport.sections("section_name&quot.controls("label_name&quot.caption = "data you want to put in"

it is true you don't see the caption property is not in a drop-down list, but this should work

greetings

Mim

 

[goatsaregreat]

Thanks for your help. I get no error message now, but there are no results. :-( Nothing seems to happen. I put a break point in the code on that line, and when you hover the mouse over it, there is no info shown to be entering the label. Once again, I've tried everything logical. Sorry to be a bother.

 

[Guest_imported]

Here's my problem... I must make a purchase order on a report and I am not able to do what I want with Data Report. Is there another report generator in Visual BASIC 6 like Access? Thank you in advance.

 

[VBmim]

to goatsaregreat:
why don't you post the code, so I can see what is going wrong here...
I used the same code in my projects several times and it still works...
the code must also be put before the report is shown or print...

to joxter:
you could try crystal reports, but I can't help you further with that

greetings

Mim

 

[goatsaregreat]

Sorry. My fault. I tried once more, and took out the datareport.refresh that I had BEFORE your code, and it works perfectly. Thanks a million.