rbuser
Comments
-
if you are using a SQLDataset or SQLQuery you could attach them to a
TDataProvider and a TClientDataset
and try that
-
Thanks Nard.
What I can't undertstand is why would one connectivety driver give the error
and another one did not. I suppose the ODBC text driver treats
"" differently to the JET driver. That is the text driver treats "" as "" as
Some more info...
I found some code on the web that replaces the int 3 in ntdll with nops and
the problem seems to gave gone.
(http://www.howtodothings…Nico:
I got it to work. Thanks for your help.
Anyone interested, this is the final version. This only returns the
first (and in my case only) instance of a subreport, so with multiple
subreports this would have to…Nico:
Thanks for the example, I'm having trouble getting it to work. I may be
showing my lack of knowledge about oop.
I get an error message that TppComponent and TppChildReport are
incompatible.
functio…Nard,
That was very usefull, now I've discovered that the error was caused by
dataset related code, and it has nothing to do with RB.
Thanks
Mocte
Nico,
Always happy to help.
--
---------------------------------------
Terry Swiers
Millennium Software, LLC
http://www.1000years.com
Check the ShowComponents property of the Designer component. If any of
components are set to False, then you may be running into the same issue
that I was running into with RB9. Change them all to True and see if the
…Hi Nico,
Thanks for replying.
When I went and chose a data pipeline in the report in the way you
described, it started working OK.
I did have ppReport1.Datapipeline assigned to the data pipeline in question
but this …I need to change SQL of various pipelines like this...
old SQL : Select * from Customer INNER JOIN Banks ON Customers.CodBank =
Bank.Cod ...
new SQL : Select * from Customer INNER JOIN Articles ON ...... ( I need
Hi
I have tested DBPipelines with the RXMemoryData, instead of using JITPipelines. This works well, so problem solved. The reason I had not done this before is that I could not see a way of creating a link between the master and detail …I resolve this with code below:
var
Comando_SQL: TdaSQLBuilder;
begin
Comando_SQL := TdaSQLBuilder.Create(ppReport1.DataPipeline.SQL);
Query1.SQL.Text:=Comando_Sql.SQL.GetMagicSQLText;
end;
OK
Made some progress here.
Question:
1. So, I have a JITPipeline that has defined fields, and appears to be
correctly decoding the BLOB.
How do I now SURFACE this pipeline such that it will showup in the DADE as a
pr…Found it. Seems only available thru the DBPipeline, and not the ppFIeld
list.
Hi Nico,
Okay, I created the tables, and checked in Enterprise Manager that they
actually existed.
I built and ran the demo. When I pressed the Launch button I got the
following error:
Error: FolderPipeline: 'pF…Hi Nico,
Thank you. I think I've got it; the tables are part of the Report Explorer.
I actually have read the pdf, and I've been running some of the demos, but
this one took me by surprise since it required me to create table…Hi Nico,
Thank you. I actually browsed to the directory in Delphi, and ran it,
totally
missing the ReadMe.doc file. I'm confused though. It talks about creating
tables
in Northwind. Since Northwind already has 12…I see. However, for some reason I cannot join a detail pipeline to a
master pipeline that is sorted by a calc field.
Hi Nico
I sent the code to the email address below. I have been able to get the
report to display correctly in the report designer but still when I run the
report, the first record prints out the entire detail. After the first
ma…Hi Nico
I created the masterfield links like the code you provided and the first
record still prints all the detail dataset while all the other records print
correctly.
Could it be something with the query component, I am using. …Hi Nico
I currently have a subreport place in the detail band. The subreport is
connected to the detail dataset. The data is traversing correctly except for
the very first record. The first record prints out the entire detail datset.<…Hi Nico
Thanks for the response.
I thought or think that I have it set up this way
My master query is select * from table where report_type='TT' order by
territory,report_type My detail query is select * from table whereHi Nico,
Thanks. That helps. Now to figure out how to do the Vertical lines for
each of the columns. I currently have the Verticals streching within
the Detail band. I'm not familiar with 'drawing' programmatically withAnd Just to add to the last message
I have no master detail links set up on any Dataset's in my Datamodule, I
intended for RB to do that for me.
Regards
Hi Nico,
Yes it does occur with other printers but not all. It was first
reported to me by our customer who was printing to a dot matrix, but it
works ok on their laser. I initially put it down to their printer dri…Hi Nico,
I have commented out the event code with the exception of the
LotPipeLineFirst which is needed to perform the Master detail linking
manually.
The report still has the same problem. Previews ok, then prints …Hi Nico,
I am using Pervasive SQL.
The index on the detail pipeline has 3 fields, idHeader, MachineId,
SerialNo.
I am linking by the primary field only.
The second two fields in the key are for retrie…Nico,
I checked this and the dataset's are ordered on the linking field.
I since modified the code so that i no longer use the MasterDataPipeline and
linking fields, instead i have a unlinked pipeline and use Locate in the <…Thanks Nico
Thanks Nico,
Is there anything else that I might need to know regarding this?