Search results for query: *

Hi, I have a crystal report in 2008 version and is automated through CE XI and writes into network location as an excel exported file. This is automated to run daily. But in case if a user leaves open the excel file on their machines the report doesn't get refresh with new data. Can anyone...

Hi, Using BI 4.1 CR 2013 I have 2 reports which connect thru SQl Server odbc and are automated thru BI 4.1 in pdf file format. One of the report works absolutely fine; but the other report is messing up with the fonts (using Arial) it replace all the L’s to W in the pdf exported file and...

Hello everyone, I am using CR 2008 for a report with Source from BEX query. The issue I am facing is when the report is exported to excel it’s cutting off 2 of the report columns to next page in excel; but prints fine through crystal tool. The page setting is legal and landscape. I am able to...

Hi All, Using CR2008, SAP bex as source Report displays data for Store#, store name, $sales1, $sales2, $variance(Sales1-Sales2). Report is group by Store# I need to sort the report by the highest variance. How can I do this? I have added @Variance to the record sort expert; but doesn't seem...

I am working on a report and has a subreport where I will need to find variance between the subreport value and the mainreport values. Report is group by store# Date, Store #, store name, saleamt1, saleamt2, varaiance (saleamt1-saleamt2) Saleamt3(subreport) variance(saleamt1-saleamt3) How...

Using SAP Bex queries and CR 2008 The report I am working on is to get data from 2 different Bex queries. So using subreport to get the data from Bex query2. Bex Query 1: main report Fields displayed are Date, store#, store name, saleamt1, saleamt2 and diff (saleamt1-saleamt2) Bex Query 2...

Using Crystal Reports 2008 with BEX query as data source I am having trouble exporting the report to excel format and using Excel 2010 Issue 1: When I export the report to excel and print the report one of the column is print in second page. I am using the following page setting in crystal...

Using CR2008 and SAP BEX Query as source for data. I have a cross tab which displays as below: 10/5/2013 10/6/2013 10/7/2013 10/8/2013 10/9/2013 10/10/2013 1111 10 20 25 22 35 0 2222 35 20 0 10 5 8 3333 0 10 5 15 40 0 4444 0 5 30 15 0 16 5555 0 8 10 0 0 0 But I would need to see the...

Using Crystal Report 2008 and SAP-Bex query as source I am trying to mimic exit analyzer report which has to be refreshed manually daily so I can auto mate it in CE CMC. I have store, Store name, Data for last 2 weeks and each day date as columns and store & store name as rows.. I was able to...

Hi, Using CR2008 and I found this solution exactly what I am looking for and wanted to try but couldn't figure how I could correct my formula. I get the error when I try the solution suggest in this forum when I create the @delimit. "The remaining text does not appear to be part of the...

Hi, Using Crystal 2008 and Crystal enterprise XI-3 I have a report with 3 parameters and one of them is date range set as option. When auto scheduling; Report failed with the error message "The specified value type is different to the current value type" I am pass blank to the date range. I...

Using Oracle exadata. Crystal reports 2008 and Crystal enterprise XI I have a report with about 6 paramters to be filter and out of these 6 parameter values 3 are optional( can be left blank). I need to auto schedule the report to run by country and write the file to excel format. I am able to...

Using CR2008 and Oracle 11g We have lot of reports which compares data from current year vs. last year. We also follow a custom calendar (fiscal calendar) where every 4 year or so the fiscal calendar has 53 week instead of 52 week. I am trying to show a message in the report header section...

Using Crystal 2008, Enterprise XI R3 I built few reports individually and they have again been used as sub reports in a single main report. I used the option as re-import sub report when opened. How do I find what path is the sub reports re-imports from. How does this option work when the main...

Hi, Using CR 2008, Oracle 11g. We are using 2 different sources to get last week end information. We have brand-1 coming from source1 and brand-2 coming from source2 Will I have to use 2 subreports or can I do with one report and group data to display both brands one after the other Report...

Hi all, Using CR2008 on oracle DB 11g. I have a main report to report sales on a date and have a suppress logic for the report to print only for the current month when no date parameters are selected or print for the select date parameters. Now I have to include a sub report to show available...

Hi, I have been struggling to get this code work for me and don't know what is wrong. I keep getting this error ORA-03113: End-of-file on communication. This is causing by using the distinct in the count. I remove the distinct it works but the data is wrong. Thanks in advance! RR Using Oracle...

I have a report where I need to pass a list of id's to filter the report for only these given id's as parameters. This input list changes every month. What is the better way for me to do this? I current load this list into temp table and query. Using CR 2008 and report will run throught...

Using CR 2008, Orcale 11g I am using a command object as source to the report. I created parameter {?startdate} and {?Enddate}. Command object looks like this: Select col1,col2,col3 from Tab1 a Where a.datefield >= {?startdate} And a.datefield <= {?Enddate} Report doesn’t seem to read any...

Using CR 2008, Oracle 11g: We have a report with lot of metrics to show by day (fiscal calendar current year vs last year) and aggregate by WTD, MTD, QTD, and YTD. How can I aggregate last year data for WTD(week to date) only instead of full week? The report what I have now is aggregating for...