Search results for query: *

Thanks for your help.

Check if DataMonitor.xls is open or not; if not, open it. - Nah, I'd prefer to manually open this file and have a button located within to activate the rest of the code Check if folder "C:\Reports" is valid or not; if valid, loop through all csv files in it. - Correct Loop through all values...

Hi Zack. In answering your questions.... What is the file that contains the imported information? It is a csv file with a format: MIRN,MIRN_CHECKSUM,GAS_DAY,CONSUMPTION_HR01,CONSUMPTION_HR02,....,CONSUMPTION_HR24,TOTAL_DAILY_CONSUMPTION,TYPE_OF_READ And a file name similar to...

Basically, what I'd like to try and do is: - Have a folder (ie C:\csvReports\) where I can place the csv reports being generated each day. - Have a button within my excel model. - Each time I press the button, the csv reports that are stored within that folder are processed and the data is...

The vlookup formula that I use is: =VLOOKUP(L7,SAGAS_INTMR_ENVSA_REMCO_20060315091008.CSV!$A$1:$AC$250,28,FALSE) where: L7 = the MIRN (this will never change) SAGAS_INTMR_ENVSA_REMCO_20060315091008.CSV = the report name (this will change) $A$1:$AC$250 = the lookup range within the report (this...

OK, here goes... My model (an excel spreadsheet) is called DataMonitor.xls The format of my model is as follows: Gas_Day,Calendar_Day,ReportName,TotalSites,Actuals,Estimates,Substitutes,MIRN1,MIRN2,....MIRN194,Total Gas_Day = the date listed in the daily report Calendar_Day = the date the...

Hi, I have an excel spreadsheet (model) that contains a big table of information. Every day I populate this table with data obtained from a daily csv report. My current procedure is to open my “model” as well as the daily generated csv file – I then use a simple vlookup function to populate my...

Thanks. I entered the formula but crystal says there is an error in the formula - the keyword 'then' is missing Am I correct in saying 'then' should be placed after: If Counter < BreakPoint THEN?

I tried manually resizing the columns in preview mode and saving the report, but it still didn't wrap the text. I've now rotated the text 90 degrees and it seems to wrap ok. The problem I face now is that I'd like the text to be aligned right. However when I click the right align button, since...

The 'Can Grow' button is greyed out so I cannot select it using a cross tab. For some reason, when I select the borders of the label and manually resize, the text still does not wrap. Any other ideas????

Hi, I have set-up a basic crystal report in v10. It contains a cross-tab. In the columns along the top, some of the headings are too long for one line so I'd like them to wrap onto the next line. Does anyone know whether I can do this? Cheers.

Hi, I have developed a website that uses two frames, topFrame and mainFrame. The topFrame does not use scroll bars, whereas the mainFrame does. Within each frame, I have used a table which is centered in each frame. However, when the webpage is viewed in a browser, they do not align. I assume...

Hi, I'm developing a webpage that has two frames (topFrame and mainFrame). When I view the webpage in Firefox, the frames are non existant. However when I view it in Internet Explorer, the frame is visable in a white colour and is movable by the user. How do I prevent this from happening? I...

I am running Crystal Reports v8.5 and Enterprise v8.5, and currently have a report published online via ePortfolio. My problem is that I need to be able to export a published report from ePortfolio in the .CSV (Comma Separated Values) format, but it does not appear as an option in the Export...

what it's exporting at the moment is as follows: "abcbirkenhead","1023","1054","1032","3845

Yeah - I mean double quotes. For example, the following is contained in the report: abcbirkenhead 1023 1054 1032 3845 and I want it to export as .csv like the following: "abcbirkenhead",1023,1054,1032,3845

Hi, I'm using Crystal Reports v8.5 and need to schedule my report through Enterprise to export as .csv When I export to .csv the numbers are exporting within inverted commas as if they were a string. Does anyone know whether the export can to .csv can be done properly (ie text within inverted...

We're using an Oracle database.

This is the SQL query: Select dp.dty_id, dp.sit_id, dv.reading_date, (Select dvs.report_value from data_points dps, data_values dvs where dps.dpt_id = dvs.dpt_id and dps.dty_id = 60 and dvs.reading_date = trunc(dv.reading_date+0.74999)+0.25 and dps.sit_id = 1) HV6AM...

Kurt Is there any way I can do this myself as most people are away on holidays? SP