Parameters in MOM 2005 reports
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Parameters in MOM 2005 reports

 
Post new topic   Reply to topic    Windows Server Forum Index -> MOM
Author Message
Jan
Guest
Posted: Thu Jan 27, 2005 2:12 pm    Post subject: Parameters in MOM 2005 reports Reply with quote
I want to create an automatic snapshot every month for a couple of reports.
In the "parameters" field I can specify the BeginDate and EndDate. However,
I can only use values such as : "01/01/2005".

I would like to specify a function so that every first day of the month a
report is created from the previous month. When I use parameters such as
GetDate(), I will get an error message like "value is invalid for its type".


Any ideas on how to create monthly reports in MOM 2005?

Thanks,
Jan
Back to top
עידן
Guest
Posted: Thu Jan 27, 2005 11:25 pm    Post subject: RE: Parameters in MOM 2005 reports Reply with quote
Hi,

If you know SQL and using Visual studio you get use getdate() function in
the SQL query and the report should be use this query

"Jan" wrote:

Quote:
I want to create an automatic snapshot every month for a couple of reports.
In the "parameters" field I can specify the BeginDate and EndDate. However,
I can only use values such as : "01/01/2005".

I would like to specify a function so that every first day of the month a
report is created from the previous month. When I use parameters such as
GetDate(), I will get an error message like "value is invalid for its type".


Any ideas on how to create monthly reports in MOM 2005?

Thanks,
Jan


Back to top
Jan
Guest
Posted: Fri Jan 28, 2005 3:02 am    Post subject: Re: Parameters in MOM 2005 reports Reply with quote
Thank you, I will look into this. I can make an SQL query and know how to
use Visual Studio. However, I can't find how to open the MOM reports in VS.
Does someone know where they are located and what there file-extension is?

Thanks,
Jan


"????" <@discussions.microsoft.com> wrote in message
news:C572F87A-EA0F-4125-B9E1-AC6232885052@microsoft.com...
Quote:
Hi,

If you know SQL and using Visual studio you get use getdate() function in
the SQL query and the report should be use this query

"Jan" wrote:

I want to create an automatic snapshot every month for a couple of
reports.
In the "parameters" field I can specify the BeginDate and EndDate.
However,
I can only use values such as : "01/01/2005".

I would like to specify a function so that every first day of the month a
report is created from the previous month. When I use parameters such as
GetDate(), I will get an error message like "value is invalid for its
type".


Any ideas on how to create monthly reports in MOM 2005?

Thanks,
Jan


Back to top
JesseH
Guest
Posted: Fri Jan 28, 2005 10:05 pm    Post subject: Re: Parameters in MOM 2005 reports Reply with quote
Please send me the query you are using... as my SQL skills could use some
polishing.

A reporting solution excellerator exists somewhere on microsoft.com/mom be
sure to install the SQL Reporting Services component to .NET 2003 our you
wont see the reports wizzard.

It took me 8hrs to create the first report, 30 minutes the second, 10 the
one after that.


"Jan" <nospam@hccnet.nl> wrote in message
news:e9uJ5MLBFHA.3940@TK2MSFTNGP09.phx.gbl...
Quote:
Thank you, I will look into this. I can make an SQL query and know how to
use Visual Studio. However, I can't find how to open the MOM reports in
VS.
Does someone know where they are located and what there file-extension is?

Thanks,
Jan


"????" <@discussions.microsoft.com> wrote in message
news:C572F87A-EA0F-4125-B9E1-AC6232885052@microsoft.com...
Hi,

If you know SQL and using Visual studio you get use getdate() function
in
the SQL query and the report should be use this query

"Jan" wrote:

I want to create an automatic snapshot every month for a couple of
reports.
In the "parameters" field I can specify the BeginDate and EndDate.
However,
I can only use values such as : "01/01/2005".

I would like to specify a function so that every first day of the month
a
report is created from the previous month. When I use parameters such
as
GetDate(), I will get an error message like "value is invalid for its
type".


Any ideas on how to create monthly reports in MOM 2005?

Thanks,
Jan




Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> MOM All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB