Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > General

Lost Password?

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 03-08-2016, 06:48 AM
FreakaZoid2 FreakaZoid2 is offline
Senior Member
 
Join Date: Jul 2009
Posts: 362
Default fast report 5 and dynamic query

Is there any way to create a fast report with a query that is not open/active.
so depending on user options/selection the single query gets changed
select * from tableA
or
select * from TableB

depending on user selection it loads a different fr3 file. but i didn't want to have to set the database connection to open and make the query active for every combination. so is there a way to just add the fields that i know will be on the report bands without having to connect every thing first?

NOTE: I add/change the field aliases for the frxdbdataset. By adding MY_FIELD=MY_FIELD and all the rest of the fields I know will be on the report then it will allow me to create the report as if the dataset was connected and active.

Last edited by FreakaZoid2; 03-08-2016 at 03:13 PM.
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT. The time now is 09:43 PM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.