Thanks a lot for the help. Database has been verified and I don't have any static dates anywhere. It's wierd. It only happened when I upgraded to ver 8.5. The same reports. If I recreate the reports rather than just refresh the previous versions, they work fine. I just want to save about 2...
Thanks for the help. I am the dba and I'm running the report. This problem doesn't occur all the time, it's rather random. As a rule, I always close all the report views down to the design level, then view and refresh from the main report. It works fine about half the time, the other half of...
I don't know if this would work for you, but I use DTSToDate ({filename.DATE_TIME}) I realize it's for a date and time string, but it works with just a date string as well.
I have a report that has only two fields in the main report. There are 2 subreports attached in their own footers. The subreports refresh fine,but the main report doesn't always refresh. It usually takes three or four times of closing out the preview mode before it actually refreshes. This...
I need to set a variable in one subreport that will carry over to other subreports. I am finding that if the date field is blank in one subreport, I get garbage. I want to be able to take the Date field from one subreport and place it in a second subreport if the second subreport Date field is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.