I have a report where I list the employees and the number of requests they have submitted. What I need to do is just display the employees that have a request in 2005 plus their running totals. How can I filter that out?
Current Results
Earliest
Name Request date...
The report I have works great it just I need to know how to combine sites information using the shared variable technique or may I should set up my report differently.
I have a main report and a subreport. The main report contains the list of employees along with the sites they belong to. I...
Good Day All
I need some help.
I have a report it's group by SBU then by SITE. IT WORKS GREAT BUT……
Raw data
SBU SITE APP NO
SBU SYSTEMS BU ACCESS CA 1
SBU...
Hello
I need some help.
I had to create a command that combined three sql queries. The results are correct however, now I have duplicates in my crystal report.
See record index
App Type Code Event Date Status Filing date Record Index
App#2 NP MY 20-Oct-05 FLG 20-Oct-05 5,834,488.00
App#2 NP...
The following formula works great {TABLE_PRODUCT}IN ["TV","VCR","DVD"]THEN 1 ELSE 0
but I needed to modified it. I needed to add one other criteria, date criteria.
IF NOT IS NULL({TABLE_APPLICATION_DATE}) AND {TABLE_TABPRODUCT.CODPRD}IN ["TV","VCR","DVD"]THEN 1 ELSE 0
The problem is that my...
In some reports I need to 'freeze' the data by the each quarter and then use the frozen results in future reports. Can this be done in Crystal automatically?
Thanks
R
Each application is usually assigned a product. One application can be assigned multiple products.
Note the application numbers are alphanumeric.
App # Country Product
USA2 US DVD
USA2 FR DVD
USA2 KR DVD
USA1 US HDTV
USA1 JP HDTV
USA1 UK HDTV
USA2 US HDTV
USA2 FR HDTV
USA2 KR HDTV
USA3 US...
I'm creating a manual cross tab. I have grouped my report by a field called product. From that field(product) I created 3 GROUPS (digital, analog and others) using the group expert. In the select expert I placed the date range 1/1/2005 - 12/31/2005.
I was trying to create a formula to count the...
I have a list of employees (287) in excel.
Baker
Cohn
Smith
I need to a create folder for each employee. Can this be automated via a script?
Many Thanks
R
Hello Experts,
I have a crosstab set up. I think I need a running total in the summarized area. I want to continue to add the number of products added between March and June (106 for Digital) and then between June and Sept. (82 for Digital )
MAR 2005 JUNE 2005...
Is it possible to customize the size of the report and specifically the width?
We have many columns to display in one page (several data by quarter, full year data…)
Thanks
I have a crosstab that works beautifully, ALMOST. ;)
Here is the crosstab
US JP GB CA MX TOTAL
TV 2 9 0 3 0 14
DVD 3 12 5 0 3 23
VCR 0 6 4 2 0 12
I want to display CA and MX but include it in the...
Good afternoon all,
I have just been tasked to deploy our Xerox Docushare documentation management system worldwide. I have ideas about filenaming conventions for all documents, requiring a workflow from each business but I'm not sure how best to organize and communicate all this information...
Good evening folks,
I have a bit of challenge.
I used a subreport to concatenate a list of values (i.e. countries for each application)
This reads that we filed Application01 in USA, France and Great Britain.
Application01 - USA, FR, UK
Application02 - USA, CN, JP
Application04 - CA, MX, TW...
Is it possible to have more than 2 parameters where selecting options is not required.
For example,
Parameter 1 Select Country
Parameter 2 Select City
Parameter 3 Customer
What if the user just wants to choose the country and customer and skip the city field? Is this possible or does the user...
When I started up my Outlook this morning, a log in screen appear with our IT guy's username in it. Does that mean he was logging into my e-mail account?
I need help badly.Someone in the Office forum suggested I post here. Thanks
I have a word document that is 357 pages. Within the document there are several file groups about 200.
For example,
File2369933 on pages 1 - 3
File9663339 on page 4
File2173993 on pages 5-9
I need to separate each...
I need help badly.
I have a word document that is 357 pages. Within the document there are several file groups about 200.
For example,
File2369933 on pages 1 - 3
File9663339 on page 4
File2173993 on pages 5-9
I need to separate each file group into it's own document.
For example...
I have a report where I group data by product type.
For example,
Model No: 123699
Location: USA
Order from: Portugal
Model No: 563336
Location: USA
Order from: China
Model No: 8696633
Location: France
Order from: Italy
I need to set up 2 parameters. (1) Select countries (2) model numbers
(1)...
I have a report where I group data by product type.
For example,
Model No: 123699
Location: USA
Order from: Portugal
Model No: 563336
Location: USA
Order from: China
Model No: 8696633
Location: France
Order from: Italy
I want to have a separate page preferably the last page where I can...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.