Extract a program from SQL 2000?

Hello,
We have a web based program that is using SQL 2000 as the db. Sql 2000 is running on a Windows 2003 server.

Is it possible to extract the SQL 2000 program(web based) with a clean db onto a blanket CD so another person can install it?

Any help would greatly be appreciated.

Mike

If you mean, is it possible to create an Installation disk for SQL Server, the answer is -No.

The 'another person' will have to purchase, or otherwise, legitimately obtain and license SQL Server.

Very, very Silly Question.

Extra space at bottom of page

I keep getting extra space at the bottom of each page on my report when it is deployed to the web server but I don't get this extra space on the report server. Does anyone know if this is in the report layout or if the problem is in the web page itself?

Thanks,

messed around with report printer properties and re-deployed.sql

Extra Characters appended to entry

I'm encountering a strange problem in all the applications I'm working on and am totally dumbfounded as to why it's occuring:
From a standard web form I'm inserting a record using a stored procedure. (I'm writing this to a SQL 2000 db - where the column types and variables are all consistant) No matter what I do, the columns are padded with extra characters maxing out the field length (if it's nchar or nvarchar or char) after insert or update. I've tried Trim - ing the field.text values that I'm feeding to the @.variables used in my stored procedure. I've even RTRIM() - ed the @.variables within the stored procedure. No matter what I do I get extra spaces padding the end of the intended column input. Ideas anyone?
Thanks in advance.
- AbeDepending on your extra characters, trimmimg won't solve your problem if they are not whitespaces.
Could you supply more info and post your ASP and T-Sql code?
|||

Thanks. I'm pretty sure it's spaces because if I run a query "SELECT Education FROM tblCV WHERE (Education LIKE N'% %')" I get all records returned except the ones that I manually stripped out the trailing spaces.

privatevoid InsertCV()
{

SqlConnection conn =new SqlConnection(connectString);

SqlCommand cmd =new SqlCommand("sp_InsertCV",conn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@.AAASS_ID",SqlDbType.NVarChar,5);

cmd.Parameters.Add("@.Education",SqlDbType.NChar,700);

cmd.Parameters.Add("@.Experience",SqlDbType.NChar,700);

cmd.Parameters.Add("@.Publication",SqlDbType.NChar,700);

cmd.Parameters.Add("@.ConferencePapers",SqlDbType.NChar,700);

cmd.Parameters.Add("@.OrganizationalMembership",SqlDbType.NChar,700);

cmd.Parameters.Add("@.EnteredBy",SqlDbType.NVarChar,10);

cmd.Parameters.Add("@.UpdatedBy",SqlDbType.NVarChar,10);

cmd.Parameters["@.AAASS_ID"].Value = _AAASSID;

cmd.Parameters["@.Education"].Value =this.education.Text;

cmd.Parameters["@.Experience"].Value =this.experience.Text;

cmd.Parameters["@.Publication"].Value =this.publications.Text;

cmd.Parameters["@.ConferencePapers"].Value =this.conferencePapers.Text;

cmd.Parameters["@.OrganizationalMembership"].Value =this.organizationalMembership.Text;

cmd.Parameters["@.EnteredBy"].Value = _AAASSID;

cmd.Parameters["@.UpdatedBy"].Value = _AAASSID;

conn.Open();

cmd.ExecuteNonQuery();

cmd.Dispose();

conn.Close();

}
CREATE PROCEDURE sp_InsertCV
(
@.AAASS_ID AS nvarchar(5),
@.Education AS nchar(700),
@.Experience AS nchar(700),
@.Publication AS nchar(700),
@.ConferencePapers AS nchar(700),
@.OrganizationalMembership AS nchar(700),
@.EnteredBy AS char(10),
@.UpdatedBy AS char(10)
)

AS
INSERT INTO [AAASSSQLData].[dbo].[tblCV]
(
[AAASS_ID], [Education], [Experience], [Publication], [ConferencePapers], [OrganizationalMembership], [DateEntered], [EnteredBy],
[DateUpdated], [UpdatedBy]
)
VALUES(
@.AAASS_ID,RTRIM(@.Education),RTRIM(@.Experience),
RTRIM(@.Publication),
RTRIM(@.ConferencePapers),
RTRIM(@.OrganizationalMembership),
GetDate(),
RTRIM(@.EnteredBy),
GetDate(),
RTRIM(@.UpdatedBy)
)
GO
tblCV
3 AAASS_ID nvarchar 5 0
0 Education nchar 700 1
0 Experience nchar 700 1
0 Publication nchar 700 1
0 ConferencePapers nchar 700 1
0 OrganizationalMembership nchar 700 1
0 DateEntered datetime 8 1
0 EnteredBy char 10 1
0 DateUpdated datetime 8 1
0 UpdatedBy char 10 1
Column contents: "SUNY Binghamton, B.A., Psychology, 1982
Pace U., MBA, Management Information Systems, 1986 "
Thank you for taking a look at this.
- Abe

|||Use varchar or nvarchar fields and they won't be padded. Char and nchar datatypes pad the data with spaces out to the field length.|||Thanks so much for the feedback. I'll give that a try.
Best,
- AbeR

Extra "blanks" in the cloumn field

When I enter a data in a table, SQL Server automatically completes the data with blanks up to length of column.

this happens in a web form also in Management Studi?o,

Whan am I doing wrong ?

does Collation have anything with it ?

SQL Server 2005 / Developer Edition

It sounds like you are using the char data type. SQL Server will automatically pad this with spaces as it is a fixed number characters. Use varchar instead.|||

thanks for your help,

now it is not padding.

External web service as datasource for Reporting Service report

Hello,
I would like to make some Reporting Services reports from a datasource
that is a web service. Is this possible? I am using SSRS 2005. Any
suggestions or directions would be greatly appreciated.
photogulliverIt is possible but I haven't done it. Read up in Books On Line on XML.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/d23408e5-e65b-4f49-a98f-234454d5d267.htm
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ehausig@.yahoo.com> wrote in message
news:1141931933.379723.119120@.e56g2000cwe.googlegroups.com...
> Hello,
> I would like to make some Reporting Services reports from a datasource
> that is a web service. Is this possible? I am using SSRS 2005. Any
> suggestions or directions would be greatly appreciated.
> photogulliver
>|||Yes. it is possible.
however, there are serious limitations on this approach. see other
postings in this group by me and Teo's responses to my postings.
1. the XML returned by the web service may not be readily consumable by
SSRS.
2. the query syntax to consume the XML is xpath like, but it is neither
xpath not xquery
3. security is a big concern. webservices consumption is non-secure
however, you can write your own custom data processing extension which
can overcome the above limitations.
thanks
- jasthi|||Ok, thanks for the feedback!
Eric

External Class Exception

I am calling a custom assembly from within my RDL. If that class raises an
Exception I would like to catch the exception in my call to the RS Web
Service method RenderReport.
Is this possible. Or is it always caught by the report?Report server will always catch and wrap your exception.
In some cases report server will stop report processing (for example if
exception occured in grouping or filter expression); in other cases (text
box value) it will result in #Error and report execution will be continued.
If report processing was stopped Render will return error information.
If report was processed with #Errors then Render will return collection of
warnings
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dlloyd" <Dlloyd@.discussions.microsoft.com> wrote in message
news:8F3A380B-1E43-43D7-8C72-B0E68FCCFB78@.microsoft.com...
> I am calling a custom assembly from within my RDL. If that class raises an
> Exception I would like to catch the exception in my call to the RS Web
> Service method RenderReport.
> Is this possible. Or is it always caught by the report?|||Thank you for the response Alexandre...
The problem is I don't want the exception to end up in an #error in the
textbox. I want the exception rasied up to the software that made the call to
render that report.
With an exception that occurs in a textbox is there a way to throw the
exception back up again?
Dave
"Alexandre Mineev" wrote:
> Report server will always catch and wrap your exception.
> In some cases report server will stop report processing (for example if
> exception occured in grouping or filter expression); in other cases (text
> box value) it will result in #Error and report execution will be continued.
> If report processing was stopped Render will return error information.
> If report was processed with #Errors then Render will return collection of
> warnings
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Dlloyd" <Dlloyd@.discussions.microsoft.com> wrote in message
> news:8F3A380B-1E43-43D7-8C72-B0E68FCCFB78@.microsoft.com...
> > I am calling a custom assembly from within my RDL. If that class raises an
> > Exception I would like to catch the exception in my call to the RS Web
> > Service method RenderReport.
> >
> > Is this possible. Or is it always caught by the report?
>
>|||There is no clean way to prop exceptions, but you can analyze report
execution warnings and if you see traces of your exception then you can
re-throw it.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dlloyd" <Dlloyd@.discussions.microsoft.com> wrote in message
news:0CD7FA30-69AB-4CA1-A838-985DA6220EFE@.microsoft.com...
> Thank you for the response Alexandre...
> The problem is I don't want the exception to end up in an #error in the
> textbox. I want the exception rasied up to the software that made the call
to
> render that report.
> With an exception that occurs in a textbox is there a way to throw the
> exception back up again?
> Dave
> "Alexandre Mineev" wrote:
> > Report server will always catch and wrap your exception.
> > In some cases report server will stop report processing (for example if
> > exception occured in grouping or filter expression); in other cases
(text
> > box value) it will result in #Error and report execution will be
continued.
> >
> > If report processing was stopped Render will return error information.
> > If report was processed with #Errors then Render will return collection
of
> > warnings
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Dlloyd" <Dlloyd@.discussions.microsoft.com> wrote in message
> > news:8F3A380B-1E43-43D7-8C72-B0E68FCCFB78@.microsoft.com...
> > > I am calling a custom assembly from within my RDL. If that class
raises an
> > > Exception I would like to catch the exception in my call to the RS Web
> > > Service method RenderReport.
> > >
> > > Is this possible. Or is it always caught by the report?
> >
> >
> >sql

Extent of Dundas functionality

I'm planning to implement MS RS and to take advantage of the charting
supplied by Dundas in my web application. My question is this:
Is the chart control available for use on web pages not created via MS
RS? I will be running MS RS and MS SQL on one machine and IIS on
another. In my web app I have need to make some simple bar charts on
one page.No, the Dundas chart that shipd with Reporting Services is only available in
the context of a report. If you would like programmitic control over the
chart in your application, you would need to license it seperately.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"MarkMurphy" <murphy@.murphysw.com> wrote in message
news:e061eb57.0406180948.687427ca@.posting.google.com...
> I'm planning to implement MS RS and to take advantage of the charting
> supplied by Dundas in my web application. My question is this:
> Is the chart control available for use on web pages not created via MS
> RS? I will be running MS RS and MS SQL on one machine and IIS on
> another. In my web app I have need to make some simple bar charts on
> one page.sql

Expression editor (sort of) bug

I've noticed in the expression editor that pasting rich text (like copied
from a web page) preserves the formatting. This makes stuff look really
screwed up in the expression editor. I noticed this copying stuff from this
newsgroup and pasting it into the expression editor.I believe the formatting goes away after you commit it. But be careful
about extra carriage returns/line feeds. They can mess up the code.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Stefan Wrobel" <StefanWrobel@.discussions.microsoft.com> wrote in message
news:8C6BE014-DC4D-400B-9CA6-CBDDFC99B16E@.microsoft.com...
> I've noticed in the expression editor that pasting rich text (like copied
> from a web page) preserves the formatting. This makes stuff look really
> screwed up in the expression editor. I noticed this copying stuff from
> this
> newsgroup and pasting it into the expression editor.

Exposing data

Hi,
I'm about to enter some new ground. I have a background of web development (
ASP) and SQL Server (network environment only). We have a new ASP.NET applic
ation running a SQL DB. This application is to be put out on the net.
Our network admin wants to buy another SQL licence and have the SQL server s
it outside of our network firewall. I'm more inclined to have the SQL server
inside some sort of DMZ (a topic new to me) and open a port for data access
.
Before I take this argument to the network admin I want to arm myself with t
he necessary knowledge. I guess I'm looking for articles/URLs/tutorials whic
h will teach me how to expose a SQL DB on our network to the internet withou
t risking the secuirty of o
ur network or the SQL box itself.
many thanks
JayGenerally for web apps, the exposure works like this:
One port (or maybe two) on the firewall is open for HTTP (80, and perhaps
443 for SSL).
The web server, BEHIND THE FIREWALL, can talk to the database server. Some
admins even go so far as to put a second firewall between the web and
database servers (which I think is generally overkill). No SQL Server ports
should ever be open on the firewall. And no SQL Server should ever be in a
DMZ! That's just asking for trouble...
Anyway, here's a link with some good information about how to secure a web
app using SQL Server:
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
ml/openhack.asp
"Jay" <Jay@.wdc.com> wrote in message
news:5D4E06B3-1BC0-4A9B-9215-2C20BC72379D@.microsoft.com...
> Hi,
> I'm about to enter some new ground. I have a background of web development
(ASP) and SQL Server (network environment only). We have a new ASP.NET
application running a SQL DB. This application is to be put out on the net.
> Our network admin wants to buy another SQL licence and have the SQL server
sit outside of our network firewall. I'm more inclined to have the SQL
server inside some sort of DMZ (a topic new to me) and open a port for data
access.
> Before I take this argument to the network admin I want to arm myself with
the necessary knowledge. I guess I'm looking for articles/URLs/tutorials
which will teach me how to expose a SQL DB on our network to the internet
without risking the secuirty of our network or the SQL box itself.
> many thanks
> Jay|||This would not be recommended. SQL should be protected by a firewall.
Consider using ISA server 2000 and publishing SQL to the internet.
1433 is one of the highest scanned ports by hackers.
http://www.microsoft.com/technet/pr...n/sp3sec02.mspx
#XSLTsection126121120120
287932 INF: TCP Ports Needed for Communication to SQL Server Through a
Firewall
http://support.microsoft.com/?id=287932
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks Adam,
Priniting it now... will digest it after my first coffee of the morning.
Jay

