Exporting PDF Problems

i ve used SOAP API in my web application and thus generated the report in
html giving user an opton to export the report to excel or PDF when user
exports the report to excel it works perfectly but when it is exported to PDF
as usual open/save dialogue box appear what so ever is the response acrobate
reader loads but instead of opening the exported report it gives an error
which stats that
file is corrupt cant b corrected and thus cant b open
can anyone tell whats the problem in all that case
i use reponse.addheader and response.write methods to enable user to export
to pdf kindly help it outMuhammad Hammad wrote:
> i ve used SOAP API in my web application and thus generated the
Which PDF-Reader do you use?
You need Adobe-Reader >= Version 6.0!
best regards
Frank
--
www.xax.de|||well frank i m already using acrobate reader 6.0 professional
"Frank Matthiesen" wrote:
> Muhammad Hammad wrote:
> > i ve used SOAP API in my web application and thus generated the
> Which PDF-Reader do you use?
> You need Adobe-Reader >= Version 6.0!
> best regards
> Frank
> --
> www.xax.de
>
>
>|||Going to version 7 is free, and seems to be worth it. Also, do you have
RS SP1 installed? It has some rendering fixes.|||well i m installed with RS sp 1. as far as acrobate reader 7 is concerned i
ll chceck that out and let it b known
"Parker" wrote:
> Going to version 7 is free, and seems to be worth it. Also, do you have
> RS SP1 installed? It has some rendering fixes.
>

Exporting data with dynamic fields

Hi,

I have one Query Builder application where user creates queries and generates output with required fields.Then user can export the same to excel (Using farPointSpread properties)
But if no. of records goes beyond 10K it goes too slow or even user machine hangs up. I want to give proper export facility. Can it be given using DTS?

I tried DTS (.vbs) file. but for random field selection it did not work.DTS package asks for new Transactions to be built for every change in Source table structure. It first creates the table in the destination databse and then exports the data.
If I try modify the VB code generated by the package to match with new Source table it does'nt work.

Can anyone tell me what should I do for export the data dynamically i.e. export the tables with differrent structres?

Thanx in advance.|||You should do a helluvalotta programming. DTS sucks, and I don't believe most people on this forum use it for much more than directly transfering defined recordsets.

Exporting crystal reports in excel

Hi all

When i export crystal report file in excel it gives unknown error and the application get closed.
But the same report is getting exported in word and other applications

What is the reason?Can anybody help for this?
Plz also tell if their is any dll used for exporting rpt files.

Regards

AanchalI'm not sure about what exactly is the problem, may be while installing you skiped to select Excel related options. Try to install again in Complete mode and select whichever is related excel.

Good Luck,
Gragi|||Which version of Excel are you using?sql

exporting a crystal report to pdf format using vb application

hai
how to export a crystal report to pdf format using vb application
please help me
thank u
rachamalluUnless you provide more information, it will be rather difficult to help you. What version of Crystal Reports are you using? What method are you using to display your reports? etc...

Try to do a search on Crystal's Website:

http://support.businessobjects.com/search/advsearch.asp|||i am using crystal report 6.0 and vb 6.0

i am using crystalreport1.printreport to display the report|||I had read somewhere that exporting to pdf through code isn't available in versions previous to 8.5, but I'm not positive. If you can upgrade to 8.5, I can tell you how to do it using RDC (Report Designer Component) as that's what I use for Exporting.

Unless you're referring to exporting based on pressing the export button on the report itself. If thats the case, then you just need to have the correct dlls installed on the machine you're using.|||hai

how to export a crystal report to pdf format using vb application

please help me

thank u

Shahla|||The following code uses RDC to export to PDF

Dim mCrApp As New CRAXDRT.Application
Dim mCrrep As CRAXDRT.Report

mCrrep.ExportOptions.DiskFileName = OutputFileName
mCrrep.ExportOptions.DestinationType = crEDTDiskFile
mCrrep.ExportOptions.FormatType = OutputFileType

'In case u want to export the complete report, use the following code

mCrrep.ExportOptions.PDFExportAllPages = True

In case u want to export a page range from the report, use the following code

mCrrep.ExportOptions.PDFExportAllPages = False
mCrrep.ExportOptions.PDFFirstPageNumber = StartPage
mCrrep.ExportOptions.PDFLastPageNumber = EndPage

mCrrep.Export False

