New Template, open exsisting, any way to call reporting wizard now?

Any way to load my new template, and then call wizard? seems wizard is
not accessable if after I start with open existing item.
Can anybody recommend and easy to follow book on on reporting services
2005?
dumb question, say I have a grouping report like this
group
detail detail datetime
detail detail datetime
detail detail datetime
and I want to change the background color any datetime fields that
elapsed more than 4 hours since last entry to red. How? where? what?
Thanks.In the background color - have an expression :
I hardcoded the date/time below as an example, but this would actually be
your Fields!dtDateField.Value and getdate() would be Now()
If it is greater than 4 hours, it is displayed in red, otherwise blue - but
=iif(datediff(hh, '10/27/06 8:00:00AM', Now()) > 4, "Red", "White")
=-Chris
"Jason" <jason@.cyberpine.com> wrote in message
news:1161914681.963331.129650@.i3g2000cwc.googlegroups.com...
> Any way to load my new template, and then call wizard? seems wizard is
> not accessable if after I start with open existing item.
> Can anybody recommend and easy to follow book on on reporting services
> 2005?
>
> dumb question, say I have a grouping report like this
>
> group
> detail detail datetime
> detail detail datetime
> detail detail datetime
>
> and I want to change the background color any datetime fields that
> elapsed more than 4 hours since last entry to red. How? where? what?
> Thanks.
>|||sorry, 4 hours greater than than the date/time on the subsiquent row
the row.
But, the thing I really stuck on is the report design, if I'm limited
to one dataset the group. Can I have two datasets in a groupset, or
will I have create a view with duplicating data?
I have two tables
filelog:
id
filename
datelog:
id
date
type
I'm trying to do this
Id
filename, filename, filename (line wraping if neccessary)
date type
date type
id
filename, filename, filename (line wraping if neccessary)
date type
date type
==there might be some 5 to 20 filelog rows for every id, there can number
of datelog entries with the same id, but other than Id there is no
other corrilationbe between filelog and datelog
Chris Conner wrote:
> In the background color - have an expression :
> I hardcoded the date/time below as an example, but this would actually be
> your Fields!dtDateField.Value and getdate() would be Now()
> If it is greater than 4 hours, it is displayed in red, otherwise blue - but
> =iif(datediff(hh, '10/27/06 8:00:00AM', Now()) > 4, "Red", "White")
> =-Chris
> "Jason" <jason@.cyberpine.com> wrote in message
> news:1161914681.963331.129650@.i3g2000cwc.googlegroups.com...
> > Any way to load my new template, and then call wizard? seems wizard is
> > not accessable if after I start with open existing item.
> >
> > Can anybody recommend and easy to follow book on on reporting services
> > 2005?
> >
> >
> > dumb question, say I have a grouping report like this
> >
> >
> > group
> > detail detail datetime
> > detail detail datetime
> > detail detail datetime
> >
> >
> > and I want to change the background color any datetime fields that
> > elapsed more than 4 hours since last entry to red. How? where? what?
> >
> > Thanks.
> >

New SQL Instance in an existing SQL Server 2000 Clustered Environm

Can I install a new SQL instance in one of the nodes in a clustered
environment?Hi
Yopu can, but if you need it independent of other instances, you have to
create a new Virtual SQL Server with it's own SAN LUNS etc.
Regards
Mike
"Randy Gadingan" wrote:

> Can I install a new SQL instance in one of the nodes in a clustered
> environment?
>

New SQL Instance in an existing SQL Server 2000 Clustered Environm

Can I install a new SQL instance in one of the nodes in a clustered
environment?
Hi
Yopu can, but if you need it independent of other instances, you have to
create a new Virtual SQL Server with it's own SAN LUNS etc.
Regards
Mike
"Randy Gadingan" wrote:

> Can I install a new SQL instance in one of the nodes in a clustered
> environment?
>

New SQL Instance in an existing SQL Server 2000 Clustered Environm

Can I install a new SQL instance in one of the nodes in a clustered
environment?Hi
Yopu can, but if you need it independent of other instances, you have to
create a new Virtual SQL Server with it's own SAN LUNS etc.
Regards
Mike
"Randy Gadingan" wrote:
> Can I install a new SQL instance in one of the nodes in a clustered
> environment?
>sql

New partition using XMLA

Hi,

I have an existing cube containing a single partition.

I am running the following xmla script to create a new partition :

<Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<ParentObject>

<DatabaseID>myDB_id</DatabaseID>

<CubeID>mycube_id</CubeID>

<MeasureGroupID>mymg_id</MeasureGroupID>

</ParentObject>

<ObjectDefinition>

<Partition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<ID>mypartition_M1</ID>

<Name>mypartition_M1</Name>

<Annotations>

<Annotation>

<Name>AggregationPercent</Name>

<Value>30</Value>

</Annotation>

</Annotations>

<Source xsi:type="QueryBinding">

<DataSourceID>myDS_id</DataSourceID>

<QueryDefinition>

SELECT blabla...

</QueryDefinition>

</Source>

<StorageMode>Molap</StorageMode>

