Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Thanks again.. There is where the issue lies. If I use the or statement there are too many records. BTW, I checked and out the SQL data and we should be able to pull 500K. So now i don't under stand why the report won't do it! Thanks again! FETCH FIRST 500001 ROWS ONLY
-
Hi Nathan, Thanks for the reply. I could have sworn I've pulled reports that yield results greater than 75K. I have played around with filters and removed some unnecessary columns. And now I the error referring to too many records. I know I could limit the number of records if I could just get the And statement in the…
-
Thank you so much for your quick response.. Yep.. It is possible. I should have caught my error when i typed this example. I meant to concatenate with "B" not "A".. Oh dear! End of the week blurs!! Thanks again!