473,472 Members | 2,038 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Customized Report

32 New Member
Any body help ,

How to create a customized report using jsp
Apr 17 '07 #1
16 1757
r035198x
13,262 MVP
Any body help ,

How to create a customized report using jsp
You will have to be more specific
Apr 17 '07 #2
jegadeep
32 New Member
i have the postgresql database,

based on this i want to create a report in jsp

but the report should be in customized format,

i mean the wanted data only displayed in the report.

how can i create....

You will have to be more specific
Apr 18 '07 #3
JosAH
11,448 Recognized Expert MVP
but the report should be in customized format,
i mean the wanted data only displayed in the report.
How do you want do specify *what* the user is allowed to define for a 'customized'
query result? Should the user be able to specify the 'where clause' of the
'select' SQL query? Should the user be able to enter an arbitrary query?
Should there just be some modifiable ranges on single columns? Should the
user be able to alter the view parts of it all? You should be very specific on
which parts of the query are supposed to be modifiable.

kind regards,

Jos
Apr 18 '07 #4
jegadeep
32 New Member
yes , the user want to customize the report...

just i am display the feilds which are in the table,through this they have to select the feilds and they want to get a report

How do you want do specify *what* the user is allowed to define for a 'customized'
query result? Should the user be able to specify the 'where clause' of the
'select' SQL query? Should the user be able to enter an arbitrary query?
Should there just be some modifiable ranges on single columns? Should the
user be able to alter the view parts of it all? You should be very specific on
which parts of the query are supposed to be modifiable.

kind regards,

Jos
Apr 18 '07 #5
JosAH
11,448 Recognized Expert MVP
yes , the user want to customize the report...

just i am display the feilds which are in the table,through this they have to select the feilds and they want to get a report
Do the users just can select the columns they want to see or are they allowed
to specify the ranges of allowed values too? Or, as I asked before, are they
allowed to specifiy the entire 'where' clause of the sql query? Can they specify
functions on the columns too? (e.g. MAX, MIN, AVG etc.)

If you only want the users to select the columns just issue this query:
Expand|Select|Wrap|Line Numbers
  1. select * from YourTable
and just display the columns selected by the user.

kind regards,

Jos
Apr 18 '07 #6
jegadeep
32 New Member
query is not a problem...

my problem is...

i have two combo box in that the list of table headings are filled...

if the user select the heading from the first combo it will added to the next combo.

at last the number of values in the combo box.... how can i get these values to the next jsp page...

plz help me...
Apr 20 '07 #7
r035198x
13,262 MVP
query is not a problem...

my problem is...

i have two combo box in that the list of table headings are filled...

if the user select the heading from the first combo it will added to the next combo.

at last the number of values in the combo box.... how can i get these values to the next jsp page...

plz help me...
Did you try
Expand|Select|Wrap|Line Numbers
  1. request.getParameterValues("comboName");
Apr 20 '07 #8
jegadeep
32 New Member
ya i tried this already ..

but it showing some incompatible types error



This is my coding

<script>
function MyMoveItem(fro, to)
{
for (var selIndex = fro.length - 1; selIndex >= 0; selIndex--)
{

if (fro.options[selIndex].selected)
{

var newText = fro.options[selIndex].text;
var newValue = fro.options[selIndex].value;
var newOption = new Option(newText, newValue)
to[to.length] = newOption;
fro[selIndex] = null;
}
}
}
</SCRIPT>
<%
String empname=request.getParameter("D1");
%>

<body>

<form method="POST" action="staff_report.jsp">

<table width="917" cellspacing="0" cellpadding="0" border="0">
<td width="251">
<SELECT NAME="sel1" SIZE"10" MULTIPLE size="10" style="width: 250; height: 250">
<%for(int m=0;m<col;m++)
{ %>
<OPTION VALUE="<%= arr[m] %>"><%= arr[m] %></OPTION>
<% } %>
</SELECT>
</td>

<td width="229">
<INPUT TYPE="button" VALUE=" Add " ONCLICK="MyMoveItem(sel1,sel2);">
<INPUT TYPE="button" VALUE="Remove" ONCLICK="MyMoveItem(sel2,sel1);">
</td>

<td width="437">
<SELECT NAME="sel2" id="sel2" SIZE="10" MULTIPLE style="width: 248; height: 248">

</SELECT></td>

Did you try
Expand|Select|Wrap|Line Numbers
  1. request.getParameterValues("comboName");
Apr 20 '07 #9
r035198x
13,262 MVP
ya i tried this already ..

but it showing some incompatible types error



This is my coding

