Report automatically runs with null params allowed. SSRS 2000

I see that other people have had a problem with this, but I never saw
a solution or a work around. Has anyone found a work around to this
issue? I want to allow nulls in all the parameters, but I don't want
the report to run by itself in Report Manager.
And does anyone know if this is fixed in SSRS 2005? We'll be
migrating to that later this year.
TIAOn Sep 17, 10:20 am, beener <rmp_c...@.hotmail.com> wrote:
> I see that other people have had a problem with this, but I never saw
> a solution or a work around. Has anyone found a work around to this
> issue? I want to allow nulls in all the parameters, but I don't want
> the report to run by itself in Report Manager.
> And does anyone know if this is fixed in SSRS 2005? We'll be
> migrating to that later this year.
> TIA
As far as I know, this is still the case in SSRS 2005. I've seen
several posts requesting this functionality. The only thing I can
think of is to have one of the parameters not have a default value.
Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Report Authoring Using Report Builder

We have deployed multiple report builder models and the number 1 user complaint is that every report builder report created can only have 1 table or 1 matrix or 1 chart in per .rdl (or report created). Anyone found any way around this? Is there a fix planned?This was an intentional design constraint for this release. There are no workarounds. We are definitely looking to include this functionality in a future release.

report authentication: windows prompt removal

Hello,

I'm writing a small program to access reports on a remote server. When simply accessing the server, using the reportviewer, I get a windows prompt for login. I would like to avoid this by passing the account information.

How should I do this? (Maybe through network credentials)

Could someone send me some example code?

Thank you.

Jos

i'm not sure but i think you mean that you want to acces it through internet explorer?

if that's the case , demanding the credentials depends on the zone your page is in

see internet explorer>extra>internet options>security

by default internet explorer demands credentials for public sites and uses integrated login for intranet, that i wouldn't change

the clue is that any address with a dot . (be it in an ip or dns notation, eg 10.2.54.56 or webserver.domain.local) is regarded by default as a public address

so either you add the adress in the intranet zone or you change the adress in wins notation style ( eg //webserver/reports)

|||

Well I want to access the reports through a small asp.net program. You may see the source code in http://www.odetocode.com/Articles/95.aspx

When I access my reportserver (http://sqlreport244_9.mysite4now.com/reportserver) I get prompted for a windows login.

What I would like to do is to set the credentials on the code of the asp.net program to avoid being shown the prompt. This program will be used by several users and don't want them to have to insert the password each time they access the reports.

Thanks

Report Authentication

This is a newbie question. I have the report viewer component on one of my
aspx pages. When the user tries to open this page, he/she is prompted with a
user/password on the server. How do I set up the reporting services so that
it uses a generic account for all requests from the web. Thanks.
PremWell, the wrong way is to turn on Anonymous access to the Report Server. The
proper way is to create a custom security extension to replace the default
Windows-based security.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Prem" <Prem@.discussions.microsoft.com> wrote in message
news:607E279E-7CC5-4135-BA35-F786EEE2A4E6@.microsoft.com...
> This is a newbie question. I have the report viewer component on one of my
> aspx pages. When the user tries to open this page, he/she is prompted with
a
> user/password on the server. How do I set up the reporting services so
that
> it uses a generic account for all requests from the web. Thanks.
> Prem
>|||Thanks Nell. That works.
"Nell" wrote:
> You need to grant permissions to your users and groups on the report server.
> You can do this at 'http://servername/reports', select the folder you want to
> apply permissions to, then select 'properties' and 'security'. Check out this
> article on Ode to Code for more info.
> http://odetocode.com/Articles/215.aspx
> You need to give browse access to the accounts you want to be able to view
> your reports, if you're using anonymous access then you need to make sure
> that the user you have set up in IIS for anonymous access (usually
> IUSR_computername or IWAM_computername) has this level of access. Don't
> give this account any unnecessary permissions though!
> "Prem" wrote:
> > This is a newbie question. I have the report viewer component on one of my
> > aspx pages. When the user tries to open this page, he/she is prompted with a
> > user/password on the server. How do I set up the reporting services so that
> > it uses a generic account for all requests from the web. Thanks.
> >
> > Prem
> >|||You need to grant permissions to your users and groups on the report server.
You can do this at 'http://servername/reports', select the folder you want to
apply permissions to, then select 'properties' and 'security'. Check out this
article on Ode to Code for more info.
http://odetocode.com/Articles/215.aspx
You need to give browse access to the accounts you want to be able to view
your reports, if you're using anonymous access then you need to make sure
that the user you have set up in IIS for anonymous access (usually
IUSR_computername or IWAM_computername) has this level of access. Don't
give this account any unnecessary permissions though!
"Prem" wrote:
> This is a newbie question. I have the report viewer component on one of my
> aspx pages. When the user tries to open this page, he/she is prompted with a
> user/password on the server. How do I set up the reporting services so that
> it uses a generic account for all requests from the web. Thanks.
> Prem
>

Report Authenication

Hi,
I have the following scenario:
1) A database server (machine A, Windows 2000 Server Standard) within a
domain
2) A Reporting Server (machine B, Windows 2003 Server Standard) within the
same domain; the Reporting-Services-Database is also on the Database-server
3) My Client (windows XP) within the same domain.
My Problem: When I publisch a Report to the Reporting Server and I use
"Windows integrated Authentication", I get an error "NT-Authority/Anonymous
User" cant access the database. That's right, but why wouldn't be used my
Username/password instead of Anonymous? What have I to do, to pass my
Logonuser form XP over the Reporting-Services to the Database ? A always
thought "windows integrated authentication" in the shared Connection object
would be enough?
Thanks
HansIt sounds to me like you have IIS setup for anonymous access. When you do
this all users are the same user (the anonymous user as you see below). You
should only be doing this if you are implementing custom authorization.
Otherwise this is a really bad idea.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Hans" <sqlserver@.strengberg.net> wrote in message
news:O0FIBcazEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have the following scenario:
> 1) A database server (machine A, Windows 2000 Server Standard) within a
> domain
> 2) A Reporting Server (machine B, Windows 2003 Server Standard) within the
> same domain; the Reporting-Services-Database is also on the
Database-server
> 3) My Client (windows XP) within the same domain.
> My Problem: When I publisch a Report to the Reporting Server and I use
> "Windows integrated Authentication", I get an error
"NT-Authority/Anonymous
> User" cant access the database. That's right, but why wouldn't be used my
> Username/password instead of Anonymous? What have I to do, to pass my
> Logonuser form XP over the Reporting-Services to the Database ? A always
> thought "windows integrated authentication" in the shared Connection
object
> would be enough?
> Thanks
> Hans
>|||If you are trying to authenticate in a scenerio which involves more than two
endpoints eg: client connects to remote RS web service which connects to a
remote database (3 endpoints) and tou're using Integrated security, NTLM
authentication will not work, you will have to setup a delegation scenerio
using kerberos authentication which supports more than one network hop. Look
here for help about setting up a asp.net app for delegation.
http://support.microsoft.com/default.aspx?scid=kb;en-us;810572
To test that this is your problem first access the report from the reporting
services console, this seems to cache your credential locally, now try from
your remote client try the same report, it should work until you log off the
rs server.
HTH,
Dan
"Hans" wrote:
> Hi,
> I have the following scenario:
> 1) A database server (machine A, Windows 2000 Server Standard) within a
> domain
> 2) A Reporting Server (machine B, Windows 2003 Server Standard) within the
> same domain; the Reporting-Services-Database is also on the Database-server
> 3) My Client (windows XP) within the same domain.
> My Problem: When I publisch a Report to the Reporting Server and I use
> "Windows integrated Authentication", I get an error "NT-Authority/Anonymous
> User" cant access the database. That's right, but why wouldn't be used my
> Username/password instead of Anonymous? What have I to do, to pass my
> Logonuser form XP over the Reporting-Services to the Database ? A always
> thought "windows integrated authentication" in the shared Connection object
> would be enough?
> Thanks
> Hans
>
>|||Thanks to all for the answers. I have disabled all anonymous and I think,
its the problem, Dan reports, because I have 3 Endpoints. I will test this.
Thanks again.
Hans
"Hans" <sqlserver@.strengberg.net> schrieb im Newsbeitrag
news:O0FIBcazEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have the following scenario:
> 1) A database server (machine A, Windows 2000 Server Standard) within a
> domain
> 2) A Reporting Server (machine B, Windows 2003 Server Standard) within the
> same domain; the Reporting-Services-Database is also on the
> Database-server
> 3) My Client (windows XP) within the same domain.
> My Problem: When I publisch a Report to the Reporting Server and I use
> "Windows integrated Authentication", I get an error
> "NT-Authority/Anonymous User" cant access the database. That's right, but
> why wouldn't be used my Username/password instead of Anonymous? What have
> I to do, to pass my Logonuser form XP over the Reporting-Services to the
> Database ? A always thought "windows integrated authentication" in the
> shared Connection object would be enough?
> Thanks
> Hans
>

