Report Parameter Display Formatting

I have a report where I want to create a boolean parameter that has two radio
buttons, where one radio botton has label "With Approval" and the other radio
buttons label says "No Approval (Under Review or No Request), plus there is
not leading text prior to the first radio. Basically I want my report
parameter display to look like this:
X - With Approval X - No Approval (Under Review or No Request)
Note: X in the above text is the radio button.
How is this done?
I can easily set up the two radio buttons, with a single boolean report
parameter, but I can only get the labels to say "true", or "false", plus a
leading label that says "With Approval". Some thing like this:
With Approval X true X falseAre you using a custom viewer you wrote to render the reports? This is the
only way I know of to use webcontrols other than text boxes and drop down
lists.
"Greg Larsen" wrote:
> I have a report where I want to create a boolean parameter that has two radio
> buttons, where one radio botton has label "With Approval" and the other radio
> buttons label says "No Approval (Under Review or No Request), plus there is
> not leading text prior to the first radio. Basically I want my report
> parameter display to look like this:
> X - With Approval X - No Approval (Under Review or No Request)
> Note: X in the above text is the radio button.
> How is this done?
> I can easily set up the two radio buttons, with a single boolean report
> parameter, but I can only get the labels to say "true", or "false", plus a
> leading label that says "With Approval". Some thing like this:
> With Approval X true X false|||No. I'm just using the standard viewer in Reporting Services.
"Aaron Williams" wrote:
> Are you using a custom viewer you wrote to render the reports? This is the
> only way I know of to use webcontrols other than text boxes and drop down
> lists.
> "Greg Larsen" wrote:
> > I have a report where I want to create a boolean parameter that has two radio
> > buttons, where one radio botton has label "With Approval" and the other radio
> > buttons label says "No Approval (Under Review or No Request), plus there is
> > not leading text prior to the first radio. Basically I want my report
> > parameter display to look like this:
> >
> > X - With Approval X - No Approval (Under Review or No Request)
> >
> > Note: X in the above text is the radio button.
> >
> > How is this done?
> >
> > I can easily set up the two radio buttons, with a single boolean report
> > parameter, but I can only get the labels to say "true", or "false", plus a
> > leading label that says "With Approval". Some thing like this:
> >
> > With Approval X true X false

Report Parameter Calendar Formatting PLEASE HELP

If anyone can help me with this, I would be really grateful. I am using
Reporting Services 2005 and Visual Studio 2005 for this problem.
A while back, I had a formatting problem with my reports that was fixed by
use of the Language property on the report. Although this fixed all
formatting within the report. However, there is still a problem with the
calendar controls that collect DateTime report parameters.
To check that this was not some kind of obscure problem with my particular
report, I put together a very simple example from the AdventureWorks
database.
The dataset was provided by the text query of:
SELECT Title, BirthDate
FROM HumanResources.Employee
WHERE (BirthDate BETWEEN @.StartDate AND @.EndDate)
The @.StartDate and @.EndDate parameters were set to type DateTime with
default value of null. I put a two column table on the report, displaying
Title and BirthDate. The Language of the report is set to English(United
Kingdom). The international setting under options in Visual Studio is set
to 'Same as Microsoft Windows'. My windows setting is English - United
Kingdom.
Once the parameters have been entered on the default calendar controls,
their values are converted to US date format (MM/dd/yyyy). Where the UK
date format will not convert, the following error displays:
"An error occurred during local report processing. The report parameter
'StartDate' is not valid for its type."
If anyone has any ideas of how to fix this, then I would be really grateful.
Virtually every report I run has the start and end date parameters, so
unless I fix this, the default method of collecting these parameters is
effectively useless to me.
Thanks in advance,
Ed AllisonInterestingly, this problem does not seem to occur when reports are deployed
to the report server.
Ed Allison
"Ed Allison" <ed@.optix.co.uk> wrote in message
news:O8B4xJlLGHA.3012@.TK2MSFTNGP14.phx.gbl...
> If anyone can help me with this, I would be really grateful. I am using
> Reporting Services 2005 and Visual Studio 2005 for this problem.
> A while back, I had a formatting problem with my reports that was fixed by
> use of the Language property on the report. Although this fixed all
> formatting within the report. However, there is still a problem with the
> calendar controls that collect DateTime report parameters.
> To check that this was not some kind of obscure problem with my particular
> report, I put together a very simple example from the AdventureWorks
> database.
> The dataset was provided by the text query of:
> SELECT Title, BirthDate
> FROM HumanResources.Employee
> WHERE (BirthDate BETWEEN @.StartDate AND @.EndDate)
> The @.StartDate and @.EndDate parameters were set to type DateTime with
> default value of null. I put a two column table on the report, displaying
> Title and BirthDate. The Language of the report is set to English(United
> Kingdom). The international setting under options in Visual Studio is set
> to 'Same as Microsoft Windows'. My windows setting is English - United
> Kingdom.
> Once the parameters have been entered on the default calendar controls,
> their values are converted to US date format (MM/dd/yyyy). Where the UK
> date format will not convert, the following error displays:
> "An error occurred during local report processing. The report parameter
> 'StartDate' is not valid for its type."
> If anyone has any ideas of how to fix this, then I would be really
> grateful. Virtually every report I run has the start and end date
> parameters, so unless I fix this, the default method of collecting these
> parameters is effectively useless to me.
> Thanks in advance,
> Ed Allison
>|||I have this question as well
"Ed Allison" wrote:
> Interestingly, this problem does not seem to occur when reports are deployed
> to the report server.
> Ed Allison
> "Ed Allison" <ed@.optix.co.uk> wrote in message
> news:O8B4xJlLGHA.3012@.TK2MSFTNGP14.phx.gbl...
> > If anyone can help me with this, I would be really grateful. I am using
> > Reporting Services 2005 and Visual Studio 2005 for this problem.
> >
> > A while back, I had a formatting problem with my reports that was fixed by
> > use of the Language property on the report. Although this fixed all
> > formatting within the report. However, there is still a problem with the
> > calendar controls that collect DateTime report parameters.
> >
> > To check that this was not some kind of obscure problem with my particular
> > report, I put together a very simple example from the AdventureWorks
> > database.
> >
> > The dataset was provided by the text query of:
> >
> > SELECT Title, BirthDate
> > FROM HumanResources.Employee
> > WHERE (BirthDate BETWEEN @.StartDate AND @.EndDate)
> >
> > The @.StartDate and @.EndDate parameters were set to type DateTime with
> > default value of null. I put a two column table on the report, displaying
> > Title and BirthDate. The Language of the report is set to English(United
> > Kingdom). The international setting under options in Visual Studio is set
> > to 'Same as Microsoft Windows'. My windows setting is English - United
> > Kingdom.
> >
> > Once the parameters have been entered on the default calendar controls,
> > their values are converted to US date format (MM/dd/yyyy). Where the UK
> > date format will not convert, the following error displays:
> >
> > "An error occurred during local report processing. The report parameter
> > 'StartDate' is not valid for its type."
> >
> > If anyone has any ideas of how to fix this, then I would be really
> > grateful. Virtually every report I run has the start and end date
> > parameters, so unless I fix this, the default method of collecting these
> > parameters is effectively useless to me.
> >
> > Thanks in advance,
> >
> > Ed Allison
> >
>
>|||I have found no solution to this, I am afraid. Since the problem does not
occur when reports are deployed, I just work around it when developing
reports.
Ed Allison
"Tango" <Tango@.discussions.microsoft.com> wrote in message
news:628FB199-1E9A-4723-8748-0C649E3683EA@.microsoft.com...
>I have this question as well
> "Ed Allison" wrote:
>> Interestingly, this problem does not seem to occur when reports are
>> deployed
>> to the report server.
>> Ed Allison
>> "Ed Allison" <ed@.optix.co.uk> wrote in message
>> news:O8B4xJlLGHA.3012@.TK2MSFTNGP14.phx.gbl...
>> > If anyone can help me with this, I would be really grateful. I am
>> > using
>> > Reporting Services 2005 and Visual Studio 2005 for this problem.
>> >
>> > A while back, I had a formatting problem with my reports that was fixed
>> > by
>> > use of the Language property on the report. Although this fixed all
>> > formatting within the report. However, there is still a problem with
>> > the
>> > calendar controls that collect DateTime report parameters.
>> >
>> > To check that this was not some kind of obscure problem with my
>> > particular
>> > report, I put together a very simple example from the AdventureWorks
>> > database.
>> >
>> > The dataset was provided by the text query of:
>> >
>> > SELECT Title, BirthDate
>> > FROM HumanResources.Employee
>> > WHERE (BirthDate BETWEEN @.StartDate AND @.EndDate)
>> >
>> > The @.StartDate and @.EndDate parameters were set to type DateTime with
>> > default value of null. I put a two column table on the report,
>> > displaying
>> > Title and BirthDate. The Language of the report is set to
>> > English(United
>> > Kingdom). The international setting under options in Visual Studio is
>> > set
>> > to 'Same as Microsoft Windows'. My windows setting is English - United
>> > Kingdom.
>> >
>> > Once the parameters have been entered on the default calendar controls,
>> > their values are converted to US date format (MM/dd/yyyy). Where the
>> > UK
>> > date format will not convert, the following error displays:
>> >
>> > "An error occurred during local report processing. The report
>> > parameter
>> > 'StartDate' is not valid for its type."
>> >
>> > If anyone has any ideas of how to fix this, then I would be really
>> > grateful. Virtually every report I run has the start and end date
>> > parameters, so unless I fix this, the default method of collecting
>> > these
>> > parameters is effectively useless to me.
>> >
>> > Thanks in advance,
>> >
>> > Ed Allison
>> >
>>|||Hi Ed,
I have the same problem and strangely - setting language property on
the report to "default" with international setting under options in
Visual Studio set to "English" sorted out the problem.
If for you this is not acceptable - the way arround (at least it works
for me) is not to press "View report" button - but the small green
refresh button on the toolbar on the preview report tab...
Hope this helps
Ivan

Report line spacing issue

There is a formatting issue that I have come across.
The report has three groups and these groups have headers. When the report is populated most of the time it prints the result properly as expected, but sometimes at different number result records of the query I see that the main group header consumes an entire page and then skips to the next page. But in the next page I get the main group header and the data as it should be printed. After adjusting a page header (not the group headers) the report behaved normally for the same set of data, but fails when the result is changed again.
Any idea what I have done wrong or need to set (maybe a line size or something ) ?Often times when I have that problem, it's due to the "Keep Group Together" option.

Right click on the group name, and choose, "Change Group." Uncheck the "Keep Group Together" box, if it's checked. That might not be the same issue, but it usually resolves the problem with me.

Good luck!|||There is no 'Keep Group Together' checked in this case. I had it earlier and removed it also thinking that may be the issue.
The problem mainly is even if I tweek it a bit and get it to work with one set of data if fails for another one later.
Thanks very much for looking at the issue.|||So all your group expert 'keep group together' and your section expert 'keep together' for groups are unchecked?|||I am terribly sorry. I was all this time unticking the 'Kepp Group Together' check box in the 'Selection Expert' window when RMB and select the 'format..' option.
As I unchecked the check box in the 'Change Group Options' window it worked.
Thank you very much for the help.
By the way do you know why is there two options of 'Keep Group Together' in these two windows ?|||The one in the section expert keeps the section together, e.g. your group header has 3 sections and this keeps these 3 sections together.
The one in the group expert tries to keep the whole group together, i.e. the entire group header, footer, details inbetween etc.

Report Formatting in Excel 2007

I am currently developing a report for users who insist on exporting to Excel 2007. When I export to Excel on my PC, the report formatting is fine (I am using Excel 2003), however, font sizing as applied in the report is lost when exported to Excel 2007 (i.e. font size 9 in the report is actually 10 in excel 2007). In Excel 2007, the data which runs onto two lines does not show up correctly - the second line is squashed below the first.

Any ideas on how I could resolve this?

Strange, I tried on mine but did not experience this. I tried exporting to Excel 2003 and then opening it in Excel 2007 it worked perfectly fine.

Then I also tried extracting the report from a PC which has Excel 2007 and then exporting the report in that PC, even this worked perfectly fine.

Report Formatting Differently on different servers with same RDL

This is a good one:

Same RDL, 2 different servers. I run the report on my computer and export to PDF, it prints properly. When the customer runs the report on their server (SSRS 2K5 SP1, same as mine), they get it displayed differently. The columns on the report extend to the next page and the lines are thicker.

