Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Report doesnt appear as subreport

Author  Topic 

kaus
Posting Yak Master

179 Posts

Posted - 2003-01-28 : 13:15:52
I dragged a report into the report footer of another report, but it doesnt appear or show any data when I open the main report. It does appear when I open it by itself. I've tried other reports within the project as subreports, and those all appear. Any ideas ?? This is a wierd one

Thanks

Pete

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2003-01-28 : 13:25:24
Is it trying to link fields that aren't matching, so there is no data being returned by the subreport?

Also, are you sure it's not in the page footer, I know that can cause some problems (as opposed to the report footer).

Also, make sure the visible property is set to true.

- Jeff
Go to Top of Page

kaus
Posting Yak Master

179 Posts

Posted - 2003-01-28 : 13:44:22
Its defintely in the report footer, not linked -- couldnt find visible property -- its funny -- if I right click on the upper left corner and do a layout preview -- it shows up, but it looks like it cuts off some of the data from the main report. Each report is linked to a separate table, but column names in the tables are identical -- any way that could cause a problem ??

Thanks

Go to Top of Page

kaus
Posting Yak Master

179 Posts

Posted - 2003-01-28 : 17:19:49
I finally had to open blank report, copy sub report into report footer, copy all elements from other report into detail section etc.. and then set datasource of new report -- Works now, but wierd, really wierd

Go to Top of Page
   

- Advertisement -