is NOT a parameter

When I use this line of code:

CASE WHEN d.StatusId IN ('XF','?','XT') THEN 1 ELSE 0 END AS Status

MS Reporting Services 2005 thinks that ? is a parameter. I know that I can use a stored proc to prevent this, but I would rather not.

Does anyone have suggestions on how to prevent this from occuring?

How about (not testing but it should work):

Code Snippet

CASE WHEN d.StatusID IN ('XF',CHAR(63),'XT') THEN 1 ELSE 0 END AS Status

>L<|||

Thanks Lisa,

That works. I also found that you can remove the <Parameter> tag from the code to fix it.

floyd

|||Nice username. HAHAHA sql

:. DataSet to Reporting Service

Hi to ev'dy:
I need to pass a DataSet created in a WebForm to a Reporting Service, Cos'
my DataSet is Modeled like I want to see in the report.
My question is: How i can to pass this DataSet to Reporting Service and
this reports interact whith it?
Thanks in advance.
José AbadYou have two options. You can write a data processing extension
(non-trivial) or you can use the new VS 2005 webform control in local mode.
In local mode you give it the dataset and the report and the rendering is
done with the control. No server needed or allowed if in local mode. For
anything other than a basic report this is also non-trivial.
Third option is to not do this. Create a stored procedure and call that from
RS. RS is not architected to easily do what you want. Or, if this is a hard
and fast requirement then consider looking at other reporting tools.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"José Abad" <JosAbad@.discussions.microsoft.com> wrote in message
news:246AADF0-9D54-4648-8A00-68E81698BE61@.microsoft.com...
> Hi to ev'dy:
> I need to pass a DataSet created in a WebForm to a Reporting Service, Cos'
> my DataSet is Modeled like I want to see in the report.
> My question is: How i can to pass this DataSet to Reporting Service and
> this reports interact whith it?
>
> Thanks in advance.
> José Abad
>

.Net Reportviewer

plese help me anybody working in .Net report viewer control
how to viewe the report in both Win forms and Webforms
sql server 2005 reporting server
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.comWhat is your question? The best way to approach this is to first learn how
to create reports. Create and deploy the reports to the server. Make sure
you throughly understand creating reports including the use of sub reports
and drill through reports.
VS 2005 comes with two new controls (a winform and webform control). These
are the easiest way to view a report. The other option is either URL
integration (search on Books Online). The final option is to program web
services yourself. With the new controls I strongly recommend against doing
the last option.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<mohan> wrote in message news:2006121355941ragu1100@.yahoo.com...
> plese help me anybody working in .Net report viewer control
> how to viewe the report in both Win forms and Webforms
> sql server 2005 reporting server
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com

.NET Remoting and Reporting Services