Exporting .sdf from pda into a text file on desktop

Dear All,

I have an application running on my mobile device and the data is stored in the mobile database. So now i am trying to build any application on my pc which upon click should download the data from my mobile database into a local text file. Is there any idea or reference where I can stary working on this ?

DataSet ds = new DataSet();

...

DataAdapter da = new DataAdapter(...);

da.Fill(ds, "table1");

...

da.Fill(ds, "tableN");

ds.WriteXml("LocalTextFile.xml");

If XML is not what you want then write data row by row in the format you want using System.IO namespace.

|||

Dear Ilya,

I would prefer it to be in text file format. The problem what project shall I develop I mean in the visual studio 2005. Should it be windows form or device application ? Because if it is device application it cant run in my desktop rite ? So it should be windows form rite ? Thanks.

|||

Dear Ilya,

I have now build a new console application. So then I add a reference to

System.Data.SqlServerCe; to enable me to connect to the mobile database found in the pda. So when I try to run I get an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". The problem is that on the same machine I can compile my device application which is also using the same reference'System.Data.SqlServerCe. Please correct me if I am doing something wrong here. Another thing is that how must I reference the path to my mobile database in the pda ? I am trying like this I dont know if this is right

Mobile Device/MiniSD Card/MiniSD Card/test1/db1.sdf. Thanks.

|||

Dear All,

I have a problem here. What i exactly want to do it that build a console application where when I connect my pda to my desktop and run the exe file it should be able to transfer the .sdf data into a text file of my local desktop ? Is there any code or reference where can guide me ?

|||Some of the components from www.primeworks-mobile.com should be able to help you.|||

Dear ErikEJ,

I would prefer to write on my own as I cant afford third party software. Hope you can show me some light into it. Thanks.

|||What you are going to want to probably do is copy the database from the device to your desktop, then use the sql ce for the desktop libs (remember you can use sql ce on devices and full blown windows) to read through the database and output . You can accomplish copying the database over through code using the Windows CE RAPI. The full framework as far as I know does not have built-in support for it. So what you would need to do is P/Invoke some functions in the rapi.dll. Luckily somebody has essentially done this, look for the opennetcf's (www.opennetcf.org) desktop communication library. So once you use this to get a copy of the database over to your desktop you can use the sql ce for windows (not wm or ce) libs to connect to your now local copy of the database. Then using a SqlCeDataReader you can just iterate through every record in the database, while reading a record in you can format it however you like then push that into a file using a StreamWriter object.
|||

Dear Steve,

Thank you very much for your kind information. So now I have downloaded the OpenNETCF.Desktop.Communication Library . Now how shall I start ? Shall I start by building a console application ? So must I first manually download the database or the system can do it for me ? I am really at lost can your pls guide me further on this. Thanks once again.

|||If you want to do it as a console application then start there. Then my next step would be to use the Desktop Communication library to programmatically get the database from your device to local computer. The communication library should have came with an example application that you can probably look at to find out how they copy files back and forth. You can look their and do the same thing.
|||

Dear Steve,

Ok I have followed and done accordingly and sucessfully download the sdf file into my desktop. My next problem is that i am not able to connect to downloaded .sdf in the desktop. I am using the same code as I build the windows device application. Can your please tell me wat can be my mistake ? For example I use this

SqlCeConnection conn1 = new SqlCeConnection("Data Source = c:/test1.sdf");

First I got an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". Then I manage to solve "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)". So wat is the possible error on my side ?

So what can be possible error on my side ? Thanks.

|||

Dear Steve,

I am ok with Desktop Communication library. I have already managed to download the database from the device to my local computer. My next step is that how can I from my console application link to the database which I have already downloaded using the said library. Thanks once again.

|||Once you have the sdf file over to you desktop you can use the desktop version of the sqlce data object. I think you need to download the Microsoft SQL Server Mobile 2005 Mobile Edition SDK. Once you have that downloaded and installed it you should be able to add the proper references to the desktop x86 version of the libraries that you need. Then you should be able to connect to the database and use it just like you did on the handheld with the .NET CF. You should be able to just use a SqlCeDataReader object to query the database then read through the returned records and output them using a StreamWriter object to put them into a text file which you can then control the format of.
|||

Dear Steve,

I have already downloaded the microsoft sql server mobile 2005 mobile edition sdk. So I tried to use the SqlCeDataReader and below is the errors I got. Can you please guide me on this ?

SqlCeConnection conn1 = new SqlCeConnection("Data Source = c:/test1.sdf");

First I got an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". Then I manage to solve that problem but got another one "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)". So wat is the possible error on my side ?Thanks.

|||F**K YOU AND YOUR STUPID QUESTIONS. GOOGLE THE ANSWER AND FIND SAMPLE CODE YOU CHEAP BASTARD.

export with a webservice

Hi,
I have created an application with VIsual Studio.NET in C#. I used a
webservice in order to view my reports.
I want export my report in format that I want with this application.
How can I do? What is the solution?I've done this by putting into a dropdownlist the available export formats
for a particular report. then when i go to render the report i have the
following code:
try
{
report =rs.Render(reportPath,format,historyID,devInfo,parameters,credentials,showHideToggle,out
encoding, out mimeType, out optionalParams, out optionalWarnings, out
streamIDs);
switch(format)
{
case "PDF":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/pdf";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
case "CSV":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/vnd.ms-excel";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
case "EXCEL":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/vnd.ms-excel";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
default:
Label1.Text = System.Text.Encoding.Default.GetString(report);
break;
}
}
catch (SoapException se)
{
Console.WriteLine(se.Detail.OuterXml);
}
"r388042" wrote:
> Hi,
> I have created an application with VIsual Studio.NET in C#. I used a
> webservice in order to view my reports.
> I want export my report in format that I want with this application.
> How can I do? What is the solution?|||Thanks you!!!
It's run very good!!!
Do you know how we can do in order to export in XML or TIFF?

Export to Excel?

I am using SQL Server CE as a backend to a dekstop application. I would like the ability to export some of the SQL Server CE tables in my databse to MS Excel. Is this possible?

Thanks.

Mike

Save your data as CSV or XML and Excel would load it.

Export to Excel programatically

Hi,

I would like to know if there is a way to programatically extract the Excel (or PDF) file from an existing report

My application has a set of Reports, and I would like to publish them in Excel (or PDF) format to a remote website, once a day.

Thank you!

Leo

Hi Leo,

This blog post might help:

http://geekswithblogs.net/vivek/archive/2006/09/26/92316.aspx

HTH,

Vivek

|||

Thank you Vivek,

but it seems to be a generic way to generate Excel files from any webpage.

What I would like to do is to use theReport Server export to PDF and Excel. I don't want to use 3rd party software to get PDF files, sinceReport Server already exports to PDF (and excel). I just have to figure out how to call Report Server to get these 2 formats programattically.

thanks

Leo

Export to Excel in MS Access

Hi,

I have one form in access application which shows various fields from
the database. The fields are like No of PCs a client has,No of
employees,revenue etc.

Need of the user is to filter the data on the form and export the
results.
I am using a Qury as the base for this form.Can I do it easily or i
need to write the code to do this.

Secondly can I provide a separate interface to allow user to Query and
extract the data.

Say, PC between <SomeRange> AND/ OR
Revenue Between <Some Range
whatever result comes will be exported to the Excel file.

Please tell me if you have any solution.

Thanks in Advance.

Rohit

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/General-Dis...pict241673.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=840002If you can utilize a query to create the data you want, then you can do
a simple trick of exporting the data within Access to Excel with very
little code.

DoCmd.OutputTo acOutputQuery, "Name Of Query", acFormatXLS

This can be assigned to a button and you have your results. This works
great if the query is based off the actual form.

Enjoy!

Export to Excel Functionality (SQL RS 2005)?

Hi there,
We have an ASP.NET 2.0 application that we are currently using and
would like to tie in some SQL RS 2005 functionality. Specifically,
we'd like to be able to use the report exporting functionality to
generate Excel or Acrobat docs, without having to use the report
viewer or using Reporting Services to generate a report in any way
that would be sent to the client. In other words, we don't want
reporting services to display the report on the site in any way, we
just want it to return the doc type selected from a drop down list.
Is this possible?
Thanks in advance,
RichReporting services is built totally on web services. This is used by
everything you see. For instance, Report Manager (the portal that ships with
RS uses it). In 2005 the reportviewer control uses it. It is totally
documented and you can use it in your app and render to whatever format you
like (html, csv, excel, pdf etc). You stream it back to your app and then do
with it as you please.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rchung77" <rich.chung@.gmail.com> wrote in message
news:1186758560.748324.102890@.e9g2000prf.googlegroups.com...
> Hi there,
> We have an ASP.NET 2.0 application that we are currently using and
> would like to tie in some SQL RS 2005 functionality. Specifically,
> we'd like to be able to use the report exporting functionality to
> generate Excel or Acrobat docs, without having to use the report
> viewer or using Reporting Services to generate a report in any way
> that would be sent to the client. In other words, we don't want
> reporting services to display the report on the site in any way, we
> just want it to return the doc type selected from a drop down list.
> Is this possible?
> Thanks in advance,
> Rich
>

