Search results for query: *

Hi guys!! I am getting a Excel spread sheet via FTP into an specified folder. Now.....I want to take that spreadsheet in that folder manupilate it to a specific xls way to DTS it to SQL Table? Help me to take load up the spreadsheet and format it to an new spreadsheet. Information: The...

Hi guys!! Maybe I am doing something wrong here or just something small that I can't figure out. I have a view that brings back records. In my Crystal Report I want only to display the PRNumbers that is duplicated. I have tried the > "1" syntax but still get non duplicates back? In my view I...

Hi guys!! How do I load an Image in an XSL? I use the normal <img src="//IDSLogo.jpg"></img> but is shows no image in the browser/rendered view. Help me on this one please! THANKS!!

Hi Guys!! I want to develop an small application that uses a FingerPrint scanner to log time entries. For example when a worker comes in to work he scans his thumb to make an time entry into the database. What do I need? Can I use the scanner to do this or is there some other software that I...

Hi guys! I have a bit of a problem, here it is, remember I am using CR 8.5: I have a report that first group by CUSTOMER, then by INVOICENUMBER. The INVOICENUMBER has different PONumbers for that invoice. I just want to add up the amounts of the INVOICENUMBER. For example the report looks like...

Hi guys!! Need some help over here.......I am using VB 6. I have a textbox, and on that textbox I do a validation(must have 8 digits). When I type in for example "12345678" it does not save because it is longer than 8 digits. Then I have found that when I type in something it adds a space at...

Hi guys!! Is there any good software tools what I can download for free. I have tried XMLSpy and it is great but do not want to spent that amount of money for only developing small amounts of XSLT. THANKS!!

Hi guys!! Have a bit of an issue here. I have a field called QuotePrice on my report. Some of my records has let's say 4 different quote prices but I want to display it in one line, how do I do that? For example: I get this: QUOTEPRICE 1000 2350 210 6540 But want to let it look like this...

Hi guys! I have a field called mUnit_Price, how do I create another field next to it with 14% added to that field. For example I have $10 and want to add 14% to that on my next field so my new field next to that field will show $11.40. How will I do that?

Hi guys!! Me again.....need your help on a calculation problem I am having. I have many Customers with CreditAmounts. I group my Customers to give me one Customer per line. How do I calculate the CreditAmounts allocated to that Customer? For example I have 10 records selected, 4 records are...

Hi guys!! I have a problem with my SQL statement, why does it not bring back the QuoteDate specified in my WHERE clause? Can you help me please....... SELECT QUOTES.FK_sCust AS Customer, QUOTES.FK_sBranch AS BRANCH, QUOTES.dQuote_Date AS QuoteDate FROM dbo.JOBS LEFT JOIN dbo.QUOTES ON...

Hi Guys!! Need some SQL help over here..... I am referencing two databases but get a error on the OnlineOrders database? Why? Here is my SQL code: SELECT top 20 QUOTES.dQuote_Date AS QuoteDate, JOBS.dDue_Date AS DueDate, JOBS.CUST_PO_NUM AS PRNumber, OO.insertedDate AS GoodsReceivedDate FROM...

Hi guys!! I have 3 records with different Processed Dates, but with the same GLCode "100-10-52-22". These 3 records also has 3 different Amounts. How do I get all of this into one line? I have grouped ProcessesDate by Month, and want to show ONLY 1 GLCode and one Total field(want to add the...

Hi guys! How can I expand in Crystal 8.5? For example I have a TOTAL field that contains a certain amount of transactions, when I click on the total field I want to display the transactions that make up that total. I do want to do something like a drill down but it must not create a new tab on...

Hi guys!!! Need some help with this issue I have. I have an application that builds up XML files and save it in a folder on the server. The application ONLY has one button that I click to get the data, to build the XML, to save it to the server for that day it has been clicked. How can I make...

Hi guys!! How do I make a field visible false in Crystal Reports(v8.5)? For example: When I get a ProcessDate back then it must hide the DueDate AND when ProcessDate = empty I want to hide the ApprovedCost field and UNHIDE the DueDate. It is very simple logic but can't seem to get to work on...

Hi guys!! I use 2 date parameters in Crystal Reports(v8.5), but I do NOT want to show them the dates just the months. For example first parameter would be Jan 2005 and second parameter March 2005. How can I do this? Is it possible? THANKS! Shaun

Hi guys!! I have a field(GLCODE) that looks like this "Stationery - 10-00-809-52". I ONLY want to see the "00" in this field, how do I do this? I know I can do a RIGHT and then a SUBSTRING, but how do I combine it? THANKS!!!

Hi guys! Does somebody know about a tool to transform a excel sheet to an xml document? THANKS!!

Hi guys! I get my Q.FK_sCust right but why do I still get Cancelled and Closed items returned? SELECT J.iJob_Status, Q.FK_sCust FROM JOBS J LEFT JOIN QUOTES Q ON J.FK_iQuote_id = Q.PK_iQuote_id WHERE J.iJob_Status <> '1000 - Cancelled' AND J.iJob_Status <> '999 - Closed' AND (Q.FK_sCust =...