Exporting to PDF through web service produses blank pages

Hi all,
I am exporting to PDF through web service a report that contains matrix.
I get almost every second page a blank page.
The same report when exported to PDF by the report manager does not contain
blank pages.
Is it a bug, Is there any work around
Thanks,
YuvalNobody is going to answer your question. I've been asking it for days. I
emailed all those Microsoft bloggers. I posted here. Nothing. I did
enough research that I am conviced Microsoft knows about the issue.
Note they claim you can find known bugs here:
http://msdn.microsoft.com/bugs/
But you can only find bugs they want you to find (ie ones they know how to
fix). If you seach for reporting services, you will find 0 known bugs.
The problem is that the List containing the matrix is growing so much that
the report won't fit on one page. So it prints two pages. You can see this
by changing the background colour of the List that contains the matrix.
When you run it, you will find the coloured list extends onto the 'blank'
page.
I haven't seen a fix yet. You can shrink your matrix so that the list won't
grow onto the next page. But that's not usually an acceptable fix, because
it means leaving about a third of the page blank.
Seems to me there's no acceptable way to print a matrix report. This issue
affects the tiff, and I found a different issue in Excel.
Scott
"Yuval Rabinovitz" <yvlrb@.netvision.net.il> wrote in message
news:e66FusBkEHA.3848@.tk2msftngp13.phx.gbl...
> Hi all,
> I am exporting to PDF through web service a report that contains matrix.
> I get almost every second page a blank page.
> The same report when exported to PDF by the report manager does not
contain
> blank pages.
> Is it a bug, Is there any work around
> Thanks,
> Yuval
>|||I did eventaully get a reponse from Microsoft. Everyone was quite friendly,
but it took a while to find the person who knew the answer.
If you are not using subtotals in your matrix, you might try "KB article
875518 is FIX: Width of the list that contains a matrix grows unexpectedly
when exported to PDF." This hotfix (only available by calling support)
didn't solve my problem.
If you are using subtotals in your matrix (like I was), this is the answer.
This response was from Sarah Parra:
"
The problem is that the list always extends a certain amount to the right
and bottom of the matrix, and the amount that it extends is based directly
on how wide (for column totals) or tall (for row totals) the total textbox
is. If you look at your report in the designer, in the bottom right corner,
under the totals boxes, there is a gray/brown empty space. That space is
effectively how much extra list you will see in the final output. We take
the size of the matrix to be the actual size that you see, minus the totals
boxes. That means that the list effectively looks like it is that much
bigger than the matrix (instead of being the exact same size). When the
rendering happens, it then adds that much padding to the right and below the
actual matrix.
This is a bug as well, it's just a different bug from the one described in
the article/hotfix. :) This one does have a fairly simple workaround. You
need to resize the list to be the size of the matrix, minus the size of the
totals columns/rows. The designer will not allow you to size the list
smaller than the matrix (which includes the totals), but you can do this
manually in the rdl. The following are the instructions I sent to another
customer on a sample report he had provided, so the sizes and line number
will not match up for you:
(1) Find the size of the column total box. You can just click on it and look
at the Width property. It's 0.875in.
(2) In the Solution Explorer, right click the .rdl file and select View
Code. In the code, find the Width definition for the List itself. You'll see
it on line 78, and it looks like this : <Width>5.875in</Width>. Change that
to that value, minus the size of the total column, .875. So just make it
5.0in, or you can make it a little bigger if you want some extra space
displayed to the right of the matrix itself. In the designer at this point,
it will look like the Total box is gone, but it's still there. You can do
the same thing for the row totals if you want. You will probably want to do
this, because if you have a situation where the matrix should end at the
very bottom of the page, you may still get an extra page if the extended
list height would force it.
(3) Preview and render the report. You should no longer see any blank pages.
"
"Scott Stonehouse" <scott@.mphec.ca> wrote in message
news:%23N3MVjFkEHA.2812@.tk2msftngp13.phx.gbl...
> Nobody is going to answer your question. I've been asking it for days. I
> emailed all those Microsoft bloggers. I posted here. Nothing. I did
> enough research that I am conviced Microsoft knows about the issue.
> Note they claim you can find known bugs here:
> http://msdn.microsoft.com/bugs/
> But you can only find bugs they want you to find (ie ones they know how to
> fix). If you seach for reporting services, you will find 0 known bugs.
> The problem is that the List containing the matrix is growing so much that
> the report won't fit on one page. So it prints two pages. You can see
this
> by changing the background colour of the List that contains the matrix.
> When you run it, you will find the coloured list extends onto the 'blank'
> page.
> I haven't seen a fix yet. You can shrink your matrix so that the list
won't
> grow onto the next page. But that's not usually an acceptable fix,
because
> it means leaving about a third of the page blank.
> Seems to me there's no acceptable way to print a matrix report. This
issue
> affects the tiff, and I found a different issue in Excel.
> Scott
>
> "Yuval Rabinovitz" <yvlrb@.netvision.net.il> wrote in message
> news:e66FusBkEHA.3848@.tk2msftngp13.phx.gbl...
> > Hi all,
> >
> > I am exporting to PDF through web service a report that contains matrix.
> > I get almost every second page a blank page.
> > The same report when exported to PDF by the report manager does not
> contain
> > blank pages.
> >
> > Is it a bug, Is there any work around
> >
> > Thanks,
> > Yuval
> >
> >
>

