Problem in installing SQLSERVER2000 Developer Edition

You have a TCP/IP alias established created on your computer. Remove it and
setup should complete successfully. Setup starts SQL Server in a mode to
accept only shared memory connections. The alias is preventing setup from
connecting.
Run cliconfg from Start - Run. Go to the ALias tab and delete the alias for
this server, You do not need it. Or should not need it. If you do then
there is another problem that needs to be addressed.
Rand
This posting is provided "as is" with no warranties and confers no rights.Rand!
You the man! I was about to have a heart attack when i had uninstalled our
SQL Developer server and could not install Standard edition. Your suggestio
n worked like a charm! Your advice is excellent even 6 months later.

Problem in inserting value in view

Hi There,

i have created one view on an exsisting table, but when i am inserting value in it, it is giving the following error msg:

Derived table 'View Name' is not updatable because a column of the derived table is derived or constant.

Thanx

Is this related to SSIS? Well the error is coming straight from SQL Server itself, and is fairly clear to me.

You cannot update a column that is not really a column. So what columns are being updated and can you honestly say they are unadulterated columns, and have not been derived or manipulated in any way before being returned from the view.?

If you want a specific answer then post the UPDATE statement and a the DDL (CREATE VIEW...) for the view.

Problem in importing data from excel to sql2005

Hi
I have to import data from a number of excel files to corresponding tables in SQL 2005. The excel files are created using excel 4.0. I have created an excel connection manager and provided it with the path of the excel sheet.Next i have added an excel source from the toolbox to the dataflow. I have set the connection manger, data access mode, and the name of the excel sheet (the wizard detects the sheet correctly) in the dialog window i get when i double click the excel source. Every thing goes fine till here. Now when i select the 'columns' in this dialog window or the preview button, i get this error

TITLE: Microsoft Visual Studio

Error at Data Flow Task [Excel Source [1]]: An OLE DB error has occurred. Error code: 0x80004005.
Error at Data Flow Task [Excel Source [1]]: Opening a rowset for "test4$" failed. Check that the object exists in the database.

ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)

Any ideas about why is this happening?
UmerDid you specify the Excel 4.0 as the version in the connection manager?|||yes i have specified the version 4.0 in the connection manager

Problem in Drillthrough report

Hi Friends,

I am very new to MSSQL Reporting service 2005. I wanted to create a drithrough report. I have created a master report using a cube created using MSSQL Analysis service 2005. The master report contains a column called 'Territory', which details some other columns also. My child report contains the same 'Territory' column, but with displays some other detailed information. If I click on the territory column data on master report, it should take me to child report where it should show only Territory which matches with the master territory.

I have created both master & child reports. In my master report, Jump to Report, I have given the name of my child report. In my child report, if I have created a hidden parameter by providing available value through query. But while clicking the territory column master report I'm getting error parameter xxx is missing a value. If I uncheck as hidden parameter it pops up for the value & it works.

How to go about it, can someone help?

Thanks & Regards,

Naveen J V

Hi,

Its a long time ago as I had built my last report - but at the Jump to Report there is also a part where you map the Target Report Paramter to something of your current Report. There you have to specify the value for Target Report Parameter - your current Territory.

If you not specify the paramters it get set to the default parameter of null - which seems to be not allowed for your parameter.

It looks like this is more related to report server - I recommend you to post your question there if my hint does not help.

Mabe someone from MS moves it to the report server forum.

Best Regards

Hannes

problem in deploying the website developed in visual web developer 2005

Hi,

I am new to asp.net.I am trying to deploy the website on IIS created in visual web developer 2005 express.I am having problem with the aspnetdb.mdf for login.
I have copied my entire contents to the physical directory( shared floder),from where the iis virtual directory can access the contents.I can see my login form but when i enter my username and password and click login it gives my error
"error occured in establishing the connection".

I am using the sql server 2005.I don't know what should i do with aspnetdb.mdf?

thanks and urgent help needed

The following article mentions similar issue, you can take a look to see if it solves your problem.

http://forums.asp.net/1257344/ShowPost.aspx

Problem in Dataset

Hi,

dim ds as new MyDataset//This dataset i created while Using ADO.NET Connection
dim dset as new DataSet//This is Standard dataset
ds=SQLHelper.ExecuteDataSet(CommandType.StoredProcedure,"spr_Procedure1")

//There is no error in stored procedure
//Then i tried giving like this

