I have a very very very big problem. Anybody, please help me.
Before next week ends, we have to pass our Developed VB Application. But I had encountered a problem when trying to generate a report using a Data Environment-sourced Data Report. Data Environment would not return exact values for the query that I have excuted containg a syntax that shows a field data with values equal to Null only.
Before appending this code in the Data Environment’s Connection Command, the Data Environment works fine and return the exact details of the report basing on the SQL string that I have encoded.
“timein=Null”
But when I add it and run the Data Report that is bind to that Data Environment Query, it only show a blank report. I have tried to verify if there are really no values for Timein field equal to Null by pasting the same code to Visual Data (VB Add In). The query returns 296 records having Timein equal to Null.
Is this a limitation of Data Environment? If so, How can I fixed it?
I really need your brilliant ideas, and hope I can get soonest possible time.


Reply With Quote