Search results for query: *

Hi everyone, I have a SQL Server and Crystal Reports client that I have been developing RPTs and SQL code on a regular basis over the last several years. Today they asked me if I could integrate reports directly into their legacy PowerBuilder app (they didn't know it was PB, I just recognized...

Help!!! Is it possible (via automation) to open a report, modify parameters, then save to Crystal Enterprise (with a result similar to what would happen if using "Save As" in Crystal Reports 9 to save to the CE server). Also, I need to set the password and format of the re-saved report. Any...

Hi, My client has a master report that is used for many locations with different parameters. Is there any way to program an upload of the RPT file to update each of the parameterized reports, in the same way that you could use the Windows save dialog and the Enteprise button to save directly...

Using AS400 (DB2), the report uses a number of variables and a single sub report... Totals are fine in Crystal Reports but when put on server lots of errors with division by zero. Put formulas in to test for 0, now get lots of blank forumlas... Any thoughts?

Hi, Using Crystal Reports 9.0, I have fields which are SUMs added with the SUM button, and I need to divide one sum by another one ... is there anyway to do this in a formula? ??

In CE9, how can I directly add PDF files to the list of reports for a given folder? I have a few extremely complex reports that I can easily extract the sections of pages from the report to give to a specifc folder as the folders follow the branch separation of my client. Or if not, can...

Is there any way to force the first row retrieved in a subquery to be returned? I am dealing with a large table and when I use MAX or MIN to limit the subquery to one record, the response is very slow. Is there a way to have the query respond immediately on the first match? Here's my SQL --...

Hi, I have a command object that looks something like: SELECT * FROM lawdbf7.JB242_V where showend_date_numeric < dbglt_posting_date and left(digits(dbglt_account),3) = '014' and dbglt_fiscal_year ={?FISCAL_YEAR} and dbglt_acct_period = {?PERIOD} --------------- Then I have a formula that...

Hi -- I have a couple of reports that work fine in the Windows client using command objects. However, all of the other web-based reports share a DSN file; I can't seem to get my settings right in the management console with this command object. I'm trying to access this data via a command...

Hi -- A report for customizations in Lawson takes hours to run. On closer inspection, it appears that in addition to formulas that need to be rewritten, the query itself is very slow. The generated SQL looks like: SELECT DBACACV.DBACV_DESCRIPTION, DBACACV.DBACV_BILLABLE_FLAG...

I am trying to reduce the overhead of things like Apache that I don't even use, but I need to have a server and client install on a laptop. When I unchecked items, they popped back up and installed anyway... HELP! Chris Larkin chrislarkin@yahoo. com