Ilyrian Posted February 10, 2023 Report Share Posted February 10, 2023 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: 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> 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: 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 11. On Search and Report Wizard - Configure Filtering Fields in Advance Tab chose Recieve External Parameter 12. In similar way you could pass other parameters. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.