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.
| Author |
Topic |
|
bobzor
Starting Member
10 Posts |
 Posted - 2010-10-06 : 18:58:31
|
| I need to convert various PowerBuilder reports to SSRS 2005, and I’m looking for a design strategy. I can use the same SQL code, slightly adapted for a different database.The first report is the "Analysis Report" and I have two problems with it:1. I need to display the Effective Date in the header. I’m using an internal parameter which gets its AvailableValues and DefaultValues from the Dataset, I’m allowing null and blank but I get an "the hAsOfDate parameter is missing a value" error if the query returns no data, even when I test for "IsDate" or "IsNothing" in an IIF() in the TextBox where it displays. If I delete the textbox, the error still occurs, so the problem seems to be the way the parameter is set up. I’ve tried various things here but the error persists.2. I need to put a big bunch of stuff on a single page. I tried adding a List control to the detail section, then added a boatload of Textboxes inside the List with 6pt Arial for the font, all stacked on top of each other. It looks good in the designer, but when the report is rendered, each of the Textboxes gets pushed down a little bit to make more room. Fiddling with the settings for "CanShrink" and "CanGrow" but that only seems to make the bottoms of letters disappear. In order to make enough room on the page, the top and bottom margins are .2 inches. Right now all the textboxes actually display on one page, but due to the push-down effect I’m getting a blank second page after every printed page. This wouldn’t be so bad but I’m getting some pushback because "it works in PowerBuilder".Any help would be appreciated. Thanks! |
|
|
bobzor
Starting Member
10 Posts |
Posted - 2010-10-08 : 16:35:27
|
| I thought that at least the first problem would have a reasonably simple solution. Apparently not? |
 |
|
|
bobzor
Starting Member
10 Posts |
Posted - 2010-10-12 : 16:15:17
|
| It turns out that there is no way to convince SSRS to leave Textboxes where you put them. Accordign to http://msdn.microsoft.com/en-us/library/ff714051.aspx it's a feature: Essentially, the location of a textbox or any other item on a report is a guideline, not a rule. There appears to be no way to make them sticky.• On the report design surface, report items grow to accommodate their contents. • When you position an item on the report page the distance between an item and the item above it becomes a minimum distance that must be maintained as the top item grows vertically. • An item in a report grows to accommodate its data and pushes peer items out of the way using the following rules:- Each item moves down to maintain the minimum space between itself and the items that end above it.- Each item moves right to maintain the minimum space between itself and the items that end to the left of it. For systems that right-to-left layouts, each item moves left to maintain the minimum space between itself and the items that end to the right of it. - Containers expand to accommodate the growth of child items. For my particular report, it turns out that the minimum height for a Textbox with 6pt Arial is around 0.135in, and making them smaller just means that SSRS will balloon them back up when the page is rendered. |
|
|
|
|
|
|
|
|
It works in PowerBuilder?