Search results for query: *

I have different product types in multiple cities with a report listing the product type in each city with the detail records of each type grouped by city. I am trying to get a subtotal of all of the different product types skipping the detail records. I have tried having a header/footer for the...

thread703-1386902 I want to respond to dhookom, many thanks to this thread above. Been trying to figure out how to do a count distinct in the report to no avail. The way dhookom explained how to do it works perfectly! thanks again

I am trying to compile a package that has globals in the packages as &case id, &begin date. When I compile the package via SQL it stops me to enter the global. The package is not for one specific case id as above but for any case id I enter when I use the package. When I ran it, I just hit enter...

Hopefully this is easy and it's my knowledge that is hard!! I am comparing two double numbers: if ( h_chrg_amt) == (h_amt_to_pay) But I am pretty sure the decimal point is the killer.. Some of the numbers are equal up to the 2 decimal position but not after that so it says they are not equal...

I have a report that is printing bills and at the end of end bill I have a section that is the 'cut and return bottom portion with your payment' with the info from the bill. I current have it in a group footer rather than a page footer so as not to print on every page. If all bills were one page...

This is killing me and do not know where it is coming from. I have a main report with 2 subreports. Each subreport only has a detail section. Main report has a bottom page section with the system date. Main report has a main query with a location field. Each of the subreports has the same field...

I am printing a report grouped on judges and data for each judge. One judge data per page. I do not have a report heading, only page headings and footers. In the page footer I have a page break. Problem is the first judge's name shows up on page one AND two, Rather than the second judge on the...

I have an Acess query that works ok. Problem is at the end of the report I want a total count of all records. Each record has one ID, so in the total field 'Control Source' properties I have =sum(id) which works fine if I have any records and gives me a total count in the report. If there are no...

We have just gone to 9ias. Finance dept wants to know who was on system Saturday. Is there a user log file or a system table where this info is retained. Thanks in advance for your help..... Ron

I am using CR8.5 on an Oracle9i d/b. I haven't used sub reports so don't know if this is what I need. The report suppose to look like a spread sheet for multiple organizations. Class Gender Caucasian AfroAmerican Hispanic Other AORgn Code Male 10 15 5 2...

I am running CR8.5 against an Oracle d/b. I am running a query that used CR Sql designer to pull up records. I have CR setup with 1 parameter. If the parameter is entered, I only want the records like that parameter like an account code. If the parameter is blank, not entered, I would like all...

I am running CR8.5 against Oracle d/b and am new to CR but trying very hard to learn. I am going against one table in the d/b. It contains budget info and there are a group of fields for each month in the record layout. There is also a year field in each record. I have a query setup via CR...

I am currently using CR8.5 and using CR Designer to make a query. I am using that query in CR in the rpt to make the report. In the query I added a condition in the 'where' clause in the SQL and it worked fine in Oracle SQL. When I added the line in the query, it looks like the report does not...

I know I am missing something very basic but I cannot get a handle on it. I am going against a Oracle D/B and picked 3 fields out of a table. One of these is FUND. I set up a formula: {Sprid.Fund}= '12345' and placed it in the Report Header. When I do a data refresh, it gives me all of the...

I have a report that uses a query that I developed in Crystal Designer going against a Oracle database. I would like to make a similar report and and change it to a different query. I have copied the query and report to another name and wrote a different query for the new report, but I cannot...

I have a report that uses a query that I developed in Crystal Designer going against a Oracle database. I would like to make a similar report and and change it to a different query. I have copied the query and report to another name and wrote a different query for the new report, but I cannot...

I am trying to run in a debug mode specifying debug=yes on the execution line. I also made a debug fmx on the form I want to debug. On execution, I have to go through other forms prior to the one I want ... (menu driven). When I execute, I get FRM-41841 'Use the debugger-enable executable if...

A friend of mine has a small business and has been doing very 'general' reports in Peachtree. He asked me if I would help him do a couple of reports in Crystal Reports. I do not know either one but have been in this business to know that you can learn on the fly if its not too bad. I do know...