Predefined reports for Perfmon data

I have perfmon data collected in a sql database and now i would like to
display the data captured in the form of report.. But I dont really know how
to go about it ? Is there a pack or set of reports that are out there that I
could use and just plug it to the perfmon collection database ?
Thankshi there
you may want to check out this link - scroll down the page - hopefully
something may help you.
http://sqlblog.com/blogs/andrew_kelly/
Jewel
"Hassan" wrote:
> I have perfmon data collected in a sql database and now i would like to
> display the data captured in the form of report.. But I dont really know how
> to go about it ? Is there a pack or set of reports that are out there that I
> could use and just plug it to the perfmon collection database ?
> Thanks
>

Precision on Money data type

How do I set the precision on the money data type in SQL Server. I want it to display only 2 decimal places and get rid of any more than that id someone tries to insert more without throwing an error.

Example:

i input 10.5432

It makes it 10.54
automatically.

If this is not possible, can I at least put in an amount like 10.56 and not have the database automatically turn this into 10.5600

Please help::How do I set the precision on the money data type in SQL Server.

Tried the documentation? Mean, this is so obvious that I would look there first.

Let me quote from "money data type / overview":

::Monetary data values from -2^63 (-922,337,203,685,477.5808) through
::2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary
::unit. Storage size is 8 bytes.

::I want it to display only 2 decimal places and get rid of any more than that id someone
::tries to insert more without throwing an error.

Welcome to programming. YOu have to do so in your input layer.

::If this is not possible, can I at least put in an amount like 10.56 and not have the database
::automatically turn this into 10.5600

You can us an insert / update trigger to round the values. I would normally handle this i n the business objects :-)|||Use decimal instead of money. You can exactly specify the precision and scale|||Thanks Dutch,... I appreciate that

Postal Code.

Can any one help me regarding the postal code. As we have seen in the
website we put postal code and it will display the nearest distance... can
any one help me out regarding this ... like what would be the formula to
calculate the distance...
I would highly appreciate.
Thanks
Rogers wrote:
> Can any one help me regarding the postal code. As we have seen in the
> website we put postal code and it will display the nearest
> distance... can any one help me out regarding this ... like what
> would be the formula to calculate the distance...
> I would highly appreciate.
> Thanks
I think you'll need latitude and longitude to do the calculation. See
this page for an example:
http://px.sklar.com/code.html/id=1062
You can buy the database here:
http://www.zipcodeworld.com/
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Yeah but they do not have the long lats.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eHyMDbKuFHA.1132@.TK2MSFTNGP10.phx.gbl...
> Rogers wrote:
> I think you'll need latitude and longitude to do the calculation. See this
> page for an example:
> http://px.sklar.com/code.html/id=1062
> You can buy the database here:
> http://www.zipcodeworld.com/
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com

Possible to perform mathematical functions on two or more text boxes?

I am looking to take the sum of the values displayed in a couple text
boxes and display the result in another text box. Is it at all
possible to include the values displayed in other text boxes in
expressions in other text boxes?On Jul 11, 8:19 am, mtnbiker419 <rdrace...@.gmail.com> wrote:
> I am looking to take the sum of the values displayed in a couple text
> boxes and display the result in another text box. Is it at all
> possible to include the values displayed in other text boxes in
> expressions in other text boxes?
If I'm understanding you correctly and you want field values displayed
in textboxes (i.e., table control cells/text boxes, etc), you can
reference them within the dataset itself (if they are aggregates or
can be aggregated):
=Fields!FieldName.Value + Sum(Fields!FieldNameInOtherDataset.Value,
"DatasetNameUsedInTextboxB")
-or similarly -
=Fields!FieldName.Value + Avg(Fields!FieldNameInOtherDataset.Value,
"DatasetNameUsedInTextboxB")
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Possible to display RTF from db? Is there a control?

I'd like to save RTF (or html, possibly) in a memo field of a table then display that as formatted text on a report. Can this be done? I've used a control (RTFedit) in Access to do this, though the results were mixed. I need to display tables with formatting.

Thanks in advance

Hello,

There is currently no way to do this with Reporting Services. We are considering adding a rich-text report control in a future version.

Thanks,
Chris

|||

Ok, so this is a really late reply, but in the event you still need it, or someone else out there is having the same problem, refer to my walkthrough in this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=738557&SiteID=1

Possible to display RTF from db? Is there a control?

I'd like to save RTF (or html, possibly) in a memo field of a table then display that as formatted text on a report. Can this be done? I've used a control (RTFedit) in Access to do this, though the results were mixed. I need to display tables with formatting.

Thanks in advance

Hello,

There is currently no way to do this with Reporting Services. We are considering adding a rich-text report control in a future version.

Thanks,
Chris

|||

Ok, so this is a really late reply, but in the event you still need it, or someone else out there is having the same problem, refer to my walkthrough in this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=738557&SiteID=1