data not displayed in ssrs, but there is a row showing?

Dynamics 365 for Finance and Operations/AX Developer Forum
1

I’m using RDP, when i deploy to ax 2012 no data showing?

what do you think is the problem?

Please can you help me on this? I working on this for 2 days and i always got this …

see the screen shot below.

8623.S1.jpg
8623.S1.jpg1364×768 123 KB

Thank you in advance !

2

Please help me my problem…

3

any update?

4

we faced these type of problem when we add some fields in existing report.

but after restarting AOS and SQL reporting services, it is showing result.

try to restart AOS service and SQL Reporting service.

5

Hi Naveed

I will try it again.

Tnx :slight_smile:

6

Hi Naveed!

i tried to restart the AOS and SSRS, but suddenly still no data diplayed.

7

We can’t just guess where you have the bug. First of all, debug your RDP to see whether it generates wrong data (and you have to fix it) or it’s fine and the bug is in the report itself.

8

Are you sure that the joins in your reports are working fine. I am sure that you are facing a problem with the joins Conditios!!

If you are having an error all rows will be empty.

9

Hi Mohamed.

Tnx to you… I found the problem .

Problem solve

10

Please tell us what was wrong and how you solved it. It may help people with the same problem, who will find this thread in future.

11

Hi Martin

Sorry…

I Create again a query and arrange the joining .

and that’s it.

12

Hi guys … I facing the same problem again…

it try the same solution that I’ve done before

but again I get blank rows.

here’s my code:

Select b.LEDGERVOUCHER DR_NO, c.CUSTACCOUNT as CUSTOMER_CODE, b.DELIVERYNAME NAME,

a.INVOICEDATE DR_DATE, b.CUSTGROUP CREDIT_TERM, a.ITEMID ITEM_CODE, a.NAME DESCRIPTION, i.ITEMGROUPID CATEGORY,

h.TEXTVALUE BRAND, a.QTY QTYDELIVERED, a.SALESPRICE UNIT_PRICE, (a.QTY * a.SALESPRICE) TOTAL_AMOUNT

from CUSTINVOICETRANS a

INNER JOIN CUSTINVOICEJOUR b ON a.INVOICEID = b.INVOICEID

INNER JOIN SALESTABLE c ON b.SALESID = c.SALESID

inner JOIN ECORESPRODUCT E ON

13

can you please verify my first answer as a solution :slight_smile:

14

Divide your code into 2 parts. rund the first part and see if you get results. then fire the second part and see if you get results.

If both parts are working and then your try to union them and you get no results. this means that the number of fields in both quires are not the same :slight_smile:

Make sure that both quires have the same number of outputs fields.