Exporting to PDF in Java with web interface issue

Hi, thanks for taking the time to take a look at this.

As you can read from the title, I'm trying to export a report to pdf from a thick java client. My connection string is:
"http://10.0.1.36/ReportServer/?/Invoice1/Invoice&assetNbr=14
&invoiceId=061000002&rs:Command=Render:&rs:Format=PDF&rc:Toolbar=false"
(I just added the toolbar=false part, and it didn't fix the problem)

After getting the datastream I just throw it into a file and it works fine... Until I add an image to my report. I don't get any errors in my program, but when I try to open up the pdf itself I get the error: "There was an error opening this document. The file is damaged and could not be repaired."

What confuses me is that if I enter the connection string in ie it comes up and asks me what I should do with the pdf and that one has the image in it with not problems.

To summarize if I've been unclear:
Export via ie no image: good
Export via ie with image: good
Export via java no image: good
Export via java with image: error

Does anyone have an idea why this would occur? I have an Execution Account set up in Reporting Services Configuration Manager and I have IIS anonymous access set up to use my local administrator account so I don't think accessing the image is an issue. But I'm definitely no server/admin expert so if there are any such issues could be causing this don't assume I've got that set up properly.

Thanks, JeffAre you certain that you are writing the file correctly from your Java app?|||I'm pretty sure I am. The whole setup works and exports correctly when connecting to a report that doesn't have an image embedded in it.

Also, is there any way to access the reports other than the web interface from java? I've only seen implementations of this in C# and vb.net|||

You should be able to use any Java SOAP toolkit (such as JAX).

FWIW, perhaps the report w/the image is larger, and exposing some bug in your Java code? Maybe you should compare the byte count of the IE output to what you are getting w/Java.

|||My face is red, it just was that I was stopping the fileout one byte too early... Thanks a bunch for your help.

If I can ask one more favor of you, I'm not familiar with the components involved in using SOAP so if you could give me a little overview that would give me someplace to start reading about it I'd really appreciate it.|||

I've never used any of SOAP toolkits for Java... so I can't really help you out there. This showed some links which may be of interest to you:

http://search.live.com/results.aspx?q=java+SOAP+toolkit&mkt=en-US&form=QBRE

Exporting to Excel without generating report.

Can a report be exported to an Excel sheet directly without showing it into
my web application?
Thanks a lot! :)Yes, use the URL Access Parameters displayed in the BOL.
&rs:Format=Excel
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Tomas Martinez" <TomasMartinez@.discussions.microsoft.com> schrieb im
Newsbeitrag news:FC958C51-856F-4869-8E95-61C64E61604D@.microsoft.com...
> Can a report be exported to an Excel sheet directly without showing it
> into
> my web application?
> Thanks a lot! :)

