Sending SSRS Report as excel file to multiple users

(0) Share

Report

Posted on by nithinkumar_007

152

In the above the screenshot if you select the record(circled in red) and click on Send Mail button highlighted in yellow color, it will send the SSRS report to the mail id in the primary contact.

This work only if i select one record, if we select multiple records and click on send Mail, it will send mail to the last selected record.

My requirement is when I select multiple records and click on send mail it should them the corresponding ssrs report to the corresponding contact.

How can I achieve this?

Thanks,

Nithin.

I have the same question (0)

All responses (4)

Answers (1)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Nithin,

Is this an adjusted form that you shared above in your screenprint?

Did you create the SSRS report or do you refer to a standard one?

Best regards,

Ludwig

Was this reply helpful? Yes No
nithinkumar_007 152 on at

Like (0)

Report

Hi Ludwig,

I created everything from scratch including the form and ssrs report.

Thanks,

Nithin.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

If it is sending email only to the last record then its a bug in your code. You have to loop through records and call report run logic and email send logic with in that loop

Was this reply helpful? Yes No
Verified answer

Pedro Tornich 955 on at

Like (0)

Report
Hello,

You will have to account for multiple selected records in your class.

There is a helper class named MultiSelectionHelper, you can check the method main() from the LedgerJournalSave class for an example:

public static void main(Args args) { LedgerJournalSave ledgerJournalSave; switch (args.dataset()) { case tableNum(LedgerJournalTable): ledgerJournalSave = LedgerJournalSave::newLedgerJournalTable(args.record()); break; case tableNum(LedgerJournalTrans): ledgerJournalSave = LedgerJournalSave::newLedgerJournalTrans(args.record()); if (SysCountryRegionCode::isLegalEntityInCountryRegion(#easternEuropeAllandRU)) { MultiSelectionHelper helper = MultiSelectionHelper::createFromCaller(args.caller()); LedgerJournalTrans localLedgerJournalTrans = helper.getFirst(); if (localLedgerJournalTrans) { List localRecIds = new List(Types::Int64); while (localLedgerJournalTrans) { localRecIds.addEnd(localLedgerJournalTrans.RecId); localLedgerJournalTrans = helper.getNext(); } ledgerJournalSave.parmMarkedTransactionsRecIdList(localRecIds); } } break; default: throw error("@SYS18626"); } if (ledgerJournalSave.prompt) { ledgerJournalSave.runOperation(); } }

Was this reply helpful? Yes No