×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

**Error Message for Cross Tab**

**Error Message for Cross Tab**

**Error Message for Cross Tab**

(OP)
I have a report that has two subreports inside it. Inside each subreport is a crosstab that looks at the the last 14 days of data. The crosstabs runs fine within each subreport, but when you try to run the whole report together I get "Error formatting Cross-Tab Object."

Can anyone help me here??? Thanks.

RE: **Error Message for Cross Tab**

In what sections of the main report are the subs located? Do the crosstabs create virtual pages when run alone? The main report will not create virtual pages to accommodate the crosstabs. You might want to create one crosstab in the main report (if they have the same number of columns) to force the virtual pages.

-LB

RE: **Error Message for Cross Tab**

(OP)
The two subreports are in PFa and PFb of the main report. Inside the subreports, the crosstabs are in the report footer. By virtual pages do you mean that it runs over into another page (horizontally)? I thought about that when I was creating them and I formatted them to make sure they wont go over. I will try putting the first crosstab in the main report also.  

RE: **Error Message for Cross Tab**

The problem is more likely to be your placement in a page footer. There are limits to the height of a page footer, and the crosstabs would have to fit on one page or you would get an error. Why were you using the page footer?

-LB

RE: **Error Message for Cross Tab**

(OP)
I didnt have to place them in the RF. I moved them up to the PH and everything worked great. Thanks lbass!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close