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 的大作中提到】
: 【 以下文字转载自 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 的大作中提到】
: 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 的大作中提到】
: do you mean dynamicPDF, ABCpdf (?) etc?
:
: ,
: stream
| a9
发帖数: 21638 | 5 外部存储过程？
on
【在 i****a 的大作中提到】
: 【 以下文字转载自 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 的大作中提到】
: 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 的大作中提到】
: 有没有推荐的比较好的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 的大作中提到】
: 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 的大作中提到】
: 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.
|
|
