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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. raven4

    Pivot table results in scientific notation value that converts to 0.

    Yes, I did that already.
  2. raven4

    Pivot table results in scientific notation value that converts to 0.

    Thank you so much, SkipVought! The field Number Format in the Pivot Table did the trick. Thanks for helping out this pivot table beginner!
  3. raven4

    Pivot table results in scientific notation value that converts to 0.

    I have data that I am exporting from an application in CSV format. I'm creating a pivot table with that data and for one larger set of values the pivot table is converting the resulting value to scientific notation. When I try to format the cell to change it to numeric it sets the value to...
  4. raven4

    Nested IF Statement

    Thank you, DaveInIowa, for the suggestion but the user who made the post is the priority thing to check, even if the date was older on the change. Only when the user matches is the date in play.
  5. raven4

    Nested IF Statement

    I haven't been on these boards a ton in 10 years - 14 total posts in that time - and not at all between 2013 and 2017. Nevertheless, thank you for the etiquette lesson and consider it done. My apologies to anyone who was offended by my lack of recognition.
  6. raven4

    Nested IF Statement

    Oh my gosh! So simple. Thank you!
  7. raven4

    Nested IF Statement

    I am a novice script writer. I am trying to write a stored procedure that will include some nested IF statements. The basic concept of the first statment in plain English is: If condition A is true AND condition B is true, then execute the next If statement: If Date A is greater than Date B...
  8. raven4

    Formula loses value in page footer.

    Just one page in the report. The details sections displays invoice details. And the page footer just has a bunch of informational text, such as "New this year!" into which I want to incorporate this formula. There is a group footer area that displays the invoice summary (total of products...
  9. raven4

    Formula loses value in page footer.

    Crystal Reports Version 9 I have a very basic formula that does the following calculation: If {Invoice.PRODUCT_CODE} = "BROAD" and {Invoice.BILL_AMOUNT} = 4295 then 11 else if {Invoice.PRODUCT_CODE} = "BROAD" and {Invoice.BILL_AMOUNT} = 895 then 2 else if {Invoice.PRODUCT_CODE} = "REG" then...
  10. raven4

    No Avery Label choices.

    I am using a version of Crystal 10 that ships with an accounting software package that we use. I can not run this version of Crystal as a stand-alone app without firing up the accounting app. I'm trying to use Crystal to create mailing labels and I'm using the mail label wizard, but when I get...
  11. raven4

    Want an additional form page at end of each group in a report.

    I'm a new SSRS user - using Visual Studio 2008. I need to build a report that provides a list of contacts for an organization, like so: Mary Jones Director ABC Company 123 Main Street Anytown, CA 11111 (444) 555-1212 Mjones@abccompany.com Scott Smith ABC Company Sales Associate 123 Main...
  12. raven4

    Sorting on new group not honored.

    Sorry, everyone. You can disregard this thread. There was a sort being imposed on the report via some specifications in the application through which I'm running the report that were over-riding the Crystal sort options. Thanks anyhow.
  13. raven4

    Sorting on new group not honored.

    Crystal version 9. I have a report that currently has the following group/sorting options: Group 1, sorted ascending: Product Group 2, sorted ascending: Product Subcategory Details, sorted Ascending: Customer Lastname_firstname I need to add a third group for customer parent company, sorted...
  14. raven4

    Details missing/suppressed in sub-report in error.

    Thanks, Ian, that was it. There was a group selection formula for amounts greater than $175.00.
  15. raven4

    Details missing/suppressed in sub-report in error.

    Crystal 9.0 I have a report that calculates the count and total balance due for items based on two different codes – A and B. There is a sub-report as well which lists the details for each of the two codes. My issue is that when I run the report, the sub-report is totaling the count and...
  16. raven4

    Create a view from unrelated tables.

    Excellent. Thanks so much, George.
  17. raven4

    Create a view from unrelated tables.

    I have Table A that contains: ID, Name I have Table B that contains: RelationType I want to be able to create a view that shows one row for each ID in Table A for each of the RelationTypes in Table B. So if there are three different RelationTypes, my results would be: ID...
  18. raven4

    Subreport in a second column.

    Well, that did work to some extent, but then I lose key formatting features like using the "can grow" feature on address data and suppressing sections with blank data.
  19. raven4

    Subreport in a second column.

    Thanks, Mike, I tried that, but each piece of board member data (name, address, phone, etc.) is in a separate details section. So when I add the sub-report in the Detail A section (where Name is) and it is larger than the main report, then I get a huge gap between my Board Member's Name and the...
  20. raven4

    Subreport in a second column.

    Crystal 9.0 I need to build a report that lists a board's members. Then, if any member of the board has an administrative assistant(s), those names should be listed in a second column. I am using a sub-report to list the assistant name, which is working just fine if I list the assistants...

Part and Inventory Search

Back
Top