i****a 发帖数: 36252 | 1 【 以下文字转载自 Database 讨论区 】
发信人: iMaJia (iMac,iPod,iPad,i馬甲), 信区: Database
标 题: Solution suggestions?
发信站: BBS 未名空间站 (Fri Jul 9 14:22:45 2010, 美东)
Need to generate pdf files from sql data and need to name the files based on
data from a column
Ex. File001.pdf. File002.pdf.
What are the possible solutions?
I can think of using .net to call ssrs and save the files by .net code. Or
use .net and pdf writer.
Any other ideas? | c**t 发帖数: 2744 | 2 Generate pdf on the fly, there are a lot of 3rd party tools you can choose,
the file name also can be controled when your code generates respond stream
on
【在 i****a 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 【 以下文字转载自 Database 讨论区 】 : 发信人: iMaJia (iMac,iPod,iPad,i馬甲), 信区: Database : 标 题: Solution suggestions? : 发信站: BBS 未名空间站 (Fri Jul 9 14:22:45 2010, 美东) : Need to generate pdf files from sql data and need to name the files based on : data from a column : Ex. File001.pdf. File002.pdf. : What are the possible solutions? : I can think of using .net to call ssrs and save the files by .net code. Or : use .net and pdf writer.
| i****a 发帖数: 36252 | 3 do you mean dynamicPDF, ABCpdf (?) etc?
,
stream
【在 c**t 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Generate pdf on the fly, there are a lot of 3rd party tools you can choose, : the file name also can be controled when your code generates respond stream : : on
| c**t 发帖数: 2744 | 4 Yes, respond pdf stream
【在 i****a 的大作中提到】![](/moin_static193/solenoid/img/up.png) : do you mean dynamicPDF, ABCpdf (?) etc? : : , : stream
| a9 发帖数: 21638 | 5 外部存储过程?
on
【在 i****a 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 【 以下文字转载自 Database 讨论区 】 : 发信人: iMaJia (iMac,iPod,iPad,i馬甲), 信区: Database : 标 题: Solution suggestions? : 发信站: BBS 未名空间站 (Fri Jul 9 14:22:45 2010, 美东) : Need to generate pdf files from sql data and need to name the files based on : data from a column : Ex. File001.pdf. File002.pdf. : What are the possible solutions? : I can think of using .net to call ssrs and save the files by .net code. Or : use .net and pdf writer.
| M******k 发帖数: 27573 | 6 or use reporting service/crystal report, stuff like that to generate pdf | m**v 发帖数: 373 | 7 有没有推荐的比较好的pdf tool? 我最近可能也得做pdf generation
,
stream
【在 c**t 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Generate pdf on the fly, there are a lot of 3rd party tools you can choose, : the file name also can be controled when your code generates respond stream : : on
| i****a 发帖数: 36252 | 8 I used ABCpdf before. It's free and it got what I needed, basic stuff,
done. I've only used this one.
【在 m**v 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 有没有推荐的比较好的pdf tool? 我最近可能也得做pdf generation : : , : stream
| i****a 发帖数: 36252 | 9 yes I can use reporting services for report generation. but I need to save
each report, over 4000 of them, as individual files with specific file
names.
【在 M******k 的大作中提到】![](/moin_static193/solenoid/img/up.png) : or use reporting service/crystal report, stuff like that to generate pdf
| i****a 发帖数: 36252 | 10 Another possibility is to use PowerShell to call the SSRS report, and save/
rename the result file into different names. | M******k 发帖数: 27573 | 11 the web service provided by reporting service will render the report in byte
array. Then you can do whatever you want with them.
【在 i****a 的大作中提到】![](/moin_static193/solenoid/img/up.png) : yes I can use reporting services for report generation. but I need to save : each report, over 4000 of them, as individual files with specific file : names.
|
|