Search results for query: *

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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.

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.