Search results for query: *

I got two cross tab (Query 1 and Query 2) reports on as single page, how can I get these on two different pages. Does I have to crater a separate page for each report or can I achieve this requirement through page break. Please explain me step by step.

I got a cross tab report with two prompts. One of the prompt is selection of a “Region”, the prompt working perfectly. Now the requirement is to display the Region Selected “as Title of the report. Ex: if user selected “EAST” from as a region in the prompt, Report Title should show as “EAST”. I...

Hi All, Can I delete some Query subjects which are redundant? I’m bit scared because of those query subjects are in the currently published package on which we developed some reports. Even though they are in current package I’m sure we have not used any of those (objects) in our reports. What...

Hi All, I’m new to Cognos report studio, I created a simple cross tab report with Months as columns and sales as rows. Basically it is budget report. Months showing as ‘Jul-08,Aug-08, Sep-08, Oct-08, Nov-08, Dec-08, Jan-09, Feb-09, Mar-09, Apr-09, May-09, Jun-09, The requirement is to show only...

Hi, In one of my report, On open event of the report. Two queries are run to load information from various tables into a dummy table. Then I have a record source for the report in the code. Which is as following: ' Set up Report RecourdSource ' mySql = "SELECT tmpJobAnalysisByMth1.JobId...

Hi, I am using the following code everything is working fine but is running very slow.Could anyone suggest how to improve. thanks in advance AddProgLog "ToGentrack - start" Print #1, "HDR,GENTRACKUPDATE,ENCOMPASS,GENTRACK," & Format(Now, "dd/mm/yyyy,hh:mm:ss") & ",000000000,EncompassLite" Set...

Hi, I have a main report with several subreports.I have totals from two subreports adding up in main report. In the calculated field in control source I am using following code: =[Reports]![rptJobCostAnalysis]![rptJobRep...

Hi, I am having an invoice report. I want to email this report to a customer. I am using SendObject method but when I run the code I am getting an errer "Access unable to open mail session". I am lost don't know what this error mean and what to do to solve this problem.Any help would be highly...

Hi, Can I put this field values in double qoutes in a query ([tlkpStockLocation].[StockLocationID]) & " " &" " ([tlkpStockLocation].[StockLocationDescr]. I am not able to figure it out.Can someone please help me. Thanks in advance.

Hi, I am running the report through form. The criteria is entered in the form and click on button opens the report. On the open event of the report I have following code. The problem is when the job status is Selected as "Accepted" nothing comes in CFAR field but when Job status is selected as...

Hi, I have a form that should open blank but users should not enter anything in fields except the filter fields. When we move to next record it should be editable. I am using following code but still when form is opened users are able to enter. Could someone tell where I am doing wrong. Thanks...

hi, I use Access 2003 as backend and frontend. By accident the file name for frontend is changed.Now I am not able to open.Is there a possibilty of retreving the file(.mdb). Please someone help me urgently, the help would be highly appreciated. thanks in advance

Hi, we use access 2003.I have a report-- "payment report" which works fine. I have 10 users. only one of the user when runs this report gets Pounds sign instead of $ sign. Also strange thing is for few columns the user gets pounds sign and for few $ sign. I am totally confused and lost.No one...

Hi, I have main report with subreports. One subreport in PageHeader, 3 subreports in detail section and 2 subreports in Report Footer. Everything working fine. My problem is when report is printed subreports of Report Footer are not being printed. I tried to print last page of the report but no...

hi, I am using Access 2003 in a multiuser environment. we have 10 users. 1-5 users should be able to look everything on the application but other 6-10 users need to be limited to few objects in the application. I think I need to create low/Row level security when users from 6-10 logs in, all...

hi, I am new to Project.Is it possible to lock some of the fields and leave some fields for update in a project. Information on this would be appriciated.Thanks in advance.

hi, I have Main report with 4 subreports in detail section and 2 sub reports in report footer section. When I run the report I can see all the information but when I print only upto to detail section is being printed.I tried placing sub report from the footer to detail section but still not able...

Hi, I am using sample code of ( Call the standard Windows File Open/Save dialog box. ) to open excel file from access form. I am getting open file dialog box and able to select the file but I am not able to open the file. After selecting file when I click on open ,dialog box is closed and file...

Can someone please elaborate Acrobat Distiller? I am not familiar with this -- How do you print to this and then save as a .pdf?

Hi, I have a TimeSheet table with WorkerName, date, Hrs, Job No. as its fields. For Example, the table has the following data: WorkerName date Hrs JobNo A 28/6/04 8.5 1 B 28/6/04 8.5 1 A 29/6/04 8.5...