BPD Drill Through - Excel Template

[Former Member]

Hello,

We have recently set up drill through to our accouting software via SQL and when it returns the data to Excel (in a seaprate worksheet), the formatting is very plain and simple. Is there any way of amending the 'template' so that it display things like commas for number formats, etc.

Thanks,

Jeff

[former_member186498]

Hi Jeff,

I don't think that's possible to prepare/modify the worksheet, but if you need you can create a worksheet template with the formatting columns and copy and past only the value on it after the drill through.

Kind regards

Roberto

[Former Member]

Hi Roberto,

Thanks for your suggestion. It would work if users were to only do a drill through for a few tiems but they are likely to do multiple drills each time. It's a shame because all of the data is right-justified and makes it a bit odd to read.

Regards,

Jeff

[former_member186498]

Hi Jeff,

yes it's true, some features like the system report are very spartan. With a little effort you can prepare the right worksheet for the drill through so that the user can copy and past only the format from this "template".

Kind regards

Roberto

Edited by: Roberto Vidotti on Jan 24, 2012 2:03 PM

Edited by: Roberto Vidotti on Jan 24, 2012 2:04 PM