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

    Editing SQL queries / Datasource owner

    Hi Thanks for replying. The report is running on tables and views. When I use the Set Location, it looks like it is going to work but doesn't. The problem I have is that I might want to send this report out to different customers who will have their own datasets with identical table names...
  2. Lintem

    Editing SQL queries / Datasource owner

    Hi I used to use Crystal about 7 years ago, but my knowledge is really rusty so forgive me if this is a stupid question. I have a report which is running okay on our live dataset. However we need to run it on a test dataset instead - different database name but the same tables & views etc...
  3. Lintem

    Query condition help

    I'm trying to retrieve data between two dates and I'm struggling. The report needs to look at the period of a week, 3 weeks ago i.e. today's date - 21 till today's date - 14. Is there any way of doing this using the query panel conditions instead of having to alter the sql in the background...
  4. Lintem

    Business Objects query condition

    I'm quite new to Business Objects so apologies if this is a stupid question! I want to put a condition in the Query panel to retrieve data between two periods: from today's date - 21 to today's date - 14. Can anyone point me in the right direction? Thanks
  5. Lintem

    manual running totals

    I'm trying to help a friend who is writing some reports - she doesn't have access to the internet, and I haven't had access to Crystal for 2 years!! What she wants to do is create a formula that will display a running total on the detail line and then the total at the end - she can't just use...

Part and Inventory Search

Back
Top