dset=SQLHelper.ExecuteDataSet(CommandType.StoredProcedure,"spr_Procedure1")
ds=CType(dset,MyDataset)

//It shows the following error
System.InvalidCastException: Specified cast is not valid.

Or is there any way i can get the dataset using ADO.NET connection & stored
Procedure,If so plz send me the procedure

Thanx in advancePost your question at ADO.NET or VB.NET section to get much response

Problem in Dataset

Hi

I created a stored procedure which returns a dataset
that is passed to crystal report like this

dset = SqlHelper.ExecuteDataset(CommandType.StoredProcedure, "spr_CR_Demo2")

dset.Tables(0).TableName = "spr_CR_Demo2"

crystal.SetDataSource(dset)
CrystalReportViewer2.ReportSource = crystal

But only one record get displayed,how can i do it
anyone can help me

ThanxAre you sure that sp returns more than one record?
Open the report and Do Verify database. Save the report and Try it again

Problem in Data Driven Subscription

Hi all,

I had created a Data Driven Subsripiton last week and it was working fine.

But now when i try to run the same, it is not working.

But my log file does not say anything, all it has, is this

w3wp!library!5!06/19/2006-13:34:22:: i INFO: Call to GetPermissions:/Influe Reports/Out Of Stock Report (Missing) (This is report name)
w3wp!library!5!0 6/19/2006-13:34:22:: i INFO: Call to GetSystemPermissions
w3wp!library!5!06/19/2006-13:35:12:: i INFO: Call to GetPermissions:/Influe Reports/Out Of Stock Report (Missing)
w3wp!library!5!06/19/2006-13:35:12:: i INFO: Call to GetSystemPermissions
w3wp!library!1!6/19/2006-13:39:44:: i INFO: Cleaned 0 batch records, 0 policies, 3 sessions, 4 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams

i am looking at the file present in this path D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\

Can any body tell me what is the problem all about.

Moving to reporting services group

Problem in creating reports using BI fields

Hi,

I have created a cube using 3 Dimensions and 1 measure. One of the dimensions is a time dimension. I have also used the ADD BI command to get the Year to Date and Year over year % . This works perfectly with the cube. But when I try and create a report I am unable to display the figures for the above mentioned columns. I get Null data there.

Does anybody have any suggestions as to why this is happening and what the way to overcome this.

Thanks in advance
MNJ

Could you provide more information on how you are creating the report and which columns are returning nulls?

Problem in creating reports using BI fields

Hi,

I have created a cube using 3 Dimensions and 1 measure. One of the dimensions is a time dimension. I have also used the ADD BI command to get the Year to Date and Year over year % . This works perfectly with the cube. But when I try and create a report I am unable to display the figures for the above mentioned columns. I get Null data there.

Does anybody have any suggestions as to why this is happening and what the way to overcome this.

Thanks in advance
MNJ

Could you provide more information on how you are creating the report and which columns are returning nulls?

Problem in creating reports using BI fields

Hi,

I have created a cube using 3 Dimensions and 1 measure. One of the dimensions is a time dimension. I have also used the ADD BI command to get the Year to Date and Year over year % . This works perfectly with the cube. But when I try and create a report I am unable to display the figures for the above mentioned columns. I get Null data there.

Does anybody have any suggestions as to why this is happening and what the way to overcome this.

Thanks in advance
MNJ

Could you provide more information on how you are creating the report and which columns are returning nulls?sql

Problem in Creating AFTER INSERT Trigger

I am trying to create a AFTER INSERT Trigger. I created it and it worked for one record. But when I am trying to input multiple inserts it gives me error even on my insert statement. I am sure the syntax is right. Can anyone confirm this syntax. When I created a small table for testing this syntax worked... I dont know why its not working here.

INSERT INTO media (
media_name,
description,
active_flag,
activity_log,
data_entry_status_code,
category_id,
vendor_id,
created_by,
created_date
)
VALUES
('Test Media20', 'Test Description20', 1, 'Test Log20', 1, -1,-1, -1,'1/1/2001 12:00:00 AM'),
('Test Media21', 'Test Description21', 1, 'Test Log21',1, -1,-1,-1,'1/1/2001 12:00:00 AM'),
('Test Media22', 'Test Description22', 1, 'Test Log22',1, -1,-1,-1,'1/1/2001 12:00:00 AM')It is an insert statement.
Show me trigger text, please and what error messages you have if any.|||Also what is table [media] definition?
I mean show me datatypes of your columns.sql

