Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bmarks

  1. bmarks

    System tables - database information

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

    Is there a test to see if a character field contains a number?

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

    Is there a test to see if a character field contains a number?

    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?
  4. bmarks

    Dynamic Groups?

    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 =...
  5. bmarks

    Dynamic Groups?

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

    Memo Field

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

    Performance Testing in crystal

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

    Nested Counting

    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 =...
  9. bmarks

    Nested Counting

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

    Nested Counting

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

    Sorting on a group-field

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

    Sorting on a group-field

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

    CR XI: Passing a datetime parameter to Stored Procedure via rpt

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

    Group Headers and page breaks prior to details

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

    Parameter field prompt order

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

Part and Inventory Search

Back
Top