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!

Register Log in
  • Congratulations derfloh 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. Iloveoracle

    How to display BLOB file of type pdf or doc or jpg or gif in report

    Hi , In one database table we have one column named file_content is having BLOB and other column is having file_name .This file_name is pdf or doc or gif or jpg. I have to display these files in the report by using paramete ID.For example If I give id='SMMXX' then it has to display the...
  2. Iloveoracle

    how to create matrix report to display daily details

    Hi, I am trying to create a report which is having parameters STARTDATE and ENDDATE. For example if STARTDATE=01-Feb-07 and ENDDATE=10-Feb-07, then we have to show the details in the report like "SYS_ID,PART,02/01,02/02,02/03,02/04,02/05,02/06/,02/07,02/08,02/09,02/10" Basing on...
  3. Iloveoracle

    how to use IN clause in the report query

    Hi, I designed one simple tabular form report.It will take list of values and displays their details. For example we will consider emp table,my sql query is "select * from emp where empno in ('100E','1002E', '1003M','1004S','1005H')" This query will retrive all details basing on the IN...
  4. Iloveoracle

    FOOTER SECTION BLANK AFTER SOME PAGES IN A REPORT WITH MANY LAYOUTS

    Hi , I have a problem with footer frame.The 4data field values in the footer frame will display in each page at the end of the page.But in my report only 3 values are coming in all pages,one value i.e approved_date field ,not showing in the last page .My report design will give multiple...
  5. Iloveoracle

    How to display footer section at the end of each page in the report

    Hi , I got the solution. Thanks GP
  6. Iloveoracle

    column header is repeating for each row in the table

    Hi , I designed a report to display the details for a given parameter list.In my report some part of data looks like a table with dynamic number of columns and rows.Actually if I am trying to creat a matrix report by using single query ,it will ask cell,row and columns fields. but now i have...
  7. Iloveoracle

    Can we match the parameter in two diff. parameter lists at runtime

    I designed one report ,it displays all parts under perticular system_id.For example system 1171 is having 3 parts. That means 1171 is the parent and 21851 with part I,21852 with partII and 21853 with partIII are the 3 children under parent 1171. Similarly parent system_id 441 is having only one...
  8. Iloveoracle

    Can we match the parameter in two diff. parameter lists at runtime

    Hi, I designed one report with two parameter list.The report will take list of system_ids and list of part_ids .For example in my report I want to display multiple reports for system_id=1171 & part_id=III and system_id=441 & part_id=I and system_id=15871 & part_id=I and...
  9. Iloveoracle

    How to display footer section at the end of each page in the report

    Hi , I designed one report with one main repeating frame ,is having bunch of frames and repeating frames inside .It displays the header and body part of the report.I have one more repeating frame at the bottom,I created this bellow the margin.Bec. I have to show this footer section in each...
  10. Iloveoracle

    report with group by and order by

    Hi, I got the solution,its working fine now. Thanks GP
  11. Iloveoracle

    how to show spanning rows in the dynamical table format in the report

    I am giving more information regarding to the above problem. I have a column called colspan in the database table.If colspan=2 means the cell value in that row is expanding between column1 and column2.if colspan is null means the cell value is in the corresponding row and cell only.Can any...
  12. Iloveoracle

    how to show spanning rows in the dynamical table format in the report

    Hi, I designed table format by using matrix query.The table structure comes dynamically ,its not fixed.table is having diff. number of coulmns and rows depending on the parameters we are passing.Now i can display table with columns and rows.But the problem is some rows are spanning between...
  13. Iloveoracle

    how to supress duplicate values in the feild

    Hi Timo , Thanks for your quick response.Its working now.Really you saved my day. Thanks GP
  14. Iloveoracle

    how to supress duplicate values in the feild

    Hi Timo, I think Group left won't work here.Problem is I have to display data order by display_order.If i make this group by it will display order by organization not by display_order.I think I didn't explaion properly,right now data in the databse is not in the order ,actual data in the...
  15. Iloveoracle

    how to supress duplicate values in the feild

    Hi , I am giving one example to explain my problem.For example I have one table called social_behavour,wich shows the people list according to the organization and location. ID ORGANIZATION LOCATION NAME DISPLAY ORDER --- ----------- --------- ------ ----------...
  16. Iloveoracle

    report with group by and order by

    Hi , I changed everything to none except col5.But now I am getting error message like "Group G1 has no break columns".I have 3 groups like MAIN,G1 and G2.MAIN is the starting group.G1 is the group with col1 and col2.G3 is having col3,col4,col5. thanks Praveena
  17. Iloveoracle

    report with group by and order by

    Hi, I have to display one tabluar form report with 5 feilds.For example col1,col2,col3,col4,col5.The report shold be group by col1 and col2 and order by col5. Problem is any one of these cases is working .If Iu se simple query it gives order by col5,but col1 and col2 also displaying many...
  18. Iloveoracle

    Bottom line of the table in the report is not showing the weblayout

    Hi , I have a problem with table border in the report.I was created one matrix query,which is having dynamic no. of rows and columns. depending on the parameters .Here I am getting the data in the correct format.But problem is bottom line of the table is missing when i open this report in...
  19. Iloveoracle

    Problem in creating matrix query in the report.

    hi, I changed horizontal and verical elasticity for the column ,but problem is if horizontal is fxed then,the string not looks nice.It wraps too much.Even outer frame and repeating frames are having either variable or expend elasticity,still the table columns are not expanding . Thanks...
  20. Iloveoracle

    QUERY RETURNS ZERO RECORDS

    Hi, I got solution.I created formula column instead of summary column,then i wrote condition on title.Its working fine. Thaks gp

Part and Inventory Search

Back
Top