I have a report that was originally set up to print as a "landscape" (paper width is longer than height) but in order to save paper, I now need to switch my report printing options use a printer orientation of "portrait".
I went into "Printer Setup" and switched the Orientation option to...
I'm using ms access to do my query.
My error says that it's "not an updateable query."
My query was:
"update products set cprice = (select tempPrice from tempTable) where catalogid > 1900"
Thanks again.
-Goalie35
I need to update the field on one of my tables with the data contained in a field on a different table. I tried doing this but I keep getting an error.
Any idea on how to do this?
Thanks.
-Goalie35
I need to create a formula that determines how many characters are in a string. If the string length is greater than 17, I need to remove all characters after the 17th and add to the string: "..."
So "Hello. How are you doing today?" would become "Hello. How are y..."
If the string length is...
My crystal reports all contain a great deal of lines and boxes to separate all of the data.
One of the bigger nuissances I've encountered in Crystal is when I'm trying to line up all of these lines properly and even though everything appears to be lined up in crystal, when I actually view the...
I'm having trouble attempting to connect to the localhosts of other machines on my company network and unfortunately, I know very little about networking.
I was able to connect to these machines a month or two ago but I now seem to have lost the ability to do so. When I try opening a web...
Thanks for the help guys.
I ultimately went with TurkBear's idea. I already knew of how to add a formula, as Dave mentioned, and while I knew that method would work, I was hoping Crystal provided a simple 1 click method of resolving this issue, which as TurkBear said, it does.
Thanks for both...
I want to set all of my running totals that have a null value to display zero on the report but I can't seem to find a way to do that. I could use the "isNull" function if I was using a formula but how could I do this with a running total field?
Thanks in advance.
-Goalie35
I have a strange javascript error on one of my company's intranet pages.
The error reads "window.document.viewreport.close is null or not an object".
The strange part about this is that only one computer in the office out of the 10 I've tried to duplicate the error on so far brings up the...
Thanks for the help so far Pattycake but unfortunately, I only explained half the problem because I felt once I resolved the issue I mentioned, the rest of my query would work fine however I'm still having a problem so perhaps I should explain the entire issue I'm having.
Recently, we added a...
i need to perform a query using 2 tables that ultimately grabs the last time a customer made a payment for one of their bills(invoices).
the first table(i'll call it tblInvoices) has all of the customer invoice #'s. now, since a customer can make several installments for their invoice, as...
I'm writing a stored procedure which involves creating a temporary table and inserting a bunch of values into it. The strange thing is, when I try to run it, I will sometimes get an error that reads:
Insert Error: Column name or number of supplied values does not match table definition.
Then...
Hi guys. I apologize if this sounds a little confusing but unfortunately, I'm not a database expert and I really need some help on this issue.
I need to retrieve about a dozen fields from various tables for a report that prints out our clients service plans however I'm not sure how to go about...
I have a particular table field name in which I need to locate each and every occurrence of throughout all of my stored procedures.
The problem however is I have over 100 stored procedures and was just wondering if there was an easier way to locate each and every occurrence of a particular...
I know you can remove leading and trailing spaces using LTrim or RTrim in a query however how would I go about removing any spaces from the middle of a string.
So, for instance, "How are you?" would become "Howareyou?".
Thanks in advance.
-Goalie35
Hi guys.
I'm writing a formula that needs to check whether the value of a summary field is null or not(ok, I'm still rather new to crystal so just to make sure I'm calling this field by its propper name, when I right click on the field, the top line reads "Field: Sum of B4DS.CreditAmount". So...
I have a report that lists all of the payments by all of our clients. If the payment is a positive amount, it means the company paid it's bill and everything's fine. If the payment is a negative number however, it means the check bounced.
Now my company wants to see the total dollar amount of...
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.