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

    Distinct count for inner group

    Never Mind. It's done. Anyway, thanks for your valuable time.
  2. sangisiva

    Distinct count for inner group

    Hi All, I am working with CR10. I have a report which is grouped by country and then by the field Detail. Detail field contains A,B,C,D,E,F,G,H,I. So for all the countries in the group , there will be these detail groups. Is there a way to count the number of records using distinctcount. I...
  3. sangisiva

    Could not find alias names

    But , how the alias names are not shown in the view definition in my schema!? But in the object owner's schema I can view the view definition with it alias names.. Strange !!!
  4. sangisiva

    Could not find alias names

    Hi SantaMufasa , sorry , I should have added it earlier in my post. Yes. The view is not in my schema. It is in another schema. I just have the SELECT permission on the view. After reading your post, I checked in the schema in which the view is created, and awesome, the alias names are there...
  5. sangisiva

    Could not find alias names

    Friends, I just changed the LKBrwnDBA 's script to explain my issue.. This is not the script I am running. I can not post my original query here.. Thats y I have taken the example script. The view which is I am working on is not created by me. It is the existing view in the database.I am...
  6. sangisiva

    Could not find alias names

    Hi all, Thanks for the reply.. Thats what I try to say.. I have never seen a view which does not have the alias names in its select statement but it differs when we select * from the view. for eg, I take the above code ... SQL> create or replace view my_vw 2 as select empno, ename, job...
  7. sangisiva

    Could not find alias names

    Hi All, I have a view in oracle 9i. This view contains totally 550 columns in it. When I refer the view description , I am not seeing any alias names specified over there. But when I select * from the view , I get totally different names... (Should be alias names) Is that possible to specify...
  8. sangisiva

    Crosstab at the Beginning of the report (RH)

    Hi lbass, This is an valuable suggestion. I started forming a query. At present I have completed with first two sections. Working on the third one. Thank you.
  9. sangisiva

    Crosstab at the Beginning of the report (RH)

    Hi lbass, Thanks for the reply. I will try designing the query using union all. Hope the Detail would be just for grouping purpose. Will post my queries as I am working on. Thank you.
  10. sangisiva

    Crosstab at the Beginning of the report (RH)

    Hi lbass, Sorry for the confusion... At very first of this thread I put a generalized question. The report currently I am working on has 9 (unrelated ) detail sections, But the records are taken from one table as I explained in the above post. My queries are : If I use subreports for all 9...
  11. sangisiva

    Crosstab at the Beginning of the report (RH)

    But the drilldown is repeating :-( Any workaround to suppress it...
  12. sangisiva

    Crosstab at the Beginning of the report (RH)

    :-) I made it worked.. The first DetailA section is working now. I placed the formula there in that detail section and in the section expert of the DetailA put the formula in suppress @A<5.. I am working on the other sections to check whether I can have more than one groups in a single report...
  13. sangisiva

    Crosstab at the Beginning of the report (RH)

    I am taking all the records from one table.But the requirement for Detail sections are unrelated. Consider I have a table with fields as Project id Project name Project created date Launch date target launch date stage For the First requirement: A I have filter criteria as All active projects...
  14. sangisiva

    Crosstab at the Beginning of the report (RH)

    Hi, Thanks for the response. Is that possible to have the unlinked tables in a single report... I tried but could not make it.... Any workaround to have unrelated tables in a single report ? I can have the crosstab in subreport... In another report of mine has 9 unrelated tables where I have...
  15. sangisiva

    Crosstab at the Beginning of the report (RH)

    Hi, I am working in CR version 10. I have a report which has two unrelated tables.So I created subreport for the second table. Grouping both the reports by Business Unit (Country name). I have a crosstab which is placed in Report Header. Crosstab contains count of records from both the...
  16. sangisiva

    Migration from crystal report 8.5 to crystal report 10

    What if the report uses some UFLs??? Is that possible to find out in a report whether any UFL is used or not..
  17. sangisiva

    Migration from crystal report 8.5 to crystal report 10

    Hi, I have some reports created in version 8.5 and the database is oracle. Now I need them to be migrated to Crystal report version 10. I tried opening a (8.5)report in crystal report 10. I can open it.But Some reports which has subreports throw warning message, still it opens. What changes...
  18. sangisiva

    Suppressed a detail using formula... need to exclude this on summation

    Never mind. I had to add one more condition (not onlastrecord )with reversed formula condition.... Thanks for your time.
  19. sangisiva

    Count each null in a table

    Hi From karluk code..this procedure would give you total null in the table for all columns... DECLARE TotalNull number(5):=0; column_count number(5); v_null number(5); sqlstr varchar2(300); CURSOR col_cur IS select column_name from user_tab_columns where...

Part and Inventory Search

Back
Top