Search results for query: *

Hi All, I am using SQL Server 2K5. I am new to SSIS. I want to create a package where i want to move foxpro data to sql server database tables on daily base. Can anyone help me out how to create a package and how to import data to sql server database.

Thanks guys for your valuable answers.....

Hi All, I am trying to create measure objects using Business Objects Designer to get Beginning Balance and Ending Balance for a yearperiod in general ledger reports I coded in such a way that: Beginning Bal:(measure object) select sum(bgbal) where <here i dont know what to written here>...

Thanks. This example will give me an idea of how to validate my queries.

Hi All, Using BOXIR2 I Have a Question regarding how to write an SQL in toad to unit test my Data generated by WEBI. I have two Queries(Query1 and Query2) and I used merge dimensions on the common dimensions. But i want to know how to write a SQL in Toad to validate my results. Data is...

Hi All, Using BOXIR2 I Have a Question regarding how to write an SQL in toad to unit test my Data generated by WEBI. I have two Queries(Query1 and Query2) and I used merge dimensions on the common dimensions. But i want to know how to write a SQL in Toad to validate my results. Data is...

Hi All, Using CRXIR2. I created a report in which it displays Rec #, Qtr,........ Report is grouped by Rec#. It gives result as follows: Rec # Qtr .... .... 001 Q2 .... .... 010 Q1 .... .... 100 Q3...

Hi All, CRXI I created a report in which lists total number of parent records in main report for each quarter. Now to get the child percentages based on parent record, i created a subreport, On Selection Expert, I'm using {@DateCreated} in {?Start Date} to {?End Date} and {Field.S_VALUE} in...

Hi All, Is this possible to show the same values on the Chart.

Hi All, I was not able to find the solution for this, if any one know about this issue let me know.

Hi All, I'm using CRXI. I created two stacked bar charts and inserted on the GF which is grouped by Name. So first chart will show the percentage for each qtr which as follows: 2007q1 2007q2 ............... 100% 0 100% 0...

Hi All, I'm using CRXI. I have text which is coming from one field and i want to pick date from tht text. for eg: Date Entered: Since 01-Jan-2008 05:00 AM GMT; Records included Above text from Date Entered to Records Included coming from one field. Now i want to pick just...

Hi All, I'm using CRXI and Oracle 9i. The problem is I am trying to count the no of records of certain event which occurs after another event. Each event is accompanied by date. Lets say event “abc” occur on 27th of Dec and event “xyz” on 31st of Dec. Now the “xyz” event can occur...

Hi All, I'm using crystal XIR2 with Oracle. I created chart in which x-axis should show up the Q1, Q2, Q3 and Q4. If there is no records in Q3, then it shows Q1, Q2 and Q4 on x-axis. My question is if there is no records fall in Q3, still i want to display that qtr on x-axis of the chart.

Thanks guyz

It works perfect. Thanks a lot Lbass.

Hi All, I want to write a formula in such a way tht it should pick last word from a text. for eg: "AccNo/100045/DVS/John Smith" Now I want "John Smith" from above word. Can anyone help me out how to get tht word from a long text.

No. there is no column which resulting in 1-4 qtrs. But tht i declared if the condition satisfies then it show up as "Nm1" ........... So I'm trying to put three different conditions within one formula so tht it should combined all three subreport values into the summary table.

Hi All, I created three different subreports in which I inserted cross-tabs. Formulas which I'm using in sub-reports are as follows: subreport1: Rows: <Name> Columns: @Summ1 Summarized Fields: Percentage of Distinct Count of <ID> @Summ1 = If not({field.value} in ["a"...

Hi All, I am using CRXI with Oracle 9i as backend. I created a report in which i inserted a Line chart in it. On x-axis, i am using months and on y-axis, sum of products. Now when i am running this report its not showing up all the months in x-axis, its showing only those months which have...