New Menu Item Leads to SSRS Report with No Data

(0) Share

Report

Posted on by Community Member

Hi,

I needed to create a new action menu item for a report. It has to be exactly like the Pro forma confirmation menu item however it needs to print a new report.

5265.comm.PNG

To do this, I extended the FormLetterJournalPrint class to be able to handle the new version of the SalesConfirmJournalPrint class I made.

1881.form.PNG

Here it points to the CustConfirmJour table where I extended it to be able to handle a new method where it points to the ouput menu item I created.

In the picture below you can see I call the new menu item below which then calls the extended controller class SalesConfirmController

In the extended SalesConfirmController I have 2 reports, I want it to be able to choose based on if they selected the Commercial Invoice menu that I had made earlier. This is the main and below it will be the ouputReport method I also modified to help show the selected report.

5123.main.PNG

The problem is that when it goes through the "else" in the main where it picks "SalesInvoiceReport", it will show all the data since it is from the original "salesConfirmation" output menu. However when it goes through the CommercialSalesInvoiceReport and it uses the new menu I made the report ends up with empty data.

7288.data.PNG

Does anyone have any ideas why the report for the customized SalesInvoiceReport will show all the data but for the customized CommercialInvoiceReport with the new menu item will give me empty data?

Best Regards,

Paulina

I have the same question (0)

All responses (12)

Answers (1)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Paulina,

In the new report, are you sing the same DP class as in the original report? Did you try debugging the DP class to check if data is getting inserted into the temp tables?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Gunjan,

Thank you for your response. Yes I debugged the DP class, it does insert the new data into the temp tables. This is why it is weird it shows in the SalesInvoiceReport but not in the CommercialInvoiceReport when they are both customized reports.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Can you do build of your customized model and do an IISRESET?

Please try running the report again and check if the report works after these steps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It still gives me an empty report. The only time it provides me a report with actual data is when I use the original SalesConfirmation menu item, otherwise when I use my new CommercialInvoice menu item the data always shows up empty. For the CommercialInvoice menu item I duplicated the original SalesConfirmation menu item. Part of me was wondering if there would be something in the back end related to the original SalesConfirmation menu item that I missed when creating the new CommercialInvoice menu item. It is as if the temp table will pass it's data to the SalesConfirmation menu item but the temp table will not pass it's data to the new CommercialInvoice menu item.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi Paulina,

One thing I didn't notice before, in the if condition, you should use this code rather than using the label.

if(_args.menuItemName() == menuItemOutputStr()) { }

As per your screenshots, you have created one report with two designs - CommercialSalesInvoiceReport and SalesInvoiceReport. Correct? In that case they share the same dataset. Does the SalesInvoiceReport design display correct data?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sure, I will adjust the code to use the code line you posted instead :)

This is correct, I have created 1 report with 2 separate designs: CommercialSalesInvoiceReport and SalesInvoiceReport.

They do share the same dataset.

If I use the original SalesConfirmation menu item for SalesInvoiceReport or for CommercialSalesInvoiceReport the design will display correctly with the appropriate data.

However if I use the new menu item for SalesInvoiceReport or for CommercialSalesInvoiceReport the designs of both will show empty data.

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Paulina,

Rather than creating an extension of SalesConfirmController class, why don't you try creating a new Controller class for this report and check if that works? Please change the menu item object property to this new controller class and check if you are able to get any data in the report.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Gunjan,

So I created a brand new controller class from scratch CommercialInvoiceController. I still used the methods from SalesConfirmController class but did modifications. I noticed, when I printed using the new menu item, it would print out SalesConfirmReport with all the appropriate data. I believe this is because in Print Management it is set to that report even though in the CommercialInvoiceController class I am asking it to take the CommercialInvoiceReport design. I believe I have narrowed it down to the issue being in the initFormLetterReport method of the SalesConfirmController class.

My guess is the formLetterReport = FormLetterReport::construct(PrintMgmtDocumentType::SalesOrderConfirmation) is blocking the new CommercialInvoiceReport design that was made as well as it's data and forcing the SalesConfirmationReport to display instead.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi Paulina,

For now, please try commenting the code for print management in the method "initFormLetterReport". Please include this code only before the super() call and check if that helps.

formLetterReport.parmUsePrintMgmtDestinations(false);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Gunjan,

I tried as you said below,

but everytime it still shows SalesConfirmationReport witih data instead of CommercialInvoiceReport even though I set it to take the report in the "main".

I know in the print management section under Form setup of Accounts Receivable it is set to take the SalesConfirmationReport. I feel like I am missing something in the controller class for it to always decide to take SalesConfirmationReport when I am asking it to take CommercialInvoiceReport.

Was this reply helpful? Yes No