Search results for query: *

Hi All, I have a question regarding cumulative calculation where I want to calculate row by row Invoice and Payment. Here is the sample data and my desired output. Cust/Month/Trans/Amount/CumulativeBal(my desired output) 1, 1, Due, 100, 100 1, 1, Payment, 50, 50 1, 1, Payment, 50, 0 1, 2...

Hi All, how to identify different fields with in a group of records? Example: create table #test (ID int, Text varchar(10)) insert into #test select 1, 'ab' union all select 1, 'ab' union all select 2, 'cd' union all select 2, 'df' select * from #test I want to show additional field as...

Hi all, I have a question regarding the selection of arrival and departure city. CREATE TABLE #XY123 ( tktamt MONEY, departcty VARCHAR(5), arrivalcty VARCHAR(5), tktnum INT ) INSERT INTO #XY123 SELECT '100.00', 'DFW', 'LGA', 12345 UNION...

Hi All, I need your valuable inputs about the production change in our database that is affecting reports, the application team has introduced an additional field to the tables in our database, with addition of that field we have to add an additional join condition and there are around 200...

Hi All, I have groupings in my report, one of the groupings is preferred clients which has all the customers and some elite customers, which can be identified based on the elite phone num field if it is null or not, determines a elite customer, I have top 15 clients for which I want to display...

Hi All, I am using Crystal 2011, is there a way to display Value and percentage on the pie chart, I can see the option to display it in the legend, but not next to the pie's, I can just display either value or percent but not both. Thanks for the help!

Hi All, Can this query be further shrinked/optimized? I am getting here the first working day of the month. xxwfs_get_work_day is a function based on a holiday table which returns "1" for a federal holiday, "2" for saturday and sunday and "0" for a working day. SELECT (CASE WHEN...

Hi all, I have these two queries below, I want to substract the qty from the first query from the second, and display the result, what would be the approach I should take? SELECT pos.trade_num, pos.time_period_cd, mkt.quote_def_cd, SUM (qty) FROM pos_20130729...

Hi all, I have these two queries below, I want to substract the qty from the first query from the second, and display in a cross tab, what would be the approach I should take? SELECT pos.trade_num, pos.time_period_cd, mkt.quote_def_cd, SUM (qty) FROM...

Hi all, I have a report with month parameter( (JAN, FEB, MAR ...)String value), users want to see current month as the default value, can this be done? I can leave it as optional prompt, but users want to have that prompt and a default value of current month. Crystal reports 2008, Oracle...

Hi All, I have cross tab report, which is exporting perfectly to excel and excel data only, the only issues I have are, some of the number fields are converted to string some of them are exporting as number, we have to select them and convert in order to do any calculation in the excel, how...

Hi All, I have a cross tab report, which runs for a month data, day 1 to day 30 which is fed by a oracle(10g) stored proc. when I export it as Excel it works, but there are lot of empty spaces and merged columns, but when I try to export it to Excel data only it just throws me an error, cannot...

Hi All, I have a stored procedure, where I have multiple order numbers and amount of orders which I display in the report using a crosstab in the report, I have to display the business days in the report, so I have included the number of days in the data as a row, Now when I pull it into the...

Hi All, I have report, where there are three sections (PO's, Sales and Adjustments), for the first two I am using a union all and getting the data to the report, and the third part is from a different application and data source. PO's have a number associated to it, a link number is passed and...

Hi All, I Have created stored proc where I am passing a parameter value which needs to be appended to the end of the table and executed, this is for a crystal reports application. Another value is passed as a parameter for the where clause. It compiled fine, but it throws error when trying to...

Hi All, I have a crystal report 2011, where user trying to change the parameter values after initial report run (input parameters) and re run the report, but the values wont clear even If we go in to the edit dialog and clear it. and a few parameter values throw this error: 2147024809...

Hello all, I have an issue with full outer join and right outer join options, which is not available to select (greyed out). I am using two separate queries from the same data source, But when I try to do a FULL JOIN or RIGHT JOIN, the options are not available to select they are greyed out...

Hello all, I have an issue with full outer join, which is not available to select. I am using two data sources and I need to bring all the programs from both the data sources irrespective of if they are in the other data source or not, in order to get the desired result I have to use full join...

Hello all, We have an issue with dynamic prompts in our BO setup, When we develop a report using dynamic prompt from repository and once the development is done, we put it in a folder to be promoted to production, when the report is opened by the administrator to test before promoting it to...

Hello all, I have a qustion regarding the crystal using union query. Could anyone tell me, If crystal reports pushes where clause in a union query? Thanks in advance!