report as side by side records display

I want to generate a report for information related to different libraries. It is required to print two library information (two records) side by side in a page. I do not know how to do so.like

libraray name: abc libraray name: abc
address: abc address:abc
phone:30 phone:abc

best regards
kashifIf there is a link between these table, then u can use linking concept and retrieve data from any of the tables.

If not, try to look at the sub reports concept. May be helpful to you.

Report Application Server

I know very little about Crystal so please bear with me.

I have created a report and copied it to my new Report Application Server. When i try to launch it through eportfolio i get the following:

CrystalReportViewer

Failed to load database information. Details: The database DLL 'crdb_p2bbtrv.dll' could not be loaded. Error in File C:\WINDOWS\TEMP\{A5C8C86B-05EA-4CB3-92B1-DF48C5382F9C}.rpt: Failed to load database information.


webReporting.dll error '800002cd'
Failed to load database information. Details: The database DLL 'crdb_p2bbtrv.dll' could not be loaded. Error in File C:\WINDOWS\TEMP\{A5C8C86B-05EA-4CB3-92B1-DF48C5382F9C}.rpt: Failed to load database information.

/rassamples/en/asp/rPortfolio/HTMLViewers/interactiveViewer.asp, line 30

Any ideas anyone...??Just download crystal report x1 redistributable package to the server

Report appearance issues

I have 2 issues wih the appearance of my report both in the preview tab and when I deploy.

1. My report contains a subreport and the subreport appears indented from the left edge of the main report. How can I stop this? I won't the subreport to be aligned with the main report.
2. The last column of my report is stretched to the edge of the page even though I have all my cells set to CanGrow = false. How can I stop this?

Any help is appreciated.
I solved this one myself. The subreport's body was wider than the main report's body and as I have the table centred on both reports the subreport appeared indented. As soon as I made both report's body width the same the subreport aligned with the main report correctly. I also set every cell in the table in both reports to CanGrow = false and that stopped the last column stretching to the edge of the page.

Report and Subreport

