Search results for query: *

Yes, I did that already.

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

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...

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.

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.

Oh my gosh! So simple. Thank you!

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...

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...

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...

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...

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...

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.

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...

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

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...

Excellent. Thanks so much, George.

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...

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.

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...

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...