Search results for query: *

Check that your Web Component Server is running and also all other server components. -Rooble

Multiple APS's are just to take care of the fail over tolerance when you cluster them. ~rooble

Are you using CE 8.0 or 8.5. In either case it is possible to have multiple APS's but essentially the APS database remains only one and therefore it is possible to have SSO in that case as the security info of the users resides in the uniques APS database. Any questions let me know... Rooble

Crystal doesn't support Tables and Stored procedures together as data source to one report. So you will have to go either way. Stored proc is the best approach if the aggregation/calculation/running totals is taking too much time for the report to come as there is a performance hit with these...

Belky, You have to ensure that the data types of the parameters on the Crystal as well as the Stored Proc. are exactly the same whether it's the date type or the varchar2 type. If not then you can create formulas within Crystal to conform them to SP type. Why don't you use the stored proc...

Yes, you will have to place the .qry file and the DSN onto the client pc from where the Report is being generated. Mind it, you will hit some performance issues using the .qry file and if you have any aggregate functions/calculations then even more. Rooble

Yes, you will have to place the .qry file and the DSN onto the client pc from where the Report is being generated. Mind it, you will hit some performance issues using the .qry file and if you have any aggregate functions/calculations then even more.

what kind of datatypes does your stored proc parameter has for storing the Date Range parameter from the Crystal? Of what I know is that you can't have a data type as array that Crystal supports. Were you able to figure out what Crystal sends if the parameter is sent to the database as Date...

If you have summary/aggregate functions in your formulas, I agree with Naith that Stored Proc. would be the best way to go. I hope you can do all your calculation of formulas in there.... As for the Sub-Report it all depends what you want to achieve by inserting a Sub-Report but definitely in...