Problem in Context connection of CLR Trigger

Hi,
I'm using June CTP Visual Studio 2005.
I have Created CLR Object. In my CLR Method i have opened a
connection like below
public partial class Triggers
{
//In my CLR Method i have Opened the connection like below
[Microsoft.SqlServer.Server.SqlTrigger(Name="ClrTrigger",
Target="Triplets",Event="FOR INSERT")]
public static void CLRTrigger()
{
Triggers objTriggers = new Triggers();
objTriggers.Connection(true);
..
...
Test();
// Here i'm calling one more method Test();
...
...
objTriggers.Connection(false);
}
In this test method i'm Executing the command.
Public void Test()
{
...
SqlCommand cmd = new SqlCommand();
string cmdText = "select dirname from Docs where id=45";
cmd.CommandText = cmdText;
cmd.Connection = con;
try
{
sdr = cmd.ExecuteReader();
}
catch (Exception exp)
{
WriteLog("R E ::: "+exp.Message);
}
.....
}
//Connection open and Close method
public void Connection(bool status)
{
if (status)
{
con = new SqlConnection("context connection = true");
con.Open();
}
else
{
con.Close();
}
}
}
I'm getting the error of Connection already in use. I have properly
opened the connection in begin of
method and Closed in end of method. Inside the execution of method if i
called some method means then it
can also use the same connection. Then Why its giving this error.
Please anybody knows solution to my
problem let me know to solve it.
Thanks,
Vinoth
vinoth@.gsdindia.comHi
Support for SQL Server 2005:
http://communities.microsoft.com/ne...p=sqlserver2005
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"None" wrote:

> Hi,
> I'm using June CTP Visual Studio 2005.
> I have Created CLR Object. In my CLR Method i have opened a
> connection like below
> public partial class Triggers
> {
> //In my CLR Method i have Opened the connection like below
> [Microsoft.SqlServer.Server.SqlTrigger(Name="ClrTrigger",
> Target="Triplets",Event="FOR INSERT")]
> public static void CLRTrigger()
> {
> Triggers objTriggers = new Triggers();
> objTriggers.Connection(true);
> ...
> ....
> Test();
> // Here i'm calling one more method Test();
> ...
> ...
> objTriggers.Connection(false);
> }
> In this test method i'm Executing the command.
> Public void Test()
> {
> ...
> SqlCommand cmd = new SqlCommand();
> string cmdText = "select dirname from Docs where id=45";
> cmd.CommandText = cmdText;
> cmd.Connection = con;
> try
> {
> sdr = cmd.ExecuteReader();
> }
> catch (Exception exp)
> {
> WriteLog("R E ::: "+exp.Message);
> }
> ......
> }
> //Connection open and Close method
> public void Connection(bool status)
> {
> if (status)
> {
> con = new SqlConnection("context connection = true");
> con.Open();
> }
> else
> {
> con.Close();
> }
> }
> }
> I'm getting the error of Connection already in use. I have properly
> opened the connection in begin of
> method and Closed in end of method. Inside the execution of method if i
> called some method means then it
> can also use the same connection. Then Why its giving this error.
> Please anybody knows solution to my
> problem let me know to solve it.
> Thanks,
> Vinoth
> vinoth@.gsdindia.com
>sql

Problem in Context connection of CLR Trigger

Hi,
I'm using June CTP Visual Studio 2005.
I have Created CLR Object. In my CLR Method i have
opened a
connection like below
public partial class Triggers
{
//In my CLR Method i have Opened the connection like below
[Microsoft.SqlServer.Server.Sq­lTrigger(Name="ClrTrigger",
Target="Triplets",Event="FOR INSERT")]
public static void CLRTrigger()
{
Triggers objTriggers = new Triggers();
objTriggers.Connection(true);
...
.....
Test();
// Here i'm calling one more method Test();
....
....
objTriggers.Connection(false);
}
In this test method i'm Executing the command.
Public void Test()
{
....
SqlCommand cmd = new SqlCommand();
string cmdText = "select dirname from Docs where id=45";
cmd.CommandText = cmdText;
cmd.Connection = con;
try
{
sdr = cmd.ExecuteReader();
}
catch (Exception exp)
{
WriteLog("R E ::: "+exp.Message);
}
.......

}
//Connection open and Close method
public void Connection(bool status)
{
if (status)
{
con = new SqlConnection("context connection = true");
con.Open();
}
else
{
con.Close();
}
}
}
I'm getting the error of Connection already in use. I have
properly
opened the connection in begin of

