Is your REPORTS60_PATH is set to the folder where you placed the rdf file and bmp file while compiling the report?
Do not use the browse button in Source File property link. type the file name with extension only.
Regards
Krishna Reddy M
mckreddy@visualsoft-tech.com
Hi,
In the property palette of Link File, set the Source FileName to the image file name with out any path information. When ever you are running reports place the rep file and image file in the same folder. It will solve your problem.
Regards
Krishna Reddy M
mckreddy@visualsoft-tech.com
We can pass user defined values to Reports by using parameter form. In some cases we donot want the parameter form to display while running the reports. To suppress / display the parameter form follow the following steps.
I) To supress the Parameter form...
If the above solution given by Dima is not working try the following query.
SELECT TABLENAMES "NAME", NVL(COUNT(TABLEAPPNO),0) "APP NO"
FROM TABLENAMES, TABLEAPPNO
WHERE TABLENAMES.IDEING=TABLEAPPNO.IDERES(+)
AND (VRPT_TABPRO.DATOUV BETWEEN TO_DATE('20040301','YYYYMMDD') AND...
Hi,
Check the following articles on How to use Indexing Service with Asp. These articles will solve your problem to some extent.
http://www.asp101.com/articles/john/indexserver/default.asp
http://www.asp101.com/articles/john/indexserver/part2.asp...
Browse the webform page using http://servername/projectname/webformname.aspx and check the server controls are displaying.
If you opened your webform page in the same way, on the broswer, right click --> View Source. Check the source code any of the <asp:> tags are present. If these tags are...
To Maximize the reports,pass the value 'Yes' to 'MAXIMIZE' parameter while calling the report.
Add_Parameter(ParamlistName,'MAXIMIZE', TEXT_PARAMETER, 'YES');
Regards
Krishna Reddy M
mckreddy@visualsoft-tech.com
Your sql query seems to be correct if the group by clause is present. Test the following three cases to identify the problem.
1. Modify the Where condition as follows and check either the desired records are coming.
WHERE TABLENAMES.IDEING(+)=TABLEAPPNO.IDERES
2. Modify the select statement...
Open the Report. In the reports menu, select Tools --> Prarameter Form Builder.
DeSelect the parameters which does not need to display before report running. Press "Ok". A warnning message displays, Press "Yes" to replace the existing Parameter form.
Select the remanining labels ("Report...
Hi tyb,
Following is the code we will using in Oracle forms to call the report and pass the parameters to report.
This code is written in the form wile calling Oracle Reports.
-------------------------------
Declare
CLIENT_PARAM_LIST PARAMLIST;
lv_vcVariableName VarChar2(50);
Begin...
Its best to move ASP.Net instead of Asp. As ASP.NET has more features and the syntax is similar to Cold Fusion. And have more advantages than Cold Fusion. I worked on Cold Fusion 4.5 version.
To run asp, Internet Information Server (IIS) or Personnal Web Server (PWS) is needed. These servers...
Thanks for the information. The problem is solved by converting into character mode report and setting the layour section. I am generating *.PRN file and using host commond we are sending the output to the printer.
Thanks to all.
Regards
Krishna Reddy M
The first thing to check would be that you have enough temporary space. This error usually occurs if you run out of temp space. Make sure that the REPORTSXX_TMP var is set to a writable dir with lots and lots of space and see if that resolves the problem.
If you are using any gif files in the report remove it and run. There is no support for transparent and interlaced .GIFs over the web. Remove the transparent fill of the GIF file and the report will run.
...In your select statement use that variable as follows. Use the ":" before the parameter name. you can pass the parameter from forms are reports depending upon your requirement.
Select * from TableName where fieldName = :UserParameter
Regards
Krishna Reddy M
mckreddy@visualsoft-tech.com
Hi Shaleen,
Is the query is working without group by function? If not add the goup by clause in the query.
Regards
Krishna Reddy
mckreddy@visualsoft-tech.com
...emp table in scott user. meens emp table is created in scott user.
Step 1.
In your reports sql coding use the following sql statement
select * from scott.emp
Step 2.
give grant permission to all other users for the required objects(tables, views, stored procedures) in the following manner...
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.