Jump to content

Pass Parameter from Login Page to filter a Report


Recommended Posts

If you want to filter your DataPage Report from Authentication follow these steps:
1. In Authentication, add a Virtual Field.
2. The form Element of the Virtual Field should be Text Field
3. In the Advance tab you can pass the parameter on exit:
image.thumb.png.dbd265de3fbb4df2e4b410fa39861236.png

4. For Text Only parameters this should be sufficient to pass the value to the next form.
5. If you need to pass a Date, then you need to add this JavaScript Code to Header:
 

<link rel="stylesheet" href="//code.jquery.com/ui/1.13.1/themes/base/jquery-ui.css">
<script src="https://code.jquery.com/jquery-3.6.0.js"></script>
<script src="https://code.jquery.com/ui/1.13.1/jquery-ui.js"></script>

<script>
document.addEventListener('DataPageReady', function(event) {
    $(function() {
        $("#cbParamVirtual1").datepicker({
            dateFormat: "mm/dd/yy"
        });
    });
});

</script>

 
image.thumb.png.0ae0e9e3950f98d4453670754a55b5b3.png

6. Change the Virtual1 to the corresponding Field based on your needs, you could as well change the Date Format according to your needs.

7. The Login Page will look like this: 
image.png.9d5cd87397655c94fd9cb7cca3b732d9.png

8. In the Report DataPage, use the Authentication you just created/modified
9. Filter the result on Pre-Defined Criteria
10. Select a Date Field for your Search Fields
image.png.b33c0c017d1d48a754c4ee157ff9798b.png
11. On Search and Report Wizard - Configure Filtering Fields in Advance Tab chose Recieve External Parameter
image.png.aebed49055b1f0dca56224254378f55e.png
12. In similar way you could pass other parameters.

Link to comment
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
Reply to this topic...

×   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...