We are trying to integrate .NET Remoting and Reporting Services through DSE.
The way we use to point out to Remoting server in the case of "normal"
applications (be it Windows Forms or ASP.NET) was through .config files where
under <configuration> section we create <system.runtime.remoting> subsection.
The problem we are facing at the moment is that we can not find appropriate
.config file where we could store this for Reporting Services. We've tried it
with RSReportDesigner.config, with (Visual Studio's) devenv.config, but
whatever we do, we get an error message "Type not found", when trying to
access the data from Report Designer.
Any hints?
Thanks in advance!Just a note: environment is Reporting Services 2000 SP2 + Visual Studio .NET
2003.|||Hi,
Welcome to use MSDN Managed Newsgroup!
Please store the information in the config file below and let me know
whether it works this time.
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin\ReportingServicesService.exe.config
Sincerely yours,
Michael Cheng
Microsoft Online Partner 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.|||Unfortunatelly, still the same :-(
I do not know, if it has anything to do with the fact that Visual Studio is
"hosting" environment, and not ReportingServices. Nevertheless, I've modified
devenv.exe.config as well, but this also didn't work...
My .config settings look like this:
<configuration>
.
.
.
<system.runtime.remoting>
<application>
<channels>
<channel ref="tcp" />
</channels>
<client>
<wellknown type="App.IPortal, App.Interfaces"
url="tcp://localhost:1234/Portal" />
</client>
</application>
</system.runtime.remoting>
</configuration>
Thanks for your time!
> Please store the information in the config file below and let me know
> whether it works this time.
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\bin\ReportingServicesService.exe.config|||During runtime, when the report is rendered under the Report Server, you
should be able to read the settings from the Report Server web.config file.
C:\Program Files\Microsoft SQL
Server\MSSQL\ReportingServices\ReportServer\web.config
During design time, you should be able to hit F5 and use the Report Host
configuration file (RSReportHost.exe.config). The file doesn't exists so you
need to create it. In VS 2003, RSReportHost.exe should be located in
C:\Program Files\Microsoft Visual Studio 2003\Common7\IDE (I believe).
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"SMG" <dadoo@.online.nospam> wrote in message
news:F7BA992E-8325-4AB8-99D6-39BDF3956056@.microsoft.com...
> Unfortunatelly, still the same :-(
> I do not know, if it has anything to do with the fact that Visual Studio
> is
> "hosting" environment, and not ReportingServices. Nevertheless, I've
> modified
> devenv.exe.config as well, but this also didn't work...
> My .config settings look like this:
> <configuration>
> .
> .
> .
> <system.runtime.remoting>
> <application>
> <channels>
> <channel ref="tcp" />
> </channels>
> <client>
> <wellknown type="App.IPortal, App.Interfaces"
> url="tcp://localhost:1234/Portal" />
> </client>
> </application>
> </system.runtime.remoting>
> </configuration>
>
> Thanks for your time!
>
>> Please store the information in the config file below and let me know
>> whether it works this time.
>> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportServer\bin\ReportingServicesService.exe.config|||Thanks for the reply, but unfortunatelly this didn't work as well :-(
Anyway, I gave up, and created new remoting.config file which I deploy
together with the .dll file.
This seems to work now in Designer, but I am getting rsErrorExecutingCommand
when trying to execute it in ReportManager (in browser). Error message says:
Request for the permission of type
System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
Sure, I did some "googling", and most of the responses on this problem tell
me to make changes to proper *.config files that I did already :-(
Among the others in the rssrvpolicy.config file I have:
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="Business.Reports.DPE"
Description="Code group for the Reports data processing extension">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="c:\SQL Server\MSSQL\Reporting
Services\ReportServer\bin\Business.Reports.DPE.dll" />
</CodeGroup>
I am really stuck with this :-(
I guess it is needless to say that I highly appreciate *any* help!
Regards!
"Teo Lachev [MVP]" wrote:
> During runtime, when the report is rendered under the Report Server, you
> should be able to read the settings from the Report Server web.config file.
> C:\Program Files\Microsoft SQL
> Server\MSSQL\ReportingServices\ReportServer\web.config
> During design time, you should be able to hit F5 and use the Report Host
> configuration file (RSReportHost.exe.config). The file doesn't exists so you
> need to create it. In VS 2003, RSReportHost.exe should be located in
> C:\Program Files\Microsoft Visual Studio 2003\Common7\IDE (I believe).
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---|||Changing the config file often is not enought. You need to find from the
.NET documentation what permission remoting needs. Supposedly, or so I've
heard, .NET 2.0 includes an utility that would tell you what permission the
assembly needs. Once you have the permission, you need to assert in your
code before making the call. If nothing else works, you can bypass CAS
security altogether by changing the rssrvpolicy.config file as follows:
<PermissionSet
class="NamedPermissionSet"
version="1"
Name="Execution">
<IPermission
class="SecurityPermission"
version="1"
Flags="Full"
/>
or web.config by removing the trustLevel line from
<securityPolicy>
<trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />
</securityPolicy>
As a side note, I wish the RS team could have simplified the RS 2005
security model to bring it in par with the SQL Server 2005 security model
where there are only three levels. I personally don't think that RS
developers need to become experts in CAS security.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"SMG" <dadoo@.online.nospam> wrote in message
news:061C5A60-A612-4357-993E-38429E7C63F4@.microsoft.com...
> Thanks for the reply, but unfortunatelly this didn't work as well :-(
> Anyway, I gave up, and created new remoting.config file which I deploy
> together with the .dll file.
> This seems to work now in Designer, but I am getting
> rsErrorExecutingCommand
> when trying to execute it in ReportManager (in browser). Error message
> says:
> Request for the permission of type
> System.Security.Permissions.SecurityPermission, mscorlib,
> Version=1.0.5000.0,
> Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
> Sure, I did some "googling", and most of the responses on this problem
> tell
> me to make changes to proper *.config files that I did already :-(
> Among the others in the rssrvpolicy.config file I have:
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="Business.Reports.DPE"
> Description="Code group for the Reports data processing extension">
> <IMembershipCondition
> class="UrlMembershipCondition"
> version="1"
> Url="c:\SQL Server\MSSQL\Reporting
> Services\ReportServer\bin\Business.Reports.DPE.dll" />
> </CodeGroup>
>
> I am really stuck with this :-(
> I guess it is needless to say that I highly appreciate *any* help!
>
> Regards!
>
> "Teo Lachev [MVP]" wrote:
>> During runtime, when the report is rendered under the Report Server, you
>> should be able to read the settings from the Report Server web.config
>> file.
>> C:\Program Files\Microsoft SQL
>> Server\MSSQL\ReportingServices\ReportServer\web.config
>> During design time, you should be able to hit F5 and use the Report Host
>> configuration file (RSReportHost.exe.config). The file doesn't exists so
>> you
>> need to create it. In VS 2003, RSReportHost.exe should be located in
>> C:\Program Files\Microsoft Visual Studio 2003\Common7\IDE (I believe).
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---

.NET Permissions Error in Reporting Services when not using a custom assembly (Smiley Faces Are

.NET Permissions Error in Reporting Services when not using a custom assembly:

I need help resolving a permissions error I’m taking in a SQL RS 2005 report.

I have a report that that is includes the following code fragment in Report Properties -> Code:

Function rtf2text(ByVal rtf As String) As String
Dim rtfcontrol As New System.Windows.Forms.RichTextBox
Try
rtfcontrol.Rtf = rtf
Return rtfcontrol.Text
Catch ex as Exception
Return ex.Message
End Try
End Function

I reference the .NET System.Windows.Forms DLL under Report Properties ->References -> References, Assembly Name (heading):

System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

I have a text box with the following expression:

=code.rtf2text(First(Fields!EndingQuoteComment.Value, "QuoteHeader"))

And I’ve verified, by removing the code.rtf2text command that is populated with the following:

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Arial;}}\viewkind4\uc1\pard\b\i\f0\fs32 ** Ending Quote Comments **\par\b0\i0\f1\fs17\par}

When I run the preview in Visual Studio is correctly strips the RTF and displays just “** Ending Quote Comments **”.When I ‘RUN’ locally or deploy to a SQL RS 2005 Server and run the report I take the following error:

Request for the permission of type 'System.Security.Permissions.UIPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I’ve tried everything that I can think of on the server to make this work.

I finally put together a Win 2003 box with SQL 2005, IIS, and RS 2005 running on it in a virtual machine to be 100% sure I had a standard clean install and deployed the report and I’m getting the same error.

Below I’ve included a basic standalone RDL file that demonstrates my issue.I get the error referenced above when I deploy the RDL below.Any ideas or suggestions are greatly appreciated?

<?xml version="1.0" encoding="utf-8"?>

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<BottomMargin>0.25in</BottomMargin>

<RightMargin>0.25in</RightMargin>

<PageWidth>7.75in</PageWidth>

<rdrawGrid>true</rdrawGrid>

<InteractiveWidth>7.75in</InteractiveWidth>

<rdnapToGrid>true</rdnapToGrid>

<Body>

<ReportItems>

<Textbox Name="textbox21">

<Left>0.25in</Left>

<Top>0.25in</Top>

<rdefaultName>textbox21</rdefaultName>

<Width>6.375in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>7.5pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>1.375in</Height>

<Value>=code.rtf2text("{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Arial;}}\viewkind4\uc1\pard\b\i\f0\fs32 ** Ending Quote Comments **\par\b0\i0\f1\fs17\par} ")</Value>

</Textbox>

</ReportItems>

<Height>5.25in</Height>

</Body>

<rd:ReportID>8804486c-882f-493c-8dfb-b2f778a24b21</rd:ReportID>

<LeftMargin>0.25in</LeftMargin>

<CodeModules>

<CodeModule>System.Windows.Forms, Version=2.0.50727.42, Culture=neutral, PublicKeyToken=b77a5c561934e089</CodeModule>

</CodeModules>

<Code>Function rtf2text(ByVal rtf As String) As String

Dim rtfcontrol As New System.Windows.Forms.RichTextBox

Try

rtfcontrol.Rtf = rtf

Return rtfcontrol.Text

Catch ex as Exception

Return ex.Message

End Try

End Function </Code>

<Width>7.25in</Width>

<InteractiveHeight>10in</InteractiveHeight>

<Language>en-US</Language>

<TopMargin>0.25in</TopMargin>

<PageHeight>10in</PageHeight>

</Report>

Definitely a .NET code access issue. Not an expert on such things, but here's a couple thoughts...

First off, I'd try changing the SSRS account(s) to your developer/admin account, and then run it. If it works, you know it's not your code (and I don't think it is your code). Then try changing back to your service account, and add the service account to the admins group. If that fixes it, it's just a question of narrowing down what permission you need to add.

This is a another longshot, but perhaps since it's running as a service account, perhaps the system won't let it access UI resources? You might to "Allow service to interact with desktop", or poking around in some of the other server security settings.

Like I said, doubt I've provided any sort of final answer, but perhaps this might get you a bit closer.

Geof

.Net integration with SQL Reporting Services

We are working on a project that includes the development of business classes
to contain all our data access routines. The goal is to be avoid writing
numerous sql statements (some quite complex and some duplicative) in SQL
Reporting Services, forms development etc..
We've tested this model in .Net 2005 using the Report Viewer control and
have a successful pilot. The data access class returns a data set(s) that we
use in the Report Viewer. We would like to move this model to use Reporting
Services.
The question is:
We will compile our data access classes into a dll. We would like to be
able to reference the data access class and return a data set(s) that can be
used by Reporting Services designer. So far we have not figured out how to
do this.
Any suggestions or tips? Thx,your starting point:
http://msdn2.microsoft.com/en-us/library/ms154655.aspx
also you'll found a sample data extension in the official SQL Server website
(part of the samples for SQL 2005)
"def59485" <def59485@.discussions.microsoft.com> wrote in message
news:C3079CEB-6497-46AC-8949-44975EA320A2@.microsoft.com...
> We are working on a project that includes the development of business
> classes
> to contain all our data access routines. The goal is to be avoid writing
> numerous sql statements (some quite complex and some duplicative) in SQL
> Reporting Services, forms development etc..
> We've tested this model in .Net 2005 using the Report Viewer control and
> have a successful pilot. The data access class returns a data set(s) that
> we
> use in the Report Viewer. We would like to move this model to use
> Reporting
> Services.
> The question is:
> We will compile our data access classes into a dll. We would like to be
> able to reference the data access class and return a data set(s) that can
> be
> used by Reporting Services designer. So far we have not figured out how
> to
> do this.
> Any suggestions or tips? Thx,

.Net Framework 2.0 and Reporting Services

When I installed 2.0 on the Web Server Reporting Services stopped working
properly. Is it possible to run them side by side. The server also has 1.1
running.
ThanksOn Fri, 25 Mar 2005 04:59:02 -0800, DJONES
<DJONES@.discussions.microsoft.com> wrote:
>When I installed 2.0 on the Web Server Reporting Services stopped working
>properly. Is it possible to run them side by side. The server also has 1.1
>running.
>Thanks
In theory,
When .NET Framework 2.0 reaches RTM it is supposed to be possible to
run them side by side without problem.
In practice, in the short term, there are assorted issues.
Why do you have .NET Framework 2.0 on your Web server? Which build?
Andrew Watt
MVP - InfoPath|||Thanks for the reply...
I'm working on the Proof of Concept phase of a project using 2.0. I wonder
if it would work with VS loaded on the Web Server instead...
"Andrew Watt [MVP - InfoPath]" wrote:
> On Fri, 25 Mar 2005 04:59:02 -0800, DJONES
> <DJONES@.discussions.microsoft.com> wrote:
> >When I installed 2.0 on the Web Server Reporting Services stopped working
> >properly. Is it possible to run them side by side. The server also has 1.1
> >running.
> >
> >Thanks
> In theory,
> When .NET Framework 2.0 reaches RTM it is supposed to be possible to
> run them side by side without problem.
> In practice, in the short term, there are assorted issues.
> Why do you have .NET Framework 2.0 on your Web server? Which build?
> Andrew Watt
> MVP - InfoPath
>|||I would suggest that the best thing is to ask your question (with a
more detailed description of your situation) on the Reporting Services
2005 NG. It's called microsoft.private.sqlserver2005.reportingsvcs.
Despite its name it's public.
You will see me there too. But I like to leave the pain of version
incompatibilities to others - so at this stage I only install one
version of SQL Server 2005 on a machine. Some of the others on that
group may have a solution to your situation though.
I would expect Visual Studio 2005 to cause you the same problem -
since it too will install .NET Framework 2.0.
Andrew Watt
MVP - InfoPath
On Fri, 25 Mar 2005 07:15:03 -0800, DJONES
<DJONES@.discussions.microsoft.com> wrote:
>Thanks for the reply...
>I'm working on the Proof of Concept phase of a project using 2.0. I wonder
>if it would work with VS loaded on the Web Server instead...
>"Andrew Watt [MVP - InfoPath]" wrote:
>> On Fri, 25 Mar 2005 04:59:02 -0800, DJONES
>> <DJONES@.discussions.microsoft.com> wrote:
>> >When I installed 2.0 on the Web Server Reporting Services stopped working
>> >properly. Is it possible to run them side by side. The server also has 1.1
>> >running.
>> >
>> >Thanks
>> In theory,
>> When .NET Framework 2.0 reaches RTM it is supposed to be possible to
>> run them side by side without problem.
>> In practice, in the short term, there are assorted issues.
>> Why do you have .NET Framework 2.0 on your Web server? Which build?
>> Andrew Watt
>> MVP - InfoPath|||We have similar situation - fix was two-fold, all done in IIS.
First, create an applicaton pool specifically for the two reporting
services applications, then set the properties of each application to
use that pool. Applications using different frameworks cannot "swim in
the same pool".
Second, ensure that the reporting services applications are configured
to use the 1.1 framework and not the 2.0 - the tedious way is to check
(and change, if needed) every mapping through the IIS properties pages.
The faster way is to use the command line applications to do this
configuration - but I think injudicious use of the command line can
remap all the applications at once - which could be what happened when
you installed the 2.0 framework.|||The command line tool aspnet_regiis has options to check the current script
mappings and to install certain versions for a particular virtual root only
rather than all virtual roots:
aspnet_regiis -lk
aspnet_regiis -s <path>
Make sure to run the aspnet_regiis.exe from the correct version directory
under \Windows\Microsoft.Net\Framework
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Parker" <psmith@.iquest.net> wrote in message
news:1112015101.606172.149480@.g14g2000cwa.googlegroups.com...
> We have similar situation - fix was two-fold, all done in IIS.
> First, create an applicaton pool specifically for the two reporting
> services applications, then set the properties of each application to
> use that pool. Applications using different frameworks cannot "swim in
> the same pool".
> Second, ensure that the reporting services applications are configured
> to use the 1.1 framework and not the 2.0 - the tedious way is to check
> (and change, if needed) every mapping through the IIS properties pages.
> The faster way is to use the command line applications to do this
> configuration - but I think injudicious use of the command line can
> remap all the applications at once - which could be what happened when
> you installed the 2.0 framework.
>

.Net and Reporting Services

Does anyone know of a good tutorial incorporating ASP.net and the new Reporting Services?Hi Sara

Hard to find but yeah - there is one on www.aspnetpro.com
Cheers
G|||Can you give me an exact link, I didn't see it.

Thank you.|||I did find this but would like to find any others:

http://www.odetocode.com/Articles/95.aspx

.net 2002 and RS

Hi is it possible to work on with in .net 2002 IDE with reporting
services. If yes, than what extra i may need to install?
Thanks in advanceNo. You need VS2003 for SQL Server RS2000, For SQL Server 2005, it comes
with report designer (if you also have VS2005 installed, the designer
becomes part of VS2005).
"Techotsav" <Utsav.Verma@.gmail.com> wrote in message
news:1134480575.125459.170630@.g14g2000cwa.googlegroups.com...
> Hi is it possible to work on with in .net 2002 IDE with reporting
> services. If yes, than what extra i may need to install?
> Thanks in advance
>|||Thnaks man!

**URGENT** Page Break Error in Custom Report Viewer

Hi Guys,
We are using in our application , the "Report Viewer" Component which comes
as part of the Reporting services Samples .
We are having a problem when viewing the data in "Report Viewer" as
explained below.
There is a Group Expression on the List in the Report and the option "Insert
a page break after this table" on the Table is set.
But when the report is rendered and viewed in the "Report Viewer", no new
pages are created for each group and the data is displayed continuously. But
when we export the report into a "PDF" document, all different groups appear
on different pages properly with proper Page Breaks.
We also have applied the SP1 to the reporting services.
Any help is appreciated..
Regards
Raj ChidipudiI am having the same problem. any luck in finding a result
"Raj Chidipudi" wrote:
> Hi Guys,
> We are using in our application , the "Report Viewer" Component which comes
> as part of the Reporting services Samples .
> We are having a problem when viewing the data in "Report Viewer" as
> explained below.
> There is a Group Expression on the List in the Report and the option "Insert
> a page break after this table" on the Table is set.
> But when the report is rendered and viewed in the "Report Viewer", no new
> pages are created for each group and the data is displayed continuously. But
> when we export the report into a "PDF" document, all different groups appear
> on different pages properly with proper Page Breaks.
> We also have applied the SP1 to the reporting services.
> Any help is appreciated..
> Regards
> Raj Chidipudi
>
>|||I know this may sound odd but try this:
Make sure that your report satisfies the condition specified below
(Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=Body.Width
"doyledirk" <doyledirk@.discussions.microsoft.com> wrote in message
news:BC90664A-2AB3-41D9-AD1D-B1B86D77AAAC@.microsoft.com...
>I am having the same problem. any luck in finding a result
> "Raj Chidipudi" wrote:
>> Hi Guys,
>> We are using in our application , the "Report Viewer" Component which
>> comes
>> as part of the Reporting services Samples .
>> We are having a problem when viewing the data in "Report Viewer" as
>> explained below.
>> There is a Group Expression on the List in the Report and the option
>> "Insert
>> a page break after this table" on the Table is set.
>> But when the report is rendered and viewed in the "Report Viewer", no new
>> pages are created for each group and the data is displayed continuously.
>> But
>> when we export the report into a "PDF" document, all different groups
>> appear
>> on different pages properly with proper Page Breaks.
>> We also have applied the SP1 to the reporting services.
>> Any help is appreciated..
>> Regards
>> Raj Chidipudi
>>
>>

*********How to settle this...***********

I have a big database to test my report, the report is made by reporting
service.
But when the query for the report get too many data such as more than
100,000 rows for the dataset, My computer is down because of lacking memory.
What can I do ?If you are on SQL Server, you can add TOP 20 or so to the query while you test. Like:
SELECT TOP 20 col1, col2
FROM ...
...
But it might be better to tune the query, look at the execution plan, perhaps create indexes to
support the query etc. This depends on where the bottleneck is. Perhaps it is the RD environment
which becomes sluggish with that many rows, and tweaking in SQL server wouldn't help in that case.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Cao tt" <Cao tt@.discussions.microsoft.com> wrote in message
news:4F14BC17-A381-4219-B124-EC2D6D5B3256@.microsoft.com...
> I have a big database to test my report, the report is made by reporting
> service.
> But when the query for the report get too many data such as more than
> 100,000 rows for the dataset, My computer is down because of lacking memory.
> What can I do ?|||Are you wanting the report to have 100,000 row result set? If so, you are
going to find that there will be problems with RS. It does certain actions
in memory and that large a resultset is a problem. Note that it is the
number of rows returned that matters. Not the size of the table on the
backend. I have 20 million row tables I am going against. The main issue
when going against large tables is do not use filters. Filters return all
the data and then filters it. Use query parameters and have only the data
you need downloaded. Or if you have aggregates, have that occur via the
query as well. Another useful technique is to use drill through instead of
drill down. With drill down you can end up with huge datasets. By using
drill through instead you can limit the data.
This issue (100,000 row resultset) is not really specific to RS. It is
always best to limit the data going to the client. No human is going to look
at 100,000 rows of data.
Bruce L-C
"Cao tt" <Cao tt@.discussions.microsoft.com> wrote in message
news:4F14BC17-A381-4219-B124-EC2D6D5B3256@.microsoft.com...
> I have a big database to test my report, the report is made by reporting
> service.
> But when the query for the report get too many data such as more than
> 100,000 rows for the dataset, My computer is down because of lacking
memory.
> What can I do ?

* * * Passing Parameter - Urgent * * *

I program an ASP.NET application that uses SQL Server 2005 Reporting
Services.
Recently I came into a dead end when I had to pass a parameter from my
application
to the report. I 've looked over the Internet and found absolutely nothing.
If someone is
capable of doing that he/she doesn't have to be shy to share it with me.
Thanks in advance,
Nick Hatzis
P.S. : To answer by e-mail remove the "bog" from the username.Hi,
What kind of parameter you must pass?|||Hi Cesar,
I have to pass four string parameters.
Two that will appear in the report and two
(from-to) that will be used in the query.
Thanks in advance,
Nick Hatzis
P.S. : To answer by e-mail remove the "bog" from the username.
"Cesar" <Cesar@.discussions.microsoft.com> wrote in message
news:490E74EF-519C-4D5E-BB69-C8412CB909C2@.microsoft.com...
> Hi,
> What kind of parameter you must pass?|||Are you using an URL to open the report? In that case, you should look at
the topic "URL access" in the SQL Server 2005 Books Online.
If you have it locally, this should be the URL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsprg9/html/52c3f2a3-3d6d-4fee-9c46-83f366919398.htm
Or find it online at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_urlaccess_374y.asp
Kaisa M. Lindahl Lervik
"Nick Hatzis" <boghatzisn@.panafonet.gr> wrote in message
news:%23MK70oQ7GHA.1012@.TK2MSFTNGP05.phx.gbl...
>I program an ASP.NET application that uses SQL Server 2005 Reporting
> Services.
> Recently I came into a dead end when I had to pass a parameter from my
> application
> to the report. I 've looked over the Internet and found absolutely
> nothing.
> If someone is
> capable of doing that he/she doesn't have to be shy to share it with me.
> Thanks in advance,
> Nick Hatzis
> P.S. : To answer by e-mail remove the "bog" from the username.
>|||On Wed, 11 Oct 2006 11:01:52 +0300, "Nick Hatzis"
<boghatzisn@.panafonet.gr> wrote:
>I program an ASP.NET application that uses SQL Server 2005 Reporting
>Services.
>Recently I came into a dead end when I had to pass a parameter from my
>application
>to the report. I 've looked over the Internet and found absolutely nothing.
>If someone is
>capable of doing that he/she doesn't have to be shy to share it with me.
>Thanks in advance,
>Nick Hatzis
>P.S. : To answer by e-mail remove the "bog" from the username.
>
Are you using reportviewer or just going direct to the URL? If direct
to the URL, something like this:
Response.Redirect("http://199.199.199.199/ReportServer?%2fReportProjectName%2fReportName&rs:Command=Render&rs:Format=PDF&IssueID=11000")
That IssueID at the end is a parameter. Note the rs:Format that gets
the report directly as a PDF.
If you're using a reportviewer control, parameters are done like this:
Dim RptParm As New
Microsoft.Reporting.WebForms.ReportParameter("FileNumParam",
lblFileNum.Text) ' name/value pair for a parameter
Dim RptParms As New Generic.List(Of
Microsoft.Reporting.WebForms.ReportParameter)
RptParms.Add(RptParm)
' add more parameters as necessary to RptParams
Reportviewer1.ServerReport.SetParameters(RptParms)

(This site might require the following ActiveX control: ‘Microsoft SQL Server 2000 Reporting Ser

When a user tries to print using client side printing it gives the following error:-

(This site might require the following ActiveX control: ‘Microsoft SQL Server 2000 Reporting Services’ from Microsoft Corporation.’ Click here to install.)

My client machines have ie 6 sp 2 already installed.

Do I need to install anything on my client machines as well? I have over 100 clients ?
Full fidelity printing requires downloading an ActiveX control to the client. You can turn off the print icon if this is not acceptable.|||Hi .

How can i turn off my print icon in report toolbar. i am using sql server 2000.

Thanks in advance,
Sanket.

(This site might require the following ActiveX control: ‘Microsoft SQL Server 2000 Reporting Ser

When a user tries to print using client side printing it gives the following error:-

(This site might require the following ActiveX control: ‘Microsoft SQL Server 2000 Reporting Services’ from Microsoft Corporation.’ Click here to install.)

My client machines have ie 6 sp 2 already installed.

Do I need to install anything on my client machines as well? I have over 100 clients ?
Full fidelity printing requires downloading an ActiveX control to the client. You can turn off the print icon if this is not acceptable.|||Hi .

How can i turn off my print icon in report toolbar. i am using sql server 2000.

Thanks in advance,
Sanket.

(This site might require the following ActiveX control: ‘Microsoft SQL Server 2000 Reporting

When a user tries to print using client side printing it gives the following error:-

(This site might require the following ActiveX control: ‘Microsoft SQL Server 2000 Reporting Services’ from Microsoft Corporation.’ Click here to install.)

My client machines have ie 6 sp 2 already installed.

Do I need to install anything on my client machines as well? I have over 100 clients ?
Full fidelity printing requires downloading an ActiveX control to the client. You can turn off the print icon if this is not acceptable.|||Hi .

How can i turn off my print icon in report toolbar. i am using sql server 2000.

Thanks in advance,
Sanket.

(Select All) Checkbox As Default

All,

When creating a dynamic parameter list from a query, Reporting Services graciously provides a "(Select All)" checkbox. How can I select this checkbox by default so that when a user generates the report, all of the values are selected?

Thanks

The "select all" item is just a UI concept at this point. You could setup a default value for the report parameter that contains all values of the valid values list - but in that case all the checkboxes for individual items would be pre-selected, but the "select all" would still not be pre-selected.

-- Robert

|||Thanks for the reply. I actually tried your approach before posting my question. The problem that I am facing when using this approach is that the pre-selection is always static so this will not work when my checkbox list is populated from a query. Since the results of the query are dynamic, I can't setup a default list with any degree of accuracy.|||

Robert,

Is there any way to tell when the Select All option is selected?

R

|||

I don't know if this works

But if my dropdown source is Query, and with "Multi-Value items" checkbox checked

Under Default Values, If I choose "Query", pick the Dataset, put in the value field -> it will select all rows in the query by default

When I go to Preview, all items from the query ARE checked in the dropdown. Even the "ALL" option I created myself

(now the problem is, how do you uncheck them all with ease...)

I hope that's what you're looking for, I wish there's easy way to post pictures

|||

The closest you can get is to compare the number of rows in the dataset used for the valid values list (e.g. =CountRows("ParameterDataSetName")) with the number of selected parameter values (e.g. =Parameters!P1.Count)

-- Robert

(Select All) Checkbox As Default

All,

When creating a dynamic parameter list from a query, Reporting Services graciously provides a "(Select All)" checkbox. How can I select this checkbox by default so that when a user generates the report, all of the values are selected?

Thanks

The "select all" item is just a UI concept at this point. You could setup a default value for the report parameter that contains all values of the valid values list - but in that case all the checkboxes for individual items would be pre-selected, but the "select all" would still not be pre-selected.

-- Robert

|||Thanks for the reply. I actually tried your approach before posting my question. The problem that I am facing when using this approach is that the pre-selection is always static so this will not work when my checkbox list is populated from a query. Since the results of the query are dynamic, I can't setup a default list with any degree of accuracy.|||

Robert,

Is there any way to tell when the Select All option is selected?

R

|||

I don't know if this works

But if my dropdown source is Query, and with "Multi-Value items" checkbox checked

Under Default Values, If I choose "Query", pick the Dataset, put in the value field -> it will select all rows in the query by default

When I go to Preview, all items from the query ARE checked in the dropdown. Even the "ALL" option I created myself

(now the problem is, how do you uncheck them all with ease...)

I hope that's what you're looking for, I wish there's easy way to post pictures

|||

The closest you can get is to compare the number of rows in the dataset used for the valid values list (e.g. =CountRows("ParameterDataSetName")) with the number of selected parameter values (e.g. =Parameters!P1.Count)

-- Robert

(Select All) Checkbox As Default

All,

When creating a dynamic parameter list from a query, Reporting Services graciously provides a "(Select All)" checkbox. How can I select this checkbox by default so that when a user generates the report, all of the values are selected?

Thanks

The "select all" item is just a UI concept at this point. You could setup a default value for the report parameter that contains all values of the valid values list - but in that case all the checkboxes for individual items would be pre-selected, but the "select all" would still not be pre-selected.

-- Robert

|||Thanks for the reply. I actually tried your approach before posting my question. The problem that I am facing when using this approach is that the pre-selection is always static so this will not work when my checkbox list is populated from a query. Since the results of the query are dynamic, I can't setup a default list with any degree of accuracy.|||

Robert,

Is there any way to tell when the Select All option is selected?

R

|||

I don't know if this works

But if my dropdown source is Query, and with "Multi-Value items" checkbox checked

Under Default Values, If I choose "Query", pick the Dataset, put in the value field -> it will select all rows in the query by default

When I go to Preview, all items from the query ARE checked in the dropdown. Even the "ALL" option I created myself

(now the problem is, how do you uncheck them all with ease...)

I hope that's what you're looking for, I wish there's easy way to post pictures

|||

The closest you can get is to compare the number of rows in the dataset used for the valid values list (e.g. =CountRows("ParameterDataSetName")) with the number of selected parameter values (e.g. =Parameters!P1.Count)

-- Robert

(RS 2000) Row Count in Header?

I am using Reporting Services 2000 and need to know if there is a way to
list the number of rows returned in the Header or Footer?
Any help is greatly appreciated.
- CarlCarl,
If you use the COUNT function in SSRS, it should calculate that for
you. In one of the header/footer cells, make the expression something
like: =Count(Fields!fieldName.Value)
You can make these more informative by putting a descriptor after the
count value like: =Count(Fields!fieldName.Value) &
Iif(Count(Fields!fieldName.Value) = 1, " Employee", " Employees")
Also, the count function just looks within its own scope. If you use a
table header, it looks at the whole table. If you use a group header,
it looks just within its group.
Hope this helps!
-Josh
Vagabond Software wrote:
> I am using Reporting Services 2000 and need to know if there is a way to
> list the number of rows returned in the Header or Footer?
> Any help is greatly appreciated.
> - Carl|||"Josh" <bell.joshua@.gmail.com> wrote in message
news:1155300982.086540.318880@.p79g2000cwp.googlegroups.com...
> Carl,
> If you use the COUNT function in SSRS, it should calculate that for
> you. In one of the header/footer cells, make the expression something
> like: =Count(Fields!fieldName.Value)
> You can make these more informative by putting a descriptor after the
> count value like: =Count(Fields!fieldName.Value) &
> Iif(Count(Fields!fieldName.Value) = 1, " Employee", " Employees")
> Also, the count function just looks within its own scope. If you use a
> table header, it looks at the whole table. If you use a group header,
> it looks just within its group.
> Hope this helps!
> -Josh
Though I couldn't use the COUNT function in the Header or the Footer, I was
able to make space in the Body, above the table, to use the function.
Thanks for the help.
- Carl|||Carl,
Glad you got it working, but you might want to further investigate the
Count problem... I borrowed a friends workstation that has SSRS 2000
and confirmed that the Count function DOES work in that version of the
product.
I made a simple query that returned 1 field and put a Count expression
in the table footer. It displayed the correct number.
Best wishes!
-Josh
Vagabond Software wrote:
> "Josh" <bell.joshua@.gmail.com> wrote in message
> news:1155300982.086540.318880@.p79g2000cwp.googlegroups.com...
> >
> > Carl,
> >
> > If you use the COUNT function in SSRS, it should calculate that for
> > you. In one of the header/footer cells, make the expression something
> > like: =Count(Fields!fieldName.Value)
> >
> > You can make these more informative by putting a descriptor after the
> > count value like: =Count(Fields!fieldName.Value) &
> > Iif(Count(Fields!fieldName.Value) = 1, " Employee", " Employees")
> >
> > Also, the count function just looks within its own scope. If you use a
> > table header, it looks at the whole table. If you use a group header,
> > it looks just within its group.
> >
> > Hope this helps!
> >
> > -Josh
>
> Though I couldn't use the COUNT function in the Header or the Footer, I was
> able to make space in the Body, above the table, to use the function.
> Thanks for the help.
> - Carl|||"Josh" <bell.joshua@.gmail.com> wrote in message
news:1155530591.436146.248650@.75g2000cwc.googlegroups.com...
> Carl,
> Glad you got it working, but you might want to further investigate the
> Count problem... I borrowed a friends workstation that has SSRS 2000
> and confirmed that the Count function DOES work in that version of the
> product.
> I made a simple query that returned 1 field and put a Count expression
> in the table footer. It displayed the correct number.
> Best wishes!
> -Josh
I will keep playing with it, but if I add a Textbox to the footer and
attempt to use the Count expression in the Value property of that Textbox, I
get a build error something like this:
"The value expression for the textbox 'textbox15' refers to a field. Fields
cannot be used in page headers or footers."
Thanks for all the help.
- carl|||Carl,
You are adding the textbox to the PAGE footer, not the table footer.
The table is bound to a dataset, so you can reference a field in the
table footer by using "Fields!fieldName.Value" without having to
specify the dataset to which that field belongs.
If you add a textbox to the body, page header, or page footer, you need
to reference the dataset as well. Usually, one you do this, it has to
return a scalar value, so you might be forced to use a First, Last,
Sum, Count, etc. function to condense the result into a single value.
If you use the expression builder (right-click on the textbox and
select Expression), you can click on Datasets on the left and see your
options. If it is a text datatype, I think it defaults to First; if it
is a number datatype, I think it defaults to Sum. The expression will
automatically add the name of the dataset using the correct syntax.
If you need it in the PAGE footer, try this approach. If you meant it
to be a table footer, it should be a simple
Count(Fields!fieldName.Value).
Any closer?
-Josh
Vagabond Software wrote:
> "Josh" <bell.joshua@.gmail.com> wrote in message
> news:1155530591.436146.248650@.75g2000cwc.googlegroups.com...
> >
> > Carl,
> >
> > Glad you got it working, but you might want to further investigate the
> > Count problem... I borrowed a friends workstation that has SSRS 2000
> > and confirmed that the Count function DOES work in that version of the
> > product.
> >
> > I made a simple query that returned 1 field and put a Count expression
> > in the table footer. It displayed the correct number.
> >
> > Best wishes!
> >
> > -Josh
> I will keep playing with it, but if I add a Textbox to the footer and
> attempt to use the Count expression in the Value property of that Textbox, I
> get a build error something like this:
> "The value expression for the textbox 'textbox15' refers to a field. Fields
> cannot be used in page headers or footers."
> Thanks for all the help.
> - carl