Search results for query: *

We are using crystal Reports 8, and displaying reports through the URL command as described in the below link. http://support.businessobjects.com/communityCS/TechnicalPapers/scr8_urlcmds.pdf It works fine for most of the reports including passing single parameters. However I have several...

Please forgive me I am new to Cognos. I have search the forum for this question and found similar ones, but none that I could apply. I am using Impromptu Admin, version 7.0 I am working with an existing catalog, which has a lot of folders. One of the tables has dramatically changed structure...

We are using crystal version 8.0 and are going to have the reports run from a web page. The report will have several parameters (Like ={?CourseCode}) and the web page will present a drop down list of Courses, including one called “ALL”. If a Course is selected from the list, then the report...

I am working on a server that does not have a printer installed. All the reports I am creating will be viewed through a web page, so I think when they are printed they will use the local printer from the computer viewing the page. I would like to change the report to be landscape instead of...

There is a Crystal Enterprise for Version 8 and one for version 9. Whatever version of report you have, you need to use the save version of Enterprise. There is also to run report through a web page, but I don't know what the requirements for that are.

Here is an idea. You said the report is grouped by Sales Person, and the data given looks like it is sorted by Quote Number. If you create another group on Quote number (you can hide the header and footer if you like), and then move the {@accum} formula, from lbass’s code to build the array...

You should be able to perform a distinct count on Property LP

Move your Summaries to the Group Footer GF2. The Running Total counts the record for each line as it is presented in the report. If the Running total is in the Head then it has not had an opportunity to count all the lines in each group.

You should be able to use a Running Total. Create a Running total and in the Summary section add your field and use a type of Sum on your field, in the Evaluation section, click the “Use a formula”, and enter in the x-2 button the opposite of your suppression formula (total less than or equal...

I am not sure what other data is in your report, but if you can move the data in the group header to the group footer, then you can use a Running Total that counts records, and is reset on the group and use it instead groupnumber to suppress the group footer.

In the Cross-Tab Expert, Add the CATEGORYURN to the Columns, then while the field is highlighted, click the Group Options button below it. The Cross-Tab Group Options window appears. On the options tab check the Customize Group Name, and select the CATEGORY filed. This should sort the...

An alternate solution to changing the select statement is to suppress the sections you don’t want to see where the description starts with DO NOT USE. Go to the Section Expert (Report Menu, Section Expert), Click/highlight the section you want to suppress and click the x-2 button next to...

The report should be performing this calculation Value* 0.90 . This is the same as subtracting 10%. In excel take your Value/0.09. This will increase the value. This should make the value in the report the same as your original, less any rounding error.

I am using a variation of the “For Loop” above in several Monthly reports. Mine increment by Day instead of by hour. These are used to determine the Maximum time allowed to complete a problem. The Time allowed, in my report, is dependent on the Priority/Severity of the ticket. The Report is...

Below is some code that may help you. It is a modification of code I use to increment by business days, so it may not be perfect, but you’ll get the point. It is a for loop that will add one hour each time it loop, for the duration of the AddBusiness varible. After adding the hour it check...