Search results for query: *

Hi guys, Just wondering if anyone has used ftp to transfer files from a Windows maching to a user folder? I'm sure it can't be very hard; I'm just wondering what the syntax is for getting or putting the file from a user folder instead of a library is? Thanks, JC

Hi guys, I'm using SQL 2000, and wrote a vb script to import data from a fixed width text file. if DTSSource("Col008") = "M" then DTSDestination("On Flyer") = DTSSource("Col020") DTSDestination("GST") = DTSSource("Col019") ... Main = DTSTransformStat_OK else Main =...

Hey Guys, Here's a good one, I think. I'm working with Crystal Reports 10, on a Toshiba notebook, and using a second Acer monitor. When editing and moving fields around on my reports it can only be done on the notebook screen. If I move the program onto the secondary monitor I am unable...

HI Guys, I'm using Crystal 10, on a Sql2000 database. My report group footers are sorted by store number. What I need to do is highlight the top three stores with the highest gross margin. The gross margin field is a calculated field. I was thinking of sharing some variables to a...

Hi Guys and Gals, Can anyone help me with this one? Before the lap-top goes across the room. I'm using MS-SQL-2000 databases both on the same server. select * from OMNIF_A.dbo.[Fact ventes entete] hd inner join OMNIF_A.dbo.[Fact ventes détail] dt on (hd.Facture = dt.Facture) and...

HI guys and gals, First, I'm running CR 10 and working with a SQL database. Back ground..... I have created a report that takes product information from the past 12 months and displays a bunch of sums, averages and calulated totals. The report is grouped by product number and is therefore...

Hey Guys, I'm trying to update table A with the sum of a column in table B. But the sum is by product number, not the bottom line sum. Here's what I have but the compute part isn't working for the update. The select statement works good without the update part. update [SFR Testing for...

HI guys, Here's today's problem. I'm using DTS to import data from a csv file into my SQL database. The csv file has dates in the format of MM/DD/YY. My SQL database is storing them as YYYY/MM/DD. How would I use DTS to convert the MM/DD/YY format into the correct SQL format? Thanks,

I'm sure this is a newbie question that can be easily answered. What I'm trying to do is find out if my result from a calulation based on a field in my database is above or below 10. If it's above ten do one thing if not do another. My problem is that the script does not reconize my table...

OK, I have looked around and can't find anything like what I want to do. First I'm running SQL 2000. I have created a extended SP with a DLL that is suppose to take in a UPC(number) and convert it to the symbols and such so that I can use a barcode font and print a label. My SQL table has...

I'm not sure if this would fall into the scope of this forum or not but here goes. Using eportfolio from CE10 have a reports that require the user to enter a list of products numbers that they would like to see on the report that they're producing. My problem is that for each entry they must...

Hey guys, Just noticed that when I'm using the FireFox broswer instead of IE I can't print. The popup; which FireFox automatically blocks the first time around; will not find the correct plugin so that I can print. Any one have any ideas on how to fix this? jc

Can anyone tell me what I'm doing wrong with the following code; I'm getting 'Server: Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'case'.' when I check the syntax. declare @dayofweek tinyint declare @tuesday date set @dayofweek = datepart(dw,getdate()) case @dayofweek...

Hey, Guys. How the heck do I take a date from a csv file in the format of yyyy/mm/dd and put it into a datetime field in SQL? Seems simple to me but the %*$&#* gives me an error every time.

First I am a complete newby. With that said I have a couple of questions. Here goes for the first one. I am using SQL 2000. Within the Enterprise Manager I'm trying to create a DTS package to import data from a csv file into my database tables. The date format in the csv is yyyy/mm/dd...

Hi Guys, and Gals, I may be mistaking, and maybe there is an easier way of doing this but here it is anyways. I have a report that shows dollar, sales gross margin, cost etc etc. The report works great and everyone likes but I would like to round the numbers to the nearest $1000, just to make...

Has anyone else had this problem? Using V10 Reports and Enterprise. My report has 4 groups each one I have set so that I can do a drill down and get the headers and footers of the next group. So when I do a drill down on group 4, I get all headers and footers for group 3; when I drill down...

I have a report with 12 months history for each product that I sell. In one of the columns, I would like to know the value of the inventory that I currenly have on hand. That would be contained in my last detail line. If I put in a formula to calculate the inventory into the first group...

Has anyone had this problem before, I have dates in my SQL database that read 2004/09/09 but they show up in Crystal as 2104/09/09. If I try the same report on a different computer I'm getting the correct date. I have checked my regional settings on my computer and they look fine. Is crystal...

HI guys, I'm using CR 10 to create a labeling report, which requires the user to enter a qty for the number of labels that they require. I'm using Ido's idea(great one) with the repeater table in SQL. Everything works great in CR but when I use CE 10.5 I'm getting the error 'Failed to open a...