Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jack91
  • Content: Threads
  • Order by date
  1. jack91

    How to make a field to show nothing rather than 0

    hi I am using crystal version 10. I have a field which sometimes have no data. For such results I would rather see the field as a blank rather than see zeroes. Please advise Jk
  2. jack91

    suppressing a part of graph when using group Layout

    hi, I am using crystal v 10. I have 2 groups for my report group 1 ---> hardware criticality (Y/N) Group 2 ---> future warranty expiration info **@hardware criticality formula: (please end of this thread) **@Future Warranty expiration info: (please end of this thread) I have made a graph...
  3. jack91

    Sub-Report placement/linking issue

    Hi, I am using Crystal Version 10. I have one main Report with Page 1 having a cross-tab as well as 2 pie charts. The rest of the sections in this main report are all suppressed. Now I have 3 sub-report which are based off of the pie charts. Which each section of the pie chart representing...
  4. jack91

    Data matrix plugin for Crystal Reports version 10

    Hi, Would you please recommend: Data matrix plugin for Crystal Reports version 10? (free or $$ software plugin) and any instructions to go along with it would be very helpful :-) TIA Jk
  5. jack91

    Comparing Crystal reports to MS SQL Reporting

    Hi, If this is the wrong section to post this please move this and let me know where you moved this thread. I have not used MS SQL reporting before. Would someone familiar with both crystal reports and this give some advise on which is better on what aspects and why. -- or if you can point...
  6. jack91

    customizing chart titles for GH when evaluating for each flag

    Hi, I am using crystal version 10. I have say 100 computers and i am evaluating which of them have warranty expired by using: if isnull({warranty_end date }) then "Assets With NO Warranty INFO" else if {warranty_end date } <= CurrentDate then "Assets Out Of Warranty" else "Assets Under...
  7. jack91

    Showing &quot;0&quot; or Null values in a bar chart

    Hi, I have created a report for warranty of computers with the following Formula. When i use this formula to create a Pie chart I am NOT able to see the ones that have 0 or null values. For example if there are NO computers that have warranty expiring within the next 30 days I *** still would...
  8. jack91

    urgent: section suppression using true/false flags

    hi, I have the following design: RH a thru d PH a ----> needs to be shown only in details section BUT suppressed in GH 1a, 1b and 1c PH b ---->needs to be shown only in details section BUT suppressed in GH 1a, 1b and 1c GH 1a GH 1b GH 1c GH 2 GH 3 GH 4 Details Please advise on how to do...
  9. jack91

    Formual for running total in cross tab

    Hi, I am using Crystal Version 10. I am unable to see a running total in cross-tab expert.I have cross-tab report which runs into 4 pages with the last page having the grand Total at the very bottom highlighted. Is there a way to have at least a "running total" in first of 3 pages of the...
  10. jack91

    Warranty expiration info formula for --

    Hi, I have created a formula for FUTURE warranty expiration info (see below) I need help for creating a similar formula for computers which* already had warranty expired For the computers that have warranty expired which of the computers have warranty expired within the next 30 days, 60 days...
  11. jack91

    How to get a clickable bar Chart?

    hi, I have a 15 different kinds of software which i have shown on a bar chart where i show the count. Then in the details section I have a separate page for each software with its own details. How can i do the following: Make the bar chart click able, for example if one of the bar in the...
  12. jack91

    grouping all blank rows with a blank column together

    hi, I have a particular column that has some blank values in some rows. I want to group all the rows where a particular column has blank values and put them at the end of the report. Please suggest a way to do this. Thanks Jk
  13. jack91

    Q on formula using if isnull

    hi, I have 100 computers which need to show warranty info which I have done the following(this works for me) if isnull({table.column})then "computers having NO warranty INFO" else if {table.column} <= CurrentDate then "computers that have Warranty Expired" else "computers having Warranty NOT...
  14. jack91

    Chosen parameters versus displayed parameters

    hi, I have always used displayed parameters/output on the upper left hand corner of the page header. But there is a possible requirement of having the chosen parameters also displayed -- what the user has chosen. Chosen parameters: 1) 2) 3) Displayed/output parameters: 1) 2) 3) My question...
  15. jack91

    Adding a custom header in cross tab report?

    Hi, Is there a way to add a custom header to a cross tab report? I have: column 1 column 2 column 3 row 1 row 2 row 3 What I would like to do is put a header name on top of row 1.I put a box object and typed in a name. -- This works fine for page 1, but for page 2 onwards the custom...
  16. jack91

    Suppressing Main reports page headers in Sub-Report while enabling in

    hi, I want to suppress the main reports page headers in the sub-report and *enable page headers of the sub-report within the sub-report only. Is this possible? Regards, Vijay
  17. jack91

    Cross Tab: Repeating page headers and extra row naming Q

    hi, I have 2 questions: 1) I have put a cross tab in Report Header. I am un-able to put in page header so I could have the page titles,dates etc repeat on each page the cross tab shows up. Is there a way to have the page titles show up on each page that the cross tab prints on? 2) On Top of...
  18. jack91

    Cross Tab: How to make the column headers 'vertical'?

    hi, I have 12 column headers for which i am using legal size paper in 'Landscape'. I would like to make the column headers vertical.Is there a way to do this? (other than to manually shorten the width of the columns?) Thanks Jk
  19. jack91

    Concatenating 3 fields when one field has no value

    Hi, I have 3 fields that i need to concatenate. Issue: When one field has *no value but the other 2 fields **have value, and when i concatenate none of the fields which do have value do not show up. Is there a way to fix this? I would like to show the fields as Good/Bad/Ugly -- basically...
  20. jack91

    Embedded sub-report image re-sizing issue

    hi, I am using an embedded sub-report on the top right hand corner of the report. But when i run the report the image size changes from the original to a size much bigger. I have made certain that "can grow" is un-checked but the issue persists. Please advise. TIA Jk

Part and Inventory Search

Back
Top