I ended up doing this task by creating a second (empty) table with the 2 int fields instead as nvarchar, and then was able to do an INSERT instead of the UPDATE. Perhaps not the shortest path, but at least it worked!
I'm having a similar problem. I have 3 int fields. For two of them I need to add padded zeroes. I've tried to do an update on those fields, but nothing happens. This is my SQL:
update <file>
set <fieldname>= (RIGHT(REPLICATE('0',5)+CONVERT (varchar(5),<fieldname),5))
set <fieldname>=...
I am combining a few fields with expression like ="Entered by: " & Fields!Entered_by.Value & " on " & Fields!date_entered.Value & " " & Fields!comment.Value. Sometimes the Fields contain NULL values, in which case I want to hide the text values. In Crystal I could set it as a formula with...
Found a solution here http://www.ds.uillinois.edu/Docs/HowTo_GeneralDW_ConnectwCrystal.pdf - where it gives a fairly picture of how to be sure that there is a Crystal ODBC driver installed. It worked just fine.
I'm doing something similiar for an audit. I'm getting caught on passing last month's tickets that are still open into the next month's data. My report is grouped by month of tickets opendate. I thought I'd be able to accomplish this with a running total of the <> "complete", but I'm not...
How about when the scenerio is posting from an Access database to a public folder that's a calendar? Warning - I'm a newbie, so hopefully something as clear as the above.
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.