Please Assist... Report Templates to save time in designing

In RS 2000 I was able to create a template report and put it in the Project
Items directory, then when I would select New Report Item, I could choose my
template report instead of redesigning everything from scratch.
Where is this folder, or to better phrase this question:
Where do I put my template reports that I want to show up when I choose "Add
new report item" in the designer in SQL 2005 RS?
I have checked the folders - but obviously I am missing something.
Thanks in advance!
=-ChrisI had to search through my computer for *.rdl files. Finally I think I found
the templates at
C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
Kaisa M. Lindahl Lervik
"Chris Conner" <Chris.Conner@.NOSPAMPolarisLibrary.com> wrote in message
news:uOtrsue%23GHA.1220@.TK2MSFTNGP05.phx.gbl...
> In RS 2000 I was able to create a template report and put it in the
> Project
> Items directory, then when I would select New Report Item, I could choose
> my
> template report instead of redesigning everything from scratch.
> Where is this folder, or to better phrase this question:
> Where do I put my template reports that I want to show up when I choose
> "Add
> new report item" in the designer in SQL 2005 RS?
> I have checked the folders - but obviously I am missing something.
> Thanks in advance!
> =-Chris
>

Please Assist! Installation Issue - Updated Info

I have updated this - I really need help! If you read this before, see the
bottom for additional info.
--
Due to configuration changes, I had to uninstall RS (which was running just
fine).
Now I cannot reinstall it.
I have a test server that is a domain controller.
It is running Windows Server 2003 Enterprise.
Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
I have not been able to put it back on - its really strange - I get the
dialog box that says it successfully installed the SQL Server Reporting
Services Setup Support Files. When I click the Next button nothing happens.
If I reboot the machine and log back in as Administrator, I get the Error
Report dialog:
SQL Server Setup encountered an error and needed to close.
Of course, I choose "Send" to send the error report. In the event viewer, it
has this:
Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
--
Now it occurred to me that it appears to be dying when it is supposed to go
to the "System Check" dialog.
I have tried to generate a setup log using /l*v setup.log to no avail - as
no log is ever generated.
Can anyone shed any light on this? I would be happy to allow a remote
desktop connection - just send me an email to
Chris.Conner@.REMOVETHISgisinfosystems.comRun the command line setup with the silent option.
I remember this from a previous post..
Jeff
"Christopher Conner" <someone@.someplace.com> wrote in message
news:#8V9WzrsEHA.3532@.TK2MSFTNGP15.phx.gbl...
> I have updated this - I really need help! If you read this before, see the
> bottom for additional info.
> --
> Due to configuration changes, I had to uninstall RS (which was running
just
> fine).
> Now I cannot reinstall it.
> I have a test server that is a domain controller.
> It is running Windows Server 2003 Enterprise.
> Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> I have not been able to put it back on - its really strange - I get the
> dialog box that says it successfully installed the SQL Server Reporting
> Services Setup Support Files. When I click the Next button nothing
happens.
> If I reboot the machine and log back in as Administrator, I get the Error
> Report dialog:
> SQL Server Setup encountered an error and needed to close.
> Of course, I choose "Send" to send the error report. In the event viewer,
it
> has this:
> Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> --
> Now it occurred to me that it appears to be dying when it is supposed to
go
> to the "System Check" dialog.
> I have tried to generate a setup log using /l*v setup.log to no avail - as
> no log is ever generated.
> Can anyone shed any light on this? I would be happy to allow a remote
> desktop connection - just send me an email to
> Chris.Conner@.REMOVETHISgisinfosystems.com
>|||How is it that the silent switch is going to allow me to install RS on the
machine?
I have tried /qn, /qb, /qr with no avail.
=-Chris
"Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
news:#BiLrOwsEHA.3200@.TK2MSFTNGP14.phx.gbl...
> Run the command line setup with the silent option.
> I remember this from a previous post..
> Jeff
> "Christopher Conner" <someone@.someplace.com> wrote in message
> news:#8V9WzrsEHA.3532@.TK2MSFTNGP15.phx.gbl...
> > I have updated this - I really need help! If you read this before, see
the
> > bottom for additional info.
> > --
> >
> > Due to configuration changes, I had to uninstall RS (which was running
> just
> > fine).
> > Now I cannot reinstall it.
> >
> > I have a test server that is a domain controller.
> > It is running Windows Server 2003 Enterprise.
> > Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> >
> > I have not been able to put it back on - its really strange - I get the
> > dialog box that says it successfully installed the SQL Server Reporting
> > Services Setup Support Files. When I click the Next button nothing
> happens.
> >
> > If I reboot the machine and log back in as Administrator, I get the
Error
> > Report dialog:
> >
> > SQL Server Setup encountered an error and needed to close.
> >
> > Of course, I choose "Send" to send the error report. In the event
viewer,
> it
> > has this:
> >
> > Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> > sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> >
> > For more information, see Help and Support Center at
> > http://go.microsoft.com/fwlink/events.asp.
> >
> > --
> > Now it occurred to me that it appears to be dying when it is supposed to
> go
> > to the "System Check" dialog.
> >
> > I have tried to generate a setup log using /l*v setup.log to no avail -
as
> > no log is ever generated.
> >
> > Can anyone shed any light on this? I would be happy to allow a remote
> > desktop connection - just send me an email to
> > Chris.Conner@.REMOVETHISgisinfosystems.com
> >
> >
>|||I believe the silent install circumvents a known bug or something. Search
this group for more info..sorry that's all I have
Jeff
"Christopher Conner" <someone@.someplace.com> wrote in message
news:#2lEolStEHA.312@.TK2MSFTNGP10.phx.gbl...
> How is it that the silent switch is going to allow me to install RS on the
> machine?
> I have tried /qn, /qb, /qr with no avail.
> =-Chris
> "Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
> news:#BiLrOwsEHA.3200@.TK2MSFTNGP14.phx.gbl...
> > Run the command line setup with the silent option.
> >
> > I remember this from a previous post..
> >
> > Jeff
> > "Christopher Conner" <someone@.someplace.com> wrote in message
> > news:#8V9WzrsEHA.3532@.TK2MSFTNGP15.phx.gbl...
> > > I have updated this - I really need help! If you read this before, see
> the
> > > bottom for additional info.
> > > --
> > >
> > > Due to configuration changes, I had to uninstall RS (which was running
> > just
> > > fine).
> > > Now I cannot reinstall it.
> > >
> > > I have a test server that is a domain controller.
> > > It is running Windows Server 2003 Enterprise.
> > > Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> > >
> > > I have not been able to put it back on - its really strange - I get
the
> > > dialog box that says it successfully installed the SQL Server
Reporting
> > > Services Setup Support Files. When I click the Next button nothing
> > happens.
> > >
> > > If I reboot the machine and log back in as Administrator, I get the
> Error
> > > Report dialog:
> > >
> > > SQL Server Setup encountered an error and needed to close.
> > >
> > > Of course, I choose "Send" to send the error report. In the event
> viewer,
> > it
> > > has this:
> > >
> > > Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> > > sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> > >
> > > For more information, see Help and Support Center at
> > > http://go.microsoft.com/fwlink/events.asp.
> > >
> > > --
> > > Now it occurred to me that it appears to be dying when it is supposed
to
> > go
> > > to the "System Check" dialog.
> > >
> > > I have tried to generate a setup log using /l*v setup.log to no
avail -
> as
> > > no log is ever generated.
> > >
> > > Can anyone shed any light on this? I would be happy to allow a remote
> > > desktop connection - just send me an email to
> > > Chris.Conner@.REMOVETHISgisinfosystems.com
> > >
> > >
> >
> >
>|||Hi,
I've tried the silent install and other recommendations (e.g., copying
the CD to a local directory), and I still can't get past the
installation of the support files. Does anyone have any other
suggestions that I might try?
Thanks,
-Melissasql

Please assist with common error 2147467259

I'm not sure if I'm even starting at the right place.

We have a web portal that we use to send email TSN Templates. When we press this link, it queries our SQL database but then times out. When we go to our logs to see waht has happened, this is what we get: Can anyone point me in the right direction?

Timestamp: 15/08/2007 9:00:13 AM
Message: HandlingInstanceID: 5228cfc1-fbc3-4c64-98ab-468d0a99ba85
An exception of type 'System.Web.HttpException' occurred and was caught.

08/15/2007 19:00:13
Type : System.Web.HttpException, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Message : Request timed out.
Source :
Help link :
ErrorCode : -2147467259
Data : System.Collections.ListDictionaryInternal
TargetSite :
Stack Trace : The stack trace is unavailable.
Additional Info:

MachineName :
TimeStamp : 15/08/2007 9:00:13 AM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=3.0.2697.40343, Culture=neutral, PublicKeyToken=d6be776f5b1b3d1f
AppDomainName : /LM/W3SVC/1/ROOT-1-128316415134243452
ThreadIdentity :

WindowsIdentity : NT AUTHORITY\NETWORK SERVICE

Category: General
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine:

Application Domain: /LM/W3SVC/1/ROOT-1-128316415134243452
Process Id: 36976
Process Name: C:\WINDOWS\SysWOW64\inetsrv\w3wp.exe
Win32 Thread Id: 35804
Thread Name:
Extended Properties:

For more information, see Help and Support Center at

This is an asp.net / enterprise library problem.

You may want to post in these links.

http://forums.asp.net

http://www.codeplex.com/entlib/Thread/List.aspx

But from the message all I can see is that the application is timing out either when connecting to database or when sending email, I cannot tell for sure, with the limited information above.

Thanks

Please assist with a query...

I have a table that can contain several entries for a given item id.
How would my select statement look if I wanted to query for:
- only the 'last' entry for 'each' id that meets certain criteria
I don't want a TOP x query, because I want the dataset to contain all
items whose 'last' entry meets certain criteria.Can you post your DLL? What is/are the key(s)? How can you tell which record
is last one?
"indee" <jeffderoche@.gmail.com> wrote in message
news:1125423719.220718.119790@.g47g2000cwa.googlegroups.com...
>I have a table that can contain several entries for a given item id.
> How would my select statement look if I wanted to query for:
> - only the 'last' entry for 'each' id that meets certain criteria
> I don't want a TOP x query, because I want the dataset to contain all
> items whose 'last' entry meets certain criteria.
>|||What criteria can we use to spot the last row for each group?
Example:
use northwind
go
-- last orders for each customer with an order
select
customerid, orderid
from
dbo.orders as a
where
orderdate = (select max(orderdate) from dbo.orders as b where
b.customerid = a.customerid)
go
AMB
"indee" wrote:

> I have a table that can contain several entries for a given item id.
> How would my select statement look if I wanted to query for:
> - only the 'last' entry for 'each' id that meets certain criteria
> I don't want a TOP x query, because I want the dataset to contain all
> items whose 'last' entry meets certain criteria.
>|||The primary key is an autonumber, however, there is an itemid field.
So, for example, here's what I want in plain english:
For each distinct item id, show me all whose last one entry (per the
autonumber) has status <> 1
So, I want the query to return all item ids whose last entry does not
have the status field set to 1.|||Can you try this (assume your autonumber is an Identity column):
select (whatever columns you have)
from YourTable T1
where T1.autonumber = (select max(T2.autonumber)
from YourTable T2
where T2.itemid = T1.itemid)
and T1.Status <> 1
"indee" <jeffderoche@.gmail.com> wrote in message
news:1125429028.896197.68730@.g14g2000cwa.googlegroups.com...
> The primary key is an autonumber, however, there is an itemid field.
> So, for example, here's what I want in plain english:
> For each distinct item id, show me all whose last one entry (per the
> autonumber) has status <> 1
> So, I want the query to return all item ids whose last entry does not
> have the status field set to 1.
>|||Try,
select
*
from
t1 as a
where
status != 1
and autonumber = (select max(b.autonumber) from t1 as b where b.itemid =
a.itemid)
AMB
"indee" wrote:

> The primary key is an autonumber, however, there is an itemid field.
> So, for example, here's what I want in plain english:
> For each distinct item id, show me all whose last one entry (per the
> autonumber) has status <> 1
> So, I want the query to return all item ids whose last entry does not
> have the status field set to 1.
>|||We're almost there, however, the query can return only the itemid
field, as it is a subquery...I really appreciate your help...
Here is the full query:
SELECT ID FROM vwAssets WHERE ID NOT IN(SELECT AssetID FROM
vwAssetValuation WHERE ActionEID IN (211, 212, 215) AND Stamp <= '" &
mCommon.FormatSQLDate(AsOf) & "') AND AssetID NOT IN(** QUERY GOES HERE
**)|||Let's get back to the basics of an RDBMS. Rows are not records; fields
are not columns; tables are not files; there is no sequential access or
ordering in an RDBMS, so "first", "next" and "last" are totally
meaningless.
THIS IS THE BASICS!! Have you ever bothered to do ANY studying
first?|||>> The primary key is an autonumber <<
Again, an autonumber cannot be a relationalo key BY DEFINITION. And
you still do not know that a field and columns are TOTALLY different
concepts.|||I see that you also use prefixes and data element names that violate
ISO-11179 data element rules. Does "vw-" mean Volkswagen?
Please stop programming until you learn the foundations. You are
dangerously ingnorant. Also you are going to get in Newsgroup is
kludges that will let you limp along until you have a disaster. Please
post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. Sample data is also a good idea, along with clear
specifications.