Crystal 9.0 and Citrix ICA Client server

I developed an app to display all my old crystal 7.0 reports in a .NET platform and migrate the reports to 9.0, some of my clients work through Citrix ICA Client.

The aplication just open the report, the report viewer by itself present the parameters window, then execute the report and show it. It works good in my local clients and my dev PC. but the same app instaled in my Citrix server execute the report without ask for parameters.

I can't find any information about it, I hope somebody can help me ...

ThanxDid you use latest service pack of CR?
See if you find solution here
http://www.businessobjects.com/support/default.asp

Crystal 8.5 - Not fetching data

We currently ship our product with the required runtime files for generating and viewing Crystal Reports 8.5 on a Windows platform. These reports are called from an application which is developed in Delphi. One of our clients has recently installed our product on XP machine with sp2. Reports are getting executed and can see the preview but in the preview/print there is no data. Only can see the structure of the report, I mean all the hard coded stuff on the report but it is not fetching data from database.

Reports use ODBC to connect to database. Connection to database if fine.

BTW: It works fine on all the other machines with OS Win2k or XP. It seems this is issue is specific to machine.

What could be the cause, I am suspecting on the same machine there might be another application which is using Crystal Reports which are developed in the higher version of CR. MY question is if I forced register CR 8.5 run time files, will the reports work? and how to forced register .dlls?

Your help is greatly appreciated.

Thanks,
ktuser.If your reports were designed in lower versions than that of the reports the dlls of older version should be registered. When making Setup files, add all the required dlls so that when you install the application they will be registered

cross platform derived table query

It's like this, I have a table of searchstrings that I want to list based on unique searchstrings and unique users(because some users search for the exact same thing many times)

table tbl_savesearch
id, searchStr, remote_addr, was_answered

This is the query that works on MS SQL server, but I can't get to work in MySQL:

SELECT ss, COUNT(DISTINCT ra) AS theCount
FROM (SELECT DISTINCT searchStr AS ss, remote_addr AS ra FROM tbl_savesearch) tb
GROUP BY ss
ORDER BY theCount DESC

I checked the mysql documentation and it seems mysql needs to put in an "as" before "tb", but it still won't work.

Is there a standard for this question, some way that I can make it work on both platforms?

Edit: is this thing really called derived table or is it just a subquery? English is not my native language.A subquery in the FROM clause is usually called an "inline view" (or at least, it is in Oracle circles). Whether mySQL supports inline views at all, I don't know.