I have defined a default values for the parameters as '*'
and set description to 'All' so usere chose * for all values and it's pass as '%' in the Show Sql.
Thanks,
Ratna
This is in record selection:
(
{VW.requested_date} in {?start_date} to {?end_date}
)
and
(
{VW.line_id} like {?line_id}
)
and
(
{VW.location_active} like {?SL_STATUS}
)
and
( if {?customer_id} <> 0 then
{VW.customer_id} = {?customer_id}
else
if {?@customer_id} = 0 then
true
)
This is in...
Yes! you are right, lbass. But this record selection would not be passed to the sql where clause in the Show sql option. My question is there any alternate to this as I can pass the string parameter to the "where clause" in the sql using "Like". Not sure how I can do for a number parameter...
Hi,
I like to clarify doubt, As I read few articles here it says filter condition should appear in the show sql to speed up the report.
When using record selection to intergate parameters in the report and that will show in the show SQL where clause. But when the parameter is quered for ALL or...
Thank you. I figure another work around. I was try to strip the acct so I can join this accstrip to another table where the acct number is base by ppid(pipe id) that is what AAA, BBB, and CCCC are. They have different formats of acct num base on the pipe id. So, I was checking against the pipe...
Hi,
I am using a case statement and hard coding it before but want to change this to do dynamical. But how can I do this when I have more than one value.
Intial I did this Hard coding in the case statment in my select clause as
AcctStrip =
(case
when ppid = 'AAA' then substring(acc_num...
If you are using Oracle as a database may be you can get the results in ranking format and then display on the report. Hope this helps or leads to another idea. I just copied the below from a Oracle site
RANK [Oracle SQL analytic function]
RANK is an analytic function that can be used to...
Try this and hope this helps you
1st report
patient number like '%HS%'
2nd Report
Patient number like '%D%'
3rd report
not(patientnumber) like '%HS%'
and
not(patientnumber) like '%D%'
I have a .dat file and the data from the file is loading into few tables and there are few .sql file to be run to update or merge data into few other tables.
How can I use a batch file to run the batch script from window and not save or hard code the user/password in the batch file?
Can I...
I did try to create a query.
But how can a user click on a button and get the data refresh.
This is what i need..on a worksheet
created a button captioned as "Click to Refresh Data"
now when the user click the button. it should connect to the db and refresh the data for the following query...
I really apperciate your help..
I am a dummy what do i do next after the external data
I choose the data source(odbc) and selected the table and field and filter I needed. The excel print the columns for the query. What do I do next to create a macro?
Hi All,
I have never done this before nor have any clue about how I can do this
I have to create a macro to refresh the data of the Sql query I have.
I will have to create a button which says "Refresh" and then when a user click the button the data should get refreshed for a sql query.
Say...
Can't we create a macro connect to a oracle db and then using the sql query to refresh the data when a refresh button is clicked ?.
I tried to create a MS query using "get external data"
Thank you,
Sameer
Hi All,
I have never done this before nor have any clue about how I can do this
I have to create a macro to refresh the data of the Sql query I have.
I will have to create a button which says "Refresh" and then when a user click the button the data should get refreshed for a sql query.
Say...
Using CR 10 and Oracle database
I have a report with a ?Id as a parameter with a "Allow multipe values" and "Discrete value" option.
My user enters the ?id everyday when runs the report. Can I save the values enter for that day and until the next day the user changes the list of values or just...
I tired what you said. But 3 pages one for main report 2 for the comment box on the subreport and 3 page when the data for the subreport.
if the supreport as no data then it prints 2 pages one main report and the other is blank page. I tried all the suppress blank space and even the suppress...
Let me try explain it again. I guess I have not made myself clear.
In the main report in report footer I have 2 section RF-A and RF-B.
RF-A I am using a Comment box. which should display when the subreport generates any data.
RF-B should start on a new page when the subreport generates data...
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.