convert 1 to Y

Hi,
I have what is hopefully a simple question:
How do I convert a database value of 1 or 0 to a Y or N so it is displayed as such in the report?
I am using CRXI.
Thanks!
jbNot sure about XI but in 10 we go into options/fields then select boolean button, under boolean tab you can change the the text to Y/N.
GJ|||That would work, except that the database value is actually coming in as a 'number' type in crystal.|||Sorry, miss understood question. You could write a formula; This is assuming your vaules are either 1's or 0's.

If({table.field} = '0' Then 'N' Else 'Y'

GJ

Controlling number of rows to display in a table and matrix on one page

Is there a way to control how many Detail Rows are displayed on one page in Table and Matrix controls?

hii

do you mean to say if there are 100 rows and you want only 10 rows to be shown in one page right without any change in the formatting?

i think the rough way is that you can increase the hight of the detail section but it will change the formatting of the page.still am trying with the issue .

Thanks

Mahasweta

Controlling number of Matrix rows displayed

Here's hopefully a simple one and I'm just not looking in the right places for the documentation:

I have a matrix and the result set it displays can range from 20 rows to 200+ rows. The columns range from 25 to possibly 100+. I need a way to set the maximum number of rows displayed per page so that if there are 200 rows returned (or some other arbitrary number) and the user wants to see 25 rows per page, then 8 pages will be returned.

Is there a way to do this?

Wayne E. Pfeffer

im also facing the same issue.. have u found the answer. if so do help me.|||

Not much help, but it may point you in the right direction:

http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx

|||

Here is another link which might help:

http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx

Control w/hidden=true displays as white space

We have a section of a report that should only be displayed if we have data
for it. We have tried putting all of the controls in a rectangle, and then
setting the visibility based on the record count. If we have zero (0) rows,
the controls are hidden, but white space is now displayed equal to the
height of the rectangle that is hidden.
We have tried moving these controls to a sub-report and we exerience the
same thing. However much vertical space the sub-report control consumes at
design time is replaced with whitespace when we hide the report. While this
is a bit better since the height of the sub-report control can be much
smaller than the report itself, it is still frustrating.
Example:
Rec A
Rec B
Rec C
When we hide Rec B, we see:
Rec A
Rec C
What we want is:
Rec A
Rec C
It seems when we hide textboxes, they do not consume any vertical space.
1) How can we also remove the white space when hiding a rectangle or
sub-report?
2) Out of curiosity, what is the rational behind this behavior? Why would
one hide a control and not want subsequent controls "moved up" to take the
hidden controls place.
SQL Server 2000 SP4
MS Reporting Services 1.0 SP2
Visual Studio.NET 2003
Thanks,
Chris?
"Chris Walls" <chwalls@.community.nospam> wrote in message
news:e2jC%23$nMGHA.3648@.TK2MSFTNGP10.phx.gbl...
> We have a section of a report that should only be displayed if we have
> data for it. We have tried putting all of the controls in a rectangle,
> and then setting the visibility based on the record count. If we have
> zero (0) rows, the controls are hidden, but white space is now displayed
> equal to the height of the rectangle that is hidden.
> We have tried moving these controls to a sub-report and we exerience the
> same thing. However much vertical space the sub-report control consumes
> at design time is replaced with whitespace when we hide the report. While
> this is a bit better since the height of the sub-report control can be
> much smaller than the report itself, it is still frustrating.
> Example:
> Rec A
> Rec B
> Rec C
> When we hide Rec B, we see:
> Rec A
> Rec C
> What we want is:
> Rec A
> Rec C
> It seems when we hide textboxes, they do not consume any vertical space.
> 1) How can we also remove the white space when hiding a rectangle or
> sub-report?
> 2) Out of curiosity, what is the rational behind this behavior? Why would
> one hide a control and not want subsequent controls "moved up" to take the
> hidden controls place.
> SQL Server 2000 SP4
> MS Reporting Services 1.0 SP2
> Visual Studio.NET 2003
>
> Thanks,
> Chris
>|||Have you tried using a table instead of independent text boxes to
display your results? If you hide the entire row (not just a single
cell) then the row below moves up.|||Hi Chris (I'm sorry to bother you but I think you could help me)
The reason I'm sending you this email is that I did find a question (see
below) which you did post in this newsgroup for almost a year ago which
indicates that you already have went through the same problem situation as
I'm right now.
May I ask which product you are using when you are merging your PDF
documents into one single document? Are you happy with your choice?
Many thanks and best regards
/Anders
To get around a MS Reporting Service limitation, instead of using
sub-reports, we may have to create individual reports in PDF format and then
merge them into a single PDF report. We have found tools that can merge PDF
files, but this presents us with another issue: page numbers. We want the
resulting merged PDF files to have continous page numbers. Is there a way
to tell MS Reporting Services to start with a specific page number when
rendering a report. Can we some how do this with a report parameter?
"Chris Walls" <chwalls@.community.nospam> wrote in message
news:e2jC%23$nMGHA.3648@.TK2MSFTNGP10.phx.gbl...
> We have a section of a report that should only be displayed if we have
> data for it. We have tried putting all of the controls in a rectangle,
> and then setting the visibility based on the record count. If we have
> zero (0) rows, the controls are hidden, but white space is now displayed
> equal to the height of the rectangle that is hidden.
> We have tried moving these controls to a sub-report and we exerience the
> same thing. However much vertical space the sub-report control consumes
> at design time is replaced with whitespace when we hide the report. While
> this is a bit better since the height of the sub-report control can be
> much smaller than the report itself, it is still frustrating.
> Example:
> Rec A
> Rec B
> Rec C
> When we hide Rec B, we see:
> Rec A
> Rec C
> What we want is:
> Rec A
> Rec C
> It seems when we hide textboxes, they do not consume any vertical space.
> 1) How can we also remove the white space when hiding a rectangle or
> sub-report?
> 2) Out of curiosity, what is the rational behind this behavior? Why would
> one hide a control and not want subsequent controls "moved up" to take the
> hidden controls place.
> SQL Server 2000 SP4
> MS Reporting Services 1.0 SP2
> Visual Studio.NET 2003
>
> Thanks,
> Chris
>

Control Report Parameters Display

Is there a way to control the way report parameters are displayed in terms of number of columns etc. The reason we need that is we have like 15 parameters in one of the report and then it just looks ugly.

Thanks.

Not if you are viewing the Reports via Report Manager. If you are using the Viewer Controls that ship with VS 2005 you could but it would mean writing your own parameter area.

Control of Parameter Field Layout

Greetings

Is it possible to control how the Parameter fields are displayed on report at the point of selection? At the moment they are equally dropped on the form in two columns. I would like to place the Alpha Numerical ones at the top and then organise the date parameters underneath in some kind of logical order.

Regards

The parameter layout is not configurable. But you can order the parameters in your report to get two columns in a more logical order.

|||

Oh well that is a shame.

Thank you anyway

Regards