473,320 Members | 1,746 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Printing and Exporting

Hi,

Couple of queries:

I am using asp.net 2.0

1. What is the best method of allowing a client to print the details of
a webform? My Webform has a number of components and a primary GridView
for displaying the results.
Should I consider using Crystal Reports or some other reporting
alternative?

2. The client needs to be able to export the query information to file.
Is this possible using ASP.NET and the clients web browser and if so,
how can I achieve this?

Thanks in advance for the help.

Regards,

Steven

*** Sent via Developersdex http://www.developersdex.com ***
Feb 8 '06 #1
5 1222
Hi,

"Steven Blair" <st**********@btinternet.com> wrote in message
news:ue**************@TK2MSFTNGP09.phx.gbl...
Hi,

Couple of queries:

I am using asp.net 2.0

1. What is the best method of allowing a client to print the details of
a webform? My Webform has a number of components and a primary GridView
for displaying the results.
Should I consider using Crystal Reports or some other reporting
alternative?
If you print directly from the page you have to be extra careful regarding
grids, you may not see the entire grid. also you have no control over header
& footer of the page.
I would go for CR , even more I prefer to export the CR to pdf and give this
pdf to the user, the user has more control over what to do with it, either
print it or store it.
2. The client needs to be able to export the query information to file.
Is this possible using ASP.NET and the clients web browser and if so,
how can I achieve this?


You can export your data in the format you need, either pdf, CSV , excel ,
access, etc . all you do is generate the file in the server and send this
file back to the user.


--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
Feb 8 '06 #2
Thanks for the reply.

I think I am going to use CR, but I have a problem regarding filtering
my queries.
My query is returned via a view, but before the report is generated, I
need to append a where clause to it before it is executed.

Have you any idea on how to do this?

*** Sent via Developersdex http://www.developersdex.com ***
Feb 9 '06 #3
Hi,

"Steven Blair" <st**********@btinternet.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
Thanks for the reply.

I think I am going to use CR, but I have a problem regarding filtering
my queries.
My query is returned via a view, but before the report is generated, I
need to append a where clause to it before it is executed.

Have you any idea on how to do this?

No clearly, no

What I do when I need to modify the rpeort source is that I use the push
method ( I think that is the correct name) I generate a Dataset with the
data from the DB, I transform it and using ReportDocument.SetReportSource(
theDataset) I assign it.
This also prevent any problems with the login auth you may have.
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
Feb 9 '06 #4
This is what I have tried to do so far, but getting a login box
appearing all the time:

1. I created the file DataSet1.xsd and mapped my columns to this.
2. On my rpt file, I selected the new DataSet and dragged a couple of
columns onto the report.
3. In my C# code I done the following:

//path and ds populated
ReportDocument CrystalReport1 = new ReportDocument();

CrystalReport1.Load(reportPath);
CrystalReport1.SetDataSource(ds)

crystalReportViewer.ReportSource = CrystalReport1;

I cannot get the the login box to disapear, and whats equallt
frustrating is the fact the login box has the servername populated as
"DataSet1" and the Database field is readonly and blank :|

This is extremly frustrating.

All I want to to do is query the Database using a View, which I need to
filter at runtime (using a where clause) and display it.

*** Sent via Developersdex http://www.developersdex.com ***
Feb 9 '06 #5
Hi,
"Steven Blair" <st**********@btinternet.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
This is what I have tried to do so far, but getting a login box
appearing all the time:


Haa, that perky window :)

What source did you use when you created your report?

You should use a dataset too, what I do is I create a piece of code that
execute the SP , fill a dataset (using a dataadapter) and then save it to
disk (with WriteSchema).
after that you assign this dataset to your report.

That should solve the problem.

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
Feb 9 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Curious Angel | last post by:
Hi, I have a version of my resume that is (almost) web ready and I'm pleased with its appearance on the screen (well, sort of heh heh, it's my first HTML). I also created a tighter, scaled-down...
3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
1
by: Sundar | last post by:
Hi, Can somebody suggest me how to print the windows form along with the controls on it using C#? I have tried exporting the form as Image and printing it, but this does not help me because...
2
by: bienwell | last post by:
Hi, I have a question about exporting data from datagrid control into Excel file in ASP.NET. On my Web page, I have a linkbutton "Export data". This link will call a Sub Function to perform...
1
by: Sandy | last post by:
Dear Pythonic People, I recently discovered SciTE (1.68) as a programming editor, and I find it just beautiful. Small, fast, elegant and beautiful. I particularly like syntax highlighting...
3
by: CatMarieS | last post by:
I have been trying to get vertical lines to work in a report using VBA code as suggested by Microsoft here: http://support.microsoft.com/kb/q151543/ (except I replaced Microsoft's default line...
2
by: Larry L | last post by:
Hi guys, been a while since I've been on the group, glad to see some regulars are still around! I've got an app that outputs a scale model plan to a printer, printing to a lettersize or a4...
0
by: aleemkhan | last post by:
I am using SQL Server 2005 Local Reports for a web based project. The problem is that the ASP.NET default Web Report Viewer does not have print facility for Local Reports. When the report is...
1
by: ambelkar | last post by:
hi , Can anybody help me in printing the Crystal report in PDF format.i.e not exporting it to PDF format.When Click preview it should be displayed in PDF format.
1
by: mailjaneen | last post by:
Hello, can someone help me. I want to display some fields on a report in print preview (i.e. instructions), that I don't want to print to the printer or export to file. I can't seem to find any...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.