Ok, I am attempting to create my first report in SQL Reporting services. I
am using SQL Enterprise 2000 sp3, VS.NET 2003, and IIS5.
I have created a report that has several columns of general information.
One of the columns is "employee_id" This report worked fine up to this
point.
I then created a subreport that pulls some employee information based on the
employee_id. This report uses a stored procedure to get the data, and the
stored proc parameter is called @.employeeID.
I have placed the subreport on the master report, set its report name to the
name of the sub report, and set it's passed parameter to the "employee_id"
field of the master report.
In the subreport, I have set the dataset's employee_id parameter to the
subreport's employee_id parameter.
When I run the master report I receive an error stating that the stored proc
used by the sub report did not receive it's value. So, it appears that the
report parameters are not making it to the stored proc... What am I
missing? Is there something special that I need to do to make the
subreports parameter pass on to the stored proc used by the subreport?
any help would be appreciated.
thanks in advance.Did you specify the subreport in hyperlink action (navigation) for
employee_id in main report, if so, this should work. Here's an example.
You'll need the following stored procedure in local pubs database:
// +++++++++++++++++++++++++++++++++++++++++++
create proc GetPublisherDetails (@.pubid_param int) As
begin
select * from publishers where pub_id = @.pubid_param
end
// +++++++++++++++++++++++++++++++++++++++++++
Here are the RDLs for main report and child report. They go against the
local pubs database. Please let me know if this works for you.
Main report:
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Height>0.75in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
�Textbox Name="textbox5">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox5</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>pub id</Value>
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>title</Value>
�/Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
�Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox4</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="title">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>title</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!title.Value</Value>
�/Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>pubs</DataSetName>
<Top>0.125in</Top>
<Width>4.33334in</Width>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="pub_id">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextDecoratiok>Underline</TextDecoration>
<FontSize>8pt</FontSize>
<Color>Crimson</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>pub_id</rd:DefaultName>
<Action>
<Drillthrough>
<Parameters>
<Parameter Name="pubid_param">
<Value>= Fields!pub_id.Value</Value>
</Parameter>
</Parameters>
<ReportName>Child</ReportName>
</Drillthrough>
</Action>
<CanGrow>true</CanGrow>
<Value>=Fields!pub_id.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox6</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table1_Group1">
<GroupExpressions>
<GroupExpression>=Fields!pub_id.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<Left>0.125in</Left>
<TableColumns>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>3.125in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="pubs">
<rd:DataSourceID>d9a7bb6a-bc81-4f36-96e6-e27dffdfd71c</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>initial catalog=pubs</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="pubs">
<Fields>
<Field Name="title">
<DataField>title</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="type">
<DataField>type</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="pub_id">
<DataField>pub_id</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>pubs</DataSourceName>
<CommandText>select title, type, pub_id from titles</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>608a77f9-a9e7-41db-ac50-c156ff9bd82e</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
Child report:
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Height>0.5in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
�Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>7</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>pub name</Value>
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>6</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>city</Value>
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="textboxk">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox3</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>state</Value>
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox4</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>country</Value>
�/Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
�Textbox Name="pub_name">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>pub_name</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!pub_name.Value</Value>
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="city">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FonkSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>city</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!city.Value</Value>
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="state">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>state</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!state.Value</Value>
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="country">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>country</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!country.Value</Value>
�/Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>pubs</DataSetName>
<TableColumns>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="pubs">
<rd:DataSourceID>d6f77576-e36c-45dc-877c-a28464b055e8</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>initial catalog=pubs</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>8.66667in</Width>
<DataSets>
<DataSet Name="pubs">
<Fields>
<Field Name="pub_id">
<DataField>pub_id</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="pub_name">
<DataField>pub_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="city">
<DataField>city</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="state">
<DataField>state</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="country">
<DataField>country</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>pubs</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>GetPublisherDetails</CommandText>
<QueryParameters>
<QueryParameter Name="@.pubid_param">
<Value>=Parameters!pubid_param.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>ab635794-d5b4-4ac8-adc6-4891acac8879</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<ReportParameters>
<ReportParameter Name="pubid_param">
<DataType>Integer</DataType>
<Prompt>pubid_param</Prompt>
</ReportParameter>
</ReportParameters>
<Language>en-US</Language>
</Report>
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Johnny Fugazzi" <abillmeier@.ldmkusa.com> wrote in message
news:eAR8Ma8fEHA.216@.tk2msftngp13.phx.gbl...
> Ok, I am attempting to create my first report in SQL Reporting services.
I
> am using SQL Enterprise 2000 sp3, VS.NET 2003, and IIS5.
> I have created a report that has several columns of general information.
> One of the columns is "employee_id" This report worked fine up to this
> point.
> I then created a subreport that pulls some employee information based on
the
> employee_id. This report uses a stored procedure to get the data, and the
> stored proc parameter is called @.employeeID.
> I have placed the subreport on the master report, set its report name to
the
> name of the sub report, and set it's passed parameter to the "employee_id"
> field of the master report.
> In the subreport, I have set the dataset's employee_id parameter to the
> subreport's employee_id parameter.
> When I run the master report I receive an error stating that the stored
proc
> used by the sub report did not receive it's value. So, it appears that
the
> report parameters are not making it to the stored proc... What am I
> missing? Is there something special that I need to do to make the
> subreports parameter pass on to the stored proc used by the subreport?
> any help would be appreciated.
> thanks in advance.
>
>|||got it working.
thanks
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:O3ZduO9fEHA.904@.TK2MSFTNGP09.phx.gbl...
> Did you specify the subreport in hyperlink action (navigation) for
> employee_id in main report, if so, this should work. Here's an example.
> You'll need the following stored procedure in local pubs database:
> // +++++++++++++++++++++++++++++++++++++++++++
> create proc GetPublisherDetails (@.pubid_param int) As
> begin
> select * from publishers where pub_id = @.pubid_param
> end
> // +++++++++++++++++++++++++++++++++++++++++++
> Here are the RDLs for main report and child report. They go against the
> local pubs database. Please let me know if this works for you.
> Main report:
> <?xml version="1.0" encoding="utf-8"?>
> <Report
>
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
> tion"
>
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <RightMargin>1in</RightMargin>
> <Body>
> <ReportItems>
> <Table Name="table1">
> <Height>0.75in</Height>
> <Style />
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> �Textbox Name="textbox5">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> <FontWeight>700</FontWeight>
> </Style>
> <ZIndex>5</ZIndex>
> <rd:DefaultName>textbox5</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>pub id</Value>
> �/Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> �Textbox Name="textbox1">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> <FontWeight>700</FontWeight>
> </Style>
> <ZIndex>4</ZIndex>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>title</Value>
> �/Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Header>
> <Details>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> �Textbox Name="textbox4">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>1</ZIndex>
> <rd:DefaultName>textbox4</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> �/Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> �Textbox Name="title">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>title</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Fields!title.Value</Value>
> �/Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Details>
> <DataSetName>pubs</DataSetName>
> <Top>0.125in</Top>
> <Width>4.33334in</Width>
> <TableGroups>
> <TableGroup>
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="pub_id">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <TextDecoratiok>Underline</TextDecoration>
> <FontSize>8pt</FontSize>
> <Color>Crimson</Color>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> <FontWeight>700</FontWeight>
> </Style>
> <ZIndex>3</ZIndex>
> <rd:DefaultName>pub_id</rd:DefaultName>
> <Action>
> <Drillthrough>
> <Parameters>
> <Parameter Name="pubid_param">
> <Value>= Fields!pub_id.Value</Value>
> </Parameter>
> </Parameters>
> <ReportName>Child</ReportName>
> </Drillthrough>
> </Action>
> <CanGrow>true</CanGrow>
> <Value>=Fields!pub_id.Value</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox6">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>2</ZIndex>
> <rd:DefaultName>textbox6</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Header>
> <Grouping Name="table1_Group1">
> <GroupExpressions>
> <GroupExpression>=Fields!pub_id.Value</GroupExpression>
> </GroupExpressions>
> </Grouping>
> </TableGroup>
> </TableGroups>
> <Left>0.125in</Left>
> <TableColumns>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> </TableColumns>
> </Table>
> </ReportItems>
> <Style />
> <Height>3.125in</Height>
> </Body>
> <TopMargin>1in</TopMargin>
> <DataSources>
> <DataSource Name="pubs">
> <rd:DataSourceID>d9a7bb6a-bc81-4f36-96e6-e27dffdfd71c</rd:DataSourceID>
> <ConnectionProperties>
> <DataProvider>SQL</DataProvider>
> <ConnectString>initial catalog=pubs</ConnectString>
> <IntegratedSecurity>true</IntegratedSecurity>
> </ConnectionProperties>
> </DataSource>
> </DataSources>
> <Width>6.5in</Width>
> <DataSets>
> <DataSet Name="pubs">
> <Fields>
> <Field Name="title">
> <DataField>title</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="type">
> <DataField>type</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="pub_id">
> <DataField>pub_id</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> </Fields>
> <Query>
> <DataSourceName>pubs</DataSourceName>
> <CommandText>select title, type, pub_id from titles</CommandText>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> </Query>
> </DataSet>
> </DataSets>
> <LeftMargin>1in</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <rd:DrawGrid>true</rd:DrawGrid>
> <rd:ReportID>608a77f9-a9e7-41db-ac50-c156ff9bd82e</rd:ReportID>
> <BottomMargin>1in</BottomMargin>
> <Language>en-US</Language>
> </Report>
>
> Child report:
> <?xml version="1.0" encoding="utf-8"?>
> <Report
>
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
> tion"
>
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <RightMargin>1in</RightMargin>
> <Body>
> <ReportItems>
> <Table Name="table1">
> <Height>0.5in</Height>
> <Style />
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> �Textbox Name="textbox1">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> <FontWeight>700</FontWeight>
> </Style>
> <ZIndex>7</ZIndex>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>pub name</Value>
> �/Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> �Textbox Name="textbox2">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> <FontWeight>700</FontWeight>
> </Style>
> <ZIndex>6</ZIndex>
> <rd:DefaultName>textbox2</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>city</Value>
> �/Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> �Textbox Name="textboxk">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> <FontWeight>700</FontWeight>
> </Style>
> <ZIndex>5</ZIndex>
> <rd:DefaultName>textbox3</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>state</Value>
> �/Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> �Textbox Name="textbox4">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> <FontWeight>700</FontWeight>
> </Style>
> <ZIndex>4</ZIndex>
> <rd:DefaultName>textbox4</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>country</Value>
> �/Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Header>
> <Details>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> �Textbox Name="pub_name">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>3</ZIndex>
> <rd:DefaultName>pub_name</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Fields!pub_name.Value</Value>
> �/Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> �Textbox Name="city">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FonkSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>2</ZIndex>
> <rd:DefaultName>city</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Fields!city.Value</Value>
> �/Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> �Textbox Name="state">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>1</ZIndex>
> <rd:DefaultName>state</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Fields!state.Value</Value>
> �/Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> �Textbox Name="country">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <FontSize>8pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>country</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Fields!country.Value</Value>
> �/Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Details>
> <DataSetName>pubs</DataSetName>
> <TableColumns>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> </TableColumns>
> </Table>
> </ReportItems>
> <Style />
> <Height>2in</Height>
> </Body>
> <TopMargin>1in</TopMargin>
> <DataSources>
> <DataSource Name="pubs">
> <rd:DataSourceID>d6f77576-e36c-45dc-877c-a28464b055e8</rd:DataSourceID>
> <ConnectionProperties>
> <DataProvider>SQL</DataProvider>
> <ConnectString>initial catalog=pubs</ConnectString>
> <IntegratedSecurity>true</IntegratedSecurity>
> </ConnectionProperties>
> </DataSource>
> </DataSources>
> <Width>8.66667in</Width>
> <DataSets>
> <DataSet Name="pubs">
> <Fields>
> <Field Name="pub_id">
> <DataField>pub_id</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="pub_name">
> <DataField>pub_name</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="city">
> <DataField>city</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="state">
> <DataField>state</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="country">
> <DataField>country</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> </Fields>
> <Query>
> <DataSourceName>pubs</DataSourceName>
> <CommandType>StoredProcedure</CommandType>
> <CommandText>GetPublisherDetails</CommandText>
> <QueryParameters>
> <QueryParameter Name="@.pubid_param">
> <Value>=Parameters!pubid_param.Value</Value>
> </QueryParameter>
> </QueryParameters>
> </Query>
> </DataSet>
> </DataSets>
> <LeftMargin>1in</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <rd:DrawGrid>true</rd:DrawGrid>
> <rd:ReportID>ab635794-d5b4-4ac8-adc6-4891acac8879</rd:ReportID>
> <BottomMargin>1in</BottomMargin>
> <ReportParameters>
> <ReportParameter Name="pubid_param">
> <DataType>Integer</DataType>
> <Prompt>pubid_param</Prompt>
> </ReportParameter>
> </ReportParameters>
> <Language>en-US</Language>
> </Report>
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Johnny Fugazzi" <abillmeier@.ldmkusa.com> wrote in message
> news:eAR8Ma8fEHA.216@.tk2msftngp13.phx.gbl...
> > Ok, I am attempting to create my first report in SQL Reporting services.
> I
> > am using SQL Enterprise 2000 sp3, VS.NET 2003, and IIS5.
> >
> > I have created a report that has several columns of general information.
> > One of the columns is "employee_id" This report worked fine up to this
> > point.
> >
> > I then created a subreport that pulls some employee information based on
> the
> > employee_id. This report uses a stored procedure to get the data, and
the
> > stored proc parameter is called @.employeeID.
> >
> > I have placed the subreport on the master report, set its report name to
> the
> > name of the sub report, and set it's passed parameter to the
"employee_id"
> > field of the master report.
> >
> > In the subreport, I have set the dataset's employee_id parameter to the
> > subreport's employee_id parameter.
> >
> > When I run the master report I receive an error stating that the stored
> proc
> > used by the sub report did not receive it's value. So, it appears that
> the
> > report parameters are not making it to the stored proc... What am I
> > missing? Is there something special that I need to do to make the
> > subreports parameter pass on to the stored proc used by the subreport?
> >
> > any help would be appreciated.
> >
> > thanks in advance.
> >
> >
> >
>

