Search results for query: *

I have MS Office 2007. Recently my documents started getting scrambled when printing to one particular printer. All letters on one row gets put together in the same space. It just look like a black mess. But if you highlight it and press ctrl-c and copy it into notepad for example, it shows as a...

Thanks for your reply, Pete. Originally, I did what you suggested, but without 2 parameters that matched the Main Report, I just couldn't get the comments to display correctly. Once I had 2 parameters to match the Main Report, all worked fine. I just kind of stumbled on a solution, and I'm not...

I finally had success in getting this report to work. My main report was always OK. But I needed to insert a comment into the main report, only if the comment field contained something. So I inserted a new SR, with database fields containing the cheque comments, and invoice details. In the...

thanks for your reply. Do you also create custom reports using Crystal? I can't get a list of what the tables in Streamline contain. Right now, I am trying to get a list of accounts who haven't purchased anything sine Jan 1st, and the list is to include the city they're in and the sales rep...

Just wondering if we have users out there who would know their way around building reports using the tables in Streamline? I work with Streamline every day, and am usually able to get the data I need in a CR, but every once it a while I get stumped trying to locate particular tables that contain...

Solved- linking Sub report parameters to main report paramaters. I finally had success in getting this report to work. My main report was always OK. But I needed to insert a comment into the main report, only if the comment field contained something. So I inserted a new SR, with database fields...

I don't know if the following information is pertinent or not. The first lot of data is the SQL Query without the "Comment" formula inserted into the Report Footer: SELECT "ap_invoices_details"."apid_supplier_id", "ap_invoices_details"."apid_invoice_num", "ap_invoices_details"."apid_total_amt"...

Good day. I am trying to add a field to a report. This field might be blank in some instances, or in others, contain text. I have created a formula that shows this field {ap_cheque_comments.apchc_comments } if it is present for the particular cheque that was issued. If...

Tried various scenarios yesterday at work, and couldn't succeed in having either the subreport or a formula show the data that I need. I even tried using the main report with it's parameters, as a subreport. I guess that I will shelve this for now, but keep coming back at it on occasion. If I...

The SR was located in the page footer. I inserted a Group Header for the invoice numbers, and then inserted the SR there. I suspect I don't have the links set up right in the SR, as it only will show the column headings but no data. Here's a wierd situation. In the CR that I use for the...

thanks for continuing to try to help me, Ian. I cetainily appreciate it. If I read your post correctly, the use of variables and a formula in the subreport, and having it inserted after the data is executed in the main report is not do-able because the user of the report wouldn't be able to...

Sorry I haven't posted anything until today, but I only work 3 days a week here. Here is the SQL query used for this report: SELECT "ap_invoices_details"."apid_supplier_id", "ap_invoices_details"."apid_invoice_num", "ap_invoices_details"."apid_total_amt", "ap_invoices_details"."apid_ref_num"...

OK- here is an example of the data that I'm able to show: Vendor Name: Kennametal Ltd Cheque number: MEFT030813 Date of Transfer: March 8, 2013 Invoice number being paid: 9864583 Invoice amount: $500.00 Invoice number being paid: 9864587 Invoice amount: $310.00 Invoice...

What do you need in raw data and how do I get it to you? I can do a screen shot, or export to a PDF, etc.

Thanks, Ian. I tried that, and after adding to the Selection Record formula, and refreshing the report data, nothing shows at all including what used to show. Guess it doesn't like that. Thanks for trying. Norm

Thanks, Ian. How can I tell if I really have null in that field. I tried your formula- created a formula called "comment", and inserted it in the report, in the detail section, and it doesn't show any comments, but duplicates the value of the invoice on the report by adding extra lines for each...

Actually, the more I was thinking of this, I don't think I need the parameters in the formula, since the User has already entered that criteria. Maybe all I need is something like: IF {ap_cheque_comments.apchc_comments}> " " THEN {ap_cheque_comments.apchc_comments} ELSE " " I will have to try...

Hello. I am trying to add a field to a report. This field might be blank in some instances, or in others, contain text. I have created a formula that I hoped would show this field {ap_cheque_comments.apchc_comments } if it is present for the particular cheque that was issued. Here is the...

Thank you for your reply. Based on your suggestion, I was able to succesfully link the apchc_transint_seq field in the ap_cheque_comments table to the ap_cheques.apch_internal_seq field in the ap_cheques table. The fields have identical values for the cheque numbers. And I can now insert the...

Good day. I am using Crystal Reports 2008. I would appreicate any help that you can give me. I know my way around Crystal, but am certainly no expert. I have created a report for our accounts payable to use when they do an Electronic Fund Transfer. The report has 3 paramaters: Vendor ?Vendor...