<script>
function MyMoveItem(fro, to)
{
for (var selIndex = fro.length - 1; selIndex >= 0; selIndex--)
{

if (fro.options[selIndex].selected)
{

var newText = fro.options[selIndex].text;
var newValue = fro.options[selIndex].value;
var newOption = new Option(newText, newValue)
to[to.length] = newOption;
fro[selIndex] = null;
}
}
}
</SCRIPT>
<%
String empname=request.getParameter("D1");
%>

<body>

<form method="POST" action="staff_report.jsp">

<table width="917" cellspacing="0" cellpadding="0" border="0">
<td width="251">
<SELECT NAME="sel1" SIZE"10" MULTIPLE size="10" style="width: 250; height: 250">
<%for(int m=0;m<col;m++)
{ %>
<OPTION VALUE="<%= arr[m] %>"><%= arr[m] %></OPTION>
<% } %>
</SELECT>
</td>

<td width="229">
<INPUT TYPE="button" VALUE=" Add " ONCLICK="MyMoveItem(sel1,sel2);">
<INPUT TYPE="button" VALUE="Remove" ONCLICK="MyMoveItem(sel2,sel1);">
</td>

<td width="437">
<SELECT NAME="sel2" id="sel2" SIZE="10" MULTIPLE style="width: 248; height: 248">

</SELECT></td>
Where did you use the getParameterValues method? Remember that it returns a String[].
Apr 20 '07 #10
jegadeep
32 New Member
yes....

i uesd only array..

String[] arrValues[] = request.getParameterValues("sel2");

even though its showing error ...

Where did you use the getParameterValues method? Remember that it returns a String[].
Apr 20 '07 #11
r035198x
13,262 MVP
yes....

i uesd only array..

String[] arrValues[] = request.getParameterValues("sel2");

even though its showing error ...
You put String[] arrValues[] intstead of String[] arrValues. the method returns a 1dim array of the values only.
Apr 20 '07 #12
jegadeep
32 New Member
ya its working....

in this list when i am selected the feilds then only it showing the output...

but i want ..

eg.. five datas moved from the combo to second combo box...

now i want the second combo datas even it selected...

is it possible...

other wise is there any way to pass these values to next page

You put String[] arrValues[] intstead of String[] arrValues. the method returns a 1dim array of the values only.
Apr 20 '07 #13
r035198x
13,262 MVP
ya its working....

in this list when i am selected the feilds then only it showing the output...

but i want ..

eg.. five datas moved from the combo to second combo box...

now i want the second combo datas even it selected...

is it possible...

other wise is there any way to pass these values to next page


Do a select all on submit of the form using a javascript function.
Apr 20 '07 #14
jegadeep
32 New Member
will you send the tag for select all values while submit the form...

this will very helpful for me

thank you

Do a select all on submit of the form using a javascript function.
Apr 20 '07 #15
r035198x
13,262 MVP
will you send the tag for select all values while submit the form...

this will very helpful for me

thank you
It's not a tag. It's a piece of javascript code that you need to write. If you are unsure about it you can ask in the Javascript forum.
Apr 20 '07 #16
jegadeep
32 New Member
thank you ...

i got answer...
Apr 20 '07 #17

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: shovan | last post by:
I am creating a customized Purchase order report using asp. I have developed the reoprt as it is displaying the amount against a sales rep within a specific date range.now values are dispalaying...
3
by: Scott | last post by:
Hi Everyone, Does anyone know if it's possible to allow an end user of an Access DB to personalize the layout of their own reports. What we would like to do is allow them to select the...
3
by: James | last post by:
Does anyone know if it is possible, in C#, to use a customized window frame? For example, programs like Winamp and AdAware do not use the standard box window frame, but a customized design. ...
1
by: Jean Bredeche | last post by:
Hi: I am trying to create customized confirmation/error/etc dialogs in my application. Up to now we've been using MessageBox.Show and passing it the various necessary flags (buttons, icons,...
0
by: segal.aviad | last post by:
Hi, I'm trying to create a customized setup project for my application. I want to write a setup project which will install several merge modules (- this I know how to do). Before running the...
5
by: RedHair | last post by:
I have a ASP.NET 2.0 web page which inherits a customized base page class and have a master page, their relation is as below Customized base page class --> web page --> master page How to...
0
by: Theam Kok Ming | last post by:
Dear All, Good day to you. I have a question. I am a newbie on crystal report with vb.net . I am using VS .NET 2003 and SQL server 2000. I need to build a report by VB.net. I try to search...
7
by: SteveT | last post by:
I would like to create a customized DataGridViewColumn called DataGridViewCheckedListBoxColumn. I'd like the ability to multi-select items in the list. Does anyone know of an example of how this...
6
by: Victor | last post by:
Hi. all I have a customize web control. I have three simple properties and customized render class. then I add this control into my datalist like <asp:DataList ID="datalist" runat="server"...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.