09-17-2017 06:11 AM - edited 03-14-2019 05:35 PM
I'm creating a Custom CUIC report using awdb datasource in UCCE. This report has two datetime and 1 string input parameters. If I give Start Date Time, End Date Time and ANI(String) as Input parameters, I'm getting 0 records. but If I copy paste the SQL query of the CUIC output in Direct Database(AWDB), I'm getting data. I have verified Datasource of the report definition and it is pointing to AWDB only. I'm not able to figure out the place where i'm missing. What are the posibilities of this issue?
Solved! Go to Solution.
09-18-2017 11:45 AM
Eliminate some of the fields as being a problem. Make it so that only ANI is entered when the report is run and the Date fields for instance are hard coded in your report definition (or vice versa). If that works, for instance, you know it likely has something to do with the data type you have selected. Also validate that the SQL server CUIC is using is the same one you're running the query against.
09-18-2017 11:45 AM
Eliminate some of the fields as being a problem. Make it so that only ANI is entered when the report is run and the Date fields for instance are hard coded in your report definition (or vice versa). If that works, for instance, you know it likely has something to do with the data type you have selected. Also validate that the SQL server CUIC is using is the same one you're running the query against.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide