Showing posts with label ssrs. Show all posts
Showing posts with label ssrs. Show all posts

Thursday, March 29, 2012

Boolean report parameter with Yes/No choice list

SSRS 2005
In the Report Designer you can specify a Boolean report parameter with a
list of values. When the report is viewed on the Preview tab, the dropdown
list is rendered for the parameter instead of the usual True/False radio
buttons.
However, when the report is run on the Report Server, the same report
parameter is rendered with the usual True/False radio buttons and the defined
list is ignored.
Is this a bug in Report Designer, Report Server or both? Are there plans to
fix one of these so at least the behavior is consistent?
--
Chris, SSSIHello Chris,
I have reproduced this issue.
I am contacting the product team to check whether there is any fix or
workaround for this issue. I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei,
Any update on a fix or workaround for this?
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> I have reproduced this issue.
> I am contacting the product team to check whether there is any fix or
> workaround for this issue. I appreciate your patience.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Chris,
The product team is still look into this. I will update any information
ASAP.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Chris,
After a long discussion with internal product team, this issue has a
workaround:
Use a string parameter with a Valid Values list instead.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Sunday, March 25, 2012

Books on SSRS

Any recommendations on best book(s) to get a quick start with SQL Reorting
Services ? and hopefully with some depth ?
Thanks ....Liz,
did you try to query Amazon ' I found some... unfortunatly I haven't found
the time to order and read one.... maybe this helps a bit...
Regards
/Martin
"Liz" <liz@.tiredofspam.com> schrieb im Newsbeitrag
news:BIMVc.22183033$Of.3703104@.news.easynews.com...
> Any recommendations on best book(s) to get a quick start with SQL Reorting
> Services ? and hopefully with some depth ?
> Thanks ....
>|||Also take a look at
http://www.microsoft.com/sql/reporting/techinfo/books.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Martin Schlenker" <Martinschlenker@.web.de> wrote in message
news:Oah0Ol7hEHA.3664@.TK2MSFTNGP11.phx.gbl...
> Liz,
> did you try to query Amazon ' I found some... unfortunatly I haven't
found
> the time to order and read one.... maybe this helps a bit...
> Regards
> /Martin
> "Liz" <liz@.tiredofspam.com> schrieb im Newsbeitrag
> news:BIMVc.22183033$Of.3703104@.news.easynews.com...
> >
> > Any recommendations on best book(s) to get a quick start with SQL
Reorting
> > Services ? and hopefully with some depth ?
> >
> > Thanks ....
> >
> >
>

Sunday, February 19, 2012

Blank Pages generated after the subreport

Hi,

I am very new to SSRS. I developed a report which has two subreports in it. Blank page is generated at the end of each Page. Can any one help me how to avoid this.

try to reduce the spacing between the sub report components on the main page - It needs some trail and error

Thursday, February 16, 2012

Blank Pages

When I print my report in SSRS it says there are 5 pages, when I print my
report to the printer, 22 pages comes out, every other page is blank. It
does the same when I print it to PDF.
I went to Report Properties>>Layout and have my settings as 10in Width, 8in
Height and margins are set to zero.
What is wrong here?
Thanks,
RyanOn Jun 14, 2:24 pm, Ryan Mcbee <RyanMc...@.discussions.microsoft.com>
wrote:
> When I print my report in SSRS it says there are 5 pages, when I print my
> report to the printer, 22 pages comes out, every other page is blank. It
> does the same when I print it to PDF.
> I went to Report Properties>>Layout and have my settings as 10in Width, 8in
> Height and margins are set to zero.
> What is wrong here?
> Thanks,
> Ryan
You want to make sure that you are not page breaking after groups,
etc. Also, I find that when exporting to PDF, a lot of times the extra
pages can be avoided by putting multiple table/matrix controls inside
a single rectangle control (where applicable). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Blank page at http://localhost/reports and VS.Net Crashes on Preview

I have two questions. I am trying to work through some very simple reports to get the feel for SSRS. I am running SQL Server 2005 Developer Edition and I have VS.Net 2005 Pro installed on Windows XP SP2. I can walk through the report wizard just fine. But when I go to preview the report I get an exception in VS.Net.

Faulting application devenv.exe, version 8.0.50727.42, stamp 4333e699, faulting module kernel32.dll, version 5.1.2600.2180, stamp 411096b4, debug? 0, fault address 0x0001eb33.

Now I know that this doesn't mean much in terms of sorting out the issue, but I thought that I would include it.

My second question is that I have created a data source and data model. When I try to bring up Report Manager at http://localhost/reports, all I see is a blank page. Nothing is displayed. I can't seem to find anything on the forums about this.

Thanks,

Scott

check reporting services have been installed properly

check Reports and ReportServer folders under default Website folder in ISS

check ReportServerDb and ReportServerTemp Db databases in sqlserver

always install first reporting services and then VS .NET ..