|
|
You're in the
sql server reporting services
group:Removing the spaces left by hidden columns or rows
sql server reporting services:
others. The comprehensive report supports dynamic grouping and the dynamic hiding of columns or rows. My problem is that if a column is hidden, a huge gap is seen in the report where the column is hidden. A C D +=====+ (hidden column) +=====+==========+ |xxxxxxxx| |xxxxxxxx|xxxxxxxxxxxxxxx| ..... Is there any way to make column A move to live where the hidden column "B" would have been had it not been hidden? Thanks. -- Jim Campbell
You have to put the colum width to 0 (in the properties window)
[quoted text, click to view] "Jim Campbell" wrote:
> I have written a comprehensive report that is used as a subreport for many > others. The comprehensive report supports dynamic grouping and the dynamic > hiding of columns or rows. > > My problem is that if a column is hidden, a huge gap is seen in the report > where the column is hidden. > A C D > +=====+ (hidden column) +=====+==========+ > |xxxxxxxx| |xxxxxxxx|xxxxxxxxxxxxxxx| > > .... > > Is there any way to make column A move to live where the hidden column "B" > would have been had it not been hidden? > > Thanks. > -- > Jim Campbell
If only it were that simple... I need to set the width based on whether or
not the column is hidden. Yet, I read the post below: http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/24eee624eae87b62/4e72f1c1abed9fcf?q=column+width&rnum=2#4e72f1c1abed9fcf that seems to imply there is no way to do this under the current release. Has anyone found a work around? - Jim -- Jim Campbell FujiFilm eSystems [quoted text, click to view] "Antoon" wrote:
> You have to put the colum width to 0 (in the properties window) > > "Jim Campbell" wrote: > > > I have written a comprehensive report that is used as a subreport for many > > others. The comprehensive report supports dynamic grouping and the dynamic > > hiding of columns or rows. > > > > My problem is that if a column is hidden, a huge gap is seen in the report > > where the column is hidden. > > A C D > > +=====+ (hidden column) +=====+==========+ > > |xxxxxxxx| |xxxxxxxx|xxxxxxxxxxxxxxx| > > > > .... > > > > Is there any way to make column A move to live where the hidden column "B" > > would have been had it not been hidden? > > > > Thanks. > > -- > > Jim Campbell
You probably have a condition that you use to hide the column; try setting
the colum width to =iif(condition;0;20) [quoted text, click to view] "Jim Campbell" wrote:
> If only it were that simple... I need to set the width based on whether or > not the column is hidden. Yet, I read the post below: > > http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/24eee624eae87b62/4e72f1c1abed9fcf?q=column+width&rnum=2#4e72f1c1abed9fcf > > that seems to imply there is no way to do this under the current release. > Has anyone found a work around? > > - Jim > -- > Jim Campbell > FujiFilm eSystems > > > "Antoon" wrote: > > > You have to put the colum width to 0 (in the properties window) > > > > "Jim Campbell" wrote: > > > > > I have written a comprehensive report that is used as a subreport for many > > > others. The comprehensive report supports dynamic grouping and the dynamic > > > hiding of columns or rows. > > > > > > My problem is that if a column is hidden, a huge gap is seen in the report > > > where the column is hidden. > > > A C D > > > +=====+ (hidden column) +=====+==========+ > > > |xxxxxxxx| |xxxxxxxx|xxxxxxxxxxxxxxx| > > > > > > .... > > > > > > Is there any way to make column A move to live where the hidden column "B" > > > would have been had it not been hidden? > > > > > > Thanks. > > > -- > > > Jim Campbell
But I am pretty sure that u can't write an expression in the width property.
U can just enter numeric values.. am I wrong ? [quoted text, click to view] "Antoon" wrote:
> You probably have a condition that you use to hide the column; try setting > the colum width to =iif(condition;0;20) > > "Jim Campbell" wrote: > > > If only it were that simple... I need to set the width based on whether or > > not the column is hidden. Yet, I read the post below: > > > > http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/24eee624eae87b62/4e72f1c1abed9fcf?q=column+width&rnum=2#4e72f1c1abed9fcf > > > > that seems to imply there is no way to do this under the current release. > > Has anyone found a work around? > > > > - Jim > > -- > > Jim Campbell > > FujiFilm eSystems > > > > > > "Antoon" wrote: > > > > > You have to put the colum width to 0 (in the properties window) > > > > > > "Jim Campbell" wrote: > > > > > > > I have written a comprehensive report that is used as a subreport for many > > > > others. The comprehensive report supports dynamic grouping and the dynamic > > > > hiding of columns or rows. > > > > > > > > My problem is that if a column is hidden, a huge gap is seen in the report > > > > where the column is hidden. > > > > A C D > > > > +=====+ (hidden column) +=====+==========+ > > > > |xxxxxxxx| |xxxxxxxx|xxxxxxxxxxxxxxx| > > > > > > > > .... > > > > > > > > Is there any way to make column A move to live where the hidden column "B" > > > > would have been had it not been hidden? > > > > > > > > Thanks. > > > > -- > > > > Jim Campbell
Yeah you're rigth, sorry about that.
Now I rember how to do it. Put the width value to zero and flag the properties/"can increase to accomadate length" . When visible the colomn width will be fine, when invisible it will be...truly invisible [quoted text, click to view] "Jerome" wrote:
> But I am pretty sure that u can't write an expression in the width property. > U can just enter numeric values.. > am I wrong ? > > "Antoon" wrote: > > > You probably have a condition that you use to hide the column; try setting > > the colum width to =iif(condition;0;20) > > > > "Jim Campbell" wrote: > > > > > If only it were that simple... I need to set the width based on whether or > > > not the column is hidden. Yet, I read the post below: > > > > > > http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/24eee624eae87b62/4e72f1c1abed9fcf?q=column+width&rnum=2#4e72f1c1abed9fcf > > > > > > that seems to imply there is no way to do this under the current release. > > > Has anyone found a work around? > > > > > > - Jim > > > -- > > > Jim Campbell > > > FujiFilm eSystems > > > > > > > > > "Antoon" wrote: > > > > > > > You have to put the colum width to 0 (in the properties window) > > > > > > > > "Jim Campbell" wrote: > > > > > > > > > I have written a comprehensive report that is used as a subreport for many > > > > > others. The comprehensive report supports dynamic grouping and the dynamic > > > > > hiding of columns or rows. > > > > > > > > > > My problem is that if a column is hidden, a huge gap is seen in the report > > > > > where the column is hidden. > > > > > A C D > > > > > +=====+ (hidden column) +=====+==========+ > > > > > |xxxxxxxx| |xxxxxxxx|xxxxxxxxxxxxxxx| > > > > > > > > > > .... > > > > > > > > > > Is there any way to make column A move to live where the hidden column "B" > > > > > would have been had it not been hidden? > > > > > > > > > > Thanks. > > > > > -- > > > > > Jim Campbell
Hi,
Access to the Reporting Service site at Microsoft appears to be hanging, so I'll reply using Google Groups.... Can you tell me where to find this 'can increase to accommodate length' option? The only thing I see that is like this is "can increase to accommodate height." Can this width option be used if there is a textbox in the column? Can a textbox widen to accommodate contents, too? Thanks, Jim Campbell [quoted text, click to view] Antoon wrote:
> Yeah you're rigth, sorry about that. > Now I rember how to do it. Put the width value to zero and flag the > properties/"can increase to accomadate length" . > When visible the colomn width will be fine, when invisible it will > be...truly invisible > > "Jerome" wrote: > > > But I am pretty sure that u can't write an expression in the width property. > > U can just enter numeric values.. > > am I wrong ? > > > > "Antoon" wrote: > > > > > You probably have a condition that you use to hide the column; try setting > > > the colum width to =iif(condition;0;20) > > > > > > "Jim Campbell" wrote: > > > > > > > If only it were that simple... I need to set the width based on whether or > > > > not the column is hidden. Yet, I read the post below: > > > > > > > > http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/24eee624eae87b62/4e72f1c1abed9fcf?q=column+width&rnum=2#4e72f1c1abed9fcf > > > > > > > > that seems to imply there is no way to do this under the current release. > > > > Has anyone found a work around? > > > > > > > > - Jim > > > > -- > > > > Jim Campbell > > > > FujiFilm eSystems > > > > > > > > > > > > "Antoon" wrote: > > > > > > > > > You have to put the colum width to 0 (in the properties window) > > > > > > > > > > "Jim Campbell" wrote: > > > > > > > > > > > I have written a comprehensive report that is used as a subreport for many > > > > > > others. The comprehensive report supports dynamic grouping and the dynamic > > > > > > hiding of columns or rows. > > > > > > > > > > > > My problem is that if a column is hidden, a huge gap is seen in the report > > > > > > where the column is hidden. > > > > > > A C D > > > > > > +=====+ (hidden column) +=====+==========+ > > > > > > |xxxxxxxx| |xxxxxxxx|xxxxxxxxxxxxxxx| > > > > > > > > > > > > .... > > > > > > > > > > > > Is there any way to make column A move to live where the hidden column "B" > > > > > > would have been had it not been hidden? > > > > > > > > > > > > Thanks. > > > > > > -- > > > > > > Jim Campbell > > > > > > FujiFilm eSystems
I did my own research here, and I see that the "CanGrow" feature of
textboxes applies only to height and not width in this particular version of MS Reporting Services. I do not see any way to do what I am asking. To illustrate what I have today: col1--col2--col3--data1--data2 X Y Z where col1 may or may not show field X if the user groups by field X, col2 may or may not show field Y if the user groups by field Y, etc.... This means that if, for example, the user chooses not to group by field Y, the report will appear like this col1 col3--data1--data2 X Z I suppose that if I found a way to have true dynmaic grouping, e.g., by having col3 group by X, Y, or Z, rather than have each column represent one field toggled on or off with grouping, I could it make it all better, but I would still have the problem of spaces to the left of the report, representing all the non-grouped columns. I guess we'll have to put this problem down to the limitations inherent in this "1.0-version" piece of software. - Jim [quoted text, click to view] jtk6204@gmail.com wrote:
> Hi, > > Access to the Reporting Service site at Microsoft appears to be > hanging, so I'll reply using Google Groups.... > > Can you tell me where to find this 'can increase to accommodate length' > option? The only thing I see that is like this is "can increase to > accommodate height." > > Can this width option be used if there is a textbox in the column? Can > a textbox widen to accommodate contents, too? > > Thanks, > Jim Campbell > > Antoon wrote: > > Yeah you're rigth, sorry about that. > > Now I rember how to do it. Put the width value to zero and flag the > > properties/"can increase to accomadate length" . > > When visible the colomn width will be fine, when invisible it will > > be...truly invisible > > > > "Jerome" wrote: > > > > > But I am pretty sure that u can't write an expression in the width property. > > > U can just enter numeric values.. > > > am I wrong ? > > > > > > "Antoon" wrote: > > > > > > > You probably have a condition that you use to hide the column; try setting > > > > the colum width to =iif(condition;0;20) > > > > > > > > "Jim Campbell" wrote: > > > > > > > > > If only it were that simple... I need to set the width based on whether or > > > > > not the column is hidden. Yet, I read the post below: > > > > > > > > > > http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/24eee624eae87b62/4e72f1c1abed9fcf?q=column+width&rnum=2#4e72f1c1abed9fcf > > > > > > > > > > that seems to imply there is no way to do this under the current release. > > > > > Has anyone found a work around? > > > > > > > > > > - Jim > > > > > -- > > > > > Jim Campbell > > > > > FujiFilm eSystems > > > > > > > > > > > > > > > "Antoon" wrote: > > > > > > > > > > > You have to put the colum width to 0 (in the properties window) > > > > > > > > > > > > "Jim Campbell" wrote: > > > > > > > > > > > > > I have written a comprehensive report that is used as a subreport for many > > > > > > > others. The comprehensive report supports dynamic grouping and the dynamic > > > > > > > hiding of columns or rows. > > > > > > > > > > > > > > My problem is that if a column is hidden, a huge gap is seen in the report > > > > > > > where the column is hidden. > > > > > > > A C D > > > > > > > +=====+ (hidden column) +=====+==========+ > > > > > > > |xxxxxxxx| |xxxxxxxx|xxxxxxxxxxxxxxx| > > > > > > > > > > > > > > .... > > > > > > > > > > > > > > Is there any way to make column A move to live where the hidden column "B" > > > > > > > would have been had it not been hidden? > > > > > > > > > > > > > > Thanks. > > > > > > > -- > > > > > > > Jim Campbell > > > > > > > FujiFilm eSystems
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |