No longer able to open up .rptproj

My visual studio .net application previously had not problem opening .rptroj
files, but now it tells me "Make sure the application for the project type
(.rptproj) is installed"
Also, when I try to create a new project, the "Business Intelligence"
project type is not listed. I have seen some suggestions on line about
removing msatinterop.dll from the PrivateAssemblies directory but this does
not change a thing for me.Try running VS from the command line with the /resetskippkgs switch. That
should do the trick. Your command would look something like:
C:\>cd C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE\
C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE>devenv
/resetskipkgs
This is assuming you have RS installed to the default directory. You would
obviously have to find where the devenv.exe file is in order to run the file.
"DBA72" wrote:
> My visual studio .net application previously had not problem opening .rptroj
> files, but now it tells me "Make sure the application for the project type
> (.rptproj) is installed"
> Also, when I try to create a new project, the "Business Intelligence"
> project type is not listed. I have seen some suggestions on line about
> removing msatinterop.dll from the PrivateAssemblies directory but this does
> not change a thing for me.|||Running devenv didn't work for me, but reinstalling MRS with the Report
Designer component checked did. Good Luck.
Bassist695 wrote:
> Try running VS from the command line with the /resetskippkgs switch.
That
> should do the trick. Your command would look something like:
> C:\>cd C:\Program Files\Microsoft Visual Studio .NET
2003\Common7\IDE\
> C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE>devenv
> /resetskipkgs
> This is assuming you have RS installed to the default directory. You
would
> obviously have to find where the devenv.exe file is in order to run
the file.
>
> "DBA72" wrote:
> > My visual studio .net application previously had not problem
opening .rptroj
> > files, but now it tells me "Make sure the application for the
project type
> > (.rptproj) is installed"
> >
> > Also, when I try to create a new project, the "Business
Intelligence"
> > project type is not listed. I have seen some suggestions on line
about
> > removing msatinterop.dll from the PrivateAssemblies directory but
this does
> > not change a thing for me.|||I solved this problem by reinstalling reporting services. I tried
running devenv.exe to no avail. On the default install for RS it
leaves the Report Designer unchecked. When you reinstall (or repair)
make sure this component is checked and it should solve the problem.
Bassist695 wrote:
> Try running VS from the command line with the /resetskippkgs switch.
That
> should do the trick. Your command would look something like:
> C:\>cd C:\Program Files\Microsoft Visual Studio .NET
2003\Common7\IDE\
> C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE>devenv
> /resetskipkgs
> This is assuming you have RS installed to the default directory. You
would
> obviously have to find where the devenv.exe file is in order to run
the file.
>
> "DBA72" wrote:
> > My visual studio .net application previously had not problem
opening .rptroj
> > files, but now it tells me "Make sure the application for the
project type
> > (.rptproj) is installed"
> >
> > Also, when I try to create a new project, the "Business
Intelligence"
> > project type is not listed. I have seen some suggestions on line
about
> > removing msatinterop.dll from the PrivateAssemblies directory but
this does
> > not change a thing for me.sql

No instance of SQL Server under MSDE installation

Hi all,
after successfully completing the installation of a
downloaded copy of MSDE for VS.Net things are
not working at all.
I was having trouble with my VS.Net installation so I
uninstalled VS.Net and MSDE.
I have installed MSDE several times today and each
time I can not see the instance name of the installation.
I have removed any existing directories, cleared the
obvious things from the registry, changed the instance
name and even chosen different target and data
directories to try and solve the problem. The service
seems to have started correctly, but I do not get
a green play icon in the system tray at the bottom of
the screen. When i open the server manager I
can not see the server running at all.
I do not know what to do next. Does anyone have any
ideas as to what what be causing this problem?
Many thanks for your assistance in helping me to
solve this problem.
Regards,
Jason.
Please ignore this post. I was just to impatient to wait
for all the services, etc to start.
All appears to be OK now.
Thanks.
On Thu, 29 Apr 2004 18:40:13 +0100, JJ <jason@.nospam.divemaster.org>
wrote:

>Hi all,
>after successfully completing the installation of a
>downloaded copy of MSDE for VS.Net things are
>not working at all.
>I was having trouble with my VS.Net installation so I
>uninstalled VS.Net and MSDE.
>I have installed MSDE several times today and each
>time I can not see the instance name of the installation.
>I have removed any existing directories, cleared the
>obvious things from the registry, changed the instance
>name and even chosen different target and data
>directories to try and solve the problem. The service
>seems to have started correctly, but I do not get
>a green play icon in the system tray at the bottom of
>the screen. When i open the server manager I
>can not see the server running at all.
>I do not know what to do next. Does anyone have any
>ideas as to what what be causing this problem?
>Many thanks for your assistance in helping me to
>solve this problem.
>Regards,
>Jason.

No Data Selected message back to .Net

Hi All
We have a .net application calling some reporting services reports and we
pass the parameters to the reports from the application.
When no data is selected, is there any way to pass a paramter or something
back to the .net application so that we can display a 'No data selected'
message within the .net application.
Thanks
PeteI don't know if you can hook into this at the report level, but the data
regions (table, subreport, matrix, etc.) have a NoRows property that can
display a message if the source data set is empty.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"P" <P@.discussions.microsoft.com> wrote in message
news:B52C45F6-E67A-42B9-8517-3107FA071C93@.microsoft.com...
> Hi All
> We have a .net application calling some reporting services reports and we
> pass the parameters to the reports from the application.
> When no data is selected, is there any way to pass a paramter or something
> back to the .net application so that we can display a 'No data selected'
> message within the .net application.
> Thanks
> Pete

No data retuned

Hi,
Does anyone know of a way to show a user that there is no data returned into a report from a query, I am using ASP.NET with reportviewer and if the report does not return data I want to tell the user and not let them wait for no response. Is there a method or property within crystal that I can use?CrystalViewer control provides two functions called GetCurrentPageNumber() and ShowFirstPage(). Using these two functions you could move your cursor to page 1 and then try getting Getcurrentpagenumber or either call GetCurrentPageNumber which if returns 0 then there is no data else there is a data.

Thanks

No data in datagrid

Hi,
Could anyone help me?
I'm trying to create a datagrid using ASP.NET. It works fine
except the coloum that is supposed to display the entrydate is blank. All
the other information displays correctly.
I used the following code to create the table on the SQL server.
CREATE TABLE ManuscriptList
(
u_id INT NOT NULL IDENTITY,
u_manuscripttitle VARCHAR( 100 ),
u_manuscriptauthor VARCHAR( 100 ),
u_genre VARCHAR( 100 ),
u_wordcount VARCHAR( 100 ),
u_critiquecount VARCHAR( 100 ),
u_entrydate DATETIME Default getDate()
)
Is the problem something to do with the last line [i.e. u_entrydate DATETIME
Default getDate()] or is it something to do with the ASP.NET code?
Thanks for your time
Paul Evans
ASP.net.
David Gugick
Imceda Software
www.imceda.com

No connection to local SQL Server when no network connection

Hi !
We are using Windows XP,
ADO.NET in our application (programming language: C#),
MS SQL Server 2000.
The computer is a SONY notebook.
SQL server is running on the same machine as the application.
The application has worked in many, many cases under W2K and even XP.
But on that computer it doesn't work:
When there is no network connection,
then the application CANNOT connect to our DB.
On the other hand, Enterprise Manager CAN connect.
When we plug in the network and restart the computer,
then the application CAN connect.
However, SQL Server is running locally !
The connection string for connecting our app to the database is something
like:
sqlConnection.ConnectionString =
"packet size=4096;user id=BIS;persist security info=false;initial
catalog=BIS; server=(local)";
How can we fix that problem ?
Your kind help would be appreciated.
Peter
I have had similar issues - am not sure why though.
However,I seem to be able to connect by either using the (local) or the
actual PC name - it just seems to change its behaviour depending on the
network connectivity status.
Hope this is of some help.
LeMuppet
lemuppet
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message411117.html

No connection could be made because the target machine actively refused it

Hi,

I have successfully created a project (using VS.Net 2003 and SQL Server Analysis Services 2000) which is dynamically retrieving dimensions, levels, and members, and i generating and executing a query as per user needs and requirements. However when I tried to deploy the project on another machine, even though the apps is running fine, and the query getting generated, when its trying to show the data in the report-display page using ADOMD.Net, the following error was shown.

No connection could be made because the target machine actively refused it

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SocketException (0x274d): No connection could be made because the target machine actively refused it]

System.Net.Sockets.Socket.Connect(EndPoint remoteEP) +307

System.Net.Sockets.TcpClient.Connect(IPEndPoint remoteEP) +24

System.Net.Sockets.TcpClient.Connect(IPAddress address, Int32 port) +81

Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +208

[AdomdConnectionException: A connection cannot be made. Ensure that the server is running.]

Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +384

Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) +51

Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) +398

Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection+IXmlaClientProviderEx.ConnectXmla() +124

Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) +144

Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() +601

cubicdimension.Reportdisp.Page_Load(Object sender, EventArgs e) in E:\Inetpub\wwwroot\cubicdimension\Reportdisp.aspx.vb:65

System.Web.UI.Control.OnLoad(EventArgs e) +67

System.Web.UI.Control.LoadRecursive() +35

System.Web.UI.Page.ProcessRequestMain() +731

May I mention here, that the computer where I tried deploying, has SQL Server 2000 as well as SQL Server 2005. I tried reinstalling MSXML, but the computer already has a higher version of MSXML.

Any help in this regard would be appreciated.

Best Wishes.

Check Programs/SQL Server 2005/ Configuration tools/SQL Server Surface Area Configuration.

In "Surface Area Configuration for services and connection", you click on the service and remote connections.

See that you have local and remote connections activated.

HTH

Thomas Ivarsson

No access from Application to SQL Server 2000

I have installed the SQL Server 2000 and its up running.

I can connect to the database direct as administrator, but my test application(asp.net 2.0) returns an exception.

SqlConnection sqlConn = new SqlConnection("data source=10.61.90.24;initial catalog=testdb;persist security info=False;user id=sa;pwd=data;Type System Version=SQL Server 2000;");

sqlConn.Open();

I receive this exception:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

This is a configuration problem. You need to go into the 'SQL Server Configuration' tool and enable Named Pipes.

Regards

Paul.

|||

I have enabled Named Pipes.The connection is still failed.

thanks.

NewID

Hello,

I use VB.Net and SQL CE 2.0. I'd like to start using UniqueIdentifier fields as my primary keys.

I saw that this would return a NewID value

System.Guid.NewGuid().ToString()

however, it is not supported in Compact Framework. So how can one obtain the next NewId()?

Thank you.

NewGuid() is supported in .NET CF 2.0. You can also have a look at this article: http://msdn2.microsoft.com/en-us/library/aa446557.aspx - Generating GUIDs on the Pocket PC

Newbie:Why this Select doesn't work ?

On ASP.NET 2.0, VB, I try to let user input data on TxtBox1.Text. Then I
would like to go to SQL database named PUBS and compare the "TxtBox1.Text"
against the table "job_id". If the results match, I return on the screen
"Information matched. Your password will be reset".
First, how can I establish the connection to the "pubs" and retrieve such
information ? The code below return error "job_id" not declared. Do I really
have to declare the "job_id" or something else I did is not working ?
rtial Class Default_aspx
Sub btnDefault_Click(ByVal sender As Object, ByVal e As
System.EventArgs)
Dim sConnect As String = ConfigurationSettings.ConnectionStrings_
("pubs").ConnectionString
Dim sSQL As String = "SELECT Employee, " _
& "WHERE job_id = TxtBox1.Text"
End Sub
End Class> Dim sSQL As String = "SELECT Employee, " _
> & "WHERE job_id = TxtBox1.Text"
Your query string should be "Select * from Employee where job_id = '" &
TxtBox1.Text & "'"
"Mr. Magoo" <maggo@.nospasm.com> wrote in message
news:ub3B3mUJFHA.1176@.TK2MSFTNGP12.phx.gbl...
> On ASP.NET 2.0, VB, I try to let user input data on TxtBox1.Text. Then I
> would like to go to SQL database named PUBS and compare the
> "TxtBox1.Text" against the table "job_id". If the results match, I return
> on the screen "Information matched. Your password will be reset".
> First, how can I establish the connection to the "pubs" and retrieve such
> information ? The code below return error "job_id" not declared. Do I
> really have to declare the "job_id" or something else I did is not working
> ?
> rtial Class Default_aspx
> Sub btnDefault_Click(ByVal sender As Object, ByVal e As
> System.EventArgs)
> Dim sConnect As String = ConfigurationSettings.ConnectionStrings_
> ("pubs").ConnectionString
> Dim sSQL As String = "SELECT Employee, " _
> & "WHERE job_id = TxtBox1.Text"
> End Sub
> End Class
>|||There is no From clause in this select statement. You need to specify that.
Dim sSQL As String = "SELECT Employee From Pubs " _
& "WHERE job_id = " & TxtBox1.Text
Thanks
Baiju
"Mr. Magoo" <maggo@.nospasm.com> wrote in message
news:ub3B3mUJFHA.1176@.TK2MSFTNGP12.phx.gbl...
> On ASP.NET 2.0, VB, I try to let user input data on TxtBox1.Text. Then I
> would like to go to SQL database named PUBS and compare the
"TxtBox1.Text"
> against the table "job_id". If the results match, I return on the screen
> "Information matched. Your password will be reset".
> First, how can I establish the connection to the "pubs" and retrieve such
> information ? The code below return error "job_id" not declared. Do I
really
> have to declare the "job_id" or something else I did is not working ?
> rtial Class Default_aspx
> Sub btnDefault_Click(ByVal sender As Object, ByVal e As
> System.EventArgs)
> Dim sConnect As String = ConfigurationSettings.ConnectionStrings_
> ("pubs").ConnectionString
> Dim sSQL As String = "SELECT Employee, " _
> & "WHERE job_id = TxtBox1.Text"
> End Sub
> End Class
>|||You guys are rocking !!
"Baiju" <baiju@.indus-systems.com> wrote in message
news:eBE94EVJFHA.2640@.TK2MSFTNGP09.phx.gbl...
> There is no From clause in this select statement. You need to specify
> that.
> Dim sSQL As String = "SELECT Employee From Pubs " _
> & "WHERE job_id = " & TxtBox1.Text
> Thanks
> Baiju
> "Mr. Magoo" <maggo@.nospasm.com> wrote in message
> news:ub3B3mUJFHA.1176@.TK2MSFTNGP12.phx.gbl...
> "TxtBox1.Text"
> really
>

Newbie:if query is successful, how to response.write on screen ?

I did this in the past using .asp, but with ASP.NET 2.0 perhaps things have
really changed, because I do response.write(TextBox1.Text) and doesn't work.
Here is what I am trying to:
Partial Class Default_aspx
Sub btnDefault_Click(ByVal sender As Object, ByVal e As
System.EventArgs)
Dim myString
myString = "SELECT Employee From Pubs " _
& "WHERE job_id = " & TxtBox1.Text
'If job_id = TxtBox1.Text is found Then
'I want to go a new page and displays on the screen 'OK
info matched'
'How can I jump to a new page from here ? (Pardon me if
this should be a question posted to .ASP newsgroup maybe ? )
Else
'Display TxtBox1.Text input did not match information in
the db'
Response.Write("Please click the 'back' button and try
to resubmit 'secret question' to reset password again.")
End If
End Sub
End ClassThis should be in an asp.net group. However, here are your answers:
First off, Response.Write's are generally discouraged, especially for what
you are doing. You should have a label and set the label's text to the
strings to display. Your sql should never ever under any circumstances be
created like that. Use stored procedures or at least parameterized queries.
Also, please google sql injection attacks to see why this is bad.
Judging from the code you posted it looks like you are doing authentication
of some kind. You might want to take a look at forms authentication. To
redirect someone to a new page you can do a
Response.Redirect("myOtherPage.html").

newbie: value expression... uses an aggregate expression w/o a sco

simply added a report parameter for a working report (which went fine and w/o
issue..)
next thing, went to build the report in VS.NET and got 100 Build Errors
telling me that every TextBox on my summary page has the error:
'The value expression for the textbox '...' uses an aggregate expression
with a scope...'
Newbie (I know), but what on earth did I do that would have screwed up
everything like this?
( Scope for what? The report and parameters already have everything they
need as far as data goes.)
Rob(this is a frickin nightmare...)
So it looks like every time I try to add a new report parameter, after
deleting the original (simply the report parameter became a different report
item), about half of the textboxes which are sums and counts threw this error
(which is nutty as heck, since about 2/3, which have the same thing are OK).
Is this some kind of bug? (Deleted all Report Parameters and I can compile
w/o errors.)
What's going on with this and what does it take to 'set the scope'.
Rob
"RobKaratzas" wrote:
> simply added a report parameter for a working report (which went fine and w/o
> issue..)
> next thing, went to build the report in VS.NET and got 100 Build Errors
> telling me that every TextBox on my summary page has the error:
> 'The value expression for the textbox '...' uses an aggregate expression
> with a scope...'
> Newbie (I know), but what on earth did I do that would have screwed up
> everything like this?
> ( Scope for what? The report and parameters already have everything they
> need as far as data goes.)
> Rob
>

newbie: Preview in VS.NET looks great, RS has poor alignment

hi folks
(newbie question) why in VS.NET, my preview'd reports look wonderful (from
imported MS Access report definitions), BUT from the web they look awful...
Am I possibility (most likely) missing something? One would believe that the
preview in VS.NET would be the same rendering mechanism from RS?
column heading misalignment, field misalignment, etc.
Respectfully
Robthat's normal, by grouping elements (that should stay together) in a
rectangle you can greatly improve your control of the web-layout
"RobKaratzas" wrote:
> hi folks
> (newbie question) why in VS.NET, my preview'd reports look wonderful (from
> imported MS Access report definitions), BUT from the web they look awful...
> Am I possibility (most likely) missing something? One would believe that the
> preview in VS.NET would be the same rendering mechanism from RS?
> column heading misalignment, field misalignment, etc.
> Respectfully
> Rob|||Hi Antoon,
I've had this problem as well...what do you mean by 'grouping in a
rectangle'?
My way of solving this problem was to create a table that called a SP
that returned exactly one row and then put what I wanted into the
table. It worked, but I figured there must be a better way...
Peter|||If you want to keep report-elements together (textboxes, rectangles, lines,
immages,...). You draw a (transparent) rectangle first and then draw (ore
move) alle your elements in this rectangle.
The rectangle functions as a container (you move alle the elements by moving
the rectangle. And the elements will not "rearange themselfs" if they are
closly contained
"Peter Nolan" wrote:
> Hi Antoon,
> I've had this problem as well...what do you mean by 'grouping in a
> rectangle'?
> My way of solving this problem was to create a table that called a SP
> that returned exactly one row and then put what I wanted into the
> table. It worked, but I figured there must be a better way...
> Peter
>|||hi
I tried this with just the Page Header (by putting everything in a
rectangle). Can tell I did it right since moving the rectangle moves all of
the texboxes, but this had no effect whatsoever. (Again, the preview in
VS.NET looks wonderful, but the browser 'View Report' is very mangled (with
items getting cut-off, being moved to a new line vs. sized correctly.)
Am I missing something here?
Rob
(I am a newbie, but I use to teach MS Access classes back in 95-97 and was a
cert'd access and developer, so I wouldn't consider myself untrainable.)
"Antoon" wrote:
> If you want to keep report-elements together (textboxes, rectangles, lines,
> immages,...). You draw a (transparent) rectangle first and then draw (ore
> move) alle your elements in this rectangle.
> The rectangle functions as a container (you move alle the elements by moving
> the rectangle. And the elements will not "rearange themselfs" if they are
> closly contained
> "Peter Nolan" wrote:
> > Hi Antoon,
> > I've had this problem as well...what do you mean by 'grouping in a
> > rectangle'?
> >
> > My way of solving this problem was to create a table that called a SP
> > that returned exactly one row and then put what I wanted into the
> > table. It worked, but I figured there must be a better way...
> >
> > Peter
> >
> >|||You might be missing something.
On the menu go to Report > Report Properties and under layout ensure that
the Page width minus left and right margins is >= your report body width.
e.g. Most of my reports are landscape 11" with .5" margins. So when I create
reports I can only stretch the body to 10" or it will give me unexpected
results in the browser or when printed.
HTH.
Cheerios.
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:037C6FCF-0078-4AA2-8C37-AFD0173FCC04@.microsoft.com...
> hi
> I tried this with just the Page Header (by putting everything in a
> rectangle). Can tell I did it right since moving the rectangle moves all
of
> the texboxes, but this had no effect whatsoever. (Again, the preview in
> VS.NET looks wonderful, but the browser 'View Report' is very mangled
(with
> items getting cut-off, being moved to a new line vs. sized correctly.)
> Am I missing something here?
> Rob
> (I am a newbie, but I use to teach MS Access classes back in 95-97 and was
a
> cert'd access and developer, so I wouldn't consider myself untrainable.)
> "Antoon" wrote:
> > If you want to keep report-elements together (textboxes, rectangles,
lines,
> > immages,...). You draw a (transparent) rectangle first and then draw
(ore
> > move) alle your elements in this rectangle.
> > The rectangle functions as a container (you move alle the elements by
moving
> > the rectangle. And the elements will not "rearange themselfs" if they
are
> > closly contained
> >
> > "Peter Nolan" wrote:
> >
> > > Hi Antoon,
> > > I've had this problem as well...what do you mean by 'grouping in a
> > > rectangle'?
> > >
> > > My way of solving this problem was to create a table that called a SP
> > > that returned exactly one row and then put what I wanted into the
> > > table. It worked, but I figured there must be a better way...
> > >
> > > Peter
> > >
> > >|||hi
double-checked what you said and all of my margins as well as width are fine.
(and would be glad to send you screenshots, just to clariy what I'm seeing.
thing that puzzles me is that these are reports that the import has
determined how to best interpret the layout. I'm in the process of migrating
60 of them and will let everyone know if I have any 'breakthroughs')
made no difference (width 10.5, margins 0.0)
but thanks, rob
"Nice_Out" wrote:
> You might be missing something.
> On the menu go to Report > Report Properties and under layout ensure that
> the Page width minus left and right margins is >= your report body width.
> e.g. Most of my reports are landscape 11" with .5" margins. So when I create
> reports I can only stretch the body to 10" or it will give me unexpected
> results in the browser or when printed.
> HTH.
> Cheerios.
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:037C6FCF-0078-4AA2-8C37-AFD0173FCC04@.microsoft.com...
> > hi
> >
> > I tried this with just the Page Header (by putting everything in a
> > rectangle). Can tell I did it right since moving the rectangle moves all
> of
> > the texboxes, but this had no effect whatsoever. (Again, the preview in
> > VS.NET looks wonderful, but the browser 'View Report' is very mangled
> (with
> > items getting cut-off, being moved to a new line vs. sized correctly.)
> >
> > Am I missing something here?
> >
> > Rob
> > (I am a newbie, but I use to teach MS Access classes back in 95-97 and was
> a
> > cert'd access and developer, so I wouldn't consider myself untrainable.)
> >
> > "Antoon" wrote:
> >
> > > If you want to keep report-elements together (textboxes, rectangles,
> lines,
> > > immages,...). You draw a (transparent) rectangle first and then draw
> (ore
> > > move) alle your elements in this rectangle.
> > > The rectangle functions as a container (you move alle the elements by
> moving
> > > the rectangle. And the elements will not "rearange themselfs" if they
> are
> > > closly contained
> > >
> > > "Peter Nolan" wrote:
> > >
> > > > Hi Antoon,
> > > > I've had this problem as well...what do you mean by 'grouping in a
> > > > rectangle'?
> > > >
> > > > My way of solving this problem was to create a table that called a SP
> > > > that returned exactly one row and then put what I wanted into the
> > > > table. It worked, but I figured there must be a better way...
> > > >
> > > > Peter
> > > >
> > > >
>
>|||it actually prints real nice, in terms of layout... (close to how the VS.NET
preview looks).
rob
"RobKaratzas" wrote:
> hi
> double-checked what you said and all of my margins as well as width are fine.
> (and would be glad to send you screenshots, just to clariy what I'm seeing.
> thing that puzzles me is that these are reports that the import has
> determined how to best interpret the layout. I'm in the process of migrating
> 60 of them and will let everyone know if I have any 'breakthroughs')
> made no difference (width 10.5, margins 0.0)
> but thanks, rob
> "Nice_Out" wrote:
> > You might be missing something.
> > On the menu go to Report > Report Properties and under layout ensure that
> > the Page width minus left and right margins is >= your report body width.
> > e.g. Most of my reports are landscape 11" with .5" margins. So when I create
> > reports I can only stretch the body to 10" or it will give me unexpected
> > results in the browser or when printed.
> >
> > HTH.
> > Cheerios.
> >
> > "Rob" <Rob@.discussions.microsoft.com> wrote in message
> > news:037C6FCF-0078-4AA2-8C37-AFD0173FCC04@.microsoft.com...
> > > hi
> > >
> > > I tried this with just the Page Header (by putting everything in a
> > > rectangle). Can tell I did it right since moving the rectangle moves all
> > of
> > > the texboxes, but this had no effect whatsoever. (Again, the preview in
> > > VS.NET looks wonderful, but the browser 'View Report' is very mangled
> > (with
> > > items getting cut-off, being moved to a new line vs. sized correctly.)
> > >
> > > Am I missing something here?
> > >
> > > Rob
> > > (I am a newbie, but I use to teach MS Access classes back in 95-97 and was
> > a
> > > cert'd access and developer, so I wouldn't consider myself untrainable.)
> > >
> > > "Antoon" wrote:
> > >
> > > > If you want to keep report-elements together (textboxes, rectangles,
> > lines,
> > > > immages,...). You draw a (transparent) rectangle first and then draw
> > (ore
> > > > move) alle your elements in this rectangle.
> > > > The rectangle functions as a container (you move alle the elements by
> > moving
> > > > the rectangle. And the elements will not "rearange themselfs" if they
> > are
> > > > closly contained
> > > >
> > > > "Peter Nolan" wrote:
> > > >
> > > > > Hi Antoon,
> > > > > I've had this problem as well...what do you mean by 'grouping in a
> > > > > rectangle'?
> > > > >
> > > > > My way of solving this problem was to create a table that called a SP
> > > > > that returned exactly one row and then put what I wanted into the
> > > > > table. It worked, but I figured there must be a better way...
> > > > >
> > > > > Peter
> > > > >
> > > > >
> >
> >
> >

Newbie: Object name 'ProductSubCategory' is not valid.

Hi all,
I have just installed Reporting Services in a W2003 server (without VS.Net).
and SQL Server 2000.
I have run the Report Administrator, and after inserting my the windows
admin user and its password, looks like it works.
Then I load the example file Company Sales.rdl which is in the
Samples\Reports folder. looks like it loads perfectly.
But when I click on it in order to see the file, gives me that error:
Error while processing report(rsProcessingAborted). Query execution error
for Sales dataset (rsErrorExecutingCommand).
The object name 'ProductSubCategory' is not valid.
What am I doing wrong?
Any help/hint or whatever will be wellcome.
Thanks in advance,
Ibai Peña"Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
<cut>
> Then I load the example file Company Sales.rdl which is in the
> Samples\Reports folder. looks like it loads perfectly.
> But when I click on it in order to see the file, gives me that error:
> Error while processing report(rsProcessingAborted). Query execution error
> for Sales dataset (rsErrorExecutingCommand).
> The object name 'ProductSubCategory' is not valid.
>
Have you created the Datasource yet? You need to create a data source for
the sample reports to run. The Books Online explains how to and what
settings to use.
Kaisa|||Thank you for your replay.
I was just to post that I have found that the datasource wasn´t defined.
What leads me to the next question:
Is is possible to set a default datasource for all reports?
Thanks,
Ibai Peña
"Kaisa M. Lindahl" wrote:
> "Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
> news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
> <cut>
> > Then I load the example file Company Sales.rdl which is in the
> > Samples\Reports folder. looks like it loads perfectly.
> >
> > But when I click on it in order to see the file, gives me that error:
> >
> > Error while processing report(rsProcessingAborted). Query execution error
> > for Sales dataset (rsErrorExecutingCommand).
> > The object name 'ProductSubCategory' is not valid.
> >
> Have you created the Datasource yet? You need to create a data source for
> the sample reports to run. The Books Online explains how to and what
> settings to use.
> Kaisa
>
>|||RSConfig.exe file. Sorry, sometimes it is better to spend some time before
asking.
Regards,
Ibai Peña
"Ibai Peña" wrote:
> Thank you for your replay.
> I was just to post that I have found that the datasource wasn´t defined.
> What leads me to the next question:
> Is is possible to set a default datasource for all reports?
> Thanks,
> Ibai Peña
> "Kaisa M. Lindahl" wrote:
> > "Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
> > news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
> > <cut>
> > > Then I load the example file Company Sales.rdl which is in the
> > > Samples\Reports folder. looks like it loads perfectly.
> > >
> > > But when I click on it in order to see the file, gives me that error:
> > >
> > > Error while processing report(rsProcessingAborted). Query execution error
> > > for Sales dataset (rsErrorExecutingCommand).
> > > The object name 'ProductSubCategory' is not valid.
> > >
> >
> > Have you created the Datasource yet? You need to create a data source for
> > the sample reports to run. The Books Online explains how to and what
> > settings to use.
> > Kaisa
> >
> >
> >