Skip to Content
0
Former Member
Jul 26, 2010 at 06:05 PM

Multiple rows when using reference path variables

30 Views

Hi all,

Im new to using BEx query designer, this is my first post, a very simple query hope u gurus will help me out so let me explain the problem im facing;I have three charactersitcs product , complaint receive date and complaint resolve date; and there can be multiple complaints recvd on different dates against one product. Now i have to form a report in the following format:

1 to 5 days 6 to 10 days

Product

In the 1 to 5/6 to 10 days columns i have to give the count of the number of complaints resolved in that period; im using reference path variable to calculate the diff' b/w the dates but the problem is for doing that i have to take the recvd and reslvd date fields in the column section (i have kept them hidden) b/c of which i get multiple rows against a product and if i remove these dates from the selection it gives me x as the result; i just need single row for each product indicating the number of complaints which were resolved in the mentioned timeframe.

Hope im able to clearly explain my query

Please advice.

Thanx in advance

FS