Hi All,
I created a stored procedure with parameters in package, i used that stored procedure in crystal Reports XI..till now its working fine.
Now i need to retrieve a report based on Parameter range values..
My question is:
Is it possible to assign Ranges to Parameters? Bydefault Ranges should be NULL. I have to enter Range values from webpage.
This is my stroed Procedure which i used without Range values:
I need Range values for Begin_Date Parameter.
procedure Select_Budget(p_PK_Budget_Header_Id IN BUDGET_HEADER.PK_BUDGET_HEADER_ID%TYPE,
P_BEGIN_DATE IN BUDGET_HEADER.BEGIN_DATE%TYPE DEFAULT NULL,
RETURN_CURSOR OUT type_pkg.ref_cursor_typ) is
begin
OPEN RETURN_CURSOR FOR
SELECT
BH.PK_BUDGET_HEADER_ID,
BH.FK_BUDGET_MASTER_ID,
BH.BEGIN_DATE,
BH.END_DATE,
BH.COMMENTS
FROM BUDGET_HEADER BH
WHERE BH.PK_BUDGET_HEADER_ID = nvl(p_PK_Budget_Header_Id, BH.PK_BUDGET_HEADER_ID)
AND BH.BEGIN_DATE = nvl(p_BEGIN_DATE, BH.BEGIN_DATE);
end Select_Budget;
I think this is clear for you, if not i am ready to give you clear idea..
Thanks in Advance
5 2858 Saii 145
Expert 100+
If your requirement implies that begin date should be between some start date and end date then you need to have two IN date parameters
Thanks for your quick reply saii..appreciated.
you said i need to have 2 IN date parameters..
If suppose my user needs Ranges for some other parameter (like datatype as Number -- ex EmpNo), Then also i have to use 2 IN parameters?
Previously, I generated Reports using simple tables, there i didn't get this problem.Why because, in Crystal Reports 1 option is there"Allow Range values -- True/False".
By setting 'True ', 2 different boxes are displayed (to enter start value and end value).
While coming to stored procedures, by default that option is set to 'False'.
I thought we have to set Range values to true/false while passing parameters only..
Its possible or not i don't know..
i am searching in this way...
Is there any other way for this problem?
Thanks in advance
Thanks for your quick reply saii..appreciated.
you said i need to have 2 IN date parameters..
If suppose my user needs Ranges for some other parameter (like datatype as Number -- ex EmpNo), Then also i have to use 2 IN parameters?
Previously, I generated Reports using simple tables, there i didn't get this problem.Why because, in Crystal Reports 1 option is there"Allow Range values -- True/False".
By setting 'True ', 2 different boxes are displayed (to enter start value and end value).
While coming to stored procedures, by default that option is set to 'False'.
I thought we have to set Range values to true/false while passing parameters only..
Its possible or not i don't know..
i am searching in this way...
Is there any other way for this problem?
Thanks in advance
Well in case of empno, if you dont want to have two INPUT parameters, then you can have one VARCHAR2 parameter which will accept the range value with some delimiter.
For Eg: I pass the value to the input parameter '10-20' which means I want all the employees whose empno is between 10 and 20.
Then you can extract the FROM and TO values using a delimiter.something like: -
select SUBSTR('10-20',1,INSTR('10-20','-')-1) FROM dual -- This query will give you value 10
-
Thanks for you reply,
I think i didn't understood your reply clearly..
I have to enter Range values from my webpage. I don't want to pass those values directly, i think you understood this.
any suggestions please?
Thanks
Thanks for you reply,
I think i didn't understood your reply clearly..
I have to enter Range values from my webpage. I don't want to pass those values directly, i think you understood this.
any suggestions please?
Thanks
If you are going to pass the RANGE values (HIGH - LOW) seperately then you need to go for two IN PARAMETERS
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Massy |
last post by:
Hi
I have created a date-range parameter in crystal and i wanted to display the value of what the user has chosen in the title of the report
I have dragged the parameter onto my report but when...
|
by: Betrock |
last post by:
This is probably very simple, but I just can't see my way thru it.....
Short version: keyed values(numeric)in a lookup table are stored in a
main table. They are displayed as text values - the...
|
by: Andy Davis |
last post by:
I have developed a number of reports that are based on parameter queries
where the user enters criteria such as a date range and a sales rep say. I
want to be able to show a graphical picture in...
|
by: Erwin Bormans |
last post by:
Hello
I want to make a parameter query where i can select the parameter out of a
drop down box instead of typing the parameter in a text box.
For example: if i have customers and want to run a...
|
by: PK |
last post by:
Hi, I have an application that opens a Crystal report document and
passes in a value to a parameter in the report (pointing to an Oracle
DB). However, if I want to pass a "null" value to retrieve...
|
by: Mike Bridge |
last post by:
I'm getting a nonsensical error when binding a DataTable with one row
to a DropDownList.
The DataTable's row contains the fields "id" (INT), "description"
(VARCHAR) and with a couple other...
|
by: Todd Perkins |
last post by:
Hello all, surprisingly enough, this is my first newsgroup post, I usually
rely on google. So I hope I have enough info contained. Thank you in
advance for any help!
Problem:
I am getting...
|
by: darrel |
last post by:
What does this error mean?
Specified argument was out of the range of valid values. Parameter name:
value
System.Web
It's being thrown here:
DDL_SubCategory.Enabled = True...
|
by: Chapi |
last post by:
hi, i'm having problems with a datagrid paging.
it's populates fine, but when i click the paging button appears this
error:"Specified argument was out of the range of valid
values.Parameter name:...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
|
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...
|
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...
| |