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 Chris Miller 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. kdub72

    Need To Filter Distinct Data - Report Studio

    Nevermind -- I got it. Since the account # is not needed, I just left it out of the query, but still filtered by Open Accounts. I didn't think it would work without an Account #.
  2. kdub72

    Need To Filter Distinct Data - Report Studio

    I have what I hope is a simple issue. Say I have thousands of customers, each may or may not have multiple accounts. I want to do a mailing. The distinct field will be SSN#. CustomerA SSN#A Account1A AddressA CustomerA SSN#A Account2A AddressA CustomerB SSN#B Account1B AddressB CustomerB...
  3. kdub72

    Quotation marks around strings for Comma Delimited File

    Yes -- the '"' + [Data] + '"' was the solution. I was trying to do it as a Calculation, but it should have been done on the Expression line. Thanks for the help!
  4. kdub72

    Quotation marks around strings for Comma Delimited File

    We are using version 8.2 of Report Studio. We have an external vendor who requires data be delivered in comma delimited files. My issue is that one of the fields that I am exporting contains commas within the field, thus throwing things off. I need to be able to put quotation marks around...
  5. kdub72

    Quotation marks around strings for Comma Delimited File

    Can someone tell me how to use Query Calculation to put Quotation Marks around a string?

Part and Inventory Search

Back
Top