Export to CSV fails with 3rd party web app

From my web application, exporting to Excel works fine, but when I export to CSV and open with Excel I get 2 garbage characters. I can export the report just fine from the ReportServer.

Is there something special that needs to be done? Could I have an old file?

Could it be something in my report? We always have the following components:
-- textboxes in the page header and footer
-- page header refers to parameter values; page footer refers to globals
-- 2 date parameters and 1 hidden boolean parameters

We're running SQL 2005 Reporting Services, and I have SP2 installed.

(I write the reports, not the web app)

?t

The export failed from SSRS, so the issue is not in the ReportViewer control.
It turns out a report parameter and a field in the dataset had the same name.
SELECT *, bad=@.bad FROM Employees

Changing the parameter name fixed it.
SELECT *, bad=@.notBadAtAll FROM Employees

Export to CSV fails with 3rd party web app

From my web application, exporting to Excel works fine, but when I export to CSV and open with Excel I get 2 garbage characters. I can export the report just fine from the ReportServer.

Is there something special that needs to be done? Could I have an old file?

Could it be something in my report? We always have the following components:
-- textboxes in the page header and footer
-- page header refers to parameter values; page footer refers to globals
-- 2 date parameters and 1 hidden boolean parameters

We're running SQL 2005 Reporting Services, and I have SP2 installed.

(I write the reports, not the web app)

?t

The export failed from SSRS, so the issue is not in the ReportViewer control.
It turns out a report parameter and a field in the dataset had the same name.
SELECT *, bad=@.bad FROM Employees

Changing the parameter name fixed it.
SELECT *, bad=@.notBadAtAll FROM Employees

export SQLServer2000 DB to Access

is there a simple way to remotely (using a ColdFusion application that can
access the database) making a copy of an entire SQLServer2000 database into
Access?
I can make an Access DB with empty tables that match the SQLServer tables,
they only have to be filled.
Somebody suggested this
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\myaccessdb.mdb';;,mytable) select * from mytable
but it is possible that this only runs with SQLServer2005 ... because it
requires enabling the Ad Hoc Distributed Queries feature which was
introduced with SQLServer2005 ... or can I run statements like this also in
SQLServer2000 ?
-MichaelMichael
1)DTS doesnt work?
2)
INSERT INTO OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\myaccessdb.mdb"; User
ID=Admin;Password='
)...Table(col1)
SELECT col1 FROM Table
"Michael Peters" <mp@.michaelpeters.de> wrote in message
news:dteomt$8eu$01$1@.news.t-online.com...
> is there a simple way to remotely (using a ColdFusion application that can
> access the database) making a copy of an entire SQLServer2000 database
> into Access?
> I can make an Access DB with empty tables that match the SQLServer tables,
> they only have to be filled.
> Somebody suggested this
> insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
> 'c:\myaccessdb.mdb';;,mytable) select * from mytable
> but it is possible that this only runs with SQLServer2005 ... because it
> requires enabling the Ad Hoc Distributed Queries feature which was
> introduced with SQLServer2005 ... or can I run statements like this also
> in SQLServer2000 ?
> -Michael
>
>|||What about using the DTS wizard for this ?
HTH, Jens Suessmeyer.|||How many tables in the DB? About how many total records?|||> DTS doesnt work?
no, DTS is not available as the server is remote and not under my control. I
have to do it programmatically, as I wrote,

> How many tables in the DB?
several dozen

> About how many total records?
thousands
-Michael|||> INSERT INTO OPENDATASOURCE(
> 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\myaccessdb.mdb"; User
> ID=Admin;Password='
> )...Table(col1)
> SELECT col1 FROM Table
"Der Ad-hoc-Zugriff auf den OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' wurde
verweigert. Sie mssen auf diesen Provider ber einen Verbindungsserver
zugreifen."
-Michael