<ProcessingMode>Regular</ProcessingMode>

<ProactiveCaching>

<SilenceInterval>-PT1S</SilenceInterval>

<Latency>-PT1S</Latency>

<SilenceOverrideInterval>-PT1S</SilenceOverrideInterval>

<ForceRebuildInterval>-PT1S</ForceRebuildInterval>

<AggregationStorage>MolapOnly</AggregationStorage>

<Source xsi:type="ProactiveCachingInheritedBinding">

<NotificationTechnique>Server</NotificationTechnique>

</Source>

</ProactiveCaching>

<EstimatedRows>1000000</EstimatedRows>

<AggregationDesignID>AggregationDesign</AggregationDesignID>

</Partition>

</ObjectDefinition>

</Create>

My partition is created and I can see it into SQL Server Management Studio.

I can process it as well and everything looks fine.

The only problem is that I cannot see the partition in BIDS which is quite strange....

Any ideas ?

Regards,

JL

BIDS works against project. Unless you made changes to the project - it won't see the changes on the live server. You can create new project by using "Import" option - i.e. create project from current server state. Or you can also work in "online mode" by doing File -> Open -> Analysis Services Database.|||

Mosha,

Thx a lot !

JL

New partition (SSAS 2005) - named query not in "available tables"

I'm trying to create another partition in an existing measure group.
I start the new partition wizard and choose my data source view in the
"Look in", and then click "Find tables".
My named query does not appear in the list. What could be wrong?

I have saved and refreshed the data source view. The named query has the
same column names and data types that the original table has (that the
measure group is using now).

I also tried to make the named query a ordinary view in the source
database but that does not appear in the list either (I choose the
data source then instead of the data source view).

Hi,

I wouldn't suspect that you'd see a named query in the list of tables when you go to create a new partition. I'm not sure if that list of tables shows views from the underlying DB, either..But, you can make your partition query binding, instead of table binding, and you can make the partition source the same query you're using in your named query, or a subset of it with a where clause, or whatever you choose.

HTH,
C
|||

I don't understand...

In the "New partition wizard" there isn't a whole lot to choose from... Pick either a data source or a data source view, and then pick the "table" - which I suppose could be a view, table, named query... When I choose data source view I can only see the table that is already being used as a fact table in the measure group (and this is actually a named query and not a table). When I choose the data soure, eg. the underlying database, I get nothing.

|||

I found the answer myself.

I thought I had the same datatypes because I created my new named query from the original table that the first named query (the one being used in the measure group already) was based on. But it turned out that the first named query did not get the same datatypes i all columns as the underlying table.

In BOL it states that the tables (or named queries) used in the same measure group must be sufficiently similar - I would call it exactly the same :-)

New Lynksys Router blocking access to SQL 2k

I have a new Wireless G router configured by a client for their VPN. They said to hook it up to my existing router. It works great if I try to connect to something on the VPN, Informix, SQL no problem.

I have my own SQL 2k on the same network locally. I can access the server with Maping tools but I can not get an ODBC connection to work either using Windows Authentication or SQL authentication. Tried my old router and it worked fine.

I figured it would not work while I was connected to the VPN, but thought I should be able to access SQL server when not on the VPN. Is this a port issue? Never had to deal with this.

Thanks

Mike D

make sure that you can access port 1433|||Take a look at all the rules implemented in your new Linksys router and check the port for SQL Server (1433 or 1434) if they are not being blocked.|||

Bass and Joey,

The client supplied Router is password protected. They gave me a laptop and router and asked that I plug their rounter into my existing router. I use their laptop to VPN to their site. I have only one cable to link the new router to the existing old router which is located in another office.

I got the WEP key so I could access the new router from my own laptop. Anyway I have to call their IT support team to get access. I have a feeling they won't want to open port 1433-34.

We will see.

Thanks for the info.

Mike

New Instance on Existing Cluster

Greetings,
I've inherited a cluster configuration and I'm new to administration of
clusters.
2 node 64 bit SQL running on 64 bit Windows 2003 Enterprise Edition.
I'd like to install a new instance to the cluster but do not know the
method. My searches have turned up only installing from scratch with custom
Instance name.
Any pointers would be greatly appreciated.
Chris
You pretty much can find all the info you need in SQL Server 2005 Books
Online under
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/d92134fe-8b36-496e-bc20-bda96973f3ac.htm
Basically, you just need to run SQL Server Setup after you have placed one
or more disk resources in a new resource group. But you do need to do some
preparation work with IP addresses, network names, AD group(s) and
privileges, etc.
Linchi
"Sammi" wrote:

> Greetings,
> I've inherited a cluster configuration and I'm new to administration of
> clusters.
> 2 node 64 bit SQL running on 64 bit Windows 2003 Enterprise Edition.
> I'd like to install a new instance to the cluster but do not know the
> method. My searches have turned up only installing from scratch with custom
> Instance name.
> Any pointers would be greatly appreciated.
> Chris
>

New Installation

