Easy question - changing Visibility of textbox

I'm trying to affect the visibility of a text box based upon a field value
returned in my dataset. The field is a summed field, and I simply do NOT
want to show the field if it is 0, less than zero, or NULL.
What should my expression for the "Visbility" property look like?
TIA,
--
Brian Grant
Senior Programmer
SI International
www.si-intl.comiif(Parameters!Fieldname.Value <= 0 OR Parameters!Fieldname.Value IS Nothing, True, False)
"G" wrote:
> I'm trying to affect the visibility of a text box based upon a field value
> returned in my dataset. The field is a summed field, and I simply do NOT
> want to show the field if it is 0, less than zero, or NULL.
> What should my expression for the "Visbility" property look like?
> TIA,
> --
> Brian Grant
> Senior Programmer
> SI International
> www.si-intl.com
>
>|||IS Nothing
that is what was tripping me up, thanks comet.
--
Brian Grant
Senior Programmer
SI International
www.si-intl.com
"comet61" <comet61@.discussions.microsoft.com> wrote in message
news:CFF1A78C-9DE1-475E-9BB9-5D4D6F4EAE04@.microsoft.com...
> iif(Parameters!Fieldname.Value <= 0 OR Parameters!Fieldname.Value IS
Nothing, True, False)
> "G" wrote:
> > I'm trying to affect the visibility of a text box based upon a field
value
> > returned in my dataset. The field is a summed field, and I simply do NOT
> > want to show the field if it is 0, less than zero, or NULL.
> >
> > What should my expression for the "Visbility" property look like?
> >
> > TIA,
> >
> > --
> > Brian Grant
> > Senior Programmer
> > SI International
> > www.si-intl.com
> >
> >
> >

Easy question

How can I output the result of a query in a text file.
(I want to use SP)EXEC master..xp_cmdshell 'bcp...

Easy (?) data-editing solution? Need help pls.

I have several thousand rows of (text) data that have some incorrect pieces. I need a way to delete part of the data but leave the rest intact.

Example:

Current data: "Bloomfield, CT"

Needs to become: Bloomfield

In other words, I need to remove the left quote, and everything after (including) the comma.

there are dozens of different cities in the DB like this.

I can write the simple query that can pull out all of the data that has a comma, or quotes. What I don't seem to get is how to then "erase" the quotes (or the string that includes the comma and everything after it) and then update the DB with this new value.

Help?Most databases have a substring and in-string (or position string) function which you can use in combination to do parsing. My example is oriented to DB2:

SUBSTR(current_data, 2, POSSTR(current_data, ',') - 1)
Result would be Bloomfield

You can use the above in an UPDATE statement:
UPDATE table SET city = SUBSTR(current_data, 2, POSSTR(current_data, ',') - 1)

Originally posted by rexnervous
I have several thousand rows of (text) data that have some incorrect pieces. I need a way to delete part of the data but leave the rest intact.

Example:

Current data: "Bloomfield, CT"

Needs to become: Bloomfield

In other words, I need to remove the left quote, and everything after (including) the comma.

there are dozens of different cities in the DB like this.

I can write the simple query that can pull out all of the data that has a comma, or quotes. What I don't seem to get is how to then "erase" the quotes (or the string that includes the comma and everything after it) and then update the DB with this new value.

Help?|||Also, use the 'REPLACE' and 'GRATER' functions to eliminate the quotes:

UPDATE mytable
SET city = REPLACE(SUBSTR(city, 1
,GREATER(POSSTR(city, ',') - 1,LENGTH(city)))
,'"','')
WHERE POSSTR(city, ',') > 0
OR POSSTR(city, '"') > 0

:cool:|||Thanks you both, will give it a shot. Unfortunately, I'm using MS Access and it doesn't recognize those particular functions, but I think I can replace them.|||For Access take a look at Instr and Mid there is even a Replace. Have fun!

Originally posted by rexnervous
Thanks you both, will give it a shot. Unfortunately, I'm using MS Access and it doesn't recognize those particular functions, but I think I can replace them.

Dynamically set different font weight for each text in the textbox

Hi friends,

I have a text box with n number of text.