method and Closed in end of method. Inside the execution
of method if i
called some method means then it
can also use the same connection. Then Why its giving this
error.
Please anybody knows solution to my
problem let me know to solve it.
Thanks,
Vinoth
vinoth@.gsdindia.comThere are a couple of possibilities:

1) You can only have one open context connection at a time within a clr procedure ("context connection=true"). Is it possible that in the missing code snippets for your example (...'s) that you are attempting to open another context connection? For instance, calling Triggers.Connection(true) again anywhere prior to the Triggers.Connection(false) call would result in this exception. The call stack where the "Connection already in use" exception is thrown would be useful to track down this cause.

2) June CTP has a couple of bugs where an exception, especially if due to an attention (i.e. cancel) signal, can cause the connection to not properly clean itself up from one invocation of the procedure to the next. This problem would not be apparent on first invocation of the proc, and would temporarily be cleared by running "DBCC FREEPROCCACHE".

One other question I have is how you get the SqlConnection from the CLRTriggers() method to the Test() method. It would appear that the "con" field must be static, true? If this is the case, you will almost certainly run into problems, since your trigger can fire on multiple threads, yet the SqlConnection object is valid only in the procedure in which it was created.

I'd like to note that the recommended use pattern for SqlConnection (and cmd.ExecuteReader) is to put them in a "using" statement to guarantee cleanup and help see the lifetime scope of the connection. i.e.

using (SqlConnection con = new SqlConnection("context connection = true")) {
con.Open();
...
}

and

using (SqlDataReader rdr = cmd.ExecuteReader()) {
...
}

~Alazel

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 importing data from a table in Access database

Hi,
I needed to import an Access database to sql server 2000. However, in one
table, the table definition got created but could not import the data. I
tried importing the data again, however, I am getting the following message:
Error at Destination for the row number 251. Errors encountered so far in
the task: 1/
Insert row error, column 5('AuditStartDate', DBTYPE_DBTIMESTAMP), status 6:
Data overflow. Invalid character value for cast specification.
The AuditStartDate column in Sql Server is currently having a datatype
smalldatetime with a length 4 while in the Access database the AuditStartDat
e
is Date/Time datatype with mm/dd/yyyy data e.g. 07/01/1992.
I appreciate any help on this. Thanks.ALTER TABLE ALTER COLUMN on the destination table and modify the data type t
o
DATETIME. This should give you a bigger range.
Sincerely,
Anthony Thomas
"Jack" wrote:

> Hi,
> I needed to import an Access database to sql server 2000. However, in one
> table, the table definition got created but could not import the data. I
> tried importing the data again, however, I am getting the following messag
e:
> Error at Destination for the row number 251. Errors encountered so far in
> the task: 1/
> Insert row error, column 5('AuditStartDate', DBTYPE_DBTIMESTAMP), status 6
:
> Data overflow. Invalid character value for cast specification.
> The AuditStartDate column in Sql Server is currently having a datatype
> smalldatetime with a length 4 while in the Access database the AuditStartD
ate
> is Date/Time datatype with mm/dd/yyyy data e.g. 07/01/1992.
> I appreciate any help on this. Thanks.sql

Problem importing data from a table in Access database

Hi,
I needed to import an Access database to sql server 2000. However, in one
table, the table definition got created but could not import the data. I
tried importing the data again, however, I am getting the following message:
Error at Destination for the row number 251. Errors encountered so far in
the task: 1/
Insert row error, column 5('AuditStartDate', DBTYPE_DBTIMESTAMP), status 6:
Data overflow. Invalid character value for cast specification.
The AuditStartDate column in Sql Server is currently having a datatype
smalldatetime with a length 4 while in the Access database the AuditStartDate
is Date/Time datatype with mm/dd/yyyy data e.g. 07/01/1992.
I appreciate any help on this. Thanks.
ALTER TABLE ALTER COLUMN on the destination table and modify the data type to
DATETIME. This should give you a bigger range.
Sincerely,
Anthony Thomas
"Jack" wrote:

