Search results for query: *

Hello ACCPAC Experts, I am a reporting analyst and I was asked by my manager to develop financial reporting that pull data from various data sources including ACCPAC. I never used or accessed ACCPAC and I would like to get my handle on the back end data structure and what data is storef in every...

Hi All, We are using Aux reason Code and when agents log into our Avaya system they by default go into Aux. Their time will be accumulated in Aux0. My question is how can I set a limit on that time when they first login. What will be the impact of setting this limit. Thanks

Hi all, I am using CR XI R2. I am joining 3 tables in my reports Main table A with left outer join to Table B & C The problem is If Table B or C have no matching value from the join, I am getting null value in the report for both. Any idea why this is happening? Thanks

Hi All, I am using CR9 on SQL server. I need to group by a datetime field in a table. The challenge is I need to group on this field from 6:00 am to 6:00 am next day. Any thoughts how this grouping can be achieved. Thanks Back2tek

Hi all, I am Using CR 9 on SQL server. I was wondering is there a way to transpose the output from a cr report automatically (trying to avoid using cross-tab). I have a report that I export to excel and then cut and paste the output values in another sheet with transpose selected in order to...

Hi all, I am using CR 9 on SQL 2000. I created a cross tab report in the report header as follows: row: emp_id,fname,lname column: date summary: sum of working hours Questions is I need to export the report in Excel and have header for the row fields smth like: EMP_ID FNAME LNAME 06/01/07...

Hi all, I am using CR9 and ODBC to pull data from 2 datasource (sql and sybase). I am pulling a weekly report for sales per agent per day. This table is on sybase. The data looks like Table A Date Agent Sales 03/01 Mark F 210$ 03/02 Mark F 570$ ..... 03/07 Mark F 1200$ 03/01 Tony...

Hi all, Using Cr9 on SQL. I am trying to filter the records selected using a formula like: ({name} >="ABC123TOR" and {name}<="ABC999TOR") I need to use a wild card in the selection formula, like ({name} >="AB*123TOR" and {name}<="AB*999TOR") How can this be achieved ? Thank you for your...

Hi all, I have a simple report that I would like to have in cross-tab format. I am running Cr9 on SQL server 2000. The table is like Sale_date date, Product_id char(3), Quantity The product_id has the product codes. I need to report on the count of each product per day. The output will be...

Hi all, I am running CR9 on SQLsever. I am applying a record selection criteria to filter records that has certain values or no values as follows: ({employee_CODE}in ['R99','R98','R03','R02']) OR IsNull({employee_CODE}) OR InStr({employee_CODE}, "") = 0 ) The result I am getting is only for...

Hi all, Using CR9 on sybase, I am having a problem exporting to csv as the header is repeated on every line. It seems there is no solution avail according to this link (please read users comment at end of page in the link). http://support.businessobjects.com/library/kbase/articles/c2014451.asp...

Hi All: A report is designed using CR9.2 . Datasource is ODBC connection to an MS access view/query. The MS Access view is collecting data from 2 linked tables in a sybase database. The issue is related to a date field in sybase table that the Crystal report is showing as datetime. I am using...

Hi all, I am using Cr9 on Informix database. I have no access to create views or Stored procedure. I would like to pull and consolidate data from 2 typical tables on 2 different servers. My question is how to use add command feature in CR9 with 2 data source to return all records from both...

Hi all, CR9 on SQL2000. A report list sales daily/weekly/previous week/montly/previous month on the same line. Looks like: Salesrep Sales daily weekly prev-week monthly prev-month My intention is to use running totals for each sales columns, I am not sure about previous week and previous...

Hi all, My env is CR9 on SQLserver2000. I have a main report that has prompt string parameter <Category> which is not associated with a database field. It is a logical grouping of employee levels, For Example category A are employees with <table.level> = 1,2,3 and so on. My selection is...

Hi all, Using Cr9. Sybase Backend. In my report I am trying to use a custom formatted date field such like "yyyy/dd/mm" After exporting to Excel 97-2000 (data only) the cell format is " yyyy/dd/mm" with a leading space in the front. Is there a workaround for this problem. Thank you all, Back2tek

Hi all: I am using CR9 to report off SQLSever 2000. I am looking for a solution to automate report generation that will allow unrelated reports ( for example sales per agents report and monthly sales summary report) to be exported in one Excel sheet on 2 different worksheets. Can this be done...

Hi all: I am using Cr9 and I am having difficulties with this scenario: Employee table (empid,fname,lname) Sales table (empid,sales_date,amount) For each employee in employee table I would like to list sales amount by date, whether the employee exist in the sales table for that day or not...

Hi All, I am trying to avoid subreport by using add command feature in CR9. I have a main report that has 2 date parameters (From Date) & (to_date). I added 2 command objects using 'add command' that pull summary data from 2 diffrent other tables. The idea is to link the main report to the...

Hi All, CR 9.. Main report has prompt parameter field (start_date) type date. Need to pass prompt value from main to subreport. The subreport has Database field (logindate) type datetime. I create a formula in the subreport as follows: @date cdate(logindate) I based the link between the...