Search results for query: *

I am creating an SSIS package to remove duplicates from (currently) the persons table. We have approx. 50 clients, each wanting to set their own paramenters for what they consider a viable match. So, example Overall match: 60% Manual Review Field Match (The following MUST add up to 100%)...

I am creating an SSIS package to remove duplicates from (currently) the persons table. We have approx. 50 clients, each wanting to set their own paramenters for what they consider a viable match. So, example Overall match: 60% Manual Review Field Match (The following MUST add up to 100%)...

Thank you Mister Mo. I don't know why that didn't sink in from the other post. Sometimes I can be a little dense.

Did you try writing written your "Stacked" code in the Report Properties, Code tab and then call then procedure?

I was able to change the chart legend to show the correct information. However, the words are too long for the column. How do I 1) Increase the width of the column 2) Make it so the Legend Rows can be taller I cannot increase the size of the chart, as I have 3 charts side by side with this...

I have several items that must be placed inside of a 2nd Group level (12 different Table and 3 Pie Charts). Is there a way to create this group level, without creating it attached to a table. Or, if I attach it to a table, how do I make sure that the 3 pie charts only print once each, instead...

Thank you. That was exactly what I was looking for.

Don't know the answer [sadeyes]. However, might want to try posting here as well: http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?&cat=en_US_96ea9d50-8249-45f3-8433-e50dd796681f&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs Good luck and hope...

I know this is 101 stuff, but I'll be danged if I can figure it out. I have a stored procedure that returns OrgID, OrgName. I want to show OrgName, for the client to choose from, and assign OrgID to the parameter, to pass to the report stored procedure. Help, please.... msflinx

In a post on the MS SRS Forum (http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs), titled "Report Header Only on First Page", Charles Kangai replied that: "It sounds like you have used a page header rather than a report header in your...

Thanks.... DUH!!! I'm an idiot.... That's just way to simple... Why didn't I figure that one out... :( Ok -- enough of the self bashing. Second, in answer to your question -- No, because if I use the "C" format for currency, it is upset by the "NA" field. Says it can't convert to decimal.

I am trying to reformat a string, if it is numeric, to look like money ($999,999.99). Otherwise, return the string unchanged. I have written the follwoing code in the report properties code tab: Public Shared Function funFormatString(strToBeFormated as String) as string dim intLen as integer...

I just re-read this and thought I would clarify. I am filling a "drop-down list" for my parameter, via a stored procedure. That stored procedure is returning a null dataset, so I do not have a "drop-down list". I want to kill the report at this point, with a No Data available. Is this...

How do I kill the report, when a parameter that is set by a stored procedure is null (this is not a data error, but a small potential error with new clients). If I set the parameter to not allow nulls, the report errors out. Is there some code I can write that will grab this null set and say...

Figured it out. My data was coming in as a string, not a date. Had to change the expression to: =Format(cDate(Fields!activitydate.Value),"dd-MMM-yy") in the value property and all is well.

I'm feeling really stupid right now. I have a text box in the group footer that is a date field. Where do I put this expression, =format(fields!activitydate.Value, "dd-MMM-yy") so that it affects my field? I have tried these boxes in the Properties box: 1) Format field 2)...