I want to set the font weight of each text in the textbox dynamically..

For eg.. suppose the text of the textbox is "Hello Friends", then i need "Hello Friends" as output.

Is there any way to accomplish this in SQL Reporting Service.

Any help will be appreciated. Its critical.

Please help me out ASAP.

No, the font settings are per textbox, so everything in the textbox will have the same font weight. You can use different textboxes, but that ends up pretty messy.

|||

Yes it is possible. However, it is not easy and you will need Visual Studio 2005 to do it.

It sounds like you are basically wanting to change the layout of the report at runtime.

Here is how to do it:

http://msdn2.microsoft.com/en-us/library/ms170667.aspx

After you are able to change the layout of the report at runtime, you will want to deploy the report from your application using SetReportDefinition.

|||

Greg, are you thinking that he would create a separate textbox for each wordin the original textbox to handle this requirement, so that each one would have its own formatting? How would that work, for different instances of the same textbox in the report (for example, the first one reads "this is my text" and "is" should be bold, but the second instance reads "this is not really my text" and the word "my" should be bold?

Also I think the positioning/kerning would be a nightmare...

>L<

|||

The only way I know how to do this successfully in Reporting Services (although Greg may have another approach, I'm not seeing it!), is to do some custom rendering. IOW, if you render the information yourself, you are free to set the formatting for each word in the text. The result becomes a small graphical "piece" in the report, though, not really text. So it wouldn't be searchable text.

If this solution appeals to you at all, I can give you more details.

>L<

|||

Lisa Nicholls wrote:

The only way I know how to do this successfully in Reporting Services (although Greg may have another approach, I'm not seeing it!), is to do some custom rendering. IOW, if you render the information yourself, you are free to set the formatting for each word in the text. The result becomes a small graphical "piece" in the report, though, not really text. So it wouldn't be searchable text.

If this solution appeals to you at all, I can give you more details.

>L<

This sounds like a better approach. I suppose I was thinking that you could change the font weight per word.

|||

Thanks Lisa and Greg for the answers .. I am sorry to reply late.. I was trying out lisa's solution.

But my scenario is different. I have a text bos and the expression of my textbox is as follows:

="Dear"+" "+Ucase("Robert")+space(2)+vbcrlf+"How are you"

where "vbclrf" is for new line and "space(2)" is for leaving 2 spaces between the text and "Ucase" stands for upper case.

Similarly I need a way to display the text "Robert" in bold letters.

Do you have any suggestion for this.

|||

Lisa Nicholls wrote:

...do some custom rendering. IOW, if you render the information yourself, you are free to set the formatting for each word in the text. The result becomes a small graphical "piece" in the report, though, not really text. So it wouldn't be searchable text.

If this solution appeals to you at all, I can give you more details.

>L<

It still sounds like this is what you need.

|||

>>But my scenario is different.

No, really, it's exactly what I thought. If you tried what I suggested... what exactly did you try?

In the current version of RS, what you need to do is build a function that parses your markup in a

CustomReportItem, and renders the content appropriately for your markup.

In the next version of RS (Katmai -- there is a thread post about rich text) you might have a

better choice, from the point of view of rendering. IOW, you would not have to use a

CustomReportItem for this. However, given your custom markup, you would still have to create a

code function to parse the markup and put it in a more standard form, such as HTML markup or RTF

or whatever Katmai supports, so that the standard rendering could deal with it.

For this reason, I strongly suggest you think about switching to a standard markup format that

standard renderers, whether in RS or elsewhere, could read! Your users and designers will also

thank you for it.

>L<

Dynamically Create Text Objects

Hello, I'm not sure if this is possible but I'm really stuck on how else to accomplish what I'm trying to do!!

I need to display all of a companies departments and summary data with them. I need to always display the department, even if there is no data and the number of departments is always different. My data needs to look something like this:

Dept Summary Field 1 Summary Field 2
-- ----- -----
1 100 100
2 200 200
3 0 0
etc..

Is it possible to take a formula that I wrote that reads in all of the departments and strings them together like 1,2,3,etc and dynamically write these values into text boxes in the report header? I know I could do this if I had a fixed number of departments but I don't know how to do this dynamically.

If this isn't possible, is it somehow possible for me to force a group to display departments that don't have any data to summarize? Thanks so much!

Steph-more details please|||What I need is a report that displays all of the department numbers along with a count of how many technical support issues they had each month and how many technical support resolutions they had each month.

Even if a department did not have any technical support issues, I still need to display that department with a value of zero for tech support issues and tech support issues resolved.

I've tried a bunch of different ways to accomplish this including using a group. Now I'm new at using crystal but it seems to me that if a department had no tech support issues then the department did not even show up in the group. I can't have this.

So essentially I'm trying to find a creative way to write my report so that I can always show all departments whether they had support issues or not. I'm open to any approaches that will get this done.

Thanks so much for helping a confused rookie!!

Stepanie.

Dynamically create text file as destination from sql script in SSIS

I have a select Script as follows:

SELECT c.ABC AS 'ABC'

, a.Qty AS 'Quantity_Recived'

, b.PC AS 'PC'

, b.PC AS 'PC'

, 'I' AS 'Flag'

FROM TNRInventory.dbo.tInventoryAlloc AS a

LEFT OUTER JOIN vwInventoryAllocMapping AS vwMap ON a.TNRAllocTypeID = vwMap.TNRInventoryAllocID

LEFT OUTER JOIN ABC.dbo.ZREFRESHTAB AS b ON a.DispenserID = b.Asset

LEFT OUTER JOIN ABC.dbo.TableJoinKey AS c ON a.TitleID = c.TITLE_ID

WHERE (vwMap.DataSourceID = 3) and vwMap.[DataSourceAllocName] = 'I'

group by c.SKU_NO , vwMap.[DataSourceAllocName],a.Qty , b.Profit_Center

order by c.SKU_NO,vwMap.[DataSourceAllocName]

GO

i have to send the result of aforesaid script in batch of 300 records per file (tab delimited text file)
now the file name must be dynamically created as each file will contain 300 records.

I have found some document related to same issue on this url

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1238184&SiteID=17

but still there is a catch.

Can any one guide/suggest me better way to do the aforesaid.

Thanks

Thinking while typing, this could be done with a few steps.

1 - Data Flow - Load a staging table with the results of the SQL. Add to it a row number counter so that every row is numbered uniquely.

2 - Control Flow - Run an Execute SQL Task to select max(rownumber) from that staging table

3 - Control Flow - Use a script task to take the output of the Execute SQL task and populate another variable with the number of iterations needed to populate files with up to 300 rows. (max(rownumber) / 300 - if no remainder, use that value, if remainder add one to the integer, etc...)

4 - Control Flow - Use a for loop to iterate the output variable from step 3 above.

5 - Control Flow - Build a variable set to an expression to use a base filename and the variable from step 3 above.

6 - Control Flow For Loop - Loop through the variable from step 3 above and add a data flow. Inside this data flow, use an OLE DB (or whatever) to connect to the staging table from step 1, filtering by (variable_step3 * 300) you can select just the records for this iteration. Hook that up to a flat file destination, which uses expressions to set the file name equal to the variable from step 5 above.

Something like that.|||

You might also check Jamie's blog post on this topic.

http://blogs.conchango.com/jamiethomson/archive/2005/12/04/SSIS-Nugget_3A00_-Splitting-a-file-into-multiple-files.aspx

Essentially the same technique that Phil recommended, but he's got some sample code already

|||

jwelch wrote:

You might also check Jamie's blog post on this topic.

http://blogs.conchango.com/jamiethomson/archive/2005/12/04/SSIS-Nugget_3A00_-Splitting-a-file-into-multiple-files.aspx

Essentially the same technique that Phil recommended, but he's got some sample code already

D'oh! Should've just looked there first!|||

What i did is i create a view for aforesaid script and then used that script in the following VB.net script

' Microsoft SQL Server Integration Services Script Task

' Write scripts using Microsoft Visual Basic

' The ScriptMain class is the entry point of the Script Task.

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Data.SqlClient

Imports System.Text

Imports System.IO

Public Class ScriptMain

Public Sub Main()

Dim ConnectionString As String = "Server=ServerName;Database=DatabaseName;uid=Login;pwd=Password;"

Dim querystring As String = "SELECT * FROM vwInventory_I"

Dim con As New SqlConnection(ConnectionString)

Dim adapter As New SqlDataAdapter()

Dim ds As New DataSet

Dim dt As New DataTable

adapter.SelectCommand = New SqlCommand(querystring, con)

adapter.Fill(ds)

dt = ds.Tables(0)

CreateFile(dt)

End Sub

Private Sub CreateFile( ByVal table As DataTable)

Dim intRowCount As Integer = table.Rows.Count

Dim Column1Value As String

Dim Column2Value As String

Dim Column3Value As String

Dim Column4Value As String

Dim Column5Value As String

Dim sb As New StringBuilder

Dim seperator As String = vbTab

Dim nFileNameCount As Integer

nFileNameCount = 0

'For i As Integer = 0 To table.Columns.Count - 1

Dim i As Integer = 0

Dim j As Integer = 0

For j = 0 To intRowCount - 1

If nFileNameCount = 100 Then

PrintFile(sb, j)

'clears the stringbuilder

sb.Remove(0, sb.ToString.Length - 1)

nFileNameCount = 0

End If

Column1Value = table.Rows(j)(i).ToString

Column2Value = table.Rows(j)(i + 1).ToString

Column3Value = table.Rows(j)(i + 2).ToString

Column4Value = table.Rows(j)(i + 3).ToString

Column5Value = table.Rows(j)(i + 4).ToString

sb.Append(Column1Value & seperator & Column2Value & seperator & Column3Value & seperator & _

Column4Value & seperator & Column5Value & seperator & vbCrLf)

nFileNameCount = nFileNameCount + 1

Next

PrintFile(sb, j)

'Next

End Sub

Private Sub PrintFile( ByVal sb As StringBuilder, ByVal recordcount As Integer)

' Create an instance of StreamWriter to write text to a file.

Dim strDate As String

strDate = String.Format("{0:yyyy}" , DateTime.Now)

strDate = strDate & String.Format( "{0:MM}", DateTime.Now)

strDate = strDate & String.Format( "{0d}", DateTime.Now)

Using sw As StreamWriter = New StreamWriter("C:\SSIS\I_" & strDate & "_" & recordcount & ".txt")

sw.WriteLine(sb.ToString)

sw.Close()

End Using

'this will create a text file in bin directory

End Sub

End Class

This is how you generate tab delimited files to test check Use Script Tas from SSIS

|||Uh, okay. Good. So why even use SSIS then? Write your own program as you have done, compile it, and execute the resulting binary file. Leave the bloat of SSIS out of it.|||

I am going to put this piece in middle of my design.

It was the one of the key to finish my jik-so-puzzle.

Other one is to delete the files from Unix Aix Server with FTP connection.

And here too I have to go all the way round, as there FTP connection works fine on Microsoft server but not on UNIX server.

It does not allow you to delete the files on UNIX server.

That is the reason I am using the code in SSIS.

Dynamically create text file as destination

I am trying to create a text file from an SQL query on a SQL table. I would like the SSIS package to prompt for the file name and path. The text file is tab delimited and the text qualifier is a double quote.

Thanks,

Fred

SSIS by itself won't be able to prompt you. You'll have to write a custom executable perhaps to get this to work.|||

I think you could use the Windows.Forms.SaveFileDialog object in a Script Task.

|||

Thanks for the suggestions but I am new to programming. I have "played" a little with VBA in Excel. Can anyone get me started with some more VB code?

I would think this has been done before but I can not find any code in any SSIS forum for it.

Thanks,

Fred

|||

Couldn't you create a package variable called FilePath (for example) of type string and then read into it through a script task?

Something like the following would give you an input prompt and then store the value into the variable created:

Public Sub Main()

Dts.Variables("FilePath").Value = InputBox("Enter your file path", "Prompt").Trim()

Dts.TaskResult = Dts.Results.Success

End Sub

Then, you could just set the ConnectionString property in Expressions to the FilePath variable.

|||

SaveFileDialog would give the same result than InputBox except you are able to browse...

Dim fSaveFileDialog As New Windows.Forms.SaveFileDialog
fSaveFileDialog.ShowDialog()
Dts.Variables("fileName").Value = fSaveFileDialog.FileName

|||

Thanks for the suggestions but I am still lost.

I have a Data Flow Task which has a SQL Server Source. In the Data Flow Task I connect the SQL Server Source to what I believe is next - a Destination Script Component. I did not see anywhere you code put code in a Data Flow Destination - Flat File Destination.

In the Script Component it allows you to add code in Script Design box which is Visual Studio's designer window. How do I assign the filename to the new file I create?

Thanks for any help.

Fred

|||

Use expressions to assign the filename to the Flat File Destination (property Connection = User::variable)

Add a Script task before your data flow task. This script task will prompt for the file location and set the User::variable.

|||

Can I just question this approach? Is this for end users? If so then I don’t think using SSIS in this way is appropriate. SSIS is a server, so it is licensed as part of the full SQL Server license, and is not something you can install on client desktops as part of the normal Client access License. Each machine needs a full SQL Server license. To have a task offering a UI to the user means that package, and therefore SSIS itself, must be installed on the user's machine, making each user machine a full SSIS server install.

dynamically changing TextDecoration property of a text box

I need to make one column on a report to display as hyperlink. I am using
TextDecoration underline property . How do I change the underline property to
None dynamically based on the data. I am writing the following code in the
Expression section of TextDecoration property of the text box.
If Parameters!pParam.Value = "Something" Underline else None
Please advice.Right click on the box and select properties, then go to the font tab, in
the decoration section click on FX on the right and enter your expression ie
iif(fields!mycol.value = "Yes","Underline","None")
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Kiran" <Kiran@.discussions.microsoft.com> wrote in message
news:A7E8C6EC-9C00-4178-BC83-B89556B127B3@.microsoft.com...
>I need to make one column on a report to display as hyperlink. I am using
> TextDecoration underline property . How do I change the underline property
> to
> None dynamically based on the data. I am writing the following code in the
> Expression section of TextDecoration property of the text box.
> If Parameters!pParam.Value = "Something" Underline else None
> Please advice.|||Hi,
I have a report with a textbox acting as a hyperlink. when i click on it, i
want the target to be opened in a new window, i.e. i want target="_blank" but
i havent found a soln yet to this. could you help me with this' i cant
believe they left out this while designing reporting services :(
Thanks
"Wayne Snyder" wrote:
> Right click on the box and select properties, then go to the font tab, in
> the decoration section click on FX on the right and enter your expression ie
> iif(fields!mycol.value = "Yes","Underline","None")
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Kiran" <Kiran@.discussions.microsoft.com> wrote in message
> news:A7E8C6EC-9C00-4178-BC83-B89556B127B3@.microsoft.com...
> >I need to make one column on a report to display as hyperlink. I am using
> > TextDecoration underline property . How do I change the underline property
> > to
> > None dynamically based on the data. I am writing the following code in the
> > Expression section of TextDecoration property of the text box.
> > If Parameters!pParam.Value = "Something" Underline else None
> >
> > Please advice.
>
>

Dynamic y axis labeling

Hi

I'm trying to label the y axis from a dataset but keep running in to problems as it only takes ints and the data from the database is text, does anyone know the best way to do this?

Thanks

L

I would suggest using a bar graph. This will enable you to put text on the y-axis and the values will be on the x-axis.

Put the dataset field you want on the y-axis in the category groups and you will be good to go.

Dynamic Width of textbox

Hi,
how can i set the width of a textbox dynamically ?
Ex: The text box has to expand in width to fit the availble data. It
shouldnt word wrap.
ex: hello how are you NOT hello how
are youSince you can not use an expression for textbox width, I do not think you
can do this...You would probably end up with bigger problems anyway, because
textboxes overlapping would be a problem unless you moved the others that
were affected by the size change anyway...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ramani" <Ramani@.discussions.microsoft.com> wrote in message
news:E1CF20D3-CD14-4DB6-A380-3B5C694C26CB@.microsoft.com...
> Hi,
> how can i set the width of a textbox dynamically ?
> Ex: The text box has to expand in width to fit the availble data. It
> shouldnt word wrap.
> ex: hello how are you NOT hello how
> are you

Dynamic Tooltip for TextBoxes in Reports?

Hi,

I want to add dynamic tooltip for the textboxes on a report where the tooltip text comes from a database lookup or maybe a resource file?

How can this be done. This is a required feature for our client and we do not want to add "Constants" as tooltip text which can be done in min as the drawback would be if the value for the tooltip changes, it has to be changed in all the reports wherever it appears.

Thanks again.You can do this by creating a second data set and binding the tooltip to aggregate expressions, i.e. =First(Fields!Tooltip1.Value, "TipQuery"). Or you could write a cusom assembly and get them from a custom resource file (would require additional permission in the assembly on the server).

Dynamic Textbox height?

Hi,

I often have a 'label' text box next to a 'data' textbox. If the data textbox expands how can I get the label to match it in height?. I tried to set the height of one to the height of the other but got errors.

Thanks,

Best way would be to use a table, the row the label and the textbox are in would be sized at the same size then.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Dear,

U can do it by using functioin.Your testbox and label size will be same.

U can try this

="hello" & space(len(Parameters!SaleOrderNo.Value)) & "."

In passed these parameter with in a lable(textbox).

Parameters!SaleOrderNo.Value in a textbox.

Hope this helps u.

from

sufian

|||

Thanks Jens,

But at present this needs to stay free form.

|||

Thanks Sufian,

But I'm not following what you are saying. I believe you are saying to create a report parameter and then use this code:

space(len(Parameters!SaleOrderNo.Value)) & "."

I did this (using my own values of course) but am not able to make it work. Please explain what I'm not understanding.

Thanks,

Fairfield

|||

Dear,

suppose u have a lable and a textbox.

In textbox u have a value(!Fieldname.value)

In the label function box write the code like this

="hello" & space(len(!fieldname.value)) & "."

So it will read the (!fieldname)length and add that length to ur lable with space function.I used a dot "." at last in the function because there should be something to hold the space.

U can customise the code according to ur need.

HTH

from

sufian.

|||

Thanks again, Sufian.

However for some reason this technique doesn't expand the textbox either horizontally or vertically. Even when I force it using Space(250) and the "." it still doesn't expand the textbox. Any ideas?

Thanks.

|||

Dear failfield,

I read ur question. In that u had written that when the size of the testbox is increased the lable size should be increaed automatically.

U had not written anything like that u need to increase the size of the textbox.

BTW there should be a object to hold another object detail.

for example

if u need to increase the size of the lable in refence to height u need to hold the height of the textbox in ur lable.

suppose u have a textbox1. and u have a text lets say "Hello world"

and a lable lable1 with text hello.

Now u need that lable should be of the same size as the text.(in refrence to height only)

then in the function box write the same code i had written.

="hello" & space(len("helloworld")) & "." .

U can also use a field in place ot "helloword".

All this code is written in lable function window.

Hope this helps u.

from

sufian

Dynamic Text Parser?

Hi Guys,

I have a script task that is supposed to read and parse a fixed width source file.

Basically, I want to make the FieldWidths dynamic so that I'll be able to reuse this package with different files. So Instead of hardcoding the field widths directly into my script task, I want it to be stored somewhere that the package can get when executions starts. Is there a way of doing this?

The code looks like this:

Using Reader As New TextFieldParser(mTempFilePAth)

Reader.TextFieldType = FieldType.FixedWidth

Reader.SetFieldWidths(1, 8, 8, 8, 4, 8) <-- I want to change this to handle dynamic widths.

Hi,

The best way to make your package re-usable is to use a "Integration Services Variable", see this link for help on variables http://msdn2.microsoft.com/en-us/library/ms141085.aspx and this one for accessing from a script http://msdn2.microsoft.com/en-us/library/aa337079.aspx.

The main gotcha is you need to be aware of is this bit from the second link "You can make existing variables available for read-only or read/write

access by your custom script by entering comma-delimited lists of

variables in the ReadOnlyVariables and ReadWriteVariables fields on the Script page of the Script Transformation Editor."

Also does SetFieldWidths take a variable number of arguments? If so you may need to define a string SSIS variable with the arguments comma seperated, then parse them into the seperate arguments for SetFieldWidths

Dave

Dynamic Text in Group Headers

I'm woirking in SSRS 2005. I'm looking for a way to add "(Continued...)" to
a group header when the group spans multiple pages. When I used to use
Crystal Reports 8.5 this was very simple to do uising the
"InRepeatedGroupHeader" built in function. I have not been able to find
anything like this in SSRS. I've seen several people asking for the same
thing on MSDN but no solutions. Any ideas on how this can be done in SSRS?tachtenberg wrote:
> I'm woirking in SSRS 2005. I'm looking for a way to add "(Continued...)" to
> a group header when the group spans multiple pages. When I used to use
> Crystal Reports 8.5 this was very simple to do uising the
> "InRepeatedGroupHeader" built in function. I have not been able to find
> anything like this in SSRS. I've seen several people asking for the same
> thing on MSDN but no solutions. Any ideas on how this can be done in SSRS?
Try Something like this:
=IIF(Globals!PageNumber > 1,Globals!ReportName &" (Continued)"
,Globals!ReportName)
-MM|||That will not work because some groups span more than one page and others do
not. Page numbering does not reset with each group.
"Michael" wrote:
> tachtenberg wrote:
> > I'm woirking in SSRS 2005. I'm looking for a way to add "(Continued...)" to
> > a group header when the group spans multiple pages. When I used to use
> > Crystal Reports 8.5 this was very simple to do uising the
> > "InRepeatedGroupHeader" built in function. I have not been able to find
> > anything like this in SSRS. I've seen several people asking for the same
> > thing on MSDN but no solutions. Any ideas on how this can be done in SSRS?
> Try Something like this:
> =IIF(Globals!PageNumber > 1,Globals!ReportName &" (Continued)"
> ,Globals!ReportName)
>
> -MM
>|||My bad. I didn't read the question slow enough. I thought it seemed a
little too easy.
Anyway, I did find this that might be what you need.
http://blogs.msdn.com/chrishays/archive/2006/09/27/ContinuedHeader.aspx
tachtenberg wrote:
> That will not work because some groups span more than one page and others do
> not. Page numbering does not reset with each group.
> "Michael" wrote:
>> tachtenberg wrote:
>> I'm woirking in SSRS 2005. I'm looking for a way to add "(Continued...)" to
>> a group header when the group spans multiple pages. When I used to use
>> Crystal Reports 8.5 this was very simple to do uising the
>> "InRepeatedGroupHeader" built in function. I have not been able to find
>> anything like this in SSRS. I've seen several people asking for the same
>> thing on MSDN but no solutions. Any ideas on how this can be done in SSRS?
>> Try Something like this:
>> =IIF(Globals!PageNumber > 1,Globals!ReportName &" (Continued)"
>> ,Globals!ReportName)
>>
>> -MM|||On Jan 18, 2:25=A0pm, Michael <Mich...@.discussions.microsoft.com> wrote:
> My bad. I didn't read the question slow enough. I thought it seemed a
> little too easy.
> Anyway, I did find this that might be what you need.http://blogs.msdn.com/=
chrishays/archive/2006/09/27/ContinuedHeader.aspx
>
> tachtenberg wrote:
> > That will not work because some groups span more than one page and other=s do
> > not. =A0Page numbering does not reset with each group.
> > "Michael" wrote:
> >> tachtenberg wrote:
> >> I'm woirking in SSRS 2005. =A0I'm looking for a way to add "(Continued=...)" to
> >> a group header when the group spans multiple pages. =A0When I used to =use
> >> Crystal Reports 8.5 this was very simple to do uising the
> >> "InRepeatedGroupHeader" built in function. =A0I have not been able to =find
> >> anything like this in SSRS. =A0I've seen several people asking for the= same
> >> thing on MSDN but no solutions. =A0Any ideas on how this can be done i=n SSRS?
> >> Try Something like this:
> >> =3DIIF(Globals!PageNumber > 1,Globals!ReportName &" (Continued)"
> >> ,Globals!ReportName)
> >> -MM- Hide quoted text -
> - Show quoted text -
Also, here's white paper that shows (among other things) how to reset
page numbers when groups change.
http://msdn2.microsoft.com/en-us/library/bb395166.aspx|||I've looked at Chris's work around. Unfortunately, there are other items
above the table I need the repeated group headers in so it will not work.
"Michael" wrote:
> My bad. I didn't read the question slow enough. I thought it seemed a
> little too easy.
> Anyway, I did find this that might be what you need.
> http://blogs.msdn.com/chrishays/archive/2006/09/27/ContinuedHeader.aspx
>

Dynamic Text Field

We have purchase orders that we are pulling from a MSSQL backend, and the report works fine.

However, in the subreport, the users would like to be prompted to enter up to 8 lines of text to be inserted into the report when they execute the report.

I am not sure if this is possible, or how to go about it. I tried using a parameter field, but there is simply not enough space for them to enter in info, and they have to enter multiple lines. I would like to make this as user friendly as possible.

We are using Crystal Reports 7, and may be upgrading to Crystal 11 by the end of the year.

Thank you in advance.Yes u can use parameter field, unfortunately, it does not display multiline but it can accomodate ur requirement, i used it at max length 65000 characters.

im using CRXI|||Actually, I figured out a neat way to do it.

You can create a Word or .rtf file in Wordpad or MSWord, and link it via OLE. That way, they can actually make the text look exactly the way they want it to on the report. It ends up looking really nice, and you can do all the shading and bordering in CR and it works fine.

I've used it in both the .rpt format and compiled it to .exe and they both work as long as the text they want to use was edited and saved before they open the .exe. I just trained the users to do this, and all is working great.

So after banging my head awhile, I finally saw through it and figured out this way.

Thank you for your help, I had tried that, but my users were upset by not being able to view their text. This was the next best way.

dynamic text

Hi.
In Reporting Services, is there a chance to make the text dynamic?
For example, sometimes I want it to show 10 lines and sometimes 20.
Is it possible?Can you be a little more specific? Nearly everything is expression based and hence can be made dynamic.|||I have a report about SaleContracts.
In the SaleContract Text area, the customer (company) definition will be shown and for example one company's definition is 20 character length and another is 50 character length.I use this definition more than once in the contract text.So the text changes from contract to contract.And so this text may be 20 line or 30 line length.
If I keep the textbox's size small, some of the text couldn't be shown when the company definition string contains 30 characters(for example).And if I keep the textbox's size large, there is a blank space and this is not a good view.Therefore I want the text to be dynamic.

Thanks in advance!|||Text boxes have 2 properties CanGrow and CanShrink that can be used to automatically size the textbox based on it's content. Bear in mind that these will only grow or shrink vertically i.e. height, the width is fixed.

Dynamic SQL help

I am trying to create a cursor that gathers a tag value and column name
for use in a sp_execute sql statement. The text is as below
SET @.qry = N'SELECT @.tag_value_out = ' +
CONVERT(nvarchar(25),@.column_name) + N' FROM FSFORMULA WHERE formula_id
= @.formula_id_in'
But when I use PRINT on the next line, nothing is printed out.
@.qry is nvarchar(1000)
Any help? This is in a stored procedure.if @.column_name is null it will return null
<cknobs@.gmail.com> wrote in message
news:1143835555.976735.287650@.g10g2000cwb.googlegroups.com...
>I am trying to create a cursor that gathers a tag value and column name
> for use in a sp_execute sql statement. The text is as below
> SET @.qry = N'SELECT @.tag_value_out = ' +
> CONVERT(nvarchar(25),@.column_name) + N' FROM FSFORMULA WHERE formula_id
> = @.formula_id_in'
> But when I use PRINT on the next line, nothing is printed out.
> @.qry is nvarchar(1000)
> Any help? This is in a stored procedure.
>|||it was, turns out i didn't have the @.column_name variable in the fetch
next statement. DERP!
thx!