Is this a formatting issue on the customer's PC? It uses standard fonts (Tahoma, Sans-serif).

Any ideas?

maybe you are using a matrix on the report and the customer has different data (more data) that makes the matrix extend?

lines are thicker? I can't think of anything there unless it is the fonts, but you look ok with that.

|||

No, it is not a matrix report. It is a standard layout table that is 10 inches wide, it's set for landscape with .5in margins.

|||I did some more research and started a new report from scratch and the same issue occurs.

Report formatting - green-bar effect

I'm trying to apply the green-bar effect to the detail rows in my report but
the alternating colours are not being applied correctly. The report uses a
table with 3 nested groups defined. For discussion purposes I'll call them
Group A, B and C. Group A is the outermost group, Group B is nested within
Group A, and Group C is nested within Group B. My result set is correctly
displayed so that I end up with 12 rows in Group C. However if I check the
number of rows using the RowNumber function, it tells me there are 20 rows
being returned for Group C.
I looked at the result set in SQL Query Analyzer and discovered that there
are 20 rows, but of these only 12 are unique. So I see why the alternating
colours aren't working, but am not sure how to fix it. Any ideas?
Thanks
--
DawnDawn,
The solution below assumes that you don't have much traffic, concurrent
sessions will cause problems.
Regards,
Cem
Shared ColorState as Boolean = True
Shared Function AlternateColor() as Boolean
if ColorState then
ColorState = False
Return False
else
ColorState = True
Return True
end if
End Function
In the report use IIF(Code.AlternateColor(),"Red","Green")
"Dawn" <Dawn@.discussions.microsoft.com> wrote in message
news:CBF95E44-4B54-4B8A-AFB4-3EEAC0D5B3B5@.microsoft.com...
> I'm trying to apply the green-bar effect to the detail rows in my report
> but
> the alternating colours are not being applied correctly. The report uses a
> table with 3 nested groups defined. For discussion purposes I'll call them
> Group A, B and C. Group A is the outermost group, Group B is nested within
> Group A, and Group C is nested within Group B. My result set is correctly
> displayed so that I end up with 12 rows in Group C. However if I check the
> number of rows using the RowNumber function, it tells me there are 20 rows
> being returned for Group C.
> I looked at the result set in SQL Query Analyzer and discovered that there
> are 20 rows, but of these only 12 are unique. So I see why the alternating
> colours aren't working, but am not sure how to fix it. Any ideas?
> Thanks
> --
> Dawn|||Dawn,
Also take a look at this example, it helped me immensely when trying to
accomplish the same thing- it's how to create a Green Bar Matrix
http://blogs.msdn.com/chrishays/archive/2004/08/30/223068.aspx
Bill Youngman
Anexinet, Inc.
"Dawn" <Dawn@.discussions.microsoft.com> wrote in message
news:CBF95E44-4B54-4B8A-AFB4-3EEAC0D5B3B5@.microsoft.com...
> I'm trying to apply the green-bar effect to the detail rows in my report
but
> the alternating colours are not being applied correctly. The report uses a
> table with 3 nested groups defined. For discussion purposes I'll call them
> Group A, B and C. Group A is the outermost group, Group B is nested within
> Group A, and Group C is nested within Group B. My result set is correctly
> displayed so that I end up with 12 rows in Group C. However if I check the
> number of rows using the RowNumber function, it tells me there are 20 rows
> being returned for Group C.
> I looked at the result set in SQL Query Analyzer and discovered that there
> are 20 rows, but of these only 12 are unique. So I see why the alternating
> colours aren't working, but am not sure how to fix it. Any ideas?
> Thanks
> --
> Dawn

Report Formatting

Hi !
I have a simple question. I am using a Table in my report. I would like to
apply a different color to alternating rows in the table.
What is the correct or recommended way to do this?
Thank you,
YCreating a Green-Bar Report
To apply a green-bar effect (alternating colors every other row) to a table
in a report, use the following expression in the BackgroundColor property of
each text box in the detail row:
=iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White")
this was from books online.
"Yoshi" wrote:
> Hi !
> I have a simple question. I am using a Table in my report. I would like to
> apply a different color to alternating rows in the table.
> What is the correct or recommended way to do this?
> Thank you,
> Y
>
>