Selection in filter pane

[Karahs]

Hi Everyone,

1.2.  

As per the above image:

I have two filters Document no and Cust_ledger...

In image1 if i select document no only one Cust_ledger entry no gets selected and

In image 2 if i select that same Cust_ledger entry no it gives me 3 entries of document no.

But i need to select document no and get 3 entries. How can i do that?

Thanks in advance

[yoganantha321]

Hi kshitijas,

While extracting Cust_ledger entry no from the data source kindly do query operation of group by Document no.

by using this way you achieve it easily

[Karahs]

Hi Yoganantha,

Can you explain in detail  what exactly has to be done.

Thanks in advance

[yoganantha321]

Hi Kshitijia,

you extracting the cust_ledger entry no field from any of the data source while extracting that give a statement like group by Document_no.

So that while selecting the document_no it will highlight all cust_ledger_entry_no associated with it.

Example I have given below:

LOAD document_no,

  cust_ledger_entry_no,

From data source

Group by document_no,cust_ledger_entry_no;

like this............

[Karahs]

As i am working on the DB i dont have that FROM data source line in my table.

[vinieme12]

what do you want to get 3 entries of and why?

Customer_No to Document number looks like a one to many relationship where do you want to have 3 entries?

[yoganantha321]

Hi Kshitijia,

I am sure you can achieve it by grouping but I dont know how to give the source

[Karahs]

On the selection of Document number i want 3 entries in Cust_Ledger entry no

[vinieme12]

That is what I'm trying to understand if one document relates to one customer ledger how will you get 3 possible values in customer ledger?

[Karahs]

But if you select that same Cust_legder entry no. you get 3 document entries