How can I print a report using VBA?

(0) Share

Report

Posted on by Community Member

I would like to print a report using VBA. I'm trying to override a button on a third party form/window. I am able to pop up a message in the event handler using VBA. I can't find any examples of how to print a report. I'm aware that sanScript has a run report command but I can't find an equivalent for VBA. I'm aware of the pass through concept but the readings I've done indicate this isn't an approach that is supported by Microsoft.

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (2)

waseem 230 on at

Like (0)

Report

GP report or external report like(Crystal) ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

GP Report.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

You cannot use vba to print gp reports. Sanscript could do it, but still really tricky. I usually build reports outside of GP (SSRS).

Was this reply helpful? Yes No
waseem 230 on at

Like (0)

Report

i will also recommend to use Crystal report or SSRS.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Can you provide more details around sanScript being tricky. The report already exists as a GP report and recreating it with another tool isn't an option.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

You would need a dexterity developer to create a chunk: put a sanscript trigger on the button, and the trigger will make the call to the dex report. it would need to load whatever temp tables it needs, when making the "run report" call. Your gp vendor should be able to hook you up with a dex developer. SSRS developers are more plentiful than dex developers, fyi.

Was this reply helpful? Yes No
Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

may I know which GP report you are trying to call?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I thought this was the direction I would have to go in. I'm a new dex developer and capable of making the changes. It just seems like a hack. As for SSRS, as I said before, it's not an option. I need to print an existing report that is part of a third party solution with a great deal of SanScript logic.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

That should work, but if you can't get that to work, here is another idea: put a trigger on the button, then call your own dex report. build a sproc then feed that data into your dex report. if you are ok with rolling your own dex code, this could work as well.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The customer gave the green light on the project and when I tried prototyping it I discovered that the button I want to register to is a local field. I was able to find a public button and was able to register to that. I'm assuming then that the fields have to be public?

Was this reply helpful? Yes No