Search results for query: *

Are there any system tables in InterBase that would give me information about the database itself? I'm looking for something that would help me return data that I can incorporate into a report that would identify the database to the reader. I'm thinking the best thing would be database...

Thanks for the responses. I think that the error handling seems like the best approach. We'll give it a try.

In a stored procedure, we are converting a char field to a numeric. Before conversion, I want to check to see if the field can be converted. Is there a way in Interbase to check this? Maybe something like the "is null" test?

I've got that a little wrong above, in my haste I combined my table aliasing into the table name. Also, below I give an alternative solution. The one from above should be: select t1.customer, (select t2.city from table as t2 where year(t2.date) = year(currentdate) and t2.customer =...

I haven't worked it all out as I would normally do this sort of thing with a sproc, but you say you don't have the authority to do so. So instead of that, use "Add Command to Report" and create a SQL query (not sure if you are using that for data retrieval now or if you are using the...

ali1227, I think the issue here is that in versions prior to 9, you can't use a SQL command. If you use 9 or above, you can use "Add Command" to input your SQL expression. Since you are using 8.5, you need to to do the work prior to Crystal. synapsevampire suggested a stored procedure or a...

Not sure about CRXI, but in CR9 after you preview a report, choose Report, Performance Information and you can see information about various aspects of the report and runtime.

You need to use unique aliases for each table in the subselect, so that they are distinguishable from the ones in the select. That is, (SELECT COUNT(DISTINCT C2.READCODE) FROM (((CLASSIFICATION CLASSIFICATION2 LEFT OUTER JOIN PATIENT ANYBODYPAT2 ON ANYBODYPAT2.PATIENTID =...

I just realized that you have a "distinct" in your query. Thus you may need to replace the COUNT(C2.USERID) with a COUNT(distinct <field>) and use a field that you do a distinct count on. If there isn't one, then you would need to do a GROUP BY in the subselect on the fields you have in the...

You could put a subselect clause in the select clause, kinda like: SELECT distinct ANYBODYPAT.NHINO NHINO, ANYBODYPAT.USERID USERID, ANYBODYPAT.ETHCODE ETHCODE, ANYBODYPAT.GENCODE GENCODE, ANYBODYPAT.DOB DOB, CLASSIFICATION.READCODE READCODE, ANYBODYPAT.ISCAREPLUS...

DeafBug, Great solution. I don't use the Group Sort Expert much, so I forget about it.

I haven't tried this, but there is another sorting option in the Group options. If your data that Crystal is reading is already sorted in the order you want, you can choose 'in original order' in the Group Options dialog. If you can't pass the data in the order that you want, or this does not...

I don't know if this will help you any, but we are working with Delphi, CR9 and CRXI and Interbase. We have found some cases were we can pass a date from Delphi to CR9 to a stored procedure in Interbase, but have also found cases were using date format does not work (haven't figured out why it...

LB, thanks for the suggestion. That might work. I don't really want to put the details in a group header if I can avoid it. I think I forgot to mention (I had meant to) that in some of the reports there are lots of calculated fields and complex formulas. I think some of them might not work...

An extension of MSBrady's question: What has been discussed here works for me when using the GUI to link tables, but if I use ADD COMMAND and have created parameters there (in CR9), it seems that the parameters automatically get ordered alphabetically. You can change them by the method above...

Thanks, I see how that might work (and quite inventive), but I do see some potential issues as well. I'll have to look at the reports, but it does concern me as our detail sections often have multiple lines and quite a few formulas. I'm not sure if I could get all those to work correctly if...

I have a problem that in some of our reports, we end with a group that occasionally will page break after the group header and before the first detail section. We want to eliminate this group header from printing at the bottom of the page, either by suppressing it or moving the page break to...

I haven't done a complete read of all the suggestions yet, but thought I'd weigh in on "12-Using a command as the datasource will be faster than using CR to link tables, select records, etc". LB you say that you wanted to keep this generic to the environment, but I've found that for report...

Dynamically change ODBC driver / datasource for the report? We are using Delphi, Interbase and Crystal Reports 9. In our Win32 product, we use a Crystal VCL which passes the report parameters and the database connection string to the report. This way we develop our reports using an ODBC...

You don't say how you know which record would be the newest record of TRACEEVENT = 'Y, but you could do it with a subquery. You would need to create a query that selects only the records that you would want. You can then either link the result of that to shipments, or you could keep the current...