Problem in generating Excel worksheets

In the Report Designer, I insert some page breaks after data regions. When
exporting to excel format, the pages are displayed as several worksheets in
the excel. But I found no way to specify the name of worksheet in Report
Designer.Is there any ways to do that?
Thanks.There is no way to specify the name of the worksheet when exporting your
report. When exporting to excel, page breaks after a data region on your
report are interepreted as a new worksheet. I'm not sure if this is on the
wishlist or this capability will be included in RS 2005.
"Johnny Chow" wrote:
> In the Report Designer, I insert some page breaks after data regions. When
> exporting to excel format, the pages are displayed as several worksheets in
> the excel. But I found no way to specify the name of worksheet in Report
> Designer.Is there any ways to do that?
> Thanks.

Problem in connecting to the SQL Server

i created a dataset in asp.net and i am trying to view the page in the internet explorer and i am getting the following error

Login failed for user 'EASTERN-DFDRY3R\ASPNET'.
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: Login failed for user 'EASTERN-DFDRY3R\ASPNET'.

Source Error:

Line 29: {
Line 30: // Put user code to initialize the page here
Line 31: sqlDataAdapter1.Fill(dataSet11);
Line 32: DataGrid1.DataBind();
Line 33: }

Source File: c:\inetpub\wwwroot\key banking system\webform2.aspx.cs Line: 31

Stack Trace:

[SqlException: Login failed for user 'EASTERN-DFDRY3R\ASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +484
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
Key_Banking_system.WebForm2.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\key banking system\webform2.aspx.cs:31
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

please help me with this....and 'EASTERN-DFDRY3R\ASPNET' is a valid user for the database?|||i dont know understand ur question.|||'EASTERN-DFDRY3R\ASPNET' is the the name of '<MACHINE>\ASPNET' account. Sumas is obviously trying to connect to the DataBase using 'Trusted_Connection=True' in his connection string. To do this, he must add the ASPNET account to the DB user list, and give this account the necessary rights.

Open Enterprise mngr and find your Database, right click and choose 'New Database User'. Locate the 'EASTERN-DFDRY3R\ASPNET' account and add the account. Choose permissions and check 'db_owner'. That should do the trick.|||I'm not sure recommending db_owner is good idea, of course I NEVER do that myself <whistle> ;)

Plus if the server is on a different machine, i.e. not EASTERN_DFDRY3R (natty name by the way), then that local user won't be available. So you'll have to change the IIS/ASPNET user.

problem in accessing report manager and server

hi,

i installed RS 2005 on windows XP with local system account,report manager does not access.it gives

The page cannot be displayed

HTTP 500 - Internal server error
Internet Explorer

although reportmanager and reportserver directory is available in its default location.

and also when i clicked on any report on report server it gives

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Requested registry access is not allowed.

i am using my account having admin privlge

please help me.....

Amit,

Could you, please, take a look at the log files for the windows service and for the web service and let me know what errors you find there?

The RS log files are located here:

%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles

The log files for the RS windows service look like this: ReportServerService_(timestamp).log and the log files for the RS web service look like this: ReportServer_(timestamp).log.

Mihaela

problem in accessing report manager and server

hi,

i installed RS 2005 on windows XP with local system account,report manager does not access.it gives

The page cannot be displayed

HTTP 500 - Internal server error
Internet Explorer

although reportmanager and reportserver directory is available in its default location.

and also when i clicked on any report on report server it gives

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Requested registry access is not allowed.

i am using my account having admin privlge

please help me.....

Amit,

Could you, please, take a look at the log files for the windows service and for the web service and let me know what errors you find there?

The RS log files are located here:

%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles

The log files for the RS windows service look like this: ReportServerService_(timestamp).log and the log files for the RS web service look like this: ReportServer_(timestamp).log.

Mihaela

Problem exporting to a .pdf

I have a column that contains a field I use for grouping.
The field prints in both the page header and footer, but not the detail section.

Hidden for the column is true.
Hidden for the textbox (field) is false
DataElementOutput for the textbox (field) is Output.
DataElementStyle for the textbox is ElementNormal ( I also tried AttributeNormal but no joy)

Everything works except when I export to acrobat, in which case the field does not print in the page header or footer.

If column is hidden, how will it ever work and print in any format?

What exactly is your problem?

|||

What version of Reporting Services are you using? I would expect the field to be present in PDF on SQL Server 2005 SP2.

Does exporting to TIFF work? Can you please file a bug on http://connect.microsoft.com and include a copy of your RDL?

Thank you.

|||Also noticed that the group field displays when the page is rendered on screen but does not print. Am using sp2. Is this a bug?|||>>What version of Reporting Services are you using?
SS 2005 SP2
>>Does exporting to TIFF work?
Nay

Problem executing stored procedure from asp

We have an ASP page which executes a stored procedure this works fine on
windows 2000 server/SQL 2000 server. We are trying to use the same page
locally on WinXP SP2/MSDE 2000A and we seem to be experiencing a strange
problem. When run locally the asp complains that it cannot find the stored
procedure. We have run profiler on both Win2000 and locally and noticed that
the commands which are executed are very different.See below
Win 2000 Server/SQL Server 2000
RPC:Completed exec spShowPhysicalBlockSeats 'TEST', 'E16' Microsoft(R)
Windows (R) 2000 Operating System sa 0 2104 0 173 1304 71 2004-11-15
11:37:49.787
WinXP/MSDE2000A
SQL:BatchCompleted spShowPhysicalBlockSeats Microsoft Windows Operating
System sa 0 4 0 0 3840 55 2004-11-15 11:36:25.927
RPC:Completed exec spShowPhysicalBlockSeats Microsoft Windows Operating
System sa 0 4 0 0 3840 55 2004-11-15 11:36:25.927
SQL:BatchCompleted select * from spShowPhysicalBlockSeats Microsoft
Windows Operating System sa 0 4 0 16 3840 55 2004-11-15 11:36:25.927
The asp page istelf is unchanged apart from the connection string, as you
can imagine we are a little confused about why the execution is so
different, and why the WinXP version seems to execute it 3 times in slightly
different ways.
Any help or advice would be greatly received.
Cheers
Andy
Well I can account for two differences: (a) on Windows 2000, you didn't
capture the SQL:BatchCompleted event in profiler, and (b) you called the
stored procedure with different parameters.
Can you show us the code for the stored procedure, the ASP Code that is
calling it, and whether you see any major differences aside from what your
*different* traces show using *different* SP calls?
http://www.aspfaq.com/
(Reverse address to reply.)
"Andy Kerner" <andrewkerner@.hotmail.com> wrote in message
news:#bSUxhwyEHA.3120@.TK2MSFTNGP12.phx.gbl...
> We have an ASP page which executes a stored procedure this works fine on
> windows 2000 server/SQL 2000 server. We are trying to use the same page
> locally on WinXP SP2/MSDE 2000A and we seem to be experiencing a strange
> problem. When run locally the asp complains that it cannot find the stored
> procedure. We have run profiler on both Win2000 and locally and noticed
that
> the commands which are executed are very different.See below
> Win 2000 Server/SQL Server 2000
> --
> RPC:Completed exec spShowPhysicalBlockSeats 'TEST', 'E16' Microsoft(R)
> Windows (R) 2000 Operating System sa 0 2104 0 173 1304 71 2004-11-15
> 11:37:49.787
> WinXP/MSDE2000A
> --
> SQL:BatchCompleted spShowPhysicalBlockSeats Microsoft Windows Operating
> System sa 0 4 0 0 3840 55 2004-11-15 11:36:25.927
> RPC:Completed exec spShowPhysicalBlockSeats Microsoft Windows Operating
> System sa 0 4 0 0 3840 55 2004-11-15 11:36:25.927
> SQL:BatchCompleted select * from spShowPhysicalBlockSeats Microsoft
> Windows Operating System sa 0 4 0 16 3840 55 2004-11-15 11:36:25.927
> The asp page istelf is unchanged apart from the connection string, as you
> can imagine we are a little confused about why the execution is so
> different, and why the WinXP version seems to execute it 3 times in
slightly
> different ways.
> Any help or advice would be greatly received.
> Cheers
> Andy
>

Problem due to locking in MSSQLServer 2000

Insert or update statements seems to be locking entire
page or table rather than locking
the corresponding row to be inserted or updated.
lets assume the table with 3 rows.
scenario 1)
In transaction A, I'm updating the 3'rd row. and in
another transaction B I'm reading
row 1.
Transaction B seems to be waiting for transaction A to
finish before returning the select results.
Scenario 2)
In transaction A, I'm inserting new row (4'th row) and in
another transaction B I'm reading
row 1.
here as well trasaction B does not return the row 1 unless
transaction A is complete.
Select operation is blocked due to insert.
Ideally in both the scenarios , read operation should have
returned the results without waiting
for update/insert to finish. As the read is being done on
different rows than that of being updated
or inserted.
I have tried both the insert/update as well as select
queries with all the possible locking hints
such as ROWLOCK, READCOMMITED, UPDLOCK etc...
The only way select query returns the row without blocking
is by using the NOLOCK locking hint. But then this is
not the proper solution as it gives us the dirty read.
Please suggest me any solution or workaround for above
issue.Adding to Tony's comments (the DDL/DML will be useful), you might find the
problem is that it's the index page that's locked during the update/insert
which is blocking the select. How many rows are in the table we're
discussing?
Depending on the WHERE clause and the optimizer query plans, sometimes row
locks are NOT released until the entire statement has finished, and
sometimes these can be escalated to table locks. See
http://www.hanlincrest.com/SQLServerLockEscalation.htm for a description.
I couldn't quite figure it out from your note, but is it the same process
attempting to execute two separate transactions on two SQL Server sessions
and thus blocking itself? If this is the case it would be wise to rethink it
so only one transaction is active from the process ar once.
Kind Regards, Howard
"Sangram Deshmukh" <sangram@.savvion.com> wrote in message
news:0c2e01c34ad9$841875a0$a301280a@.phx.gbl...
> Insert or update statements seems to be locking entire
> page or table rather than locking
> the corresponding row to be inserted or updated.
> lets assume the table with 3 rows.
> scenario 1)
> In transaction A, I'm updating the 3'rd row. and in
> another transaction B I'm reading
> row 1.
> Transaction B seems to be waiting for transaction A to
> finish before returning the select results.
>
> Scenario 2)
> In transaction A, I'm inserting new row (4'th row) and in
> another transaction B I'm reading
> row 1.
> here as well trasaction B does not return the row 1 unless
> transaction A is complete.
> Select operation is blocked due to insert.
>
> Ideally in both the scenarios , read operation should have
> returned the results without waiting
> for update/insert to finish. As the read is being done on
> different rows than that of being updated
> or inserted.
> I have tried both the insert/update as well as select
> queries with all the possible locking hints
> such as ROWLOCK, READCOMMITED, UPDLOCK etc...
> The only way select query returns the row without blocking
> is by using the NOLOCK locking hint. But then this is
> not the proper solution as it gives us the dirty read.
> Please suggest me any solution or workaround for above
> issue.

