Genetating Report [Run Time]

[reda]

my problem is how to generate my report but its InDepended of any database

im using ADO my connection string using .UDL file becoz im going to change my database from access into SQL server in the Future

if i builded my reports using access later i cant run it from SQL server so im trying to generate my reports at run time to Avoid this issue .

How i can generate Cool Looking crysta report at run time????

i did it but i cant control in my report's generated Objects??

its one of Crystal report 8.5 Samples but


something like this...

dim fld as FiledOject
dim fld2 as FiledOject

set fld=m_report.section3.addfieldobject("{ado.name}",0,0)
fld.font.size=12


How to pass Pic and How to Create tabels and lines??

[reda]

How to Quering multitabels with

tabel 1 -------> tb1
table 2 -------> tb2

mysql="select * from tb1 inner join tb2 on (tb1.pid=tb2.pid) and (tb1.sid=tb2.sid) where tb1.name='"& p_name &"';"

Issue: its repeat records in query????

I mean i got the record values twice somtimes More...

then problem how to create TMEP Query 2 use it with selectionformula and view my report;; and after viewing my report how i can Delect that Temp query;