Exporting to Excel

Hello Everyone,
I'm using SSRS 2005 on top of a sql2k database.
When exporting a report from the Report manager web interface into Excel,
the report gets formatted with the cells merged. This causes a problem with
sorting colums since Excel does not like to sort data in merged cells. I
could have my users simply unmerge all cells, but that leaves some emply
colums that have to be deleted.
Is there any way to prevent the cells from being merged after exporting from
the Report manager? I create the reports in Visual Studio 2005, is there some
setting I can change while creating them in VS05 that will prevent this?
Thanks.You've got two choices. The first I present here is from a poster in the
newsgroup. The second is what I do. I (not too surprisingly) prefer the
second method.
>>>>>>>>The Table can be the full width or slightly less
>>>>>>>>of your page. I have best results when it is less
>>>>>>>>than the full width. I don't know if you can have
>>>>>>>>multiple tables in the body and still sort ok - I
>>>>>>>>doubt it. Any/all other objects in the body (logo
>>>>>>>>images, textboxes) MUST be full width - from
>>>>>>>>leftmost edge to rightmost edge. Images can use
>>>>>>>>Sizing = FitProportional to appear ok. If any of
>>>>>>>>those objects in the body is even slightly less
>>>>>>>>than full width (such as two text boxes adjacent
>>>>>>>>to each other on the same row, or a logo in the
>>>>>>>>upper left and the title textbox in the upper
>>>>>>>>right on the same row), I've found that you will
>>>>>>>>get merged cells in Excel and cannot sort. I also
>>>>>>>>tried all kinds of careful alignments of objects
>>>>>>>>(matching the columns in the table, etc) but it
>>>>>>>>still caused merged cells. I don't believe it
>>>>>>>>matters what you have in the page header or
>>>>>>>>footer - I can put multiple textboxes on the same
>>>>>>>>row in my page footer and it works ok.
Hope that helps,
Steve Nyberg
>>>>>>>>
OK, now my method.
What I do is the following. I add additional header rows and then merge
either the whole row together of a couple of cells and then put in what I
normally would have put in a textbox. You would think that merging cells
together this way would cause a problem with merged cells in Excel but it
does not. If you select your header and your data you can sort, while if you
have exported with a textbox above the table you get the problem with merged
cells when trying to sort.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Damon Johnson" <DamonJohnson@.discussions.microsoft.com> wrote in message
news:3CEDDB9B-B8FE-4582-A88A-41A8A403D41B@.microsoft.com...
> Hello Everyone,
> I'm using SSRS 2005 on top of a sql2k database.
> When exporting a report from the Report manager web interface into Excel,
> the report gets formatted with the cells merged. This causes a problem
> with
> sorting colums since Excel does not like to sort data in merged cells. I
> could have my users simply unmerge all cells, but that leaves some emply
> colums that have to be deleted.
> Is there any way to prevent the cells from being merged after exporting
> from
> the Report manager? I create the reports in Visual Studio 2005, is there
> some
> setting I can change while creating them in VS05 that will prevent this?
> Thanks.|||Thanks Bruce. I'll give these a once over.
Damon
"Bruce L-C [MVP]" wrote:
> You've got two choices. The first I present here is from a poster in the
> newsgroup. The second is what I do. I (not too surprisingly) prefer the
> second method.
> >>>>>>>>The Table can be the full width or slightly less
> >>>>>>>>of your page. I have best results when it is less
> >>>>>>>>than the full width. I don't know if you can have
> >>>>>>>>multiple tables in the body and still sort ok - I
> >>>>>>>>doubt it. Any/all other objects in the body (logo
> >>>>>>>>images, textboxes) MUST be full width - from
> >>>>>>>>leftmost edge to rightmost edge. Images can use
> >>>>>>>>Sizing = FitProportional to appear ok. If any of
> >>>>>>>>those objects in the body is even slightly less
> >>>>>>>>than full width (such as two text boxes adjacent
> >>>>>>>>to each other on the same row, or a logo in the
> >>>>>>>>upper left and the title textbox in the upper
> >>>>>>>>right on the same row), I've found that you will
> >>>>>>>>get merged cells in Excel and cannot sort. I also
> >>>>>>>>tried all kinds of careful alignments of objects
> >>>>>>>>(matching the columns in the table, etc) but it
> >>>>>>>>still caused merged cells. I don't believe it
> >>>>>>>>matters what you have in the page header or
> >>>>>>>>footer - I can put multiple textboxes on the same
> >>>>>>>>row in my page footer and it works ok.
> Hope that helps,
> Steve Nyberg
> >>>>>>>>
> OK, now my method.
> What I do is the following. I add additional header rows and then merge
> either the whole row together of a couple of cells and then put in what I
> normally would have put in a textbox. You would think that merging cells
> together this way would cause a problem with merged cells in Excel but it
> does not. If you select your header and your data you can sort, while if you
> have exported with a textbox above the table you get the problem with merged
> cells when trying to sort.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Damon Johnson" <DamonJohnson@.discussions.microsoft.com> wrote in message
> news:3CEDDB9B-B8FE-4582-A88A-41A8A403D41B@.microsoft.com...
> > Hello Everyone,
> > I'm using SSRS 2005 on top of a sql2k database.
> >
> > When exporting a report from the Report manager web interface into Excel,
> > the report gets formatted with the cells merged. This causes a problem
> > with
> > sorting colums since Excel does not like to sort data in merged cells. I
> > could have my users simply unmerge all cells, but that leaves some emply
> > colums that have to be deleted.
> >
> > Is there any way to prevent the cells from being merged after exporting
> > from
> > the Report manager? I create the reports in Visual Studio 2005, is there
> > some
> > setting I can change while creating them in VS05 that will prevent this?
> >
> > Thanks.
>
>

exporting SQL data as Access readable file

hi guys.
i'm looking to try and get a web tool together that will basically allow a user to download a file that can be plopped into MS Access, using the data i have on my servers stored in MS SQL Server...
any ideas?nobody, huh?|||bcp out a data file?

You need to be clearer on your process and what you're trying to do..

I'd venture to say that a stored procedure will be called, then using xp_cmdshell bcp out a view or use queryout...

But a little more explination would help us...