Search results for query: *

Is anybody out there pulling data from ACCPAC back end data who can shed some lights on the back end table and where to go about learning there structure. Thanks

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

Thank you. I was under the impression that you can Change the setup in a way to force Aux0 to Avail after certain thershold.

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

Help Anyone..

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

Thank you synapsevampire, Could you please elaborate a little on this "Within Crystal, create a Main report for the Agent data, and then use a linked subreport to supply the aggregates for the other table." I am afraid this will give me only days where agent had sales (from agent data) + their...

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

Thank you

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

Thank you LB. Greatly appreciated.

That's a lot of manual work..On a second thought if I would display what was sold only that day, How would I set up the row fields in the cross-tab. Thanks in advance

Thank Lbass, What I am trying to do is the following: The Sales table has the insurance policy sales and looks like policy type char(3) [ values are 1 for deluxe, 2 for medical, 3 for car insurance, etc] duration char(3) [values are 1 for (9-15 days), 2 for (16-30 days), 3 for over 30 days)...

Yes . It appears as an option. I have also XI just installed on another machine..

Crosstab gurus, where are you? Thank you

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

Thank you Rhinok ..