Search results for query: *

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 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...

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...

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...

For each column name in a sql server table, there are a list of column properties. One of these properties is the "description" property. I need to somehow retrieve the contents of this description and display it on a web page. Does anyone know how I can go about doing this or know of a...

I have a query that should diplay the 3 top selling items from a particular product category(i.e: Clothes, Hats, Shoes, etc). I'm joining 2 tables to gather all of the necessary information however more than 3 rows are being returned for some strange reason. I'm selecting the product ID...

I have an asp application that needs to check whether or not an ms access table "insert" statement was successful. If the new table row was successfully added, I need to inform the user of this. If it wasn't successful however, I need to halt all further execution of my code. Does anyone know...

I need to create an application for a client that spiders specific sites for magazine images. Does anyone know of a website that explains how to create this type of software? Thanks. -Goalie35

I need to create a web bot for a client of ours but the problem is I don't even know where to begin looking. Essentially, I need to create an asp.net(or asp 3.0) application that searches the internet for magazine cover images. Does anyone know how I can go about finding information on this...

I'm uploading an entire asp.net project to my server for the 1st time and I thought I had everything set up properly but I'm getting an error when I try to access the page. Can you please check out this page and perhaps point me in the right direction as to how I can fix this...