Search results for query: *

Thanks, Actually; I didn't have to do anything it was automatically using namefmt 1. All I did was cd to the folder that I needed.

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

Thanks, JVZ It works great. jc

Thanks, JVZ Now, sorry for being such a newby; but what do I use to write this code and how do I run this code? Training is a very low priorty around here so I pretty much have to wing everything that I'm doing. Again sorry for being such an idiot. jc

Thanks for the reply JVZ Here is a sample of some of the data, I can't see anything wrong with it. If I pull it up in MS Excel I get 315 lines from this file that match my query, but my SQL script only imports 164 lines. The lines that are bold are the ones not being imported. Let me know if...

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

Nope, could not sort it in the sub-report either. This is going to be much more complicated than I first expected. The formula for GM is Sales-Cost/Sales. My Sales figure is pulled from invoiced detail lines, same as cost. Anyways, I really don't want the users dumping the report into Excel...

Thanks LB, Yep, the calculated gross margin is not available for a topN/group sort, but I was thinking that if I stick it into a shared variable, I hopefully can sort it in the sub-report. I havn't had a chance to look into yet, just looking for a easy way out. jc

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

Thanks, Pattycake It's working great now.

...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 (hd.[Date facture]...

How can I tell what account the CE services are running under?

Sorry that this doesn't help, but I have the same problem when ever I link to an Excel spread sheet. Again works fine in CR but using CE and eportfolio, I get either the database login error or an invalid argument error. I try not to use Excel, but the users like to do alot of stuff in it...

-k Thanks, for the reply. Yes, I'm using sql server. A couple of questions about the stored procedure method. 1st - can I pass a date parameter directly from CR to the procedure. 2nd - I can figure out how to select the data that I want but is there a way of taking one selection 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,

Perfect Thanks,

...of my script that's giving me issues. if (105+(substring([BarCode conv].[Barcode Number],1,2))+ (substring([BarCode conv].[Barcode Number],3,2)*2)+ (substring([BarCode conv].[Barcode Number],5,2)*3)+ (substring([BarCode conv].[Barcode Number],7,2)*4)+ (substring([BarCode...