embedding RS into a java (j2ee) application

Can anyone point me to some useful information on embedding reports into a
java (J2EE) application?
StephanieNot specifically but I can tell you your options. There are three ways to
integrate reports into an application: roll your own with web services, use
URL integration, use the reportviewer control that comes with VS 2005. Of
these you can use the first two. The control is a 2.0 framework control and
is of no use to you.
The easiest is URL access(search BOL for URL).
Report Manager itself uses web services (Report Manager is really just a
portal that ships with RS. It does nothing that you can't do yourself with
published web services)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:015E15B4-EFDB-422C-917E-B6E7ECACACB5@.microsoft.com...
> Can anyone point me to some useful information on embedding reports into a
> java (J2EE) application?
> Stephanie|||Thanks, Bruce. I can see how you can hide the Toolbar if you want to
(&rc:Toolbar=false). Is there a way to hide sections above the toolbar?
Basically, I want the user to only see the Toolbar and below within the app.
Perhaps the application can manage the Back button functionality?
Also, another quick question: Can you hide the report header and footer with
this sort of option or would you have to add hidden parameters to do that?
Some reports are used within the app and outside the app. When inside the
app, I do not want the report header and footer to show. I'm thinking I have
to add yet another hidden parameter.
S.
"Bruce L-C [MVP]" wrote:
> Not specifically but I can tell you your options. There are three ways to
> integrate reports into an application: roll your own with web services, use
> URL integration, use the reportviewer control that comes with VS 2005. Of
> these you can use the first two. The control is a 2.0 framework control and
> is of no use to you.
> The easiest is URL access(search BOL for URL).
> Report Manager itself uses web services (Report Manager is really just a
> portal that ships with RS. It does nothing that you can't do yourself with
> published web services)
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:015E15B4-EFDB-422C-917E-B6E7ECACACB5@.microsoft.com...
> > Can anyone point me to some useful information on embedding reports into a
> > java (J2EE) application?
> >
> > Stephanie
>
>|||You can hid the parameter area too. This link shows the things you can
control for the html viewer. I tend to hide the parameter area but not the
toolbar.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsprg9/html/1c3e680a-83ea-4979-8e79-fa2337ae12a3.htm
Correct about the hidden parameter for the report header and footer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:DD1721F3-3164-479A-BB25-AB4218CA6E40@.microsoft.com...
> Thanks, Bruce. I can see how you can hide the Toolbar if you want to
> (&rc:Toolbar=false). Is there a way to hide sections above the toolbar?
> Basically, I want the user to only see the Toolbar and below within the
> app.
> Perhaps the application can manage the Back button functionality?
> Also, another quick question: Can you hide the report header and footer
> with
> this sort of option or would you have to add hidden parameters to do that?
> Some reports are used within the app and outside the app. When inside the
> app, I do not want the report header and footer to show. I'm thinking I
> have
> to add yet another hidden parameter.
> S.
> "Bruce L-C [MVP]" wrote:
>> Not specifically but I can tell you your options. There are three ways to
>> integrate reports into an application: roll your own with web services,
>> use
>> URL integration, use the reportviewer control that comes with VS 2005. Of
>> these you can use the first two. The control is a 2.0 framework control
>> and
>> is of no use to you.
>> The easiest is URL access(search BOL for URL).
>> Report Manager itself uses web services (Report Manager is really just a
>> portal that ships with RS. It does nothing that you can't do yourself
>> with
>> published web services)
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> news:015E15B4-EFDB-422C-917E-B6E7ECACACB5@.microsoft.com...
>> > Can anyone point me to some useful information on embedding reports
>> > into a
>> > java (J2EE) application?
>> >
>> > Stephanie
>>

Embedding reports in Winform App...

