RB Excel Export w/ ppDBCalc

rbuser

Hi,

We just upgraded to 12.0 Pro and have started to use the Excel "XLS Report"
export option but have found that if I used a ppDBCalc component and have
code in the onGetText event, the resultant field value is ignored and uses
the original value of the field linked in the DBCalc component.

ie DBCalc linked to field "QTY" which has a value of 5. The onGetText even
however changes the value to be 10...report shows as 10 and exports as 10 in
other exports (ie PDF) but the XLS Report shows 5.

All other exports seem to work fine and show what ever value is in the
GetText event.

Is this a bug in the XLS Report export option?

Thanks, Luke.


__________ Information from ESET NOD32 Antivirus, version of virus signature database 5185 (20100609) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

nardmoseley

To be provide high quality output, the RB XLS export devices must export the
data value, datatype, and display format separately so that the spreadsheet
cell contains the data value in the appropriate datatype (integer, currency,
datetime, etc). This is consistent with how spreadsheets work. It enables
the output to be used in further spreadsheet calculations. Exporting raw
text would be much simpler for RB to do, but provide a much lower quality
result - not acceptable to most users,

Rather than use DBCalc.OnGetText, try using DBCalc.OnPrint to update the
DBCalc.Value property. Or perhaps use the DBCalc.OnCalc event. If that is
not acceptable and you prefer to use OnGetText, then implement the
OnDrawCommandCreate event to update the aDrawCommand.Value property.




--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Thanks Nard,

I will try the onPrint event and see if that helps any.

Cheers,

Luke.

rbuser

"Luke" wrote in message news:4c16b10c@mail....
I tried the OnPrint event and it works fine for DBCalc components but just
realised its not working for DBText components.

So now im going through every report now and checking them


__________ Information from ESET NOD32 Antivirus, version of virus signature database 5273 (20100712) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com