Search results for query: *

When I drag and move around text and text boxes in impromptu reports , i cant seem to place them exactly where i want . They seem to stick to some grid and the movement is not smooth. Is there anyway i could press some shortcut and do it. I know in MS word you can press ALT or shift to drag...

suppose select * from bajwa outputs os2 ds3 of4 as5 os9 How do I change the query to putput all the values in a single line of type varchar with commas in between the values os2,ds3,of4,as5,os9 M.Bajwa http://www.nextgenlogic.com/bajwa

I have a couple of impromptu reports on upfront that I need to output in excel format only. When the reports are run they automatically open up in excel. I want the "save dialog" to show up right after the report is run so the user first saves the file on his own PC and then he can open it...

When uses run reports from upfront the coulmns in the pdf reports generated are sometimes not wide enough to show all the text and it cuts the text. How can I get these columns to automatically adjust. I dont want wrapping. M.Bajwa http://www.nextgenlogic.com/bajwa

I dotn know if this is the right plaxe to post this but here we go ! I have folder with about 100 files. I need a batch file which would check to see which files are more than a month old and delete them leaving the fresh files intact. any ideas ? M.Bajwa http://www.nextgenlogic.com/bajwa

We allow users to save cognos reports under their personal newsboxes in upfront. The server hard disk is running out of space now as there are tons of reports saved. How do i decide which ones to delete. Where exactly are they saved. How do I know which file was saved by which user ? So far I...

currently we use the LAE file to authenticate users - users and groups) and then they are required to log in with a username and password - we would like to change this to active directory, where they are automatically authenticated because they have already logged into their pc and we know who...

We are currently usedin cognos impromtu for ad hoc reporting. I have several users who want to make their "personal newsboxes" . Even though I have specified in the Access manager that these users cannot create their personal newsboxes they still get the option. NEW--> NEWSBOX If they click on...

I have a pivot table where the user can pivot on a field that has dates. Right now the dropdown shows all the available dates. I need to change that to like a month o year range which the user could select. I think I can group on that field but Cant figure out how to do so. Any comments/...

I am an intern right now and there are a couple of full time positions posted on our corporate intranet website which I would like to apply for. First I would like to know who the best person is to talk to if I want more info about these positions. Would HR tell me what the exact pay of this...

I need to dump data from a database to excel pivot tables for Business reports. I have never worked with them before so was wondering where to start off from. The simple tutorials on the web dont seem to be of much help. Can anyone suggest a good book about Pivot Tables. An online guide would...

I have just got dsl service through centurytel and want to know how to configure my DLink wireless router DI 524 with the netopia DSL modem. I have tried configuring the router with the pppoe and tried to put my dsl username and password in the dlink config but it still doesnt work. Any ideas ...

I have a stored procedure which needs 2 parameters: Status and Substatus The parameters are passed from a webpage where a user can choose from the available status/substatus e.g if a user chose status 10 substatus 20 , the string to be executed will be execute...

I have a simple sql statement which i use to populate a selection list in a webpage. The SQL statement returns a NULL too which i dont want to show up in the selection box. So I want that Null value to be replaced by any text string . lets use "blank" for now case when...

So I have some impromptu reports which have the user pick some criteria in the power prompt apps. How would i get this selected criteria output in the final report too like in the header to let the user know what he actually chose. M.Bajwa http://www.nextgenlogic.com/bajwa

We have a Large Datadump and we are usign pivot tables to allow users to look at the data from different perspectives by pivoting the data on the numerous fields. I was wondering if I could transfer this data dump pivot table into a cognos report. is that possible at all ? We are currently...

I am reporting off from a SQL server. A user wants a data dump of the all the records and it takes about 2-3 minites for the query to run in query analyzer. I have been asked to create a 'job' which can be scheduled to run at certain intervals and dump all the required output to an excel...

I was wondering if there was a way I could make a power prompt run more than 1 cognos report. The ideal situation would be where the use hits a button , e.g Run REPORT in the power prompt app and then both the cognos reports are run and their output is stored on a shared drive on the network...