Help - Unable to Add Column to Report

I have inherited a report that appears to be too big for the VS designer.
The query is 664 lines long and every time I move to the Data tab, Reporting
Services locks up and stops responding. (I am using the generic query
designer)
The report runs fine, my problem is I need to add another data column to the
report. I did this by editing the RDL in a text editor but when I reload in
RS and got to the Layout tab to add the column to the report, it is not
listed in the Fields list. I tried to manually add it but I then get the
'Index out of bounds error'. So it seems the field list needs to be updated
by accessing the Data tab and then moving to the Layout or Preview tab but
every time I try to do this it locks up.
I thought I might try to temporarily remove part of the query so the field
list could be updated but the report has the columns scattered throughout so
I can't locate a large enough block of contiguous query data that does NOT
affect the fields list.
Is there any work around for this?
Many thanksHi Mike,
I'm not sure what the preview issue is, but if you are ok with editing the
RDL, you should be able to do it.
When you added the field to the RDL, did you add it to both the query and to
the fields collection?
The fields collection maps results returned from the query to fields you can
put on the report. If you added a column to the query in the RDL, makes
sure you add a field element (under datasets/fields) that matches the column
name. If you did both of those and still have the problem then I don't
know.
I hope that helps!
Chris
"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:OO$4Noz3FHA.4080@.tk2msftngp13.phx.gbl...
>I have inherited a report that appears to be too big for the VS designer.
>The query is 664 lines long and every time I move to the Data tab,
>Reporting Services locks up and stops responding. (I am using the generic
>query designer)
> The report runs fine, my problem is I need to add another data column to
> the report. I did this by editing the RDL in a text editor but when I
> reload in RS and got to the Layout tab to add the column to the report, it
> is not listed in the Fields list. I tried to manually add it but I then
> get the 'Index out of bounds error'. So it seems the field list needs to
> be updated by accessing the Data tab and then moving to the Layout or
> Preview tab but every time I try to do this it locks up.
> I thought I might try to temporarily remove part of the query so the field
> list could be updated but the report has the columns scattered throughout
> so I can't locate a large enough block of contiguous query data that does
> NOT affect the fields list.
> Is there any work around for this?
> Many thanks
>

Help - Error: Unable to open the physical file

Hi, I've just finished creating my first ASP.NET website. I created it on my laptop and it works perfectly, but I'm having some problems deploying it to my web server (PC).
The site works ok, but when I try to log in to my client area, I get this error:

"Unable to open the physical file "c:\inetpub\wwwroot\ONeillStrata\App_Data\aspnetdb.mdf". Operating system error 5: "5(Access is denied.)".
An attempt to attach an auto-named database for file c:\inetpub\wwwroot\ONeillStrata\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."

I've searched far and wide for a solution and have read many articles, but none seem to be able to fix my problem. I've tried using that SEUtil tool, but that didn't work, I've made sure the App_Data directory on the web server isn't read only (the read-only checkbox isn't ticked, but it DOES have that little green square which I can't get rid of), I've assigned the ASPNET user as a db owner and that didn't work and I've manually attached the database to the web server's instance of SQL Express 2005.
When I launch the solution in VS2005 on the web server, I can browse through the database and see the tables and data etc, but when I try to run the application, I get that message above...

Surely it shouldn't be this hard to get it going?
Any help would be massively appreciated.

Hi,

It seems that the physical file location of the aspnetdb.mdf is wrong.

Please open your IIS, right click on your default web site,and click on the properties, change to the ASP.NET tab, edit configurations.Then you can see the LocalSqlServer string listed there, change the string into the following:data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true.

Thanks.

HELP - "17832 Unable to read login packet(s). "

Hello,

I am sorry if this has appeared in the forum before but...

"17832 Unable to read login packet(s). "

We cannot see any hit on the server at all and the network appears to be OK. MS Knowledgebase 109787 refers to possible problems from the client end or a possibility that network latency is contributing to the problem. Connectivity from clients to server does look to be ok.

Essentially users are getting very slow performance and I need to find out why.

If anyone has experienced this problem before or has any pointers I would be extremely grateful for any direction you can give me.

Thanks in advance.This is a tough one to isolate - check out the following article:

article (http://support.microsoft.com/default.aspx?scid=KB;en-us;169521&)

HELP

Error Message "unable to load sql server odbc driver resource DLL.The
Application cannot continute"
Please help me !
You might try reinstalling MDAC
http://msdn.microsoft.com/data/downl.../default.aspx. The latest
version is 2.8.
Hope this helps.
Dan Guzman
SQL Server MVP
"??H" <lemel@.hungnet.idv.tw> wrote in message
news:eryrMLU$EHA.2700@.TK2MSFTNGP14.phx.gbl...
> Error Message "unable to load sql server odbc driver resource DLL.The
> Application cannot continute"
> Please help me !
>

HELP

Error Message "unable to load sql server odbc driver resource DLL.The
Application cannot continute"
Please help me !You might try reinstalling MDAC
http://msdn.microsoft.com/data/down...s/default.aspx. The latest
version is 2.8.
Hope this helps.
Dan Guzman
SQL Server MVP
"??H" <lemel@.hungnet.idv.tw> wrote in message
news:eryrMLU$EHA.2700@.TK2MSFTNGP14.phx.gbl...
> Error Message "unable to load sql server odbc driver resource DLL.The
> Application cannot continute"
> Please help me !
>

HELP

Error Message "unable to load sql server odbc driver resource DLL.The
Application cannot continute"
Please help me !You might try reinstalling MDAC
http://msdn.microsoft.com/data/downloads/updates/default.aspx. The latest
version is 2.8.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"¶Ë¤ß¤H" <lemel@.hungnet.idv.tw> wrote in message
news:eryrMLU$EHA.2700@.TK2MSFTNGP14.phx.gbl...
> Error Message "unable to load sql server odbc driver resource DLL.The
> Application cannot continute"
> Please help me !
>