Recent content by TechAbhiVaray

I found a cheat for this. I added a date data item to the query and added that to the 1st page. Then all i had to do is create a drill down and add that as a bookmark to my remaining pages. Works wonderful now!

All, I have a report with few hundred pages and the report output is in .pdf . I would like the end user to be able to click on a hyperlink at the end of page to go back to the 1st page of the report. Is there a way to do this in Cognos Reporting Studio 8.4. I have tried using bookmarks but...

All, I have 6 queries in the report, with a date prompt with range; Three of those queries are grouped by date, hence i need the date range for those 3 queries. However the other 3 only requires the last date from that range. I have tried a range of options like maximum(date), however it still...

I have a peculiar issue where the report has a date prompt. Ex: 09/30/2011 and i have specified a filter to display dates from the 1st day of the month to the date prompt. Filter: [Report Date] >= _first_of_month (?Report_Date?) and [Report Date] <= (?Report_Date?) The next step was to sort...

Hello gmmastros, Side Note - To add the time portion to the date value it's not required to use any explicit conversion. The implicit conversion will "recognize" the format. This is what i got when i ran the query you presented: XYZ 2010-08-19 09:42:00.000 2010-08-19 09:57:00.000 2010-09-03...

Hello All, I have a table with following data EMPLOYEENAME, EMP_ID, CLIENTID, BEGINDATE, STARTTIME, ENDTIME, SIGNDATE, SIGNTIME ABC 123 131 10/16/2009 11:00:00 12:30:00 10/18/2009 13:11:00 ABC 123 132 10/15/2009 14:00:00 15:30:00 10/16/2009 11:10:00 In he earlier two lines you can see that...

Hello All, This is what i have so far: im oFS, oFolder set oFS = WScript.CreateObject("Scripting.FileSystemObject") set oFolder = oFS.GetFolder("C:\inetpub\ftproot\photos\") ShowFolderDetails oFolder sub ShowFolderDetails(oF) dim F wscript.echo oF.Name & ":#Files=" & oF.Files.Count...

I have a table which i have stored as a csv in the Data Flow task. Now i am trying to upload this csv to a FTP Server. I was successful in storing the file in csv but the FTP Task is not working. I have the server name, the username and password and also the root folder. Can anyone help on this?