Multiple Table Report

[tdecenso]

Just wondering if someone has documentation or knows how to create a report using multiple tables.

Everytime I do it flakes out with multiple entrys or runs out of memory.

So if someone could just explain a good way to create a custom report with multiple tables.


Thanks again,

Tim DeCenso

[Hemoco]

Try this : http://www.screencast.com/users/geert.moernaut/folders/Jing/media/5ff85c08-f853-42d0-830f-31f14ed99f76

[tdecenso]

But also where do I drag it to on the other table?


Thanks,

Tim D.

[Hemoco]

Your base table which should be used in almost all reports is table "tblcomputers"

You then need to link 2 tables together by dragging the primary key (computername) to the other table)

What do you exactly want to accomplish with this report?

[tdecenso]

Lansweeper wrote:
Your base table which should be used in almost all reports is table "tblcomputers"

You then need to link 2 tables together by dragging the primary key (computername) to the other table)

What do you exactly want to accomplish with this report?

I want the person's name, username, computer name, and service number for this report.


Thanks,

Tim DeCenso

[Hemoco]

Hi Tim,

First I would like to suggest to download the new beta report builder : http://www.lansweeper.com/forum/yaf_postst2046_Premium-Report-builder-352-beta.aspx

Could you give an example of the report you are trying to build?
Out of memory might be caused by not linking the tables and producing millions of results.

[tdecenso]

Lansweeper wrote:
Hi Tim,

First I would like to suggest to download the new beta report builder : http://www.lansweeper.com/forum/yaf_postst2046_Premium-Report-builder-352-beta.aspx

Could you give an example of the report you are trying to build?
Out of memory might be caused by not linking the tables and producing millions of results.

I have attached a photo. I have selected the two table I want and I am just wondering if there is way to get this to work.

As you can see I have downloaded the new report builder.

Thank you for your help.

Tim DeCenso