Search results for query: *

Thank you SkipVought! I will sure looking into that post you sent me to see how I can work around. Thanks again!

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

It still keeps me wondering how the another similar report prints fine through excel for same page size and setting on the same printer Thank you for the quick reply :)

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 Dev; Thank you for the reply. I have tried your suggestion and works. Thanks again, RR

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

Thank you Sir Bob. appreciate you reply. I was confused on where to reset the variable to zero...from your reply I split the GF1 to a,b,c sections and it works ok so far. Thanks again! RR

Thank you Dell and Ken for your reply. Ken, I cannot bring the 2 bex queries in single report (my first thought was the same as a work around rather recurring the subreport) and join them by store# Each bex query is based on a different source and the parameter variables imported into report...

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

Thank you Charily for your reply. I have a subreport with same format as main report. I tired specifying 100 with constant column width option in the export dialog box. but out of luck.

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

Please let me know if this is even doable? Thanks!

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

Thank you again Charily. This really worked.

I cannot even save the Formula Delimit. I get the error when I am save the custom function code in the delimit formula. Thank you the reply, Charliy

...http://stackoverflow.com/a/10105692 Create a Custom Function (named 'Delimit') with this text: // Delimit() // enclose each value in array in **, returning an array Function (Stringvar Array params) Split("*" + Join(params, "*,*") + "*", ",") Modify the report's record-selection...

Here is the really issue I am facing. I am able to run the report thru CMC with nu value to the date range(optional)but we are using a .csv file to pass multiple values to the report and kick it off thru a shell script and we get the error