Showing posts with label accordance. Show all posts
Showing posts with label accordance. Show all posts

Friday, March 30, 2012

How to format a text box to show bullets

I want to display this on a report

Conditions of your reward

· The enclosed reward has been couriered to you in accordance with the selection you made.

· This reward cannot be returned in full or part for points, swapped or exchanged for cash.

· If your product is defective in any way upon receipt, please contact to arrange a replacement.

you would think it would be simple but I can't seem to get it to work.

The best I can come up with is a bullet point then the text straight afterwards. I have also tried an image but when it prints it doens't really look the part.

Any ideas

I too have the same problem with Bullets.Any suggesstions or ideas are appreciated.

Thanks,

Prabaharaprabu

|||if you are talking about static text (as opposed to databound), I was able to create the bulleted text list in MS Word, then copy and paste it in the textbox.|||I need a data to be displayed in a text box and it should be formatted with bullets.|||In the end I created all my text in a textbox and copy a large bullet in another labelbox. Each bullet I created in it's own labelbox and set all text padding to 0|||What if the text is not static ... who do you do that with the hanging indent?|||

why not use something similiar to the following:

=space(number) & chr(number) & space(number) & "whatever you need here"

This should allow you to pick an item off the ASCII character chart for chr(). The space() would allow you to set necessary spacing. If you need a hanging indent for sub-items, I'm pretty sure a iif() would do the trick. I hope this is somewhat helpful.

Curtis

Wednesday, March 28, 2012

How to format a text box to show bullets

I want to display this on a report

Conditions of your reward

· The enclosed reward has been couriered to you in accordance with the selection you made.

· This reward cannot be returned in full or part for points, swapped or exchanged for cash.

· If your product is defective in any way upon receipt, please contact to arrange a replacement.

you would think it would be simple but I can't seem to get it to work.

The best I can come up with is a bullet point then the text straight afterwards. I have also tried an image but when it prints it doens't really look the part.

Any ideas

I too have the same problem with Bullets.Any suggesstions or ideas are appreciated.

Thanks,

Prabaharaprabu

|||if you are talking about static text (as opposed to databound), I was able to create the bulleted text list in MS Word, then copy and paste it in the textbox.|||I need a data to be displayed in a text box and it should be formatted with bullets.|||In the end I created all my text in a textbox and copy a large bullet in another labelbox. Each bullet I created in it's own labelbox and set all text padding to 0|||What if the text is not static ... who do you do that with the hanging indent?|||

why not use something similiar to the following:

=space(number) & chr(number) & space(number) & "whatever you need here"

This should allow you to pick an item off the ASCII character chart for chr(). The space() would allow you to set necessary spacing. If you need a hanging indent for sub-items, I'm pretty sure a iif() would do the trick. I hope this is somewhat helpful.

Curtis

Sunday, February 19, 2012

How to filter a report using an asp.net page

Hi,
I need to filter a single .rdl page in accordance with an option chosen from an asp.net page.
I know how to filter a report within the reporting page. But how can I do the filtering from an asp.net page? For example I have a Report1.rdl that prints out all the locations. I need the same report1.rdl page to print out only for a certain location based on the option I chose from the asp.net page. My asp.net page has 3 buttons. One to for all locations, another for location1, and the other one for location2. Please help. Thanks

1. Add a parameter to the report for location.

2. Modify your SQL code to account for that parameter, ie. WHERE Location = @.Location.

3. In Visual Studio, pass the location parameter value based upon the option chosen.

|||

GregSQL wrote:

1. Add a parameter to the report for location.

2. Modify your SQL code to account for that parameter, ie. WHERE Location = @.Location.

3. In Visual Studio, pass the location parameter value based upon the option chosen.

Thanks Greg. I got 1 and 2 working. Now how do I make the 3rd part? How do I call the parameters from an asp.net page to show the report in a browser? Thanks again for your help.
|||

Code Snippet

Dim param AsNew Microsoft.Reporting.WebForms.ReportParameter

Dim paramarr(0) As Microsoft.Reporting.WebForms.ReportParameter

param = New Microsoft.Reporting.WebForms.ReportParameter("myParameter", DropDownList1.SelectedValue.ToString())

paramarr(0) = param

ReportViewer1.ServerReport.SetParameters(paramarr)

This would set the report parameter myParameter to the selected value of DropDownList1. Remember that the parameterarray's starting index is zero...that typically leads me to off by one errors.

Oh and I was somewhat assuming that you already knew how to use a report viewer component in .NET to display a report in an internet browser. If not, let me know.