| Author |
Message |
    
Kushi_ram
Vooriki Bewarse
Username: Kushi_ram
Post Number: 4669
Registered: 04-2004
Posted From: 192.62.193.123
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 1:08 pm: |    |
AW babai take the fields which the user wants to see on the screen. Using that fields form a dynamic query at runtime and populate the dataset.
Then assign the dataset to a hidden crystal report on the form. Finally Export the crystal report using the API provided by Crystal.
Chala simple ga aipothundi with less code. |
Kushi_ram
Vooriki Bewarse
Username: Kushi_ram
Post Number: 4668
Registered: 04-2004
Posted From: 192.62.193.123
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 1:06 pm: | |
http://blogs.wwwcoder.com/mustafaf/archive/2005/03 /04/2125.aspx
AW Mama Pandaga chesuko |
Andhrawala
Vooriki Bewarse
Username: Andhrawala
Post Number: 5341
Registered: 03-2004
Posted From: 192.58.204.226
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 1:06 pm: | |
>>AW yenkama, Crystal report can be exported to a PDF or excel format..try cheyyi..infact it also provides API for doing this..
Crystal lo vundhi mama. adhi thelusu. Data eda peda grouping sesi vallaki kavaalsina format lo sesi dobbenu. so adhi ippudu workout avvadhu.
Probably I can create another spreadsheet with all the columns and use it.
Thanks babailu for the help.
I will try the Miscrosoft site stuff |
Kushi_ram
Vooriki Bewarse
Username: Kushi_ram
Post Number: 4667
Registered: 04-2004
Posted From: 192.62.193.123
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 1:05 pm: | |
aggu manodiki source code techi pedtha.. |
Sollu
Vooriki Bewarse
Username: Sollu
Post Number: 4947
Registered: 03-2004
Posted From: 144.160.130.16
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:56 pm: | |
KIKIKI KR babai nijame kada?
AW babai edo property set cheyyali to export the data ani gurthu...try seyyi |
Kushi_ram
Vooriki Bewarse
Username: Kushi_ram
Post Number: 4665
Registered: 04-2004
Posted From: 192.62.193.123
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:50 pm: | |
AW yenkama, Crystal report can be exported to a PDF or excel format..try cheyyi..infact it also provides API for doing this.. |
Kushi_ram
Vooriki Bewarse
Username: Kushi_ram
Post Number: 4664
Registered: 04-2004
Posted From: 192.62.193.123
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:49 pm: | |
http://msdn.microsoft.com/library/en-us/dno2k3ta/h tml/odc_Office2003ADONet.asp?frame=true
aw mama paina link lo examples kuda unnayi. |
Andhrawala
Vooriki Bewarse
Username: Andhrawala
Post Number: 5340
Registered: 03-2004
Posted From: 192.58.204.226
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:48 pm: | |
SQL Server vundadhu mama.
Oka search screen vundhi. Report ki formatted Crystal report chesemu.
Inka konni custom reports sesukotaaniki Excel lo dump adigedu of all the fields for the filtered data.
|
Sollu
Vooriki Bewarse
Username: Sollu
Post Number: 4946
Registered: 03-2004
Posted From: 144.160.130.16
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:41 pm: | |
ippudu thadu antha sadiva....just oracle nunchi one time excell conversion kavala?
ala ayina kuda sql server unte u can write a dts connecting oracle db as ur source and excell file as target...... |
Kushi_ram
Vooriki Bewarse
Username: Kushi_ram
Post Number: 4663
Registered: 04-2004
Posted From: 192.62.193.123
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:41 pm: | |
Mama sollu mama chepindhi chesthe you have to consider the issue in my post number 4661. Ikkada koncham careful ga implement cheyyali ENDUKANTE Web application kada. |
Kushi_ram
Vooriki Bewarse
Username: Kushi_ram
Post Number: 4662
Registered: 04-2004
Posted From: 192.62.193.123
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:40 pm: | |
ya ..then you have to write it to a file row by row in your .NET Code. |
Sollu
Vooriki Bewarse
Username: Sollu
Post Number: 4945
Registered: 03-2004
Posted From: 144.160.130.16
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:40 pm: | |
manam seppukunnadi work kaleda babai?
datareader badulu dataset loki lakkuni foreach loop vesi response.out seyyi babai work avvali
ofcourse datareader is faster. ayina datareader nunchi read chesthu output kuda cheyyochu kada? |
Andhrawala
Vooriki Bewarse
Username: Andhrawala
Post Number: 5339
Registered: 03-2004
Posted From: 192.58.204.226
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:35 pm: | |
Kushi babai,
It is Oracle database.
DTS is for SQLServer kadhaa.
|
Kushi_ram
Vooriki Bewarse
Username: Kushi_ram
Post Number: 4661
Registered: 04-2004
Posted From: 192.62.193.123
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:34 pm: | |
Babai Response object antunnavu is it synchronous operation..IF so is the data you want to export to excel is huge or small.
There might be some timeout errors cos IIS will time out the request... |
Kushi_ram
Vooriki Bewarse
Username: Kushi_ram
Post Number: 4660
Registered: 04-2004
Posted From: 192.62.193.123
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:32 pm: | |
DTS package also exposeD through a .Net Assembly..undu assembly name cheptha.. |
Kushi_ram
Vooriki Bewarse
Username: Kushi_ram
Post Number: 4659
Registered: 04-2004
Posted From: 192.62.193.123
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:32 pm: | |
USE DTS Package... |
Andhrawala
Vooriki Bewarse
Username: Andhrawala
Post Number: 5338
Registered: 03-2004
Posted From: 192.58.204.226
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:25 pm: | |
Inka dorakaledhu |
Sollu
Vooriki Bewarse
Username: Sollu
Post Number: 4943
Registered: 03-2004
Posted From: 144.160.130.16
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:24 pm: | |
dorakaleda babai? leka thadu esthu nannu adigara? |
Andhrawala
Vooriki Bewarse
Username: Andhrawala
Post Number: 5336
Registered: 03-2004
Posted From: 192.58.204.226
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 08, 2005 - 12:13 pm: | |
from Datareader to Excel through Response object
I need to export data retrieved from a query to excel.
using asp.net and VB.
Any help is appreciated. |