Export SQL Server 2k/2k5 DB to SQL Mobile 2k5?

Hi,

I'm currently doing a application for a smartphone which requires me to replicate the desktop version of a db which was running on SQL 2k. From my reading, it seems that i will need SQL server 2k5 Management studio in order to convert my desktop db to the SQL Mobile version? Is there any other way? For now, i only have the 2k5's management studio express which came with my VS 2k5. I only notice that the express version doesn't allow me to create a SQL mobile db.

Thanks!!

John

Express will not work. There is a great third party product that can do what you want:

www.primeworks.pt

Darren

|||

SQL Server Express can also create a SQLCe (Compact Edition) database. It's a bit more convoluted, but you can also download the SQL Server Mananagement Studio (Express) that can create it as well. I describe how to create databases as well as discuss replication in my EBook. See www.hitchhikerguides.net.

hth

export roles and users into CSV

First of all, my SQL coding skills are not very good. Therefore I am
looking for a script which will export all SQL2k DB Roles (Application
& Database) including the Users (native SQL & AD Groups (we are using
mixed mode)) into a *.CSV.
thanks for your helpThat would be a nice Script to have.
In the meantime, try going to each database and selecting Generate Scripts.
Then only choose to scipt logins ?
that should be it,
Now to do it for one or more databases on one or more Servers.
Might have to try that on sunday
"Marty" <martin-za.frick@.ubs.com> wrote in message
news:fe528b81-5d2a-4732-93f3-ad47f8316644@.c33g2000hsd.googlegroups.com...
> First of all, my SQL coding skills are not very good. Therefore I am
> looking for a script which will export all SQL2k DB Roles (Application
> & Database) including the Users (native SQL & AD Groups (we are using
> mixed mode)) into a *.CSV.
> thanks for your help|||Hi Randy
Have a look at this link:
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31889/
Just need to build a DTS around the script and than adding it on each
DB server
On 13 Mrz., 16:55, "Randy Pitkin" <RandyPit...@.ydpages.com> wrote:
> That would be a nice Script to have.
> In the meantime, try going to each database and selecting Generate Scripts.
> Then only choose to scipt logins ?
> that should be it,
> Now to do it for one or more databases on one or more Servers.
> Might have to try that on sunday
> "Marty" <martin-za.fr...@.ubs.com> wrote in message
> news:fe528b81-5d2a-4732-93f3-ad47f8316644@.c33g2000hsd.googlegroups.com...
> > First of all, my SQL coding skills are not very good. Therefore I am
> > looking for a script which will export all SQL2k DB Roles (Application
> > & Database) including the Users (native SQL & AD Groups (we are using
> > mixed mode)) into a *.CSV.
> > thanks for your help

export roles and users into CSV

First of all, my SQL coding skills are not very good. Therefore I am
looking for a script which will export all SQL2k DB Roles (Application
& Database) including the Users (native SQL & AD Groups (we are using
mixed mode)) into a *.CSV.
thanks for your help
That would be a nice Script to have.
In the meantime, try going to each database and selecting Generate Scripts.
Then only choose to scipt logins ?
that should be it,
Now to do it for one or more databases on one or more Servers.
Might have to try that on sunday
"Marty" <martin-za.frick@.ubs.com> wrote in message
news:fe528b81-5d2a-4732-93f3-ad47f8316644@.c33g2000hsd.googlegroups.com...
> First of all, my SQL coding skills are not very good. Therefore I am
> looking for a script which will export all SQL2k DB Roles (Application
> & Database) including the Users (native SQL & AD Groups (we are using
> mixed mode)) into a *.CSV.
> thanks for your help
|||Hi Randy
Have a look at this link:
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31889/
Just need to build a DTS around the script and than adding it on each
DB server
On 13 Mrz., 16:55, "Randy Pitkin" <RandyPit...@.ydpages.com> wrote:[vbcol=seagreen]
> That would be a nice Script to have.
> In the meantime, try going to each database and selecting Generate Scripts.
> Then only choose to scipt logins ?
> that should be it,
> Now to do it for one or more databases on one or more Servers.
> Might have to try that on sunday
> "Marty" <martin-za.fr...@.ubs.com> wrote in message
> news:fe528b81-5d2a-4732-93f3-ad47f8316644@.c33g2000hsd.googlegroups.com...
>