Display .356 as a percentage

I have several columns of data in a report that have values like .743 or
.253, and I'd like them to display as 74.3% and 25.3%.
I'm a reporting services newbie - I didn't see a format option in the
properties of a textbox. Suggestions?
Thanks in advance.
MarkSorry - just found it.
Properties of Textbox- Format - enter "P2"
Mark
"Mark" <markfield88@.nospam.nospam> wrote in message
news:u3451E0fGHA.4004@.TK2MSFTNGP04.phx.gbl...
>I have several columns of data in a report that have values like .743 or
>.253, and I'd like them to display as 74.3% and 25.3%.
> I'm a reporting services newbie - I didn't see a format option in the
> properties of a textbox. Suggestions?
> Thanks in advance.
> Mark
>|||that works or you can set the value of the text box to
=Format(Fields!FieldName.value, "p")

DiskIO value in sp_who2

When I run sp_who2, the result set contains a column 'DiskIO'.
I want to know if this values shows total number of physical Page Read or
Write by a process. Is my understanding correct?This column is most likely referencing to physical_io column in sysprocesses
table.
"Sumanta Gayen" <SumantaGayen@.discussions.microsoft.com> wrote in message
news:3ED22FD8-E4CC-46F6-A263-E4C092A988C8@.microsoft.com...
> When I run sp_who2, the result set contains a column 'DiskIO'.
> I want to know if this values shows total number of physical Page Read or
> Write by a process. Is my understanding correct?
>
>|||It is a combination of Physical and Logical I/O that is cumulative from the
start of the connection.
Andrew J. Kelly SQL MVP
"Sumanta Gayen" <SumantaGayen@.discussions.microsoft.com> wrote in message
news:3ED22FD8-E4CC-46F6-A263-E4C092A988C8@.microsoft.com...
> When I run sp_who2, the result set contains a column 'DiskIO'.
> I want to know if this values shows total number of physical Page Read or
> Write by a process. Is my understanding correct?
>
>sql

DiskIO value in sp_who2

When I run sp_who2, the result set contains a column 'DiskIO'.
I want to know if this values shows total number of physical Page Read or
Write by a process. Is my understanding correct?
This column is most likely referencing to physical_io column in sysprocesses
table.
"Sumanta Gayen" <SumantaGayen@.discussions.microsoft.com> wrote in message
news:3ED22FD8-E4CC-46F6-A263-E4C092A988C8@.microsoft.com...
> When I run sp_who2, the result set contains a column 'DiskIO'.
> I want to know if this values shows total number of physical Page Read or
> Write by a process. Is my understanding correct?
>
>
|||It is a combination of Physical and Logical I/O that is cumulative from the
start of the connection.
Andrew J. Kelly SQL MVP
"Sumanta Gayen" <SumantaGayen@.discussions.microsoft.com> wrote in message
news:3ED22FD8-E4CC-46F6-A263-E4C092A988C8@.microsoft.com...
> When I run sp_who2, the result set contains a column 'DiskIO'.
> I want to know if this values shows total number of physical Page Read or
> Write by a process. Is my understanding correct?
>
>

DiskIO value in sp_who2

When I run sp_who2, the result set contains a column 'DiskIO'.
I want to know if this values shows total number of physical Page Read or
Write by a process. Is my understanding correct?This column is most likely referencing to physical_io column in sysprocesses
table.
"Sumanta Gayen" <SumantaGayen@.discussions.microsoft.com> wrote in message
news:3ED22FD8-E4CC-46F6-A263-E4C092A988C8@.microsoft.com...
> When I run sp_who2, the result set contains a column 'DiskIO'.
> I want to know if this values shows total number of physical Page Read or
> Write by a process. Is my understanding correct?
>
>|||It is a combination of Physical and Logical I/O that is cumulative from the
start of the connection.
Andrew J. Kelly SQL MVP
"Sumanta Gayen" <SumantaGayen@.discussions.microsoft.com> wrote in message
news:3ED22FD8-E4CC-46F6-A263-E4C092A988C8@.microsoft.com...
> When I run sp_who2, the result set contains a column 'DiskIO'.
> I want to know if this values shows total number of physical Page Read or
> Write by a process. Is my understanding correct?
>
>

discrete domains in sql

I have a sql-table. The domain of one of my columns a fix number of string values (like "blue", "green" and "yellow"). However, there is a big likelyhood that the domain will be expanded by more string values in the future (however, none of the existing string values will ever be discluded from the domain). How would I go about enforcing that all strings added to my column in my table is within my domain?

Should I use a check constraint, or create a domain, or sholud a create another table with the domain values and use a foreign key? What would be best practise for my problem?

Any of the choices would work. The best choice will really depend on other things. Use the table or domain if that type of column could appear in other tables, otherwise use a Check constraint. The choice between the domain and the look-up table has more to do with the frequency of changes and who will be responsible. If changing the values is more of a business function, then the lookup table will be best.sql

Disappearing parameter values

