Search results for query: *

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

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

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

Hi, I have developed a SQL statement using Crystal SQL Designer. I need to use this new query within an existing report, hence joining the new SQL table to existing tables (using the same table headings). However when I try to do this Crystal crashes. Is this possible to achieve or am I wasting...

Hi, Is it possible to develop a report using both a Crystal SQL Query as well as a database with various tables? This is the first time I have used a Crystal SQL Query but I cannot use it in my original report which uses tables from an Oracle database. Can anyone step me in the right...

Hi, I have data constantly entering our database every 10 minutes. I have set-up a report that enables the user to select data for a customer to display either Hourly, Daily or Monthly parameter data. I have set-up 3 simple cross tabs in 3 seperate headers (supressing the ones that are not...

Hi, I'm not sure if anyone is going to be able to help me but here goes: Our database is constantly being updated with data every 30 minutes. We also publish our reports using Crystal Enterprise. I have written a simple report that checks whether data has registered against a certain site...

Hi, Is it possible to supress 1 column in a crosstab? I have created 2 crosstabs which display different info. However, all the data that is being called through the selection expert is appearing in both crosstabs. If it is not related to one of the crosstabs, it appears in a column but with...

Hi, I have a basic report where the 'details' section contains 10 minutely data (this section is supressed). I have inserted a group header that groups it into daily data. What I need to do is display the 'maximum' daily figure over the period. Is this possible using Crystal 8.5? Ideally I'd...

I have a report that includes the following in the selection criteria: {DATA_VALUES.READING_DATE} > DateTimeValue({?Start Gas Day},Time(06,00,00)) and if (DateDiff (&quot;d&quot;,{?Start Gas Day} ,{?End Gas Day} ) > 92) then {DATA_VALUES.READING_DATE}<= DateTimeValue({?Start Gas...

Hi, I have created a projector where the movie properties are set to 800x600pixels. I need to increase the size to 1024x768 pixels. The reason for this is because I have converted this projector file into a screensaver and I currently have the monitor settings at 1024x768. Is there a way I can...

Hi, I have a report that displays data for every ten minutes over a 24 hour period. I have 2 group headers, one which groups it by 'hour' and the other to group it by 'site name'. I have suppressed the details section and I have hidden the header which groups it by hour so that the user can...

Hi, I have a database that is automatically updated daily with data sent via telemetry from all our customer sites. I have written a crystal report that has a simple cross-tab listing the &quot;customer name&quot; (column) and the &quot;gas consumption&quot; (row) for a particular day. However...