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

    Linking Stored Procedure Paremeters

    I am using Crystal Reports (v6) and PeopleSoft Query. The queries are considered to be stored procedures by Crystal. In the query I prompt for several parameters. I need to add several subreports to the main report (which require the same input parameters), but I cannot figure out how to link...
  2. heatherk

    Physical Database Missing?

    Hi All! Has anyone ever encountered a problem with one of the databases missing from the list? When I choose the "log on server" option under the "database" pull down menu sometimes "Oracle 7" is a choice and sometimes it is not. I had previously been using the...
  3. heatherk

    Missing Expression, Running Total Problem

    I am trying to get a running total column in my query for year to date but I keep coming up with the error "missing expression" on my scalar subquery. Is there something I am missing? Can anyone help? select a.region_cd, a.sales_person, b.category_id, a.corporate_cust_id,a.cust_id...
  4. heatherk

    Sorting by Formula Field Within a Group

    I have tried to create a running total column in my query but I keep bombing out on the sql. Could you possibly give me an example sql expression. I have tried it many ways. For example : select region_cd, sales_person, category, corporate_cust, cust, sum(qty), sum(amount), sum(select d.qty...
  5. heatherk

    Sorting by Formula Field Within a Group

    I am using CR version 6 and we run off an Oracle Database using PeopleSoft, so I get my CR tables from queries written using the PS QueryTool.
  6. heatherk

    Sorting by Formula Field Within a Group

    I have created a report with 5 groups: Region, Salesperson, Category, Corporate Customer, and Customer. After sending out the reports for the first time last month the salespeople decided that they would like the Corporate Customer and Customer Groups to be sorted by the YTD Quantity Column...
  7. heatherk

    Best Tool To Build A Cube??

    My company is evaluating PowerPlay and we are trying to find the best tool to build the cube. We are using PeopleSoft and I am running queries to Excel in order to evaluate the the product using our data. I am sure you all know that Excel has a limitation on number of lines, which is a problem...

Part and Inventory Search

Back
Top