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...
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 !!!
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...
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...
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...
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...
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.
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.
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...
:-) 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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.