Search results for query: *

My report setup like something like this: Vendor 1 bill1 bill2 bill3 Vendor 2 bill1 bill2 I have the vendor as part of its own group and then I also group by bill number. I conditionally suppres the bill footer. This part is working fine. My problem is coming when...

Working on a AP aging report this is the basic format Vendor1 X1-bill billdate ageddays balance aged0-30 aged31-60... X2-bill billdate ageddays balance aged0-30 aged31-60... X3-bill billdate ageddays balance aged0-30 aged31-60... billtot Vendor2 Y1-bill billdate...

I have a record selection set up in which I have a percentage range parameter. I then have a formula that is looked at to be in the the percentage range that was entered into the parameter. Then inside that formula I have multiple comparisons. The only thing that I have added new is a shared...

I need to join two tables that both have the same unique identifier column. But the data types in which they are stored are different. Is there a way to join the two together. The table that is currently in use is in a subreport. I just get an error saying that the data types are different. I...

Here is the command that I am trying to edit. I have never done a report with a command and I am not sure on exactly how to edit it. But here is the code: SELECT 'B' TX_TYPE, VENDOR_ID, BILL_NUMBER, TX_DATE, ROUND(TX_AMT, 2) TX_AMT, CURRENCY_CODE, TX_POSTED, AP_BILL_ID ID, ( SELECT...

I am pulling straight from the database and I have one number that is set to show like 38.39 with the rounding set to the .01. My issue lies in the fact that the number is actually 38.395. So my question is why is this not round to 38.40. This may not seem like a big deal but my overall total is...

I have two reports that are pulling one of their calculatioins from the same exact location. One report is calculating everything correctly. The "other" report has the same exact calculation going on but randomly the end result is being doubled. I have went through the function methodically...

I have two tables to a mailing label report. One table I am pulling the Customer address info. The other table has a date that I am filtering by. I'm receiving multiple addresses. I know why... The "other" table has an ID attached to each record. What I need to do is be able to get the max ID...

I need some assistance on how to pull a record from a database through crystal XI. I need to pull the record that has the most current date. So basically I need the record with the MAXIMUM(date) but I'm pretty sure that MAXIMUM() is not the correct function to use here. Any guidance would be...

I have a report that a user can select what they would like to group the report by. By doing this grouping the sort is automatically set. I have all string options then one date. when I try set up my function if the user selects a date crystal XI won't all me to have the date. Here is what my...

I have a report tied to an Access DB. I have create a Crystal report and tied it to this DB and there are also a hand full of parameters to the report. When I run the report through viewer. I am NOT prompted to enter any of the paramters. Am I missing something? Does the viewer have the...

I have a page header that appears on every page of my report. But after the first page the header is no longer needed and to save space I want it to become suppressed. Any suggestions????????

I have a field that does a summary of employees gross wages. Then in another column I take that employees gross wages times .008 this is to calculate the amount of FUTA taxes that need to be paid. The employee only gets charges for 7000 dollars out of their wages. So I have a simple function...

Here is what I believe that I need but I'm not for sure. More or less the question that I have is how to loop through a multiple selection parameter. Please read through the comments and see if you can make sense of what I am trying to say. ( if {?Loctype filter} = '*' then...

I get this error when trying to run a report from a stand alone program. "Error 732: The minimum and maximum values should be zero when the range limit option is not checked ParamFields[0].SetShowDialog" I'm not sure what this means. But I can track it down to a specific parameter. If I get...

I am editing a "Deadmans" report and cannot edit or delete a parameter. I also cannot change the datatype of the parameter. Any Suggestions?