Search results for query: *

I figured that it could be done this way, just was hoping to avoid the overhead and maintenance aspects of additional sub-reports. Thanks

Hi. I have a pie chart that shows the Top N (by percentage) of certain categories. There are a number of records that have no category and I wish to exclude from the chart- but I need those records elsewhere in the report. Is there a way to do this? Thanks

Hi. We are running BOXI R2 SP1 on .NET under IIS. I want to be able to slightly customise the scheduling page- under the parameters section, instead of having an empty parameter say 'Empty', I would like it to say 'Click Here'. There are a number of resource files under Program Files\Business...

I resolved this issue. I updated the Oracle client's tnsnames.ora and it magically worked. Still do not understand why the application works when run manually.

Hi. This is a similar problem to unresolved post thread329-978428 I have written a VB application that queries an Oracle database, writes 2 reports and a text file. This app is intended to be installed on a server and run once a week. When I run the application on the server manually it runs...

You can link from one report to another by building a link from your teamMember text control somthing like this: "/folder/memberDetailReport.rox?teamMember=" & DataValue This is assuming you have a parameter in your detail report named teamMember. -Brendan

Unfortunately it is on a production server.. I'll see if we cant reboot it this weekend. Thanks...

I have an Ms 2000 access database which is being used to select and union data from 2 different datasources- one sql server, one oracle. The tables are linked using ODBC datasources. The access db is placed on a network share and used as a source for a (crystal) report. The report will not run...

I had to reinstall crystal (full version option) and it magically appeared!

I am using CR85. I have a bar chart which displays several series grouped on a date-time field. In the chart expert, under the 'order' on the Data tab, I want to display chart values for each day, but for some reason of all the choices, 'for each day' is the only one that is unavailable. (I can...

Ido, that's good to hear! What type of connection are you using- under my 'More Data Sources' choices i do not see any choices that seem to relate to IIS or logs, and I do not find the 'p2smsiis.dll' anywhere in my file system. Any suggestions? Thanks.

I am using Crystal Reports and Enterprise 8.5 running on a windows 2000 server on IIS. The CR documentation makes reference to a way of reporting from the IIS logs under the heading 'Web/IIS log files'. It basically says that CR provides translation from the log files using a dll p2smsiis.dll -...

I thought there was a way to do this, and for the limited number of names that I have, this seems to make sense. Thanks for the tip!

But I don't have the actual season in a date format, all I have is a beginning day(number) & month(string) and an ending day & month, no year. So I cannot simply compare the scheduled date to the season, it needs to be calculated somehow.

I have been scratching my head all morning over this. I am running CR 8.5 hitting an Oracle 8.1.7 db. I have created a scheduling report which brings displays a 'calendar' of jobs that are required on a regular schedule for a given time period. e.g. Job#1 is scheduled every 1 month on the 1st...

I found a way to do it. select task#, pointname, max(reading) from (select task#, n.pointname, s.reading from steps s, points p, names n where n.pointname = p.pointname and p.point# = s.point# union select task#, n.pointname, null as reading from steps s, names n) group by task#, pointname

Thanks Mufasa, but I need to select based on task#- suppose I have some more rows in the STEPS table: task# step# point# reading ... 345 1 10 0.9 345 2 I want to be able to say select n.pointname, s.reading from steps s, points p, names n where task#=123 and...

I am reporting from an oracle 8.1.7 database. I have 3 tables- steps, points and names. STEPS: task# step# point# reading 123 1 10 0.5 123 2 20 0.2 123 3 POINTS: point# pointname 10 x 20 y NAMES: pointname x y z I want a sql...

You are probably right, i should not hard code this in my view. Thanks

This is probably very simple...I need a query that will return rows of a single column with certain hard-coded names. i.e. return should look like: FRED JOHN BILL MIKE you get the idea. I want to join this query to another. Thanks