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 Chriss Miller 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. chinnaseenu

    error in Framework Manager

    hai i'm just trying to create a sample model. in the process of creating a query subject in the model when i click on 'tables' in perticular database i'm getting the error ------------------------------------------------- QE-DEF-0177 An error occurred while performing operation 'sqlOpen'...
  2. chinnaseenu

    Can Any one tell me about the basics of cognos.....

    Hey , I'm also new to this tool.I can tell whatever i know. This is basically a reporting tool. And within this cognos there are diff. tools like IMPROMPTU--In this we'll develope catalog which is metadata means it stores the table structure and joins b/w them(the tables we bring into catalog...
  3. chinnaseenu

    ReportStudio CAST functions

    i really thank you for your patience and helping me. actually i'm getting that column [DUEDATE] from SQLServer into a tabular model there i dragged 'Dataitem' and in the expression of that i wrote "cast_integer([DueDate])". How should i use convert in reportnet does it work for any database...
  4. chinnaseenu

    ReportStudio CAST functions

    Hai thanx for the reply, but it's working if i give explivitly like'20050816' and it's not working if i send a column from sqlserver data base Cast_integer([duedate]) i'm getting that the function does not exist. QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions'...
  5. chinnaseenu

    ReportStudio CAST functions

    Hai, I've SQL Server Column 'DueDate' that is a string data type but it stores a date value as 'yyyymmdd'(eg:20050816) i want to convert it into integer ,when i use SQLServer function cast_integer([DueDate]) i'm getting the error that the function does not exist. please any kind of help would...
  6. chinnaseenu

    ReportStudio 'date' conversion

    Hai, I've column in sql Server database which stores date in string or numeric field as 'yyyymmdd'.I'm getting that column into report but i want to convert it into date format because i want to compare it to system date (eg:Aug 10,2005). When i use 'date' or 'cast-date' i'm getting error that...
  7. chinnaseenu

    Report Filter

    Hey I just got an idea I don’t know wether it works or not I assumed say 4 classes class xx,yy,zz,mm and 4 students A, B,C,D The data you have is Calss student xx A xx C yy A yy D zz C mm B You want is yy mm xx 1 0 zz 0 0 IF this is the scenario In the query create 2 data...
  8. chinnaseenu

    IWR

    Hey Christenhusz and scottsdale2k Thank you for your replies but i'm not sure how to find appropriate *.utml file(where will it be) and what do i do in there? could you please give it in detail. this is the first time i'm looking at IWR Thank you
  9. chinnaseenu

    IWR

    hai , in the IWR , when the user runs the reports, that are published to the upfront, they are able to save a copy of that report. we don't want the user to be able to have that option,what should i do?
  10. chinnaseenu

    Report Studio - Display Summary Only

    hay Kadet84 try this: in the tabular level in property list left side: for 'town' aggregate function---'none' for calcol1,queryitem1,calcal2 and queryitem2 select the aggregate function as 'total' and now select these in to the query. another way: in the tabular level create 4 data items...
  11. chinnaseenu

    ReportStudio

    Thanx alot Kingcrab. I got that thing related to text item. do u know how to put condition in 'count' function. actually if you don't mind i have couple of more questions. 1) I have 2 pages in a report ,i just want to give the user a chance to go to the page depending on his selection. 2)and...
  12. chinnaseenu

    ReportStudio

    hai, i'm inserting a text item in the page header, i want to assign a query item to that 'text item' but in the property list the 'query item' property does not have any values . how do i assign a query to get those values? and how do i put a condition in combination with 'count'(summary...
  13. chinnaseenu

    page breaks in impromptu

    Hai I have a Report whiche has multiple list frames placed in blank report,user wants to disply some extra content other than table data so how can i add another page (i guess that's called page break) thanks
  14. chinnaseenu

    iwr error

    thank you Draoued. they just rebooted the server ,now it's working fine.
  15. chinnaseenu

    iwr error

    hai, when i try to open iwr service page (u[pfront)("http://iwr/cognos) we r getting error page "An error occurred while attempting to create an authenticator handle. Access Manager: Invalid host or port number. Page generation error while preparing a page based on template: errorpage.utml."...
  16. chinnaseenu

    Dynamically Changing Reports in Cognos Connection

    hey, I think this is Master/Detail type of report which we can create in report studio.i donno exactly how u do it i'm just fresher mine is alll documentation knowledge.
  17. chinnaseenu

    dashbord reports

    hai , i want to know what are dashbord reports and which tool is used to create them. if any one could give that information i would really appreciate it. thanx in advance.

Part and Inventory Search

Back
Top