Report and styles question

Hi:
I have to define several style guidelines to build a set of reports with the
same visual styles.
I want my reports to have tables and I want the odd rows WHITE and the even
rows RED (by example)... how can I do this kind of thing?
About the deployment of my styles: I have to configure any report I will
implement with the same styles one by one?
There is no way to apply a style template (like a cascading style sheet or
XSL) to all my reports or to define my reports using something like
Model-View-Controller design?
Thanks in advance
ErnestoGreen Bar Report
----
See the sample rdl at the end of this message. It shows how this can be
accomplished for groups and detail rows.
Style Templates
----
SQL Server 2000 Reporting Services has somewhat limited style template
support. Improving support in this area is being looked at for inclusion in
a future release.
Until then you have the following options:
1. You can approximate this behavior by creating the specific report you
want and then placing it in C:\ProgramFiles\Microsoft SQL
Server\80\Tools\Report Designer\ProjectItems\ReportProject directory. These
reports "templates" will show up in Report Designer's Add New Item dialog
along with the Report Wizard, Report, and Data Source templates when
you add a new report to a project.
2. For simple wizard-created reports, you can control the style via
modifying the wizard style templates (there's an XML config file for this
documented in the help)
3. If you're wanting to modify the style dynamically after the reports are
created, you could store style information in your database and then query
for that information in your report, setting style properties based on the
query results (e.g. FontFamily
=First(Fields!DetailRowFontFamily.Value,"StyleDataSet"))
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
news:%23AOSqt8XEHA.3012@.tk2msftngp13.phx.gbl...
> Hi:
> I have to define several style guidelines to build a set of reports with
the
> same visual styles.
> I want my reports to have tables and I want the odd rows WHITE and the
even
> rows RED (by example)... how can I do this kind of thing?
> About the deployment of my styles: I have to configure any report I will
> implement with the same styles one by one?
> There is no way to apply a style template (like a cascading style sheet or
> XSL) to all my reports or to define my reports using something like
> Model-View-Controller design?
> Thanks in advance
>
> Ernesto
>
>
Green Bar Report Sample
----
--
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Height>0.75in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Country</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Company Name</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox4</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CompanyName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RowNumber(Nothing) Mod 2,
"PaleGreen", "White")</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>CompanyName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!CompanyName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>DataSet1</DataSetName>
<Width>4.33333in</Width>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="Country">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RunningValue(Fields!Country.Value,CountDistinct,Nothin
g) Mod 2, "Cornsilk", "White")</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>Country</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!Country.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox11</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<Grouping Name="CountryGroup">
<GroupExpressions>
<GroupExpression>=Fields!Country.Value</GroupExpression>
</GroupExpressions>
<PageBreakAtEnd>true</PageBreakAtEnd>
</Grouping>
</TableGroup>
</TableGroups>
<TableColumns>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>0.875in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>b688b025-197a-46a6-ad1e-97cfe7c0d320</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=localhost;initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="CustomerID">
<DataField>CustomerID</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="CompanyName">
<DataField>CompanyName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ContactName">
<DataField>ContactName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ContactTitle">
<DataField>ContactTitle</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Address">
<DataField>Address</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="City">
<DataField>City</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Region">
<DataField>Region</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="PostalCode">
<DataField>PostalCode</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Country">
<DataField>Country</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Phone">
<DataField>Phone</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Fax">
<DataField>Fax</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>select * from customers</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>0848d9be-0d3d-4002-8752-e94ca66164e0</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>|||Bruce,
thanks for your help
Saludos
Ernesto
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:esd85S9XEHA.2408@.tk2msftngp13.phx.gbl...
> Green Bar Report
> ----
> See the sample rdl at the end of this message. It shows how this can be
> accomplished for groups and detail rows.
> Style Templates
> ----
> SQL Server 2000 Reporting Services has somewhat limited style template
> support. Improving support in this area is being looked at for inclusion
in
> a future release.
> Until then you have the following options:
> 1. You can approximate this behavior by creating the specific report you
> want and then placing it in C:\ProgramFiles\Microsoft SQL
> Server\80\Tools\Report Designer\ProjectItems\ReportProject directory.
These
> reports "templates" will show up in Report Designer's Add New Item dialog
> along with the Report Wizard, Report, and Data Source templates when
> you add a new report to a project.
>
> 2. For simple wizard-created reports, you can control the style via
> modifying the wizard style templates (there's an XML config file for this
> documented in the help)
> 3. If you're wanting to modify the style dynamically after the reports
are
> created, you could store style information in your database and then query
> for that information in your report, setting style properties based on the
> query results (e.g. FontFamily
> =First(Fields!DetailRowFontFamily.Value,"StyleDataSet"))
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
> news:%23AOSqt8XEHA.3012@.tk2msftngp13.phx.gbl...
> > Hi:
> >
> > I have to define several style guidelines to build a set of reports with
> the
> > same visual styles.
> >
> > I want my reports to have tables and I want the odd rows WHITE and the
> even
> > rows RED (by example)... how can I do this kind of thing?
> >
> > About the deployment of my styles: I have to configure any report I will
> > implement with the same styles one by one?
> >
> > There is no way to apply a style template (like a cascading style sheet
or
> > XSL) to all my reports or to define my reports using something like
> > Model-View-Controller design?
> >
> > Thanks in advance
> >
> >
> >
> > Ernesto
> >
> >
> >
> Green Bar Report Sample
> ----
--
> --
> <?xml version="1.0" encoding="utf-8"?>
> <Report
>
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
> tion"
>
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <RightMargin>1in</RightMargin>
> <Body>
> <ReportItems>
> <Table Name="table1">
> <Height>0.75in</Height>
> <Style />
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox1">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>5</ZIndex>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>Country</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox2">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>4</ZIndex>
> <rd:DefaultName>textbox2</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>Company Name</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Header>
> <Details>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox4">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>1</ZIndex>
> <rd:DefaultName>textbox4</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="CompanyName">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <BackgroundColor>=iif(RowNumber(Nothing) Mod 2,
> "PaleGreen", "White")</BackgroundColor>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>CompanyName</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Fields!CompanyName.Value</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Details>
> <DataSetName>DataSet1</DataSetName>
> <Width>4.33333in</Width>
> <TableGroups>
> <TableGroup>
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="Country">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
>
<BackgroundColor>=iif(RunningValue(Fields!Country.Value,CountDistinct,Nothin
> g) Mod 2, "Cornsilk", "White")</BackgroundColor>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>3</ZIndex>
> <rd:DefaultName>Country</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Fields!Country.Value</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox11">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>2</ZIndex>
> <rd:DefaultName>textbox11</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> <RepeatOnNewPage>true</RepeatOnNewPage>
> </Header>
> <Grouping Name="CountryGroup">
> <GroupExpressions>
> <GroupExpression>=Fields!Country.Value</GroupExpression>
> </GroupExpressions>
> <PageBreakAtEnd>true</PageBreakAtEnd>
> </Grouping>
> </TableGroup>
> </TableGroups>
> <TableColumns>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> </TableColumns>
> </Table>
> </ReportItems>
> <Style />
> <Height>0.875in</Height>
> </Body>
> <TopMargin>1in</TopMargin>
> <DataSources>
> <DataSource Name="Northwind">
> <rd:DataSourceID>b688b025-197a-46a6-ad1e-97cfe7c0d320</rd:DataSourceID>
> <ConnectionProperties>
> <DataProvider>SQL</DataProvider>
> <ConnectString>data source=localhost;initial
> catalog=Northwind</ConnectString>
> <IntegratedSecurity>true</IntegratedSecurity>
> </ConnectionProperties>
> </DataSource>
> </DataSources>
> <Width>6.5in</Width>
> <DataSets>
> <DataSet Name="DataSet1">
> <Fields>
> <Field Name="CustomerID">
> <DataField>CustomerID</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="CompanyName">
> <DataField>CompanyName</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="ContactName">
> <DataField>ContactName</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="ContactTitle">
> <DataField>ContactTitle</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Address">
> <DataField>Address</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="City">
> <DataField>City</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Region">
> <DataField>Region</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="PostalCode">
> <DataField>PostalCode</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Country">
> <DataField>Country</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Phone">
> <DataField>Phone</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Fax">
> <DataField>Fax</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> </Fields>
> <Query>
> <DataSourceName>Northwind</DataSourceName>
> <CommandText>select * from customers</CommandText>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> </Query>
> </DataSet>
> </DataSets>
> <LeftMargin>1in</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <rd:DrawGrid>true</rd:DrawGrid>
> <rd:ReportID>0848d9be-0d3d-4002-8752-e94ca66164e0</rd:ReportID>
> <BottomMargin>1in</BottomMargin>
> <Language>en-US</Language>
> </Report>
>

