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

Hi Dave. If you dont mind teling how much did you pay and where exactly is this facility in Philli ? M.Bajwa http://www.nextgenlogic.com/bajwa

thanx guys. I tested and tried all of the solutions and they work as described. FYI . I have decideded to use Catadmin's solution for my final solution. M.Bajwa http://www.nextgenlogic.com/bajwa

ok. a little deviation here. thanx jbenson001 for the solution but heres what the thing is I have a sproc that is passed a parameter exec RefSearchHeader '102426,102424,102424' now I can query a dictionary table to get descriptive values of these parameters and that is actually what i want...

no limit. but they will alway sstay less than 100 i guess u are pointing to the total limit of the string that is going to hold these values. right ? what is the limit anyway. is it 8000 ? 8000 is good enough for me M.Bajwa http://www.nextgenlogic.com/bajwa

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

Well . firstly I use impromptu and have never used report net. But here's what I think about your idea. Like you say , 300 different answers cannot be put in a pie chart and even if they could be , there would be no point in doing so . You could simple do a select distinct and get all the...

I scheduled the audit , where would it dump the info too ? M.Bajwa http://www.nextgenlogic.com/bajwa

Thanks Gary, you answered my question in the first part pf your post. In the second part when you say, "not always", how often do you think that is the case ? M.Bajwa http://www.nextgenlogic.com/bajwa

Im a newbie too ! First I would advise you to post the full info of what report you are going to make ? Is it an Impromptu report or ReportNet? what cognos version are you using? M.Bajwa http://www.nextgenlogic.com/bajwa

oi just cant stop asking questions.lol so I was in the schedule window and the other schedule option available was "Collect Audit Data" Do any of you guys use it ? Is it any good ? I am guessing it would help to know which users run which reports and what what frequency ? Am I right ? M.Bajwa...

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

thanks guys. I have now scheduled the cleanup. Just for informational purposes. would this cleanup clean all reports that are there or leave the reports that have actually been saved by users ? M.Bajwa http://www.nextgenlogic.com/bajwa

if u want to try .. grab crss.exe from another pc where notepad works fine and paste it in ur pc. just a thought ! M.Bajwa http://www.nextgenlogic.com/bajwa

hey tsuji i used forfiles which worked great. but how do i delete the subfodler in the directory which are also older than x days M.Bajwa http://www.nextgenlogic.com/bajwa

put a shortcut on ur taskbar in the quick launch taskbar.. that way u wont have to minimize programs to click on the notepad icon. M.Bajwa http://www.nextgenlogic.com/bajwa

good suggestion longhair.. thanx. P.S mbusa is definately a *HIM* & proud of it :P M.Bajwa http://www.nextgenlogic.com/bajwa

thanks for the response. i am now looking into a script for the periodic cleaning. I guess it would be a batch file that would run monthly and delete all files that are more than a month old.( it would still delete reports that are more than a month old and users have saved them) Let me know...

thanx bill & longhair. great resources.. M.Bajwa http://www.nextgenlogic.com/bajwa