I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
application using SQL Server 2K.
Thanks everyone.Use fyiReporting component (http://www.fyireporting.com). Is open source and
read RDL files with Windows Forms Viewer component.
[]s
"Terry Mulvany" <terry.mulvany@.rouseservices.com> escreveu na mensagem
news:eh4oCnMqFHA.2072@.TK2MSFTNGP14.phx.gbl...
>I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
>application using SQL Server 2K.
> Thanks everyone.
>|||Thanks Pedro, do you or anyone else know of any similar 3rd party (pay or
open source) components that actually use the infrastructure of SQL Server
Reporting Services (i.e. ReportServer web service and it's corresponding
security) rather than just simply being able to load an RDL file and view it
as the FYIReporting stuff does.
(I know .Net 2.0 and Yukon will support this but we do not have that as an
option)
Thanks all.
-Terry
"Pedro Jr." <pedro.alvesjr@.gmail.com> wrote in message
news:epT5CvMqFHA.2776@.TK2MSFTNGP10.phx.gbl...
> Use fyiReporting component (http://www.fyireporting.com). Is open source
> and read RDL files with Windows Forms Viewer component.
> []s
>
> "Terry Mulvany" <terry.mulvany@.rouseservices.com> escreveu na mensagem
> news:eh4oCnMqFHA.2072@.TK2MSFTNGP14.phx.gbl...
>>I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
>>application using SQL Server 2K.
>> Thanks everyone.
>|||You can use web services to return a stream rendered how you want and then
display that (pdf, excel, html, etc). Or you can use URL integration. Put a
IE browser control and set its URL appropriately. With .Net 2.0 where will
be a winform control which will make all of this extremely easy.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
news:eh4oCnMqFHA.2072@.TK2MSFTNGP14.phx.gbl...
>I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
>application using SQL Server 2K.
> Thanks everyone.
>

Embedding reporting services as a standalone product

Hi,
In the application that I am working on, we currently use Crystal Reports as
the embedded reporting engine. I am trying to evaluate if we should move
over to Microsoft Reporting Services. However, one thing confuses me. It
seems Microsoft Reporting Services will work only as a server under IIS.
This will not work for our customers. I am wondering if Reporting Services
has any embedded component much like Crystal Reports that we could use.
Thank you in advance for your help.
SunnyVersion 2 will have a web form and a winform that does not require the
server (works with the server if there but does not require it).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sansanee" <sansanee@.nospam.com> wrote in message
news:%23LD40RJ3EHA.1144@.TK2MSFTNGP09.phx.gbl...
> Hi,
> In the application that I am working on, we currently use Crystal Reports
as
> the embedded reporting engine. I am trying to evaluate if we should move
> over to Microsoft Reporting Services. However, one thing confuses me. It
> seems Microsoft Reporting Services will work only as a server under IIS.
> This will not work for our customers. I am wondering if Reporting Services
> has any embedded component much like Crystal Reports that we could use.
> Thank you in advance for your help.
> Sunny
>

Embedding a reporting Services object

Hi,
Can I embedde a reporting services object in my web based application so the
clients can use the reporting seemlessly.
Thanks in advance,
BenjaminYes, you can. Take a look at the ReportViewer sample that Microsoft
includes.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"BenJ" <BenJ@.netvu.com> wrote in message
news:O3XVHB4HFHA.2456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Can I embedde a reporting services object in my web based application so
> the
> clients can use the reporting seemlessly.
> Thanks in advance,
> Benjamin
>|||Check this example
http://www.rdlcomponents.com/ASPExamples/default.aspx
"Jeff A. Stucker" wrote:
> Yes, you can. Take a look at the ReportViewer sample that Microsoft
> includes.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "BenJ" <BenJ@.netvu.com> wrote in message
> news:O3XVHB4HFHA.2456@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > Can I embedde a reporting services object in my web based application so
> > the
> > clients can use the reporting seemlessly.
> >
> > Thanks in advance,
> > Benjamin
> >
> >
>
>

Embedded SQL Server Express Deployment - Unhandled Exception: Database already exists

Good Afternoon.

I am trying to write a short application within which I would like to embed a SQL Server Express database, all of which would be deployed via ClickOnce through a web site. The installation process seems to be working without trouble, including installation of the .NET Framework 2.0 and SQL Server Express 2005.

When the application launches on the new machine, however, I get a big Microsoft .NET Framework "Unhandled exception" error dialog box that indicates the database already exists and that the database file could not be attached. I am working with a clean virtual machine that I know has never had the database installed on it.

I fear I am overlooking something quite straightforward, but since this is the first time I have ever attempted to build a data-bound application, I am not sure where I am going wrong.

Perhaps the source of the problem, or a related problem, might be revealed even when I run the application in debug mode from within Visual Studio. I can run the application once, but if I try to run it again, I get an error when I try to open the database connection that is similar in content (database already exists...could not attach). I can run the SSEUtil and detach the database and then run the application again in debug mode and it works no problem (the first time!).

Lastly, if I install the application on the machine on which it was developed and make sure the database is detached, it will run without any trouble (even repeatedly). But, on a new blank machine, there is no database listed that matches my database name, so I cannot try to detach anything!?

My apologies for such a novice question!

Sean

Hi Sean,

I would suggest removing the ‘Initial Catalog’ keyword from your connection string. Among the things that are stored about a database when it is attached is the Name/Path pairing; SQL Server gets a little upset if you try to attach a database using an existing name but with a different path. Enter the |DataDirectory| macro…

I’m guessing you’re using ClickOnce deployment for this application. There are things that will cause the install directory of a ClickOnce deployment to move, when this happens, VS magically fixes up things as far as the application goes, but it cannot fix up the fact that SQL Server has recorded your explicit database as being linked to the old file location. When you attempt to open the application now, the attach fails because there is already a database named JMU_2007 listed in the master database, but it is associated with a different path, so you get the error that the database already exists. I’m guessing this is the problem you’re hitting.

By removing the ‘Initial Catalog’ keyword, you’re forcing SQL Express to give the database an autoname based on its path. If the database moves as a result of VS behavior, the name will be changed because the path has changed, so it will appear to be a different database from the SQL perspective. Hopefully this helps.

Mike

|||

Thanks very much Mike. That did the trick...I can't believe I overlooked that after spending too much time trying to fix this problem.

Sean

Embedded PDF and Excel Files

I want to upload PDF and Excel files to the Report Server database. I
would like to display them in a custom web application. When working
with the ReportViewer control, I can easily show reports. I can't
figure out the process on how to show a PDF to a user. In particular,
if the user selects a PDF ( I can check the MIMETYPE), then, how do I
get the file from Report Server so I can stream it to the user?On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> I want to upload PDF and Excel files to the Report Server database. I
> would like to display them in a custom web application. When working
> with the ReportViewer control, I can easily show reports. I can't
> figure out the process on how to show a PDF to a user. In particular,
> if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> get the file from Report Server so I can stream it to the user?
If you create a report that has the same format and output as the PDF
and Excel files, you could call the report and automatically render it
to PDF or Excel with a download prompt via URL. Here are a couple
examples.
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=PDF
-or-
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=Excel
Here's the URL format:
http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Render&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> > I want to upload PDF and Excel files to the Report Server database. I
> > would like to display them in a custom web application. When working
> > with the ReportViewer control, I can easily show reports. I can't
> > figure out the process on how to show a PDF to a user. In particular,
> > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > get the file from Report Server so I can stream it to the user?
> If you create a report that has the same format and output as the PDF
> and Excel files, you could call the report and automatically render it
> to PDF or Excel with a download prompt via URL. Here are a couple
> examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=
=3DRend...
> -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=3DRe=
nd...
> Here's the URL format:
> http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=3DR=
ende=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML/Excel/=MHTML>
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
These are generic PDF files, not based on a report so they cannot be
rendered. We are using Reporting Services to provide security not
only to reports, but also some ancillary PDF and Excel files.|||Where does an uploaded pdf get stored'
Our uploaded pdf changes every week and rather than reupload everytime I was
hoping we could just save changes to the location it was uploaded to.
Many Thanks
"google@.landy.net" wrote:
> On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> >
> > > I want to upload PDF and Excel files to the Report Server database. I
> > > would like to display them in a custom web application. When working
> > > with the ReportViewer control, I can easily show reports. I can't
> > > figure out the process on how to show a PDF to a user. In particular,
> > > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > > get the file from Report Server so I can stream it to the user?
> >
> > If you create a report that has the same format and output as the PDF
> > and Excel files, you could call the report and automatically render it
> > to PDF or Excel with a download prompt via URL. Here are a couple
> > examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> > -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> >
> > Here's the URL format:
> > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Rende-r&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
> > Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
> These are generic PDF files, not based on a report so they cannot be
> rendered. We are using Reporting Services to provide security not
> only to reports, but also some ancillary PDF and Excel files.
>

Embedded and distribute MSDE on CD

Hi,

I am trying to find something like a light version of SQL Server 2k to store data for an application that will be distributed through a cd.

Since we also have a web front end for this application when the user is online, we prefer that we can reuse the code for connection on both the cd and the web.

Any idea what will work?

I have come accross MSDE 2k but was not able to find any documentation on the pros and cons for this product regarding its capacity, the type of data it can handle, security, ...

Please give me some pointer.

Thanks very much.

Baoha.http://www.microsoft.com/sql/msde/default.asp hompage and corresponding links for more information.

Embed Report Builder

Hi,
I am trying to find out if I can embed report builder into a Delphi 5
application.
Does anyone know if this is possible?
Thanks,
SDAlas, it isn't...
Neither the VS.NET designer, nor the Report Builder designer can be
integrated into custom applications. To make the matter worse, there isn't a
single extensibility hook in the Report Builder (not event command line
switches). It is pretty much "take as it-is or leave it" kind of a design
pattern. Very strange, considering the extensibility has been one of the RS
hallmarks since its first release. Currently, we are implementing a
home-grown ad hoc designer to this reason. Don't ask me how much fun we are
having implementing a WYSIWYG designer :-(
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"ScottishDeveloper" <ScottishDeveloper@.discussions.microsoft.com> wrote in
message news:2EEA3CD0-F2E6-4639-A116-1FD7DC79D8BB@.microsoft.com...
> Hi,
> I am trying to find out if I can embed report builder into a Delphi 5
> application.
> Does anyone know if this is possible?
> Thanks,
> SD

Embed HTML tags into report fields

I have a need to render data returned from a relational DB with spacing intact. The application is a viewer for input data so the end user can determine if the input data is different than the file layout specified so the data will be parsed correctly, so spacing is critical.

I changed to a fixed-pitch font to ensure that the text records align properly in VS (which they do), but when I render to HTML, the spaces collapse (of course). PDFs render correctly, but we were trying for HTML output.

Is there any way to replace the native spaces with &nbsp; so it will render correctly in HTML? From the other posts, it seems not, but I want to double check.

If anyone knows of a way to do this, I would appreciate any insight.

Thx.See http://blogs.msdn.com/bimusings/archive/2005/12/14/503648.aspx.sql

Embed HTML tags into report fields

I have a need to render data returned from a relational DB with spacing intact. The application is a viewer for input data so the end user can determine if the input data is different than the file layout specified so the data will be parsed correctly, so spacing is critical.

I changed to a fixed-pitch font to ensure that the text records align properly in VS (which they do), but when I render to HTML, the spaces collapse (of course). PDFs render correctly, but we were trying for HTML output.

Is there any way to replace the native spaces with &nbsp; so it will render correctly in HTML? From the other posts, it seems not, but I want to double check.

If anyone knows of a way to do this, I would appreciate any insight.

Thx.See http://blogs.msdn.com/bimusings/archive/2005/12/14/503648.aspx.

embbed AS cube browser

Hi,

How could I embbed AS cube browser to my application?

thanks a lot,

I have been looking for the same, but so far I have only seen reference to using OWC (Office Web Components) to embed an Excel doc that references the cube.

The add-in is available here:

http://www.microsoft.com/downloads/details.aspx?familyid=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en

and I found this link to helpful for initial set-up

http://www.upyourasp.net/articles/article.aspx?aid=15

The book I found most helpful whas the "Microsoft Office Web Components Black Book with .NET".

Hope that helps somewhat. If you do find a way to embed the cube browser please post back to this thread as I would be most interested.

Tristan

Emailing from MS SQL

Hey,

I would like to set up a job to send mail out to clients on a semi-regular basis. Is there a way to mail directly from MS SQL.

or some application which I can set to interface with MS SQL and send these mails out.

I'm currently using asp.net, however, doing it through the web is very time consuming, I would much rather use some application to generate the mails on the server as it currently takes close to 20 min to send through the web interface (and that's only to 900 members, we are looking at having at least 2000 members in a few weeks). What am I looking for is something I can call perhaps with transact sql so I can run it through an ms sql server job, however any solution you have would be fantastic.

If you don't have specific details, that's fine, I'm not even sure what apps etc to look into, even a name of some technology to use (or does MS SQL have a way of doing all of this itself?)

Thanks a lot for your help, life saver ;-)have you looked at xp_sendmail in the bol??|||lol, arg, it's always something simple.

Awesome, that looks pretty much like example what I want.

Thanks a lot mate ;-)|||So worries, hope it works out for you. I have often wanted to use it but due to server setup and network admins being what they are it's never happened... :(|||it's pretty simple to set up SQLMail
the trick is to get the SQL Server agent a domain user account to use as a startup account. then just set up a user mail profile by logging in as that user account. and opening your client (Isuggest outlook 98 or newer)
it will work with any MAPI1 compatible mail server even so even lotus notes...|||KBA (http://support.microsoft.com/default.aspx?kbid=263556) to configure the SQLMail.|||even so even so even so even so

sorry i was stuck in the inner groove of sgt pepper|||Hey,

I've had a few weeks on another project, and I'm back onto this job again (um, yay?, lol).

Anyway, I have had a look over the KBA link Satya posted. I am unsure if this will solve my problem, so, here are some more details about my situation.

I have a dedicated webserver at Cradle (an internet hosting company in australia).

My machine is isolated from the other machines (I'm not 100% sure about this, but it 'seems' to be the case).

They have a mail server which is something like: host1.xxxxxx.com.au. I need to send my mail through this.

The mail I send, I also need to be able to control the <From> field.

As the user who sends the mail, needs to be the user who the message is <From>, the stuff I've read in the KBA seems to send the mail through a single mail account (correct me if I'm wrong).

Also, I don't have access to Outlook on that machine. Is there some free tool etc I can install, or will I need to ship an old copy of outlook to the server for them to install for me?

Thanks, I'll head back to the KBA and keep reading now, see if I can't try and answer my own questions (fingers crossed)|||If you don't wish to set up SQL Server with a domain account or if you don't wish to use Outlook/Exchange, there are alternatives. I use a stored procedure that just needs a SMTP server to relay mail through that I found here:

http://www.sqlservercentral.com/scripts/contributions/510.asp

You'll have to register with the site to get the script, but it's well worth it. Their script library is VERY impressive.

Email subscription. Dynamic field of From.

hi,
I have a console application calling reporting service to generate email
subscription. It works but the email from field always show the fix address
in RSReportServer.config. Is there a way I can programmable change the From
field with my code?
Please suggest.
regards,
JoeNo, the from field can not be changed. You can change the Reply-To field.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:50E4BCAD-DD67-494D-8D63-205D8E257BBD@.microsoft.com...
> hi,
> I have a console application calling reporting service to generate email
> subscription. It works but the email from field always show the fix
> address
> in RSReportServer.config. Is there a way I can programmable change the
> From
> field with my code?
> Please suggest.
> regards,
> Joe|||That is correct, the from field cannot be changed programmatically per
request. You can usually use the reply-to header to achieve what you're
looking for.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:50E4BCAD-DD67-494D-8D63-205D8E257BBD@.microsoft.com...
> hi,
> I have a console application calling reporting service to generate email
> subscription. It works but the email from field always show the fix
> address
> in RSReportServer.config. Is there a way I can programmable change the
> From
> field with my code?
> Please suggest.
> regards,
> Joe|||Thanks for your reply.
Joe
"Lukasz Pawlowski [MSFT]" wrote:
> That is correct, the from field cannot be changed programmatically per
> request. You can usually use the reply-to header to achieve what you're
> looking for.
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:50E4BCAD-DD67-494D-8D63-205D8E257BBD@.microsoft.com...
> > hi,
> > I have a console application calling reporting service to generate email
> > subscription. It works but the email from field always show the fix
> > address
> > in RSReportServer.config. Is there a way I can programmable change the
> > From
> > field with my code?
> > Please suggest.
> > regards,
> > Joe
>
>sql

Email Delivery

I'm using the web service to run reports from an application. However, I don't want to wait for a report to complete; I would like to just have the report emailed to the user when it is complete. I've only found email delivery through subscriptions. Is there another way to deliver reports via email?

If I have to use subscriptions I would like to set them to run "immediately". I've found that setting the start date to sometime in the past does not seem to run the report. Is there some way to set a schedule to run immediately. I've thought of setting the time to the near future, but I seem to have the problem of getting the proper timestamp. Can I get this through the web service some how?

Thanks,

Sam

No there is no such functionality. As you are creating a subscription, as job is created at the SQL Server Agent Service which will keep track of the execution of it, therefore setting the value to a past datetime won′t effect the execution.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Eliminate Blank Spaces Between Cross-tabs

Hi.
I am developing our company's inventory application. I am creating a report that involves a cross-tab and subreport. We are using VB 2005 on which the Crystal Report is integrated.

I placed my cross-tab in the Group Header Section, and the subreport, also containing a crosstab in the Group Footer Section. Logically, it works properly but i cannot get rid of the blank spaces in between the cross-tab and subreport.

I have already checked all the properties of the sections. like suppressing those sections that are not included. But still, the blank spaces are there.
Please extend help on this matter. Thanks!What section is the space attributed to in the preview?|||Hello.

I suspect that the blank spaces are generated within the Group Header Section, wherein the cross-tab is placed.

Efficient INSERT of rows- .NET

Hello- I have a C++ .NET application that rips through a raw file, generating
thousands of INSERT statements to insert into a SQL Server 2000 database
through the SQLConnection class in .NET. While this seems reasonably fast,
I'm wondering if it is the most efficient way of doing this. Would creating
a stored procedure on the SQL Server and then passing parameters to the SP
through the Command object be faster and more efficient? I've also
considered dumping the contents to a flat CSV file and using SQL Server DTS
to BULK INSERT the rows- but that is additional overhead in creating the CSV
file and then launching DTS etc. Any suggestions/comments would be
appreciated.
Thanks,
Jon
I replied to this in .programming. Please don't multipost. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonathan Porter" <JonathanPorter@.discussions.microsoft.com> wrote in message
news:D72A8997-D492-49A4-86DB-16C786771F3F@.microsoft.com...
> Hello- I have a C++ .NET application that rips through a raw file, generating
> thousands of INSERT statements to insert into a SQL Server 2000 database
> through the SQLConnection class in .NET. While this seems reasonably fast,
> I'm wondering if it is the most efficient way of doing this. Would creating
> a stored procedure on the SQL Server and then passing parameters to the SP
> through the Command object be faster and more efficient? I've also
> considered dumping the contents to a flat CSV file and using SQL Server DTS
> to BULK INSERT the rows- but that is additional overhead in creating the CSV
> file and then launching DTS etc. Any suggestions/comments would be
> appreciated.
> Thanks,
> Jon

Efficient INSERT of rows- .NET

Hello- I have a C++ .NET application that rips through a raw file, generatin
g
thousands of INSERT statements to insert into a SQL Server 2000 database
through the SQLConnection class in .NET. While this seems reasonably fast,
I'm wondering if it is the most efficient way of doing this. Would creating
a stored procedure on the SQL Server and then passing parameters to the SP
through the Command object be faster and more efficient? I've also
considered dumping the contents to a flat CSV file and using SQL Server DTS
to BULK INSERT the rows- but that is additional overhead in creating the CSV
file and then launching DTS etc. Any suggestions/comments would be
appreciated.
Thanks,
JonI replied to this in .programming. Please don't multipost. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonathan Porter" <JonathanPorter@.discussions.microsoft.com> wrote in messag
e
news:D72A8997-D492-49A4-86DB-16C786771F3F@.microsoft.com...
> Hello- I have a C++ .NET application that rips through a raw file, generat
ing
> thousands of INSERT statements to insert into a SQL Server 2000 database
> through the SQLConnection class in .NET. While this seems reasonably fast
,
> I'm wondering if it is the most efficient way of doing this. Would creati
ng
> a stored procedure on the SQL Server and then passing parameters to the SP
> through the Command object be faster and more efficient? I've also
> considered dumping the contents to a flat CSV file and using SQL Server D
TS
> to BULK INSERT the rows- but that is additional overhead in creating the C
SV
> file and then launching DTS etc. Any suggestions/comments would be
> appreciated.
> Thanks,
> Jon

Efficient INSERT of rows- .NET

Hello- I have a C++ .NET application that rips through a raw file, generating
thousands of INSERT statements to insert into a SQL Server 2000 database
through the SQLConnection class in .NET. While this seems reasonably fast,
I'm wondering if it is the most efficient way of doing this. Would creating
a stored procedure on the SQL Server and then passing parameters to the SP
through the Command object be faster and more efficient? I've also
considered dumping the contents to a flat CSV file and using SQL Server DTS
to BULK INSERT the rows- but that is additional overhead in creating the CSV
file and then launching DTS etc. Any suggestions/comments would be
appreciated.
Thanks,
Jon
I replied to this in .programming. Please don't multipost. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonathan Porter" <JonathanPorter@.discussions.microsoft.com> wrote in message
news:D72A8997-D492-49A4-86DB-16C786771F3F@.microsoft.com...
> Hello- I have a C++ .NET application that rips through a raw file, generating
> thousands of INSERT statements to insert into a SQL Server 2000 database
> through the SQLConnection class in .NET. While this seems reasonably fast,
> I'm wondering if it is the most efficient way of doing this. Would creating
> a stored procedure on the SQL Server and then passing parameters to the SP
> through the Command object be faster and more efficient? I've also
> considered dumping the contents to a flat CSV file and using SQL Server DTS
> to BULK INSERT the rows- but that is additional overhead in creating the CSV
> file and then launching DTS etc. Any suggestions/comments would be
> appreciated.
> Thanks,
> Jon

efficiency of sql server on searching on text field

Hi

We have a application running on Sql server 2005, which require to browse/search text field. Does anyone know if Sql server's search/browse performance on text field is better than oracle?

The table the application will search on is a customer table that has a 10000 records in it, does this size of table casue a performance problem for sql server 2005 if I index the text field?

Please advise, thanks for your help!

Li

Id it a TEXT field or a field with characters stored in it ? How much data can be stored in the attribute ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Actually it is text field with 10 character length

|||

Well 10k rows is not that much. It could be that SQL Server will even cache the rows or do a table scan rather than touch the index. but in terms of planning for the future, you should consider using an index if the attribute is queried a lot.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||did u tried to create an index that match the search query

find below steps of choosing the most needed indexes

The following query will get the 10 missing indexes would produce the highest anticipated cumulative improvement, in descending order, for user queries.

SELECT TOP 10 *

FROM sys.dm_db_missing_index_group_stats

ORDER BY avg_total_user_cost * avg_user_impact * (user_seeks + user_scans)DESC

You can get the missing index details in the following way:

The following query determines which missing indexes comprise a particular missing index group, and displays their column details.

For the sake of this example, the missing index group handle is 24.(You will need to change the handle value with handle values which comes up from the earlier query)

SELECT migs.group_handle, mid.*

FROM sys.dm_db_missing_index_group_stats migs

INNER JOIN sys.dm_db_missing_index_groups mig

ON (migs.group_handle = mig.index_group_handle)

INNER JOIN sys.dm_db_missing_index_details mid

ON (mig.index_handle = mid.index_handle)

WHERE migs.group_handle = 24 <<put your handle value here>>

For details on this refer to the following articles:

http://msdn2.microsoft.com/en-us/library/ms345421.aspx

Using Missing Index Information to Write CREATE INDEX Statements

http://msdn2.microsoft.com/en-us/library/ms345405.aspx

Effects of using Transaction in SP on Performance?

Hi All;
I have a web application which is being used at large scale and there are
upto 10,000 entries per day. Currently, there is no Begin Tran/Commit
Tran/Rollback Tran and b/c of that we found some data corruption. Now, I
changed all the transactional Stored Procedure and used Transaction into
them. Now, I am thinking about the performance of the application when I use
d
Transaction into Stored Procedures which are being used by each user very
frequently. Transaction Lock the objects which might hurt the application
performance. Please, comments on it and should I use Transaction now or not?
Thanks.
Essa, M. Mughal
Software Developer
CanadaYou should DEFINITELY use transactions. Performance penalty or not. There
is no choice here. Data integrity is, by far, the MOST IMPORTANT THING IN A
DATABASE. Sorry for the all caps, but I had to drive it home. Do not
sacrifice your data quality. Otherwise there is very little reason to even
be using a database.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Essa" <essamughal@.hotmail.com> wrote in message
news:46BFC928-7375-47ED-AA79-73FE92A45843@.microsoft.com...
> Hi All;
> I have a web application which is being used at large scale and there are
> upto 10,000 entries per day. Currently, there is no Begin Tran/Commit
> Tran/Rollback Tran and b/c of that we found some data corruption. Now, I
> changed all the transactional Stored Procedure and used Transaction into
> them. Now, I am thinking about the performance of the application when I
used
> Transaction into Stored Procedures which are being used by each user very
> frequently. Transaction Lock the objects which might hurt the application
> performance. Please, comments on it and should I use Transaction now or
not?
> Thanks.
> --
> Essa, M. Mughal
> Software Developer
> Canada|||Hi Adam;
Thanks for your strong recommendataion. I really appreciate your way of
conveying me the importance of Data. I have already changed all the
transactional stored procedure but I was just wondering so now I'll go live
with them and then see what happens. I hope nothing will happen but it will
increase data integrity.
Thanks
"Adam Machanic" wrote:

> You should DEFINITELY use transactions. Performance penalty or not. Ther
e
> is no choice here. Data integrity is, by far, the MOST IMPORTANT THING IN
A
> DATABASE. Sorry for the all caps, but I had to drive it home. Do not
> sacrifice your data quality. Otherwise there is very little reason to eve
n
> be using a database.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Essa" <essamughal@.hotmail.com> wrote in message
> news:46BFC928-7375-47ED-AA79-73FE92A45843@.microsoft.com...
> used
> not?
>
>