Report and Query Design

Hi all - have finally got reporting services working and am wondering how I would go about designing an order form. I have 2 tables - order and orderline.

Would it be best to design a query which got all information in one retrievale (so that orderid is repeated on each record retrieved) or 2 seperate queries and therefore use a subreport - the main report having the order details and the subreport containing all the orderlines.

Thanks in advance,

Stephen.

The best way to do this by using subReport or drillthrough report where you get the main data in the first report and each row will navigate to the sub report and get the detials fro great start and sample

please read this is article it also contains great sample

http://www.gotreportviewer.com/

Report and other controls not rendered

After resolving all the installation and configuration related issues, I was able to deploy a couple of projects on my report server. I can see alll folders and reports listed inside the folders from http://<servername>/reports . All works fine except when I run a report, the http://<servername>/Reports/Pages/Report.aspx page does not render report.

This page displays View, Properties, History Subscriptions etc, menu items on the top section of the page. It also displays Home, My Subscriptions, Site Settings, Help etc. links on top right corner of the page. I can also see the bar that has "New subscription" button. But the problem starts from the section below that. It does NOT display the Report navigation bottons (like First page button, Next Page button, previous page button, Last page button, print button etc.) Appears that the icons images for these bottons are missing. And above all, the page does not render report.

IE browser status indicate the following error:

