nardmoseley
Comments
-
You can manually edit the SQL to specify that SQL text.
What issue are you encountering? What is the environment: Delphi version,
ReportBuilder version, database engine, data access components, etc.
--
Nard Moseley<… -
MagicSQL is the default linking type.
If a QueryDataView has manually edited SQL text or is linked to a master
QueryDataView with manually edited SQL text, then MagicSQL is not available
and the default linking type is P… -
Creating new DADE plug-ins is not difficult. All of the DADE plug-ins are
very similar, I recommend picking an existing DADE plug-in as a starting
point. You can either use one of the plug-ins included with RB, such as
daADO.… -
The RB Data workspace (DADE) currently supports parameterized query linking
for the SQL where clause. So that will not work for a stored proc call.
You might consider creating a custom dataview template. For an examples … -
I made the same mods here so that AutoSearchCriteriaByName or
AutoSearchFieldByName will check for the FieldAlias or FieldName. That will
be included going forward.
-
Nard Moseley
Digital Metaphors
www.dig… -
Use Report.Parameters['ParamName'] to access and set the values.
Thanks for pointing that out, will put that on the list to be improved.
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
-
Thanks for the kind words!
Parameterized dataset linking is a feature of VCL and the data access
components. … -
RB 11 introduced a number of new enhancements for Parameters, AutoSearch,
and DADE, include the ability to perform data linking with manually edit SQL
and to reference report parameters from manually edited SQL.
You can probab… -
All linking uses the '=' operator, whether MagicSQL or ParamterizedSQL or
ManualSQL.
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
-
This is a limitation - I added this to the list of requested enhancements.
One alternative is to use the manual rather than the parameterized SQL
option.
-
Nard Moseley
Digital Metaphors
www.dig… -
Paul,
Thanks for the feedback. We'll look into adding this for the next major
release. If the tables are re-ordered, then all the join conditions have to
be analyzed and re-defined.
Best regards,
-
N… -
For future reference...
1. Please do not post attachments to the newsgroup.
Attachments may be sen… -
Thanks for the feedback, I will add this to the requested feature list.
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
-
1. Here is a link to an rbWiki with Report Parameters Fundamentals
http://www.digital-metaphors.com/rbWiki/End-User… -
David,
Here are the steps:
1. From the Design workspace, define a Report.Parameters[ ] item, let's
call it paCustNo
2. From the Query Designer, define a DADE query with a search condition on
the paramte… -
There is no conceptual problem.
The Query Designer is used to create/edit a SQL query. When the user presses … -
Create a group in the subreport on MessageID. Add TppVariables to the
GroupFooter. By pressing the right mouse button over a variable and
selecting the Timing... menu option you can configure the Variable to reset
the totals whe… -
Due to timing, you need to set
Report.Engine.Page.PrinterSetup.PaperHeight
However, this property is not available to RAP. To set this property via RAP
you will need to code a pass-through function that passes … -
We are not aware of a way to do this. Perhaps contact support@waler.com
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
-
The RAP global OnCreate and OnDestroy are going to fire differently when
you preview from the ReportDesigner than when you preview from the
preview form. There is going to be a difference in timing.
If you would like to c… -
Thanks for the feedback, we can investigate whether this is feasible for a
future release.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.… -
Sorry, but we do not have anything available that you can browse, it is on
our 'to do' list for the future...
--
Nard Moseley
Digital Metaphors
http://www… -
1. RB's built-in AutoSearch feature and EditSQLAsText are NOT compatible.
See the article below for more details about this. If you try this in the
Data workspace, you will see that once you edit the SQL text, the options to
mai… -
-
Thanks for the suggestion. It is something that we can consider for the
longer term future. As momentum moves towards the .Net platform we need to
investigate the possibility of supporting VB .Net or C# .
--
Nar… -
Due to the timing of the Report.BeforePrint you have to set
Report.Engine.Page.PrinterSetup
--
Nard Moseley
Digital Metaphors
http://www.digit… -
Run the RBuilder\Demos\Reports\Demo.dpr project and select the "Events"
category. Demos 141 thru 147 visually show various events as they are being
generated. You can easily adapt the techniques shown here to create your own
"ev… -
1. You could try setting Report.CachePages to true. However you may still
encounter issues, due to the events you are using.
2. An Alternative approach:
Try modifying the global variables from floats to references to… -
-------------------------------------------------------
Tech Tip: Printing a Unique Caption for each copy of
of a multi-copy report sent to the printer.
-------------------------------------------------------