Windows 2003 Advanced Server
SQL Server 2K sp3a
There was an existing reporting services database on the SQL Server
Instance. Tried to perform an new install of Reporting Services and point to
this existing database, ReportServer DB. Installation was successful.
However, RS would not activate becuase it thought I was adding to a WEB Farm.
To acivate I needed to run rsactivate from the active RS Server, there was
none. Decided to remove the databases and RS and start clean. Now, everytime
I try to install RS its trying to point to a database that does not exist and
the installation fails. Can anyone help?
ThanksWhat do you mean it tries to point to a DB that doesn't exist? During setup
you can specify a DB that does not exist, it should then create that DB.
What error are you getting?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
> Windows 2003 Advanced Server
> SQL Server 2K sp3a
> There was an existing reporting services database on the SQL Server
> Instance. Tried to perform an new install of Reporting Services and point
> to
> this existing database, ReportServer DB. Installation was successful.
> However, RS would not activate becuase it thought I was adding to a WEB
> Farm.
> To acivate I needed to run rsactivate from the active RS Server, there was
> none. Decided to remove the databases and RS and start clean. Now,
> everytime
> I try to install RS its trying to point to a database that does not exist
> and
> the installation fails. Can anyone help?
> Thanks|||I know its suppose to create the database if it does not exist. The error is
"Database ReportServer does not exist".
"Daniel Reib [MSFT]" wrote:
> What do you mean it tries to point to a DB that doesn't exist? During setup
> you can specify a DB that does not exist, it should then create that DB.
> What error are you getting?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
> > Windows 2003 Advanced Server
> > SQL Server 2K sp3a
> >
> > There was an existing reporting services database on the SQL Server
> > Instance. Tried to perform an new install of Reporting Services and point
> > to
> > this existing database, ReportServer DB. Installation was successful.
> > However, RS would not activate becuase it thought I was adding to a WEB
> > Farm.
> > To acivate I needed to run rsactivate from the active RS Server, there was
> > none. Decided to remove the databases and RS and start clean. Now,
> > everytime
> > I try to install RS its trying to point to a database that does not exist
> > and
> > the installation fails. Can anyone help?
> >
> > Thanks
>
>|||At what point in setup do you get this? Have you tried changing the DB
name?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:A8598F84-FDBF-49E5-BB2B-24CFA774A7C7@.microsoft.com...
>I know its suppose to create the database if it does not exist. The error
>is
> "Database ReportServer does not exist".
> "Daniel Reib [MSFT]" wrote:
>> What do you mean it tries to point to a DB that doesn't exist? During
>> setup
>> you can specify a DB that does not exist, it should then create that DB.
>> What error are you getting?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "FredG" <FredG@.discussions.microsoft.com> wrote in message
>> news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
>> > Windows 2003 Advanced Server
>> > SQL Server 2K sp3a
>> >
>> > There was an existing reporting services database on the SQL Server
>> > Instance. Tried to perform an new install of Reporting Services and
>> > point
>> > to
>> > this existing database, ReportServer DB. Installation was successful.
>> > However, RS would not activate becuase it thought I was adding to a WEB
>> > Farm.
>> > To acivate I needed to run rsactivate from the active RS Server, there
>> > was
>> > none. Decided to remove the databases and RS and start clean. Now,
>> > everytime
>> > I try to install RS its trying to point to a database that does not
>> > exist
>> > and
>> > the installation fails. Can anyone help?
>> >
>> > Thanks
>>|||Hello Daniel,
After I have completed all the setup questions then selected next. The
installation was running fine then it bombed out with that message. I was
able to track down the log file located in the C:\Progam Files\Microsoft SQL
Server\80\RS Setup Bootstrap\Log directory. I noticed that the account RS
setup was trying to use to create the database was DOMAIN\SERVER_NAME$, (I
believe this occured becuase I was running the Windows service under NT
AUTHORITY\NETWORK SERVICE). Once I added this account to SQL server and
granted CREATE DATABASE it worked fine. I have done other installs of RS and
never ran into this problem.
Thanks
"Daniel Reib [MSFT]" wrote:
> At what point in setup do you get this? Have you tried changing the DB
> name?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:A8598F84-FDBF-49E5-BB2B-24CFA774A7C7@.microsoft.com...
> >I know its suppose to create the database if it does not exist. The error
> >is
> > "Database ReportServer does not exist".
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> What do you mean it tries to point to a DB that doesn't exist? During
> >> setup
> >> you can specify a DB that does not exist, it should then create that DB.
> >> What error are you getting?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> >> news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
> >> > Windows 2003 Advanced Server
> >> > SQL Server 2K sp3a
> >> >
> >> > There was an existing reporting services database on the SQL Server
> >> > Instance. Tried to perform an new install of Reporting Services and
> >> > point
> >> > to
> >> > this existing database, ReportServer DB. Installation was successful.
> >> > However, RS would not activate becuase it thought I was adding to a WEB
> >> > Farm.
> >> > To acivate I needed to run rsactivate from the active RS Server, there
> >> > was
> >> > none. Decided to remove the databases and RS and start clean. Now,
> >> > everytime
> >> > I try to install RS its trying to point to a database that does not
> >> > exist
> >> > and
> >> > the installation fails. Can anyone help?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>