Search results for query: *

Hi DanHD, If you cannot modify the table, please post a little more about your problem - is this for straight SQL or are you using in CR, and if it's a CR issue, are you using a command object or building the selection in the CR designer? Best, Chris

(a) it does seem like this forum isn't as busy as the forums were when I last frequented tek-tips (2006, I can't believe it was that long ago!!) (b) Matt gave me a quick reply the other day - he's a real gem!

Thank you Matt - I've determined that I'm working with (gasp) PowerBuilder 6 files and the bulk of the reports are .srd (?) files compiled into pbd files. Looks like this is going to be an adventure, but at least I get the pleasure of learning something new! Now I need to dig into any...

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

Thanks for the ideas! I want to get the same result as if I used the Windows save dialog and the Enteprise button. In my case, I have to put in the database password and change the output format to Acrobat. Can either of you suggest a way of automating this process? Is there a particular...

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

Hi, found the answer, and it is a silly mistake. When adding a range of values to a parameter, Crystal Reports defaults to including both ends of the range and Crystal Enterprise (e-portfolio) defaults to not including them. Thanks for your time!

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

Thanks -- actually what I'm trying to do is get all of the activites and pull the customer over from the AR record, because the activity table doesn't have the field. There are multiple records for each activity and each AR record and I've had trouble with several of the examples I've found in...

kkitt -- could you show your suggestion based on the SQL above?

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

Found the solution -- File -> Options -> Fields -> Number one machine had commas enabled and that was causing my formula to not recognize the number as a number. There was no error of any kind generated because of this in Crystal Reports 9.

It appears that I can use the global temp tables. The reason I was using MIN as a function before is because I know that there is only one customer per activity, even though there are multiple records of that single match. I could use select distinct but would also have the problem of the...

This is not the best fix, but it worked. Because some of the reports got pointed to the TFC.DSN file in a path on the T: mapped drive, I created that same mapping on the server. Now these reports work fine, but at some point it would probably be better to go back and change report data sources...

Thanks for your help -- the error I'm getting is "keyword fetch not expected" here's how I added fetch to the original post's code select DBACV_ACTIVITY, DBACV_DESCRIPTION, DBACV_BEGIN_DATE, DBACV_END_DATE, c.SHOWEND_DATE_NUMERIC, DBACV_HIGH_PST_DATE, PB.DBAJV_BRANCH AS P_BRANCH...

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

Error Message: Unable to connect: incorrect log on parameters. File C:\Program Files\Crystal Decisions\Enterprise 9\Data\procSched\DALTFCRWS1.report\~tmp12ac41e5ce78af0.rpt. On the Database Expert form, the command object I'm using shows up under Repository -> Crystal Repository -> Commands -...