Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vani65

    Separate page for each Report

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

    Separate page for each Report

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

    Separate page for each Report

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

    Delete redundant Query subjects

    Thanks Ties -- a STAR for you
  5. vani65

    Display prompt value (text) as Report Title

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

    Delete redundant Query subjects

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

    Delete redundant Query subjects

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

    Half Year Filter

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

    Half Year Filter

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

    Record Source Problem

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

    Module code running slow

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

    #Error# in Calculated field

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

    #Error# in Calculated field

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

    #Error# in Calculated field

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

    URGENT HELP---error in sending report thru email

    Hi, I was away for holiday. Thanks for the reply. we use Microsoft Office Outlook.
  16. vani65

    URGENT HELP---error in sending report thru email

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

    [b]Concatenation of values[/b]

    Hi PHV, That worked great. Once again thanks for your help.
  18. vani65

    Query Options - "Do Not Retrieve Data"

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

    [b]Concatenation of values[/b]

    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"
  20. vani65

    [b]Concatenation of values[/b]

    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.

Part and Inventory Search

Back
Top