Search results for query: *

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

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

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

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

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.

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

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