cancel
Showing results for 
Search instead for 
Did you mean: 

BPD Drill Through - Excel Template

Former Member
0 Kudos
100

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186498
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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