error:'HoevrImagectl161_ctl01_ctl01_ctl06_ctl01' is null or not an object.

The report renders fine via http://<servername>/ReportServer/Pages/ReportViewer.aspx

I may not have explained the problem well here however, if you are interested, I can email you the screenshot of Report.aspx to help you understand the problem.

Any help is appreciated!!!

It seems you are using MOSS. Are you you have installed Sharepoint addon for Reporting Services found at http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en

If you have. Have tou configured the reporting services in central admin - Application Settings?

If you have make sure in VS2005 you have deployed to the correct MOSS site collection and correct MOSS library and that is where you view your reports.

In MOSS the reports should render using RSViewerPage.aspx

Thanks
|||

Thanks for reply.

No. I am not running MOSS on this machine. Any other thought?

|||

I just uploaded the screenprint at :

http://i205.photobucket.com/albums/bb8/spnet/ReportSerrverProblem.jpg

P.s. : I have deliberately masked out the server name and parameter value.

|||

Pls help!! Any ideas?

|||

Woohhaaa!!!!!!!!! Figured that out.

It was a javascript error - "RSController.

Make sure your Reports website has the following seeting:

Right click "Reports" website on IIS manager

Go to Properties

Click on Virtual Directory tab

Click on Configuration button

In "wildcard Application Maps.." section, you should have the latest version of aspnet_isapi.dll file listed. If not listed, insert the file. Usually, the file is located at C:\Windows\Microsft.NET\Framework\<your version folder>\aspnet_isapi.dll

Now, click on "Edit" button. Make sure "Verify that File exixts" checkbox is UNCHECKED.

Click "ok" and exit out of Report properties dialogue box. Your reports should work now without IIS throwing any RSController or PramasCtl, imagehower etc. related errors.

Also visit:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=327473&SiteID=1

thank you all!!

Report and other controls not rendered

After resolving all the installation and configuration related issues, I was able to deploy a couple of projects on my report server. I can see alll folders and reports listed inside the folders from http://<servername>/reports . All works fine except when I run a report, the http://<servername>/Reports/Pages/Report.aspx page does not render report.

This page displays View, Properties, History Subscriptions etc, menu items on the top section of the page. It also displays Home, My Subscriptions, Site Settings, Help etc. links on top right corner of the page. I can also see the bar that has "New subscription" button. But the problem starts from the section below that. It does NOT display the Report navigation bottons (like First page button, Next Page button, previous page button, Last page button, print button etc.) Appears that the icons images for these bottons are missing. And above all, the page does not render report.

IE browser status indicate the following error:

error:'HoevrImagectl161_ctl01_ctl01_ctl06_ctl01' is null or not an object.

The report renders fine via http://<servername>/ReportServer/Pages/ReportViewer.aspx

I may not have explained the problem well here however, if you are interested, I can email you the screenshot of Report.aspx to help you understand the problem.

