Search Results | SQL Server Performance Forums

SSRS - automatically Execute & Save a report with Web Services using VBscript

Thread by: Ismailc, Jan 15, 2010, 1 replies, in forum: SQL Server 2005 Reporting Services

Good day, I need help. Not sure what i'm thinking is possible. I recently updated a Sharpoint List using Web Services with VBscript. I would like to...

Update a Sharepoint List in SSIS (Web Service)?

Thread by: Ismailc, Jan 7, 2010, 1 replies, in forum: SQL Server 2005 Integration Services

Good day, I'm trying to update a Sharepoint List withh SSIS (Web Service)? I tried using Web Services with vbscript/javascript but struggled for...

SSRS automatically run report & save pdf output to c:

Thread by: Ismailc, Dec 1, 2009, 3 replies, in forum: SQL Server 2005 Reporting Services

Good day, I need help. I normally run a report via url and add the &rs:Format=PDF to open file directly in PDF format. But i now need to...

Textbox with table next to it and 1st value is on next row.

Thread by: Ismailc, Nov 2, 2009, 7 replies, in forum: SQL Server 2005 Reporting Services

Hi, I need help. I have a textbox with a one column table next to it:textbox1 : table1 col1but reslt will display Textbox1(Site) : " "...

SSRS Report load through URL Performance problem

Thread by: Ismailc, Sep 3, 2009, 4 replies, in forum: SQL Server 2005 Reporting Services

Good day, I need help. In VS2005 SSRS when preview the report it runs for 2 seconds and then I deploy. But I call the report's URL from a web page...

Value Prop expression change append value font color

Thread by: Ismailc, Aug 25, 2009, 4 replies, in forum: SQL Server 2005 Reporting Services

Good day, I need help. I know how to change the color of a value in the color property based on an expression. I know how to change a value in a grid...

SSRS table to have scrollbars down & not let the table grow

Thread by: Ismailc, May 4, 2009, 1 replies, in forum: SQL Server 2005 Reporting Services

Good day, I need help. I would like have scrollbars downwards, i have a report table that grows longer than the page. I'm not going to print the...

Retreive Windows user logged on PC, possible?

Thread by: Ismailc, Apr 20, 2009, 10 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, I would like to know if it's possible to retreive Windows user logged on to the PC (domainuserid) using Sql, if possible please provide code?...

SQL convert 1 column's values to 1 row string

Thread by: Ismailc, Apr 18, 2009, 4 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, I need help please. I have one column whith different values depending on result. I would like to return a one row string result with a comma...

SSRS refresh report automatically every 2 min

Thread by: Ismailc, Apr 16, 2009, 2 replies, in forum: SQL Server 2005 Reporting Services

Hi, I need help please. I would like to know if it's possible & how. I have an html page with a iframe source being the SSRS report. Can I...

Writing to the same file within a DF, The process cannot access the file because it is being used by another process

Thread by: Ismailc, Mar 30, 2009, 2 replies, in forum: SQL Server 2005 Integration Services

Hi, help please. I'm writing twice to the same file in one Data Flow task and I get the error: The process cannot access the file because it is being...

Create Csv File from DF adds additional commas

Thread by: Ismailc, Mar 30, 2009, 4 replies, in forum: SQL Server 2005 Integration Services

Hi, I'm trying to dynamically build a csv file, at start I delete the file. Then Create using a Data Flow task with a Ole DB Source writing to Flat...

SSIS, Append CSV File

Thread by: Ismailc, Mar 27, 2009, 3 replies, in forum: SQL Server 2005 Integration Services

Hi, I need help. I have an error csv file and it writes successfully after one data flow task. But when at another task how do I append the new rows...

SSIS, Write all package errors to one flat file

Thread by: Ismailc, Mar 26, 2009, 2 replies, in forum: SQL Server 2005 Integration Services

Hi, I need help please. I have several tasks, with a lot of error checking with sending email on each task failure. This worked fine because i had a...

Offline SSRS File

Thread by: Ismailc, Jan 12, 2009, 4 replies, in forum: SQL Server 2005 Reporting Services

Hi, I need help please. Currently have an SSIS package the output to an excel pivot table, reason being that the report can be emailed/distributed...

Change ToggleItem Expand/Collapse Icon for one report only

Thread by: Ismailc, Nov 17, 2008, 2 replies, in forum: SQL Server 2005 Reporting Services

Hi, I would like to know if it is possible to change an Toggleitem Expand/Collapse icon for one report only. Regards

SSRS One page output only & hide page 1 of 1 rc:parameter option

Thread by: Ismailc, Nov 17, 2008, 1 replies, in forum: SQL Server 2005 Reporting Services

Hi, I need help. I'm using SSRS to assist with another application. The purpose is for view only and not like a report. I want to hide all bars...

SSRS Design Parameter Area for a report only

Thread by: Ismailc, Nov 13, 2008, 0 replies, in forum: SQL Server 2005 Reporting Services

Hi, I need help please. I want to change the design of the Parameter Area for one report only. I would like to set the height and background color...

SQL 2005 Certified

Thread by: Ismailc, May 5, 2008, 5 replies, in forum: SQL Server 2005 Certification [Archive]

Hi, I want to get certified in SSIS,SSRS & SSAS The exam number is 70-445 (course: 2791,2792,2793) I would like to know is there no tuctorails, self...

Filters Design on top, set format to look better.

Thread by: Ismailc, Apr 17, 2008, 3 replies, in forum: SQL Server 2005 Reporting Services

Hi, I need help. I have 4 filters/parameters on top of the report but it looks very untidy. Is there a way where i can set the boxes sizes &...