> Hi,
> I needed to import an Access database to sql server 2000. However, in one
> table, the table definition got created but could not import the data. I
> tried importing the data again, however, I am getting the following message:
> Error at Destination for the row number 251. Errors encountered so far in
> the task: 1/
> Insert row error, column 5('AuditStartDate', DBTYPE_DBTIMESTAMP), status 6:
> Data overflow. Invalid character value for cast specification.
> The AuditStartDate column in Sql Server is currently having a datatype
> smalldatetime with a length 4 while in the Access database the AuditStartDate
> is Date/Time datatype with mm/dd/yyyy data e.g. 07/01/1992.
> I appreciate any help on this. Thanks.

Problem importing data from a table in Access database

Hi,
I needed to import an Access database to sql server 2000. However, in one
table, the table definition got created but could not import the data. I
tried importing the data again, however, I am getting the following message:
Error at Destination for the row number 251. Errors encountered so far in
the task: 1/
Insert row error, column 5('AuditStartDate', DBTYPE_DBTIMESTAMP), status 6:
Data overflow. Invalid character value for cast specification.
The AuditStartDate column in Sql Server is currently having a datatype
smalldatetime with a length 4 while in the Access database the AuditStartDate
is Date/Time datatype with mm/dd/yyyy data e.g. 07/01/1992.
I appreciate any help on this. Thanks.ALTER TABLE ALTER COLUMN on the destination table and modify the data type to
DATETIME. This should give you a bigger range.
Sincerely,
Anthony Thomas
"Jack" wrote:
> Hi,
> I needed to import an Access database to sql server 2000. However, in one
> table, the table definition got created but could not import the data. I
> tried importing the data again, however, I am getting the following message:
> Error at Destination for the row number 251. Errors encountered so far in
> the task: 1/
> Insert row error, column 5('AuditStartDate', DBTYPE_DBTIMESTAMP), status 6:
> Data overflow. Invalid character value for cast specification.
> The AuditStartDate column in Sql Server is currently having a datatype
> smalldatetime with a length 4 while in the Access database the AuditStartDate
> is Date/Time datatype with mm/dd/yyyy data e.g. 07/01/1992.
> I appreciate any help on this. Thanks.

Problem exporting report to other format

Hi,

I have successfully created my first report. however when i tried to export the report to other format like excel, it doesn't work. and give me some funny codes

======================================
MIME-Version: 1.0
X-Document-Type: Workbook
Content-Type: multipart/related;boundary="--=_NextPart_01C35DB7.4B204430"
This is a multi-part message in MIME format.
--=_NextPart_01C35DB7.4B204430
Content-Type: text/html;
Content-Transfer-Encoding: base64
Content-Location:file:///c:/Report.htm
77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb2[TRIMMED]=
--=_NextPart_01C35DB7.4B204430
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Location:file:///c:/Sheet1.htm

77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb2[TRIMMED]==
--=_NextPart_01C35DB7.4B204430
Content-Type: text/css
Content-Transfer-Encoding: base64
Content-Location:file:///c:/stylesheet.css

77u/Lnhscl8zewpwYWRkaW5nLWJvdHRvbTowcHQ7ZGlyZWN0aW9uOkxUUjt0ZXh0LWRlY29yYXRpb246Tm9uZTtmb250LXNpemU6MTBwdDtjb2xvcjp[TRIMMED]
--=_NextPart_01C35DB7.4B204430--
=====================================================

Anything that i need to set?

______________
Post trimmed by moderator SomeNewKid

Hi eeyore21
I run Office 2003 and XP with SRS SP2. So It may differ or not. But what I found was that Office2k3 allows you to right click( which brings up the context menu) and choose export to excel. This is totally diffrent than to select the export format for the Report Server Toolbar. If you want to export a SRS report you must use the SRS Toolbar and not the IE context menu. Context menu does strange things to the SRS formating and the way it gets exported. Sometimes it ( context menu) will work depending on the HTML rendered by SRS it is not to complex|||

Hi l0n3i200n ,
Yup, i used the SRS toolbatr to export to excel, but it doesn't give me the end result.
Another issue that i face is that when i export to pdf, it seems to break the report horizontally to serveral pages, instead of 1 page only.
Is there anywhere i can set this?

|||

Hi

I've had the same problem with PDF files, I read in one of the posts that you should set the Report Margins to the required size, however that didn't work for me. In the end I had to resize the controls to fit on a report(SRS Report Designer Page) set with margins the same as a A4 page. This made things better but didn't solve the problem completely.

