Search results for query: *

I'm catching the SQLException now and returning a message that it can't be deleted because it's in use. I just wanted to show them that they can't delete it before they try. There are 10 types of people in the world, those that understand binary, and those that don't.

I gave a simplified example. In reality, one of our master tables is linked to no fewer than 30 tables, with more to be added as we expand the application. That's also true for a number of our master tables. I was hoping there was a built-in function of which I wasn't aware that would tell...

We have a web app that lets users create records in a table, then assign those to other records using primary keys and foreign keys. If a user tries to delete one of the master records while it's linked using a FK, it will error. I have it catching this error now, but I'd like to deny deleting...

The program I am using is a clipper payroll program. I work for the company that produces it. The program opens crystal's runtime files, viewer, or whatever it's called and passes parameters to it to display/print the report. The rest of the data is pulled from the SQL tables. The parameter...

CR 8.5.0.127 If you remember, I had a very annoying report I had to fight with. Long story short, they got fed up and rewrote the report but told me to fix the formatting. So I did. I came up with a solution for today and it works, but I want to know if anyone else has a solution. I am...

I am not saying I don't welcome the help. I really do, but when frustrated with these things, such sarcastic remarks just make it worse. I really appreciate the help, but not the comments. Anyway, I tried the hotfix but it still does the same. As far as the version, I am limited to what my...

CR: 8.5.0.217 I am not exporting from crystal. The report was written in crystal, but there is DOS-based clipper program that does the actual exporting using the "TEXT" export. If I knew what the actual crystal terms were before posting, I would already know the answer to my problem. It...

I am exporting a single line report to an ascii database file for email. I keep getting a leading space in the export file. I have tried using the trim() function on the first field, but there are no leading spaces. I have placed the field at the far left and set all margins to 0. I've been...

I give up. I'm scrapping the report. I can't figure out what they did or how they did it. If they want the report later, I will write it myself. Thanks for all the help anyway guys and/or gals! There are 10 types of people in the world, those that understand binary, and those that don't.

#batch_sum_1 is a running total of @batch_amt. I want it to suppress the entire group if there is no total. The running sum comes up with a null value for some reason if it is a sum of zero. It does so even if @batch_amt has 2 records, one is 10 and the other -10. The sum is 0, but it shows...

I've tried both lbass and chealseatech's approaches. Neither work. Chealseatech's says "can't create summary/running total field" and lbass' doesn't suppress anything. The thing is that it isn't a summary of a field in a table, its the sum of a formula field. It's formula is...

That's all good for other situations, but won't work for me. Remember that I am in the second of 3 group sections. The first is suppressed entirely, it's just there for group on record. The second, where I am, is grouped on another within that, and the third, is, well, I'm not really sure...

Let me clarify a little. If the header is set to suppress on isnull({#batch_sum_1}), it will suppress all headers for that group if there is a null value in the field #batch_sum_1 anywhere on the report not just that in that specific instance of group.

I've suppressed the footer and details sections separately. The details section will suppress if there is no data, and the footer will suppress if the value is null. The value will be null if there is no data. So an empty details section will suppress the details and the footer but the header...

How do I suppress an entire group and everything in it if the footer contains a null field value. My footer has a total field. If there is no data in the details I can suppress the details and the footer. How do you suppress the entire section if there is a null value in the footer? I have...