Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. devnaren

    How to move Foxpro data to SQL Server tables through SSIS

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

    Problem while creating measure objects in Universe

    Thanks guys for your valuable answers.....
  3. devnaren

    Problem while creating measure objects in Universe

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

    How to validate the result from BO by writing SQL in toad

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

    How to validate the result from BO by writing SQL in toad

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

    How to validate the result from BO by writing SQL in toad

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

    Displaying the Qtr on Page Header

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

    Chart Problem

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

    Help with the percentage in Crosstab

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

    Stacked Bar Chart Percentage Problems

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

    Stacked Bar Chart Percentage Problems

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

    How to pick date from a text?

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

    Counting Issue

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

    Chart Issue

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

    How to pick last word from a text

    It works perfect. Thanks a lot Lbass.
  16. devnaren

    How to pick last word from a text

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

    Question about Cross Tab

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

    Question about Cross Tab

    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"...
  19. devnaren

    Months(which has no data) not displaying in chart

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

Part and Inventory Search

Back
Top