|||

Thanks l0n3i200n,
I managed to export to excel file after installing service pack 2 for Reporting server.
I guess we have to make our report fit on a A4 page. :(

|||Good Evening Or Good Morning!
I have just "scrapped" the export capibilities to PDF!
PDF never renders anything useful in Thai, Korean, Laos, or Cambodian!
So I just make everyone and at times do it automatically to a TIFF!
The export to a TIFF never "burps"!
This may be of some help or not and -
Best Regards,

problem editing dataset mdx query sql 2005

Hi all,
I have created a report with the report wizard. I used a cube as a
datasource.
After creating I also run the report without any problems.
However when I go to the data tab to edit my dataset.
The dataset becomes empty and my reports is getting errors like
"Report item expressions can only refer to fields within the current
data set scope or, if inside an aggregate, the specified data set
scope"
What is the problem, why can't I change a dataset based on analysis
services, i don't have any problems with datasets based on normal
databases.In Short:
WORKAROUND: If you have created your report using the Report Wizard to start
the MDX Query Builder, open the .rdl file as XML. Find the section starting
with <rd:MdxQuery> and ending with </rd:MdxQuery> and delete all spaces and
newlines between elements (between closing > and opening <) so the whole
complex element is inline. You will be able to continue working with the
report normally.
1) The problem arises when you use the Report Wizard (as GaryV indicated
before me)
2) If you compare the XML generated by the Query Builder when using the
Report Wizard and Add existing item... you will see
a) the complex element <rd:MdxQuery> from the Wizard path is nicely
formatted with spaces and newlines while
b) the Query Builder used directly puts the whole long
<rd:MdxQuery></rd:MdxQuery> "subdocument" inline
c) the proof is in the pudding - if you delete the formatting characters (I
ssupect the inlines are key) you can tab to Data and edit the dataset w/o
problems
See thread " VS crashes when ..."
"Anke" <anke_ruigrok@.zonnet.nl> schrieb im Newsbeitrag
news:1134563578.098538.277750@.g49g2000cwa.googlegroups.com...
> Hi all,
> I have created a report with the report wizard. I used a cube as a
> datasource.
> After creating I also run the report without any problems.
> However when I go to the data tab to edit my dataset.
> The dataset becomes empty and my reports is getting errors like
> "Report item expressions can only refer to fields within the current
> data set scope or, if inside an aggregate, the specified data set
> scope"
> What is the problem, why can't I change a dataset based on analysis
> services, i don't have any problems with datasets based on normal
> databases.
>|||Thanx for you're help, it works fine for me!
Ralph Watermann schreef:
> In Short:
> WORKAROUND: If you have created your report using the Report Wizard to start
> the MDX Query Builder, open the .rdl file as XML. Find the section starting
> with <rd:MdxQuery> and ending with </rd:MdxQuery> and delete all spaces and
> newlines between elements (between closing > and opening <) so the whole
> complex element is inline. You will be able to continue working with the
> report normally.
> 1) The problem arises when you use the Report Wizard (as GaryV indicated
> before me)
> 2) If you compare the XML generated by the Query Builder when using the
> Report Wizard and Add existing item... you will see
> a) the complex element <rd:MdxQuery> from the Wizard path is nicely
> formatted with spaces and newlines while
> b) the Query Builder used directly puts the whole long
> <rd:MdxQuery></rd:MdxQuery> "subdocument" inline
> c) the proof is in the pudding - if you delete the formatting characters (I
> ssupect the inlines are key) you can tab to Data and edit the dataset w/o
> problems
>
> See thread " VS crashes when ..."
> "Anke" <anke_ruigrok@.zonnet.nl> schrieb im Newsbeitrag
> news:1134563578.098538.277750@.g49g2000cwa.googlegroups.com...
> > Hi all,
> >
> > I have created a report with the report wizard. I used a cube as a
> > datasource.
> > After creating I also run the report without any problems.
> > However when I go to the data tab to edit my dataset.
> > The dataset becomes empty and my reports is getting errors like
> >
> > "Report item expressions can only refer to fields within the current
> > data set scope or, if inside an aggregate, the specified data set
> > scope"
> >
> > What is the problem, why can't I change a dataset based on analysis
> > services, i don't have any problems with datasets based on normal
> > databases.
> >|||I mean thanx for your help............