Hi all, im new in crystal reports, like always i have questions like
others,
Here is the q: I'm building a by the input the user enters the
fields can change the filters can change, sorting order can change
and so on, i can generate the tsql script,
for this project we had a bad way to use .net we actually wrote the
code in the html area, and had to use aspcomat : 'asp compatible' to
get the database connection (if didnt use that it would simply
wouldnt except the connection)
we basicly include our db functions
<!--#INCLUDE file="DbLib.aspx" -->
and
Db = Server.CreateObject("ADODB.Connection")
Db.Open(application("Conn1_ConnectionString"))
basic connection is created using adodb
and tsql was ran by using
sSQL = "SELECT * FROM table"
RS = Db.Execute(sSQL)
and results from rs
now i got the code ready in the page to get the record set where do
i go from there i'm not sure how to get results out.
others,
Here is the q: I'm building a by the input the user enters the
fields can change the filters can change, sorting order can change
and so on, i can generate the tsql script,
for this project we had a bad way to use .net we actually wrote the
code in the html area, and had to use aspcomat : 'asp compatible' to
get the database connection (if didnt use that it would simply
wouldnt except the connection)
we basicly include our db functions
<!--#INCLUDE file="DbLib.aspx" -->
and
Db = Server.CreateObject("ADODB.Connection")
Db.Open(application("Conn1_ConnectionString"))
basic connection is created using adodb
and tsql was ran by using
sSQL = "SELECT * FROM table"
RS = Db.Execute(sSQL)
and results from rs
now i got the code ready in the page to get the record set where do
i go from there i'm not sure how to get results out.