Search results for query: *

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

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

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

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

Hi , I got the solution. Thanks GP

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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