Search results for query: *

Hi I have a problem where i have a folder with number of system generated .txt files that it names 00001.txt, 00002.txt etc currently on 05473.txt. Each file has the descriptor for the file content as the first 10 characters of the firstline of said file. I am trying to use SSIS to loop...

Hi I'm either trying to over think this as I think it should be quite simple. I have 2 tables The first with an Action Table which is a list of records and date for each eg.(RecordNumber, PDate). The second table is a history table with the list of records and 6 date columns eg.(RecordNumber...

I am trying to get the entire DDL for my existing SQL Server 2005 database extracted into a .sql file is this possible? and if so is there a set SQL code to accomplish this? Thanks M

I have an Excel sheet that has 85 tabs of data that I would like updating from an oracle database. I have set up database queries on each and tested them all and they all run correctly. My problem is once I have closed and come back to the workbook at a later date, when i refresh data I get the...

I have a table that stores customer information, at present I do not store the customer title, initials and forenames as separate fields - they are stored as a single field, for example, “Mr”, “Mr & Mrs”, “Mr J” and “Mrs AD” are stored as a single field. I would like to split out this field into...

Hi, i have completed a report in Access97 and the users have asked for the detail section of the report to be striped row by row alternating from a light grey to white. I have drawn a blank on how to acheive this. I know it is possible but just cant remember how. Any help would be greatly...

Hi, I have a problem accessing reports from the OnDemand Server. I can log into the website no problem, and browse through the folders containing all the documents we have on the ODS. However, when I try to access a document I get two messages: Brio Quickview - File Error Error Opening File -...

Is there a way of hard coding the order of colums in a pivot, depending the the value returned by the result set eg. if result = 1 then column order = 12345 else if result = 2 then column order = 54321

I have a table i need to query the table holds in formation for the last year my only needs to see the infor for the last full week, eg if today is Tuesday i would need the information for last week eg the previous Sunday to Saturday. do you have any ideas?

Hi Guys, I need to get data for the FullWeek before the LastFullWeek (last but one full week if you like) is there a way of doing this or does anyone have a formula i could use. I am using Crystal 8.5 on a Sybase Adaptive Server. Date is coming from a {Datetime} field. thanks in Advance Matt

I have just upgraded from Crystal 8.0 to 8.5. And when I try to open some of my older reports in I get the TLV error. The reports that I completed in V8.0 open correctly but other reports that were created in earlier versions don't open correctly. I have about 750 Reports only 140 of them as...

I have a field in a table that is made up of 7 Digits made up to represent a date. eg. 1001212 = 12 Dec 2000 the first 3 digits are for the year but 100 = 2000, 101 = 2001 and so on. the next two are the month and the next the day I,m trying to write a formula to convert the field into a...

I,m trying to pass the Maximum Value from a Running total, to a text box to display on my report. My Formulae are as follows: //RunTotal1 // Goes in group header for Agent Screen Name (group header #2a) WhilePrintingRecords; NumberVar Sessions:=0 //RunTotal2 //goes in detail section...