Problem creating Page Header

I'm trying to create a page header in a report. The report is a simple list
of participants in one of our training programs. I'm trying to put the title
of the training program in the header of the report. According to
directions, I placed the field textbox in the body of the report. eg.
=First(Fields!Event_Title.Value, "EventListHeader"). I then placed an empty
text box into the header section of the report. I then right click the empty
text box and in the expression builder type
=First(ReportItems!Event_Title.Value, "EventListHeader"). After I save this
and recompile, I get the following error message:
The value expression for the textbox â'textbox4â' uses a scope parameter for
an aggregate function. The scope parameter cannot be used in page headers or
footers.
I would appreciate any help with this. I'm just learning and I can't find
any documentation on this error message.
--
MelissaIn the page header, you need to reference the textbox name, not the dataset
field. Which textbox is named textbox4?
"Melissa" wrote:
> I'm trying to create a page header in a report. The report is a simple list
> of participants in one of our training programs. I'm trying to put the title
> of the training program in the header of the report. According to
> directions, I placed the field textbox in the body of the report. eg.
> =First(Fields!Event_Title.Value, "EventListHeader"). I then placed an empty
> text box into the header section of the report. I then right click the empty
> text box and in the expression builder type
> =First(ReportItems!Event_Title.Value, "EventListHeader"). After I save this
> and recompile, I get the following error message:
> The value expression for the textbox â'textbox4â' uses a scope parameter for
> an aggregate function. The scope parameter cannot be used in page headers or
> footers.
> I would appreciate any help with this. I'm just learning and I can't find
> any documentation on this error message.
>
> --
> Melissa|||Thank you, DAW. You pointed me in the right direction. For anyone else who
is encountering the same problem, here's the solution. The text box in the
report header (e.g. textbox4) should reference the textbox name that holds
the field value you want in the report header (e.g. Event_Title_1). This
field value text box must exist in the report body. In the report header
textbox (e.g. textbox4), create an expression using the global collection
(ReportItems). Here is the syntax for my solution
=(ReportItems!Event_title_1.Value)
--
Melissa
"Melissa" wrote:
> I'm trying to create a page header in a report. The report is a simple list
> of participants in one of our training programs. I'm trying to put the title
> of the training program in the header of the report. According to
> directions, I placed the field textbox in the body of the report. eg.
> =First(Fields!Event_Title.Value, "EventListHeader"). I then placed an empty
> text box into the header section of the report. I then right click the empty
> text box and in the expression builder type
> =First(ReportItems!Event_Title.Value, "EventListHeader"). After I save this
> and recompile, I get the following error message:
> The value expression for the textbox â'textbox4â' uses a scope parameter for
> an aggregate function. The scope parameter cannot be used in page headers or
> footers.
> I would appreciate any help with this. I'm just learning and I can't find
> any documentation on this error message.
>
> --
> Melissa

