Jump to content
  • 0
EilisD

Same record returned multiple times in report

Question

I have a separate search datapage and report datapage, the search has three listboxes which a user can choose an option from (only the first listbox is required the other two are optional). 

I have embedded the datapages on the same web page and each time I choose either one or all of the three listbox options the resulting records are repeated three times in the report.

Can anyone advise on why this might be happening? I have tried having just one filter on the report datapage but the records are still shown three times.

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 1

Hi,

I suppose you need to check condition when you receive a parameter in the predefined criteria on the Configure Filtering Fields of the report (advanced tab) 

Try using If empty, ignore criteria  option. It means if you leave this field blank, you will get all the values on report in that field. But if you enter value in that field, you will get only records containing entered value. 

Also you may check comparison type (on the standard tab). Try using 'equal' or 'contains'. If you select equal - you should enter full value in the search field to find it in the report. If you select contains - you will get values even if you enter the value partly. E.g. if you have John in the field, you may enter Jo and you will get all the values containing  Jo in the field.

 

Please feel free to ask if something is not clear enough.

 

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...