Search results for query: *

Hi Guys! I successfully moved crosstab2 from page1 to page2 – just cut and past from page structure view. When I try to print (PDF) the report (crosstab1 on page 1), same report printing on 10 pages instead of printing on one page. I tried to look at report pages option under page explorer, I...

Hi guys, Thanks for your advise, still I’m not sure how we can move second crosstab to new page. As advise: 1) I crated a new page (Page2) 2) and add “Layout Component Reference” 3) Gives me option to copy second crosstab to page 2 my understanding is this option is only reference to my...

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.

Thanks Ties -- a STAR for you

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 Ties, That sounds safe to me. Once published a new package with different name, how to switching existing report to Newly Created package. It may be silly question -- for me every thing is New in Cognos. vani

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 almeids / Ties blom Thanks for your response, still the case statement not working in “Filter” - complaining the following Error. but the same statement works on SQL editor, don’t find the reason. . Could you please explain what the meaning of this error. CASE substring([Month],1,3) When...

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...

...& Format(Now, "dd/mm/yyyy,hh:mm:ss") & ",000000000,EncompassLite" Set cnn = CurrentProject.Connection sSQL = "SELECT * FROM FromGentrack " & _ "WHERE EXISTS (SELECT 1 FROM FromRegistry WHERE FromGentrack.ICP = FromRegistry.ICP AND FromRegistry.RType = 'STATUS')" rs.Open sSQL, cnn...

Hi Remou, I was away just back to work. That was wonderful I have been missing all the time. Thanks for your pointing the error.

Hi THWatson, I tried using following but still getting #Error# in the field. =[Reports]![rptJobCostAnalysis]![rptJobRep: Expenses].[Form]![ExpenseTotals]+IIf([JobSheet].[Report].[HasData]=-1,[JobSheet].[Report]![Text19],0) Could you please point me where I am doing wrong. Thanks

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 was away for holiday. Thanks for the reply. we use Microsoft Office Outlook.

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 PHV, That worked great. Once again thanks for your help.

are you sure it is happing to all documents as default?

Hi, Thanks for immediate reply. I came back today and used what PHV suggested. [tlkpStockLocation].[StockLocationID] & ' - "' & [tlkpStockLocation].[StockLocationDescr] & '"' I am getting 1234 - "ShelfOne" but I need "1234" - "ShelfOne"

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.