problem conneting to SQL server 2000 on Win2k3 from ASP page using dsn connectio

Hi,
the log in user has default database set and also in the
connection string information i am specifying database
name along with DSN.But still i am not able to
connect.Please help me in this

>--Original Message--
>Make sure that your login has its default database
>properly set. Another option is to ensure that your DSN
>is changing the database from the default to the one you
>wish to use.
>Sincerley,
>Invotion Engineering Team
>Advanced Microsoft Hosting Solutions
>http://www.Invotion.com
>
>connect.I
>responding
>pointing
>then
>connection
>.
>If you go into the DSN and choose "test connection" and enter the same id
and password you specify in your ASP page does the test work?
If you use trusted authentication in your ASP page connection string will
it work?
Use SQL Profiler and/or netmon to see exactly what is happening when you
see the "hang". It may not have anything to do with the connection, it may
be a problem with the code after the initial connection.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

problem connecting to the database

Hi...

I just started to go through the "Microsoft visual c# 2005 step by step" I noticed on page 412 when i try to connect to the database, it says tochoose "Microsoft SQL server" from the Choose datasource menu. But I dont have Microsoft SQL Server. There are only "Microsoft Access Database file" and "Microsoft SQL Server Database File" and not "Microsoft SQL Server".

Please Help

Sunil

Hi,

Do you have the MDAC 2.6 or later installed?

Regards,

Janos

|||Unless you choose to install SQL Server (download the free SQL Server 2005 Express here), you will have to use the Access file connection process.|||

thanks for the reply Janos... I'm fairly new to the SQL stuff... What is MDAC?

Thanks

Sunil

|||

thanks for the reply arnie.... yes i did install the free sql server 2005 express.... i still cant figure it out... i used the commands at the dos prompt to configure the SQL server like it says in the book and everything was good...

then i used sqlcmd -S yourserver\SQLExpress - E -iinstnwnd.sql

That was also successfull....

still i dont see "microsoft SQL server" in the choose datasource section. But i do see "Microsoft SQL server database file".

Thank you

|||

Hi,

Please follow Arnie Rowland's post. You should have SQL Server installed.

Regards,

Janos

|||Seems that you are using Visual Studio Express. If so, the behaviour is by design.

http://msdn2.microsoft.com/en-us/vstudio/aa700921.aspx

But you can code against it.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

i'm sorry..i dont follow...what does it mean by design?

thank u

sunil

|||VS Express is not able to connect to SQL Server Express in the GUI (locked down feature) but you can programmtically access the Server.

Jens K. Suessmeyer.

http://www.sqlserver2005.de