I have an ASP.NET application with a page which has a Reportviewer control
linked to a Reporting Services report on a Remote Server. I pass parameters
into it OK including the name of the database which is then referenced by a
dynamic connection string. The database is the first parameter. Other
parameters have dropdown lists based on datasets using the dynamic connection
string.
All of this works fine, but...
When I hide some of the parameters, because I know what value is required,
the value is not acceoted, nor does the report use the default value. It is
as though hiding the parameter prevents the list of available values being
requeried; consequently the passed in value is ignored as it does not match
an available value!
Can anyone help please?
Thanks
GeorgeGeorge,
I assume you are setting the Visible property of some web control that
holds the value of your report parameter. You should set the Visibility
Style of the control to 'hidden' so that it still gets rendered into the web
form but is not 'seen' in the web browser. This way the controls value is
still within the form and viewstate when the form is posted back.
Hope I made the correct assumption and this helps.
thx
-jsh
"George Davies" wrote:
> I have an ASP.NET application with a page which has a Reportviewer control
> linked to a Reporting Services report on a Remote Server. I pass parameters
> into it OK including the name of the database which is then referenced by a
> dynamic connection string. The database is the first parameter. Other
> parameters have dropdown lists based on datasets using the dynamic connection
> string.
> All of this works fine, but...
> When I hide some of the parameters, because I know what value is required,
> the value is not acceoted, nor does the report use the default value. It is
> as though hiding the parameter prevents the list of available values being
> requeried; consequently the passed in value is ignored as it does not match
> an available value!
> Can anyone help please?
> Thanks
> George|||Thanks jsh for replying so promptly
I'm not sure I've explained the problem correctly, as I could not find the
Visibility Style for the control as you suggested. I am using RS2005 and
ASP.NET 1.1 with a ReportViewer control linked to a deployed remote report.
But I think you may be on to something as the problem does not arise when
designing the report, nor in Report Manager, only when I run it from within
the ASP ReportViewer control as a Remote Report.
The parameter is passed into the Reporting Services report OK, but when the
Report Server processes the parameters it first takes the name of the
database as the first parameter, then it recognises that there are cascading
parameters because the dropdown lists require data from tables which have
been queried using the dynamic connection string. At this point it seems to
assume that because it is going to refresh the dropdown lists that it can no
longer rely on the selections supplied in the other parameters and scrubs
them i.e. it insists that the user rekey each of the parameter values
wherever the dropdown lists use the dynamic connection string.
This causes two problems:
1 When I want a parameter value hidden, it is impossible to set it and the
report fails with e.g. "Parameter zzz does not have a value". I could get
round this by using two parameters for each value, one for when I want to
force the parameter to be a certain value and hide it with no associated
dropdown list, and one for when I want to show it and ask the user to pick
from a list. Messy, but I could get the report SQL to test for either of the
values in the two parameters. But this still leaves problem number 2...
2 When cascading parameters are used, each time the user picks a value, it
postbacks to the server. This is not very clever of Reporting Services. It
should post back when the value for a parameter is changed where that
parameter is used by other parameters, not when a parameter changes which
uses the value from another parameter.
The long and short of it is that with eight parameters, the selection of
report options is excruciatingly slow and won't be acceptable to my users.
If you or anyone else can shed any light on this problem, I would be really
grateful.
Thanks again and best wishes
George
"jsh02_nova@.hotmail.com" wrote:
> George,
> I assume you are setting the Visible property of some web control that
> holds the value of your report parameter. You should set the Visibility
> Style of the control to 'hidden' so that it still gets rendered into the web
> form but is not 'seen' in the web browser. This way the controls value is
> still within the form and viewstate when the form is posted back.
> Hope I made the correct assumption and this helps.
> thx
> -jsh
> "George Davies" wrote:
> > I have an ASP.NET application with a page which has a Reportviewer control
> > linked to a Reporting Services report on a Remote Server. I pass parameters
> > into it OK including the name of the database which is then referenced by a
> > dynamic connection string. The database is the first parameter. Other
> > parameters have dropdown lists based on datasets using the dynamic connection
> > string.
> >
> > All of this works fine, but...
> >
> > When I hide some of the parameters, because I know what value is required,
> > the value is not acceoted, nor does the report use the default value. It is
> > as though hiding the parameter prevents the list of available values being
> > requeried; consequently the passed in value is ignored as it does not match
> > an available value!
> >
> > Can anyone help please?
> >
> > Thanks
> >
> > George

Disable and/or Hide Parameters

Is it possible to conditionally disable or hide parameter prompts, depending
on other already selected parameter values? For example, if I have two
parameters p1 and p2, is it possible to somehow disable or hide p2 if
P1="Yes"? Also, is it possible to conditinally set the default value of a
parameter, based on the user-selected value of another parameter? for ex: If
P1="YES", set default value of P2
to "2005"
Thanks in advanceSorry, conditionally hiding parameters dependent on other parameters values
is not supported natively at this point. The closest you can get right now
is to write your own custom parameter application that knows about your
business logic and once all parameters are satisfied, you use a SOAP call
(or URL access) to trigger the rendering of the report.
Adding the ability to conditionally hide parameters is a good suggestion and
it is under consideration for future releases.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"isaak" <isaak.peretsman at usa.dupont.com (no spam)> wrote in message
news:F0F8CE1D-6A38-4821-AEBA-30EA647CA913@.microsoft.com...
> Is it possible to conditionally disable or hide parameter prompts,
> depending
> on other already selected parameter values? For example, if I have two
> parameters p1 and p2, is it possible to somehow disable or hide p2 if
> P1="Yes"? Also, is it possible to conditinally set the default value of a
> parameter, based on the user-selected value of another parameter? for ex:
> If
> P1="YES", set default value of P2
> to "2005"
> Thanks in advance