drewex
01-25-2005, 12:31 PM
Hi all, I'm having difficult time deciding now,
I’m trying to get a custom report that the fields that are show that can change the filter options can change, probably in time I’m and the full sql statement is going to change to a joined query too.
My previous post was http://www.webdeveloper.com/forum/showthread.php?s=&threadid=54614
but i had to change it a lot so i created a new post, :( ;)
I use basic adodb connection to get the data
Db = Server.CreateObject("ADODB.Connection")
Db.Open(application("Conn1_ConnectionString"))
basic connection is created using adodb
and tsql was ran by using
sSQL = "SELECT field1, field3, field9 FROM table where blah blah"
RS = Db.Execute(sSQL)
ok
now here is the question should I use crystal reports (if so how can I get the crystal report working and how do I handle field changes)or should I write the whole thing by my self(if so I need ideas how I should do the paging the reports)
And by the way there are around 25 fields that I must be able to show in the report so it has to grow horizontally (or some way that can be suggested)
Please i do need help on upcoming few days, i have decide which way to go on this, Thanks a lot in advance (at least for reading it)
I’m trying to get a custom report that the fields that are show that can change the filter options can change, probably in time I’m and the full sql statement is going to change to a joined query too.
My previous post was http://www.webdeveloper.com/forum/showthread.php?s=&threadid=54614
but i had to change it a lot so i created a new post, :( ;)
I use basic adodb connection to get the data
Db = Server.CreateObject("ADODB.Connection")
Db.Open(application("Conn1_ConnectionString"))
basic connection is created using adodb
and tsql was ran by using
sSQL = "SELECT field1, field3, field9 FROM table where blah blah"
RS = Db.Execute(sSQL)
ok
now here is the question should I use crystal reports (if so how can I get the crystal report working and how do I handle field changes)or should I write the whole thing by my self(if so I need ideas how I should do the paging the reports)
And by the way there are around 25 fields that I must be able to show in the report so it has to grow horizontally (or some way that can be suggested)
Please i do need help on upcoming few days, i have decide which way to go on this, Thanks a lot in advance (at least for reading it)