Sub queries at record level
Ok, if you can't use stored proc, then the solution of basing the report on
a stored proc is out of the question.
The alternatives are
(1) run the queries in your VB app before calling the report routine.
(2) Use UFL functions to execute multiple SQL statements. Execute method
should be able to handle any valid SQL statements, regardless whether it's a
proc or not.
Quote:
> Thanks for your help!!
> But the report has to be done before a migration from clipper to SQL
server.
> I cannot use stored procedures.
Quote:
> > You can package your SQL queries into a stored proc, and call the stored
> > proc from VB before calling the report.
> > Alternatively, you can create a UFL for Crystal report, which includes
an
> > execute method to allow SQL queries to be executed in report. This way,
> > using BeforeReadingRecords predicate, you can execute any SQL queries
inside
> > the report. Now apparently CR 9 already has this functionality built in
(to
> > allow you to execute any SQL queries inside the report).
> > > Hi,
> > > I need some help to anderstand the Crystal/VB architecture.
> > > I have to make a financial report.
> > > In this report each positions need to be revaluated at the forexrate
> > > of the actual day.
> > > To get the forexRate I need a build job that use several SQL queries.
> > > How to link this job with Crystal Reports at the records levels ?
> > > Should I use VB composant and use vb evant to do this report ?
> > > Thanks lot to any sugestion.