Any help is appreciated!!!

It seems you are using MOSS. Are you you have installed Sharepoint addon for Reporting Services found at http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en

If you have. Have tou configured the reporting services in central admin - Application Settings?

If you have make sure in VS2005 you have deployed to the correct MOSS site collection and correct MOSS library and that is where you view your reports.

In MOSS the reports should render using RSViewerPage.aspx

Thanks
|||

Thanks for reply.

No. I am not running MOSS on this machine. Any other thought?

|||

I just uploaded the screenprint at :

http://i205.photobucket.com/albums/bb8/spnet/ReportSerrverProblem.jpg

P.s. : I have deliberately masked out the server name and parameter value.

|||

Pls help!! Any ideas?

|||

Woohhaaa!!!!!!!!! Figured that out.

It was a javascript error - "RSController.

Make sure your Reports website has the following seeting:

Right click "Reports" website on IIS manager

Go to Properties

Click on Virtual Directory tab

Click on Configuration button

In "wildcard Application Maps.." section, you should have the latest version of aspnet_isapi.dll file listed. If not listed, insert the file. Usually, the file is located at C:\Windows\Microsft.NET\Framework\<your version folder>\aspnet_isapi.dll

Now, click on "Edit" button. Make sure "Verify that File exixts" checkbox is UNCHECKED.

Click "ok" and exit out of Report properties dialogue box. Your reports should work now without IIS throwing any RSController or PramasCtl, imagehower etc. related errors.

Also visit:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=327473&SiteID=1

thank you all!!

Report and Images on Interanet

Hi - I wonder if anyone has tried to display images from a intranet site? when I try to do it the images doesn't get render and ends up as [x]. And the same report executed in VS gives me the following error:

The value expression for the image ‘image1’ contains a URL reference, which is not supported.

Any ideas? IS it looking for a .com ... Limitation?

The URL is constructed as follow: http://servername/folder/imagefile

Thanks

Are you rendering the report with the webservice?

What are you exactly trying to do? I had the same problem and in my new article I solved it but I dont know if its what you are looking for, anyway when you read you can ask again or clear the question.

http://levalenciam.spaces.msn.com/

|||The issue was related to bad server/password. Thanks

Report and Audit Controls from Log??

Can The SqlServer Log/LogArchives be used for reporting a change/audit history of important database fields?
Cand the Logs be used to lookup when and how often certain fields were/are changed...
Cnn the log be used as an Audit control to prove to the customer that he changed his oun fields by date and time? And Provide before and after images of changes by date and time...
You might want to look into the products offered by Lumigent.
(www.lumigent.com)
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"SqlBob" <rplewis@.mindspring.com> wrote in message
news:855EDBB3-1857-456F-91BD-DB51947B0BE4@.microsoft.com...
Can The SqlServer Log/LogArchives be used for reporting a change/audit
history of important database fields?
Cand the Logs be used to lookup when and how often certain fields were/are
changed...
Cnn the log be used as an Audit control to prove to the customer that he
changed his oun fields by date and time? And Provide before and after
images of changes by date and time...

Report and Audit Controls from Log??

Can The SqlServer Log/LogArchives be used for reporting a change/audit histo
ry of important database fields?
Cand the Logs be used to lookup when and how often certain fields were/are c
hanged...
Cnn the log be used as an Audit control to prove to the customer that he cha
nged his oun fields by date and time? And Provide before and after images
of changes by date and time...You might want to look into the products offered by Lumigent.
(www.lumigent.com)
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"SqlBob" <rplewis@.mindspring.com> wrote in message
news:855EDBB3-1857-456F-91BD-DB51947B0BE4@.microsoft.com...
Can The SqlServer Log/LogArchives be used for reporting a change/audit
history of important database fields?
Cand the Logs be used to lookup when and how often certain fields were/are
changed...
Cnn the log be used as an Audit control to prove to the customer that he
changed his oun fields by date and time? And Provide before and after
images of changes by date and time...

Report always end with blank page

