May 9, 2008 at 11:30 am
Why does the subreport have to be a column? Why can't it be a row?
May 9, 2008 at 11:42 am
I'm not sure if I'm clear on what you're asking Brandie. The subreport is a row in the main report. The subreport is working fine. Both main and sub have the same number of columns. The last column for both's visibility is determined by a parameter. If the last column is hidden, for some reason the second last column of main stretches out to fill it's alloted space also. But the second last column for sub doesn't. What I tried was to delete the last column and put those fields in a separate table right next to main so it would look like they were part of the same table. The problem being if a field in main wrapped and the height increased in main, it wouldn't in the new table so they wouldn't align. Does that make sense?
Melissa
May 9, 2008 at 11:54 am
Ah. I thought you had the subreport as a column instead of as a row.
Nevermind. @=)
May 9, 2008 at 11:59 am
No worries...I've confused myself many times over this, and I don't think express what I'm trying to say very well most times. 🙂
August 28, 2008 at 8:18 am
Instead of creating a new thread, I figured I would ask my question on this one. I have a subreport that contains 4 tables in it. I still have a problem after following all of the directions mentioned in this thread such as: setting the can shrink property to false, making the columns the same size in both the main and the subreport, leaving some empty space in the subreport so that it can expand, and making the subreport slightly smaller than the main report. The problem is sometimes the tables in the sub report are empty (containing no rows). When the tables are empty, the lines do not get drawn all the way across to the right as they had been when information existed. As a result, the report doesn't look good through Internet Explorer even though it prints fine, and acrobat displays it perfectly as well. Any help would be appreciated!
Thanks.
August 28, 2008 at 8:22 am
When you say "lines" do you mean border lines?
August 28, 2008 at 12:00 pm
Yes, by lines I meant border lines. They're the table's borderlines which are still showing even though there is no information in the table.
September 2, 2008 at 4:38 am
In which case, I would add the borderlines outside the subreport object in the main report rather than adding them inside the subreport itself.
See if that draws them all the way to the right for you. But you'll want to test it printing as well as rendering in HTML.
September 2, 2008 at 7:26 am
<"In which case, I would add the borderlines outside the subreport object in the main report rather than adding them inside the subreport itself.
See if that draws them all the way to the right for you. But you'll want to test it printing as well as rendering in HTML.">
Unfortunately, I can't put them in the main report. The sub report contains 4 tables of which the main report doesn't know anything about. I want to have borderlines to separate the tables when two or more of the tables are empty. As you may or may not know, an empty table displays the table's border lines. Thus, when the no rows property returns "No index information." or "No foreign keys." (FYI, The information the report displays is schema information about the database.) I would like the two statements to be separated by a borderline so that the text doesn't "run" together. My existing border lines to do this don't display properly, even though they print properly.
September 2, 2008 at 10:35 am
You can actually do this, it just requires a little bit of experimentation.
Set a parameter up in the subreport that populates 1 if you have tables returned and 0 if you have no tables returned. Pass that param back to the main report so that if subreport Param = 0 subreport, it prints a border around the subreport object and if subreport Param = 1, it doesn't.
September 2, 2008 at 1:19 pm
I think I understand your solution, but I don't see how it would work. There are four tables in the single sub report. How can the main report given it knows which subreport tables are blank be able to draw the borders on the sub report's tables?
September 3, 2008 at 4:03 am
I wasn't exactly sure what you meant by your previous post, but this last one clarifies what you're actually looking for.
The other solutions would be to:
1) break up your subreport into four different subreports and do the borders outside of all four objects,
2) get rid of the border lines & draw a physical line underneath each of the subreport tables, making the line the exact length you need it,
or 3) just live with the HTML renderer not working correctly.
September 3, 2008 at 10:18 am
Brandie,
I think I'm going to leave it as is unless they complain. I could always just remove the borderlines entirely. It might look better than having partial lines.
Thanks for your help.
Cool name, too. Brandie. Are you a woman?
September 4, 2008 at 4:18 am
Yes, I am a woman. @=)
The HTML renderer isn't exactly the best in SQL 2k5. Rumor has it that it works better in 2k8, but as I haven't played with 2k8 yet, I wouldn't know that for a fact.
Viewing 14 posts - 16 through 28 (of 28 total)
You must be logged in to reply to this topic. Login to reply