Hi,
Regardless of the set of data, I am finding that the report always ends with
a blank page.
I have tried several combinations of changing the KeepTogether parameter and
have made sure the PageBreakAtStart = false and PageBreakAtEnd = false
everywhere.
What could cause this extra page?
KevinThis has happened to me when my report contained an object, like a
table, that was a hair wider than the margins. Make sure your objects
are within the left and right margins.
Just an idea.
Shane
Kevin VanRiper wrote:
> Hi,
> Regardless of the set of data, I am finding that the report always ends with
> a blank page.
> I have tried several combinations of changing the KeepTogether parameter and
> have made sure the PageBreakAtStart = false and PageBreakAtEnd = false
> everywhere.
> What could cause this extra page?
> Kevin|||I also frequently get stumped by how non-obvious it is that report
items that are too wide are creating extra pages.|||there is nothing obvious about this topic really. I have followed all the
suggested fixes to the letter many times and still end up with blank page at
the end with a header. If there is a report item that is "too wide" ... it
is anything BUT obvious when I am certain that my page width < rt.margin +
body + lt. margin (from report page properties). If you have another
suggestion to add I am open to anything. I use them all. Thanks.
"Eva Pierce Monsen" wrote:
> I also frequently get stumped by how non-obvious it is that report
> items that are too wide are creating extra pages.
>|||I have reviewed each line of the actual XML of the RDL and confirmed that
margins + body do not exceed size of the page.
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:63C7514E-0AB3-478F-B955-E6456C7E486E@.microsoft.com...
> there is nothing obvious about this topic really. I have followed all the
> suggested fixes to the letter many times and still end up with blank page
> at
> the end with a header. If there is a report item that is "too wide" ...
> it
> is anything BUT obvious when I am certain that my page width < rt.margin +
> body + lt. margin (from report page properties). If you have another
> suggestion to add I am open to anything. I use them all. Thanks.
> "Eva Pierce Monsen" wrote:
>> I also frequently get stumped by how non-obvious it is that report
>> items that are too wide are creating extra pages.
>>|||Try ensuring that everything is smaller than the width of the page -
and check for anything that might be 'pushed down', in terms of height.
It is all too easy to get something just a hair off - and I find that
sometimes going to the exact limit (mathematically) means that you go
too far when you actually render|||In my table footer there is a cell with content that can be multiple lines
(includes CRLF within the data). Will this cause the issue? If so, what is
the fix for this knowing that I need the data to include these CRLF?
"Parker" <psmith@.iquest.net> wrote in message
news:1150977864.447449.124050@.y41g2000cwy.googlegroups.com...
> Try ensuring that everything is smaller than the width of the page -
> and check for anything that might be 'pushed down', in terms of height.
> It is all too easy to get something just a hair off - and I find that
> sometimes going to the exact limit (mathematically) means that you go
> too far when you actually render
>|||Kevin,
Yes, that's exactly something that could cause the extra page. Make
sure that your footer area is large enough to fully contain the largest
data including the CRLFs. Double check all the size and location
properties for page Header, Body and Page Footer to ensure everything
fits inside your report size. I always leave at least an eighth inch
leeway all the way around just in case.
Good reporting!!
toolman
Kevin VanRiper wrote:
> In my table footer there is a cell with content that can be multiple lines
> (includes CRLF within the data). Will this cause the issue? If so, what is
> the fix for this knowing that I need the data to include these CRLF?
> "Parker" <psmith@.iquest.net> wrote in message
> news:1150977864.447449.124050@.y41g2000cwy.googlegroups.com...
> > Try ensuring that everything is smaller than the width of the page -
> > and check for anything that might be 'pushed down', in terms of height.
> >
> > It is all too easy to get something just a hair off - and I find that
> > sometimes going to the exact limit (mathematically) means that you go
> > too far when you actually render
> >|||I believe this is a bug not a developer issue. We don't have this issue
with other reporting tools.
It is impossible to know during development the exact length of dynamic,
variable length data that is coming from a varchar(max) field. That is the
whole reason one looks to using a reporting tool like SQL Reporting
Services.
Is there anyone from Microsoft that can respond with a reasonable fix to
this bug?
"toolman" <timd@.infocision.com> wrote in message
news:1151065588.315448.204240@.c74g2000cwc.googlegroups.com...
> Kevin,
> Yes, that's exactly something that could cause the extra page. Make
> sure that your footer area is large enough to fully contain the largest
> data including the CRLFs. Double check all the size and location
> properties for page Header, Body and Page Footer to ensure everything
> fits inside your report size. I always leave at least an eighth inch
> leeway all the way around just in case.
> Good reporting!!
> toolman
> Kevin VanRiper wrote:
>> In my table footer there is a cell with content that can be multiple
>> lines
>> (includes CRLF within the data). Will this cause the issue? If so, what
>> is
>> the fix for this knowing that I need the data to include these CRLF?
>> "Parker" <psmith@.iquest.net> wrote in message
>> news:1150977864.447449.124050@.y41g2000cwy.googlegroups.com...
>> > Try ensuring that everything is smaller than the width of the page -
>> > and check for anything that might be 'pushed down', in terms of height.
>> >
>> > It is all too easy to get something just a hair off - and I find that
>> > sometimes going to the exact limit (mathematically) means that you go
>> > too far when you actually render
>> >
>|||Try adding border lines to all objects that don't have them, just to see if
there are any objects that behaves strangelly.
I've found that if you pub a matrix in a rectangle, and there's extra space
in that rectangle, the matrix will make sure that the rectangle ends the
same number of pixels to the right when the matrix is filled with columns -
which gives me a blank page, even if the rectangle is within the limits of
the margins.
Kaisa M. Lindahl Lervik
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:63C7514E-0AB3-478F-B955-E6456C7E486E@.microsoft.com...
> there is nothing obvious about this topic really. I have followed all the
> suggested fixes to the letter many times and still end up with blank page
> at
> the end with a header. If there is a report item that is "too wide" ...
> it
> is anything BUT obvious when I am certain that my page width < rt.margin +
> body + lt. margin (from report page properties). If you have another
> suggestion to add I am open to anything. I use them all. Thanks.
> "Eva Pierce Monsen" wrote:
>> I also frequently get stumped by how non-obvious it is that report
>> items that are too wide are creating extra pages.
>>

Report always displays 2 pages

Hi, I have a SQL Reporting service on which I have a footer with the number of page, something like "page 1 of 1". THe thing is, if I preview the report, it displays the nr of pages correctly, however, when I export to PDF; it alwas displays 2 pages, on the 2nd page only displays the footer "page 1 of 2" even if the first page is small and fits that page only. I've tried to reorganize the controls on the report and fit the footer to display only one page, however, no result.. any guess?Thanks a lot!Check the page margins settings in the report's properties.|||Problem solved. I've resized the report width to a less value than the value that I was using and is working!Thanks for the tip!

Report against oracle with multiple statements

hello developers!!!!!

How I have to do a Report against oracle with multiple statements?

I need execute multiple SQL statements in the generic query designer with an oracle connection.

thanks

Maybe I'm missing something, but couldn't you just define multiple datasets in the report with one query per dataset?

If the queries have interdependencies, you could look into moving them into a stored procedure and calling the stored procedure from SSRS. You should find several threads on the regular SSRS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) discussing how to call Oracle stored procedures from SSRS.

-- Robert

|||

Robert -- slightly off topic but do you have any idea why the Query Designer would be really slow loading tables from Oracle?

There are two threads on this subject:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=324176&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2019689&SiteID=1

...maybe this deserved looking at for a fix in Katmai if it's not already done... is there an issue with multiple connections for each table that is being added or something?

Thanks in advance,

>L<

|||The query designer is actually a VS component, not an RS component. It might use the OLE DB provider but I'm not 100% certain.

|||

Thanks Brian. I might have known that the query designer was a shared component, but I haven't heard of anybody complaining about its speed except in this (report design) context.

As far as whether the query designer uses OLE DB or not... it can, and does, and when it does it is apparently fast -- against the same data.

It's just when these guys are accessing Oracle and their specified connection to this data source is *not* an OLE DB connection that they see the problem. (10-15 minutes to add a table in the designer ?!? Yuck...) I was thinking maybe the designer was trying to make a separate connection every time they pressed that "Add" button.

>L<

|||

Well, I know this won't really resolve the issue, but the shared VS query designer component is actually only supported for a particular set of OLEDB providers, as described in the following KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;811241

? Microsoft OLE DB Provider for SQL Server
? Microsoft Jet 4.0 OLE DB Provider
? Microsoft OLE DB Provider for Oracle

It is not supported for any other providers.

-- Robert

|||

Thanks for going the extra mile, Robert <s>. That totally makes sense. I will refer them to this post and stop worrying that the query designer has a bug <g>.

>L<