report does not show a table

Hi,

We have a report published to two report servers ( same configuration). this report displays data in two side by side tables. on server 1, the left side table does not get displayed where as both the tables show fine on server 2.

What could be the reason for this

Any help greatly appreciated.

Thanks,

Phani

I assume that the reports are pointing to different databases, so is there any data being returned for the table that doesn't show?|||

Hi,

It is the same report deployed on two webservers so they pull from the same database. One report shows both the tables with data and the second one shows only the right side table with data and does not show left hand side table.

Thanks,

Phani

|||

are the two tables using the same datasource?

could it be a time out issue from sql?

Have you looked into the reportserver log files and compared the results from each report server?

sql

Report Designer: REPORT(!) templates?

Hi,
I found STYLE templates for the appearance of tables and matrices, but I
want to retain my header and margins and grid spacing and possibly some
common Datasets and references to assemblies when creating a new report with
REPORT Designer.
I want to create a new Report against an OLAP Cube with the report designer.
So I can get all the necessary datasets for cascading parameters. But then
all my above mentioned settings are lost.
Any ideas?
Many thanks in advance,
RalphYou can make a general report, with a page header and footer and datasets
for parameters you will use in many reports. Create it's own project so you
don't mess it up. Then you save it in either
For SQL Server 2000
C:\Program Files\Microsoft SQL Server\80\Tools\ Report
Designer\ProjectItems\ReportProject
or
For SQL Server 2005
C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
Give it an easily recognizable name, like <clientname>_template.rdl.
Then create a new project for the different reports. Create a Shared Data
Source named the same as in you template. RIght click on the Reports folder,
choose Add new item and choose your newly created template from the list of
templates.
You can also save your Shared Data Sources, and just add them to new
projects later.
Kaisa
"Ralph Watermann" <We.Want@.NoSpam.de> wrote in message
news:e$pQ$wd8FHA.1276@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I found STYLE templates for the appearance of tables and matrices, but I
> want to retain my header and margins and grid spacing and possibly some
> common Datasets and references to assemblies when creating a new report
> with REPORT Designer.
> I want to create a new Report against an OLAP Cube with the report
> designer. So I can get all the necessary datasets for cascading
> parameters. But then all my above mentioned settings are lost.
> Any ideas?
> Many thanks in advance,
> Ralph
>|||Many thanks for yor answer, but my problem with RS 2005 is a bit more
complex:
I want to use the Report Designer to get those complex MDX-Statements for
the main dataset and the cascading parameters (sometimes ~ 15 datasets) so I
can't add the report-template in the way you suggested, or do I miss
something?
The best solution I found so far is to put at least the header and
report-layout and so on into the mini-template of the Report-Designer. But
if i put my datasets there to, then I end up with two <Datasets /> in XML
what lead of course to an error. Same thing with common parameters. So there
is LOTS OF "intelligent" copy and paste to do with a lot of possible
mistakes... Really no fun...
So to summarize: I just have to decide wether I want to retain parameters
and datasets or get MDX/cascading parameters the easy way?... Really
tedius work..!'
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> schrieb im Newsbeitrag
news:updxECF9FHA.1248@.TK2MSFTNGP14.phx.gbl...
> You can make a general report, with a page header and footer and datasets
> for parameters you will use in many reports. Create it's own project so
> you don't mess it up. Then you save it in either
> For SQL Server 2000
> C:\Program Files\Microsoft SQL Server\80\Tools\ Report
> Designer\ProjectItems\ReportProject
> or
> For SQL Server 2005
> C:\Program Files\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
> Give it an easily recognizable name, like <clientname>_template.rdl.
> Then create a new project for the different reports. Create a Shared Data
> Source named the same as in you template. RIght click on the Reports
> folder, choose Add new item and choose your newly created template from
> the list of templates.
> You can also save your Shared Data Sources, and just add them to new
> projects later.
> Kaisa
> "Ralph Watermann" <We.Want@.NoSpam.de> wrote in message
> news:e$pQ$wd8FHA.1276@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> I found STYLE templates for the appearance of tables and matrices, but I
>> want to retain my header and margins and grid spacing and possibly some
>> common Datasets and references to assemblies when creating a new report
>> with REPORT Designer.
>> I want to create a new Report against an OLAP Cube with the report
>> designer. So I can get all the necessary datasets for cascading
>> parameters. But then all my above mentioned settings are lost.
>> Any ideas?
>> Many thanks in advance,
>> Ralph
>>
>

Report Designer: Refreshing Fields VERY Slow

I have a query that uses temp tables, and the query seems to execute and
refresh fields fine, but as soon as I put in a parameter for a DateTime field
the query will run but the Refresh Fields button takes forever...like 2
hours! I think it is running my rather lengthy query without the parameters
which because of the size of the tables takes a long time.
I have tried changing the data type for the parameter from String to
DateTime and neither seem to refresh the fields quickly.
Can anything be done to refresh the fields list quicker?I thought my MSDN Universal Subscription entitled me to a response within two
days... I guess not.
"Chance" wrote:
> I have a query that uses temp tables, and the query seems to execute and
> refresh fields fine, but as soon as I put in a parameter for a DateTime field
> the query will run but the Refresh Fields button takes forever...like 2
> hours! I think it is running my rather lengthy query without the parameters
> which because of the size of the tables takes a long time.
> I have tried changing the data type for the parameter from String to
> DateTime and neither seem to refresh the fields quickly.
> Can anything be done to refresh the fields list quicker?
>

Report Designer data Tables

I have a set of data tables with their own datasets from different database
tables. They go across the report page and all need to be linked together
via an ID number. How can this be achieved or is there a better way of doing
it other than in report tables?
The data tables across the report page are:
Details, Actuals and Budgets ie., ID number in Details need to be linked to
the same ID in Actuals and Budgets so that it appears as a single line of
continuous information across the page.
Thanks
IanStep 1. Create one report for each of the Details, Actuals, Budget data.
Give each report an ID parameter.
Step 2. Create a main report and add a list data region. Make the dataset of
the list be based on a query that returns unique id values. Inside the list
data region add subreport controls and map them each to the reports you
created at Step 1. You will need to map the subreport parameters to the ID
field in the main report.
Done.
HTH
Charles Kangai, MCT, MCDBA
"IanP" wrote:
> I have a set of data tables with their own datasets from different database
> tables. They go across the report page and all need to be linked together
> via an ID number. How can this be achieved or is there a better way of doing
> it other than in report tables?
>
> The data tables across the report page are:
>
> Details, Actuals and Budgets ie., ID number in Details need to be linked to
> the same ID in Actuals and Budgets so that it appears as a single line of
> continuous information across the page.
>
> Thanks
> Ian
>|||This sounds more like a query problem than a report problem. Is there a
reason that you are not joining the tables in the source query? Then each
record returned will contain all your information -- details, actuals, and
budgets. When you say single line of data, I presume that there is only one
row of data for each ID. Is that not the case?
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"IanP" <IanP@.discussions.microsoft.com> wrote in message
news:9F30A2FE-A28F-45E6-989C-913EB78FD61A@.microsoft.com...
>I have a set of data tables with their own datasets from different database
> tables. They go across the report page and all need to be linked together
> via an ID number. How can this be achieved or is there a better way of
> doing
> it other than in report tables?
>
> The data tables across the report page are:
>
> Details, Actuals and Budgets ie., ID number in Details need to be linked
> to
> the same ID in Actuals and Budgets so that it appears as a single line of
> continuous information across the page.
>
> Thanks
> Ian
>|||Thank you Charles and Jeff
Yes jeff it is a db design problem, I was not involved in its design, and
now it is being revisited and Jeff, your note sounds promising so I will go
back and revisit what I was experimenting with
Ian
"Jeff A. Stucker" wrote:
> This sounds more like a query problem than a report problem. Is there a
> reason that you are not joining the tables in the source query? Then each
> record returned will contain all your information -- details, actuals, and
> budgets. When you say single line of data, I presume that there is only one
> row of data for each ID. Is that not the case?
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "IanP" <IanP@.discussions.microsoft.com> wrote in message
> news:9F30A2FE-A28F-45E6-989C-913EB78FD61A@.microsoft.com...
> >I have a set of data tables with their own datasets from different database
> > tables. They go across the report page and all need to be linked together
> > via an ID number. How can this be achieved or is there a better way of
> > doing
> > it other than in report tables?
> >
> >
> > The data tables across the report page are:
> >
> >
> > Details, Actuals and Budgets ie., ID number in Details need to be linked
> > to
> > the same ID in Actuals and Budgets so that it appears as a single line of
> > continuous information across the page.
> >
> >
> > Thanks
> >
> > Ian
> >
>
>

Report deployement

Hi,

I have a heavy report:

- 18 datasets (some with filters)

- 15 parameters

- about 10 tables (some with groups)

- lots of TextBox static or calculated (50 at least)

- and a little report footer

Anyway…

I’m using Visual Studio 2005 to deploy my report on a server. Recently, my deployments became very long and now, Visual Studio throw Timeouts when I deploy it. I walk around this problem with the report management site on the server But deploying my report through it takes about 8 or 10 minutes…quite long !

Here are my questions :

- What are report elements that causes such time span ?

- How lighten the deployment ?

- How configure the deployement timeout in visual studio ?

Thanks

Which exact error message are you experiencing ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

The report services on the server has been installed with the french version

so the error message is in french : "Le dlai d'attente de l'opration a expir"

in english it looks like : "The wait delay of the operation has expire"

thanks

Report Corruption When Exported to Excel

Hello. Anyone please help me with my problem with regards to exporting reports to excel. My report consists of two tables, first table is just plain data displaying from the database; however, it has drilldowns. My second table consists of graphs. My report generates big size depends on the parameters selected by the user. The design of this report is the requirement of our clients, so i cannot do anything about it. So, here comes the problem when i try to export it to excel. The following error message is encountered:

"Microsoft Office Excel File Repair Log

Errors were detected in file 'C:\Documents and Settings\Administrator\Local Settings\Temporary Internet Files\Content.IE5\VKP9ZCSW\MyStore? Performance (Estate).xls'
The following is a list of repairs:

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted."

The report corruption is inconsistent, sometimes, the exported report is ok; however, there are some time where the report exported is corrupted. What could be the possible cause of this report corruption? Is this a known bug for the export feature of the Reporting Services? Does the file size matter? Moreover, i find this so weird, since, we use subscription feature to send reports to our clients and we chose to send these reports in .xls format. I have observed: a report is exported, same date and time, same parameters, two subscriptions were done for a single report; however, one report was corrupted but the other report was ok. What is the problem on this bug?

Anyway, we are using SP2.

Please help me. A reply for this will be very much appreciated. Thank you. May God bless you.

I have encountered this error as well.

Seems to be related to the amount of characters in a cell in my case. My report is all text and when the character count in a cell reaches around 4000 or so the report won't export to excel. It will export in Visual Studio but not when run from our report server.

Any help from Microsoft would be appreciated!!!

|||I dont think i reach that number of characters (4000) for every cell.|||I have a hunch. Try moving the contents of your paged footer to the report body. Make sure nothing is in the page footer.|||

In my case I have no information in the report footers.

The reports that I need to create are based on a database with a lot of textural information and when the character count reaches at or around 4000 characters in a cell then the report will not export to excel. It is interesting that the report will export to excel when run from my Visual Studio environment.

As a test I created a new report. Dropped a table on the body of the report and pasted some random words (4300 characters) in the “Detail” cell. I next created a dataset that would return one row so that the report would run. I next run the report from Visual Studio and export to excel. When I open the excel report everything is fine.

Now I publish the report to our report server (SQL 2K) and run it but when I export the report to excel I get the corrupt data error.

|||

We are also experiencing this problem. I also do not have anything in a report footer. The report we use has a drop down box with values for one of two parameters. The report renders and exports fine for most of the values, however one or two dont export correctly. It is not always the same values that cause the error, but sometimes it works and sometimes it doesnt.

The report does include quite a bit of information with 3 matrixes and 3 tables on top of each other, each with a page breaks so the information will be reported in several tabs in the same Excel worksheet. However, again, it works sometimes and not other times.

Another thing, I noticed in the thread that someone said it worked from the Visual Studio environment, but I did not find that to be true always.

Any help from Microsoft would be appreciated! This is a report that is run for executive management each month and this is the second month we have had a problem with it. We have tried using a different machine that had not been run today at all, in case it was too many windows open at a time, or memory usage, etc. But that did not work either. It finally just worked for the value we needed.

Thanks!

- Glenda

Regeneration Technologies, Inc.

ggable@.rtix.com

|||

It sounds very much like the report isn't being rendered improperly, but the file itself has become corrupt by the time it is opened on the client. Would it be possible to save the file on a client machine when that error occurs, and examine it outside of Excel? If it is possible to save the file, check if it is of a reasonable size. It should be virtually identical to a non-corrupt xls generated by the same request. If there is a large disparity, the file might be getting delivered in a corrupt state, as opposed to rendered in a corrupt state.

|||

There was a bug resolved in SP2 for RS 2000 that addressed issues where rendering would fail when a single textbox had 4000+ characters. Are you currently running SP2 on your server? It is entirely possible that your client has become updated while your server has not, leading it to work in Visual Studio but not on the server.

|||

I too have just encountered this problem on a report that worked successfully on 7/14/06. Is it possible that MS July patch introduced this problem. If not, then it may be my data. I have one LargeNarrative field in the report and there may be new data on the report that goes beyond 4K characters.

In my case does not work from VS 2003 either. Using VS2003 7.1.3088/, SS2005 with SP1, RS 2003 fully patched

|||I have the same problem, in my report, I have few graphs and the color was user defined color, when I change it to pre defined colors, it works. Any body know how to fix that? I need to use the user defined colorsql

Report Corruption When Exported to Excel

Hello. Anyone please help me with my problem with regards to exporting reports to excel. My report consists of two tables, first table is just plain data displaying from the database; however, it has drilldowns. My second table consists of graphs. My report generates big size depends on the parameters selected by the user. The design of this report is the requirement of our clients, so i cannot do anything about it. So, here comes the problem when i try to export it to excel. The following error message is encountered:

"Microsoft Office Excel File Repair Log

Errors were detected in file 'C:\Documents and Settings\Administrator\Local Settings\Temporary Internet Files\Content.IE5\VKP9ZCSW\MyStore? Performance (Estate).xls'
The following is a list of repairs:

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted."

The report corruption is inconsistent, sometimes, the exported report is ok; however, there are some time where the report exported is corrupted. What could be the possible cause of this report corruption? Is this a known bug for the export feature of the Reporting Services? Does the file size matter? Moreover, i find this so weird, since, we use subscription feature to send reports to our clients and we chose to send these reports in .xls format. I have observed: a report is exported, same date and time, same parameters, two subscriptions were done for a single report; however, one report was corrupted but the other report was ok. What is the problem on this bug?

Anyway, we are using SP2.

Please help me. A reply for this will be very much appreciated. Thank you. May God bless you.

I have encountered this error as well.

Seems to be related to the amount of characters in a cell in my case. My report is all text and when the character count in a cell reaches around 4000 or so the report won't export to excel. It will export in Visual Studio but not when run from our report server.

Any help from Microsoft would be appreciated!!!

|||I dont think i reach that number of characters (4000) for every cell.|||I have a hunch. Try moving the contents of your paged footer to the report body. Make sure nothing is in the page footer.|||

In my case I have no information in the report footers.

The reports that I need to create are based on a database with a lot of textural information and when the character count reaches at or around 4000 characters in a cell then the report will not export to excel. It is interesting that the report will export to excel when run from my Visual Studio environment.

As a test I created a new report. Dropped a table on the body of the report and pasted some random words (4300 characters) in the “Detail” cell. I next created a dataset that would return one row so that the report would run. I next run the report from Visual Studio and export to excel. When I open the excel report everything is fine.

Now I publish the report to our report server (SQL 2K) and run it but when I export the report to excel I get the corrupt data error.

|||

We are also experiencing this problem. I also do not have anything in a report footer. The report we use has a drop down box with values for one of two parameters. The report renders and exports fine for most of the values, however one or two dont export correctly. It is not always the same values that cause the error, but sometimes it works and sometimes it doesnt.

The report does include quite a bit of information with 3 matrixes and 3 tables on top of each other, each with a page breaks so the information will be reported in several tabs in the same Excel worksheet. However, again, it works sometimes and not other times.

Another thing, I noticed in the thread that someone said it worked from the Visual Studio environment, but I did not find that to be true always.

Any help from Microsoft would be appreciated! This is a report that is run for executive management each month and this is the second month we have had a problem with it. We have tried using a different machine that had not been run today at all, in case it was too many windows open at a time, or memory usage, etc. But that did not work either. It finally just worked for the value we needed.

Thanks!

- Glenda

Regeneration Technologies, Inc.

ggable@.rtix.com

|||

It sounds very much like the report isn't being rendered improperly, but the file itself has become corrupt by the time it is opened on the client. Would it be possible to save the file on a client machine when that error occurs, and examine it outside of Excel? If it is possible to save the file, check if it is of a reasonable size. It should be virtually identical to a non-corrupt xls generated by the same request. If there is a large disparity, the file might be getting delivered in a corrupt state, as opposed to rendered in a corrupt state.

|||

There was a bug resolved in SP2 for RS 2000 that addressed issues where rendering would fail when a single textbox had 4000+ characters. Are you currently running SP2 on your server? It is entirely possible that your client has become updated while your server has not, leading it to work in Visual Studio but not on the server.

|||

I too have just encountered this problem on a report that worked successfully on 7/14/06. Is it possible that MS July patch introduced this problem. If not, then it may be my data. I have one LargeNarrative field in the report and there may be new data on the report that goes beyond 4K characters.

In my case does not work from VS 2003 either. Using VS2003 7.1.3088/, SS2005 with SP1, RS 2003 fully patched

|||I have the same problem, in my report, I have few graphs and the color was user defined color, when I change it to pre defined colors, it works. Any body know how to fix that? I need to use the user defined color

Report Builder, Stored Procedures and Views

How can I access recordsets from Stored Procedures and/or views instead of
tables from the database. I need to limit the amount of data a user can
access but the only entities showing up in the Explorer are tables.Hi,
You can access from tables and views, what ever filter criteria you can give
it in views. Go to "Data Source Views" in the Report model project and click
on add existing items from your datasource you should see tables and views.
Amarnath
"SYoung" wrote:
> How can I access recordsets from Stored Procedures and/or views instead of
> tables from the database. I need to limit the amount of data a user can
> access but the only entities showing up in the Explorer are tables.|||You're talking about a Report Project in VS. What I'm talking about is an
add on client development tool accessible via the
http://YourReportServer/Reports page called "Report Builder". This tool
allowes the user to create adhoc reports without having to write 1 line of
SQL.
"Amarnath" wrote:
> Hi,
> You can access from tables and views, what ever filter criteria you can give
> it in views. Go to "Data Source Views" in the Report model project and click
> on add existing items from your datasource you should see tables and views.
> Amarnath
>
> "SYoung" wrote:
> > How can I access recordsets from Stored Procedures and/or views instead of
> > tables from the database. I need to limit the amount of data a user can
> > access but the only entities showing up in the Explorer are tables.

Report Builder permissions

I would like to know how can I show parts of tables in report builder,

according to parameters that will be sent from the application.

Is it possible?

help...

can I send parameters to report builder, in order to show specific report model for each user?

report builder not displaying some rows

Hi friends
am using report builder to create a report ,the report not displaying some rows.
i've 2 tables . Patients and transactions (1- many)

and assume that i've following records
patient
--
1 , sriram , albert street,nz
2 , david , victoria street ,aus

transactions (flds are patientid,charge,transaction date)

1 , $100, diabetes problem ,10/10/05
1, $100 , diabetes problem , 19/01/06
2, $150,someother problem

if i create a report with following fields

name , address (from patient table)

charge , problem (from transactions table) i get following results

sriram , albert street,nz,$100
david , victoria street ,aus , $150

as

u can see it ignored the 2nd record for patient "sriram" ?i used sql

profiler to get query report builder creating and if i run it in QA i

get all results am expecting but report builder thinks ignores 2rd

record as it thinks its duplicate.

i know how to fix this by

just adding transaction date field but the abv report is very common

one our users create ,is there any way report builder displays all rows ?
Thanks

it is still an issue for me !! no one has faced similar situation ?|||

Sorry: I have not used Report Builder (we're on SQL 2000 and Report Designer), but it sounds like it is just returning DISTINCT recordset.

There may be an attribute on the table? Or the query uses SELECT DISTINCT?

Perry

|||Thanks for the post Perry
The query RB creates is fine as it returns correct results if i run it QA.
but looks like RB doing a distinct after gettting the data!

report builder not displaying some rows

Hi friends
am using report builder to create a report ,the report not displaying some rows.
i've 2 tables . Patients and transactions (1- many)

and assume that i've following records
patient
--
1 , sriram , albert street,nz
2 , david , victoria street ,aus

transactions (flds are patientid,charge,transaction date)

1 , $100, diabetes problem ,10/10/05
1, $100 , diabetes problem , 19/01/06
2, $150,someother problem

if i create a report with following fields
name , address (from patient table)
charge , problem (from transactions table) i get following results

sriram , albert street,nz,$100
david , victoria street ,aus , $150

as u can see it ignored the 2nd record for patient "sriram" ?i used sql profiler to get query report builder creating and if i run it in QA i get all results am expecting but report builder thinks ignores 2rd record as it thinks its duplicate.

i know how to fix this by just adding transaction date field but the abv report is very common one our users create ,is there any way report builder displays all rows ?
Thanks
it is still an issue for me !! no one has faced similar situation ?|||

Sorry: I have not used Report Builder (we're on SQL 2000 and Report Designer), but it sounds like it is just returning DISTINCT recordset.

There may be an attribute on the table? Or the query uses SELECT DISTINCT?

Perry

|||Thanks for the post Perry
The query RB creates is fine as it returns correct results if i run it QA.
but looks like RB doing a distinct after gettting the data!

Report Builder Filter drop down list - when the list is more than 500 values

Hi All,

I build a model (either from Cube or from tables) and open it in report builder. When I select a FIELTER on field which has few distinct values like state code, I get a drop down list. But when I select a filter on 'Dept Name', the drop down list on filter disapears. I have to manually key the filter value.

Can any one help me in getting a drop down list on filter, when distinct values in that column are more than few hundred.

Regards

Bobba

This is controlled by a property InstanceSelection, that can be set on each attribute of a dimension (within the dimension Editor).

The cube/dimension wizard initially sets this property, but then it can be changed as required.

Report Builder Error - Novice please suggest !!

I created report model based of three relational tables(SQL Db). When I try to run it gives me error 'cannot run this report - A filter must be specified'. When I supply filter it will go head and run.

Basically I have three relational tables from SQL database. one is the Master say A and other two are related tables say B and C. I joined with id1 to B from A and id2 to C from A.

A(id1) -> B(id1)

A(id2) -> C(id2)

1.Why is it asking me the enter filter?

2.Also, when I created a report based on fields from A,B and C I tried to do the click through.

I can able to click through to table B by clicking on the fields of B but similarly I am unable to do for the fields from the C.

3.Can I create a report model based on tables from different databases rather than from single database.?

I am novice to the Reporting Services arena. Your suggestions/help is greatly appreciated.

Thanks in advance.

Prakash

1. Report Builder requires you to specify a filter if Entity.InstanceSelection=MandatoryFilter in the report model. The model generation wizard will set this value if the underlying table has a very large number of rows in it. If you don't like the setting, you can change it in Model Designer.

2. Only certain fields have EnableDrillthrough=True by default. I believe the model generation wizard sets this only for highly unique fields and/or fields that are part of the primary key in the underyling table. If you want Report Builder to create Clickthrough links for more fields, you can change this property in Model Designer.

3. The DSV that describes the database over which the report model is built can only have one datasource. However, you can use linked servers to access data on other servers.

Hope that helps!

|||

Thanks for your response.

Please tell me where I can find these properties. I am unable to find them(I guess I am dumb). Your help is greatly appreciated.

Thanks !!

Report Builder Error - Novice please suggest !!

I created report model based of three relational tables(SQL Db). When I try to run it gives me error 'cannot run this report - A filter must be specified'. When I supply filter it will go head and run.

Basically I have three relational tables from SQL database. one is the Master say A and other two are related tables say B and C. I joined with id1 to B from A and id2 to C from A.

A(id1) -> B(id1)

A(id2) -> C(id2)

1.Why is it asking me the enter filter?

2.Also, when I created a report based on fields from A,B and C I tried to do the click through.

I can able to click through to table B by clicking on the fields of B but similarly I am unable to do for the fields from the C.

3.Can I create a report model based on tables from different databases rather than from single database.?

I am novice to the Reporting Services arena. Your suggestions/help is greatly appreciated.

Thanks in advance.

Prakash

1. Report Builder requires you to specify a filter if Entity.InstanceSelection=MandatoryFilter in the report model. The model generation wizard will set this value if the underlying table has a very large number of rows in it. If you don't like the setting, you can change it in Model Designer.

2. Only certain fields have EnableDrillthrough=True by default. I believe the model generation wizard sets this only for highly unique fields and/or fields that are part of the primary key in the underyling table. If you want Report Builder to create Clickthrough links for more fields, you can change this property in Model Designer.

3. The DSV that describes the database over which the report model is built can only have one datasource. However, you can use linked servers to access data on other servers.

Hope that helps!

|||

Thanks for your response.

Please tell me where I can find these properties. I am unable to find them(I guess I am dumb). Your help is greatly appreciated.

Thanks !!

Report Builder : select multiple tables in one report

Hello,
I'm trying to create a report on Microsoft CRM on the following tables
dbo.FilteredAccount
dbo.FilteredNew_internatsamenwerking
dbo.FilteredNew_ImpExpCountry
I have created a data source view in with the following relations :
dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_internatsamenwerking
dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry
I can create a report with fields from dbo.FilteredAccount and
dbo.FilteredNew_internatsamenwerking and another report with fields from
dbo.FilteredAccount and dbo.FilteredNew_ImpExpCountry. But i can't get fields
in one report from the 3 tables, dbo.FilteredNew_internatsamenwerking is
disabeling dbo.FilteredNew_ImpExpCountry and visa versa.
Is this relationship 1 to N a restriction in Report Builder?
Do you have a solution?
Thanks in advanceIs all your tables connected with a key , then it should not be a problem
Amarnath
"carolineb" wrote:
> Hello,
> I'm trying to create a report on Microsoft CRM on the following tables
> dbo.FilteredAccount
> dbo.FilteredNew_internatsamenwerking
> dbo.FilteredNew_ImpExpCountry
> I have created a data source view in with the following relations :
> dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_internatsamenwerking
> dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry
>
> I can create a report with fields from dbo.FilteredAccount and
> dbo.FilteredNew_internatsamenwerking and another report with fields from
> dbo.FilteredAccount and dbo.FilteredNew_ImpExpCountry. But i can't get fields
> in one report from the 3 tables, dbo.FilteredNew_internatsamenwerking is
> disabeling dbo.FilteredNew_ImpExpCountry and visa versa.
> Is this relationship 1 to N a restriction in Report Builder?
> Do you have a solution?
> Thanks in advance
>
>|||Hi,
Table dbo.FilteredAccount has a primary key accountid
Table dbo.FilteredNew_internatsamenwerking has a primary key intsamenwerkingid
Table dbo.FilteredNew_ImpExpCountry has a primary key impexpid
dbo.FilteredAccount 1 to many relation on
dbo.FilteredNew_internatsamenwerking (on the field accountid in both tables)
dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry (on
the field accountid in both tables)
I'm I missing something?
Thanks
"Amarnath" wrote:
> Is all your tables connected with a key , then it should not be a problem
> Amarnath
>
> "carolineb" wrote:
> > Hello,
> >
> > I'm trying to create a report on Microsoft CRM on the following tables
> > dbo.FilteredAccount
> > dbo.FilteredNew_internatsamenwerking
> > dbo.FilteredNew_ImpExpCountry
> >
> > I have created a data source view in with the following relations :
> >
> > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_internatsamenwerking
> > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry
> >
> >
> > I can create a report with fields from dbo.FilteredAccount and
> > dbo.FilteredNew_internatsamenwerking and another report with fields from
> > dbo.FilteredAccount and dbo.FilteredNew_ImpExpCountry. But i can't get fields
> > in one report from the 3 tables, dbo.FilteredNew_internatsamenwerking is
> > disabeling dbo.FilteredNew_ImpExpCountry and visa versa.
> >
> > Is this relationship 1 to N a restriction in Report Builder?
> > Do you have a solution?
> >
> > Thanks in advance
> >
> >
> >|||Report Model can be designed in such a way that one table will act as storing
all the PK and FK's of the table.
ie taking your example.
dbo.FilteredAccount 1
account ID as PK
dbo.FilteredNew_internatsamenwerking
intsamenwerkingid PK
accountid as FK
dbo.FilteredNew_ImpExpCountry
impexpid as PK
accountid as FK
If you can design in such a way that both the other tables PK should be in
FilteredAccount Table then it should work. Since you are refereing just
account ID for all the tables it assumes 1 to 1 relation.
You can try this and see.
Amarnath
"carolineb" wrote:
> Hi,
> Table dbo.FilteredAccount has a primary key accountid
> Table dbo.FilteredNew_internatsamenwerking has a primary key intsamenwerkingid
> Table dbo.FilteredNew_ImpExpCountry has a primary key impexpid
> dbo.FilteredAccount 1 to many relation on
> dbo.FilteredNew_internatsamenwerking (on the field accountid in both tables)
> dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry (on
> the field accountid in both tables)
> I'm I missing something?
> Thanks
> "Amarnath" wrote:
> > Is all your tables connected with a key , then it should not be a problem
> >
> > Amarnath
> >
> >
> > "carolineb" wrote:
> >
> > > Hello,
> > >
> > > I'm trying to create a report on Microsoft CRM on the following tables
> > > dbo.FilteredAccount
> > > dbo.FilteredNew_internatsamenwerking
> > > dbo.FilteredNew_ImpExpCountry
> > >
> > > I have created a data source view in with the following relations :
> > >
> > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_internatsamenwerking
> > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry
> > >
> > >
> > > I can create a report with fields from dbo.FilteredAccount and
> > > dbo.FilteredNew_internatsamenwerking and another report with fields from
> > > dbo.FilteredAccount and dbo.FilteredNew_ImpExpCountry. But i can't get fields
> > > in one report from the 3 tables, dbo.FilteredNew_internatsamenwerking is
> > > disabeling dbo.FilteredNew_ImpExpCountry and visa versa.
> > >
> > > Is this relationship 1 to N a restriction in Report Builder?
> > > Do you have a solution?
> > >
> > > Thanks in advance
> > >
> > >
> > >|||Do you mean that i have to add the PK's as a field in the table
dbo.FilteredAccount 1
intsamenwerkingid PK
impexpid as PK
This is not possible since the relation is 1 to n in both tables?
Thanks
"Amarnath" wrote:
> Report Model can be designed in such a way that one table will act as storing
> all the PK and FK's of the table.
> ie taking your example.
> dbo.FilteredAccount 1
> account ID as PK
> dbo.FilteredNew_internatsamenwerking
> intsamenwerkingid PK
> accountid as FK
> dbo.FilteredNew_ImpExpCountry
> impexpid as PK
> accountid as FK
> If you can design in such a way that both the other tables PK should be in
> FilteredAccount Table then it should work. Since you are refereing just
> account ID for all the tables it assumes 1 to 1 relation.
> You can try this and see.
> Amarnath
> "carolineb" wrote:
> > Hi,
> >
> > Table dbo.FilteredAccount has a primary key accountid
> > Table dbo.FilteredNew_internatsamenwerking has a primary key intsamenwerkingid
> > Table dbo.FilteredNew_ImpExpCountry has a primary key impexpid
> >
> > dbo.FilteredAccount 1 to many relation on
> > dbo.FilteredNew_internatsamenwerking (on the field accountid in both tables)
> > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry (on
> > the field accountid in both tables)
> >
> > I'm I missing something?
> >
> > Thanks
> >
> > "Amarnath" wrote:
> >
> > > Is all your tables connected with a key , then it should not be a problem
> > >
> > > Amarnath
> > >
> > >
> > > "carolineb" wrote:
> > >
> > > > Hello,
> > > >
> > > > I'm trying to create a report on Microsoft CRM on the following tables
> > > > dbo.FilteredAccount
> > > > dbo.FilteredNew_internatsamenwerking
> > > > dbo.FilteredNew_ImpExpCountry
> > > >
> > > > I have created a data source view in with the following relations :
> > > >
> > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_internatsamenwerking
> > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry
> > > >
> > > >
> > > > I can create a report with fields from dbo.FilteredAccount and
> > > > dbo.FilteredNew_internatsamenwerking and another report with fields from
> > > > dbo.FilteredAccount and dbo.FilteredNew_ImpExpCountry. But i can't get fields
> > > > in one report from the 3 tables, dbo.FilteredNew_internatsamenwerking is
> > > > disabeling dbo.FilteredNew_ImpExpCountry and visa versa.
> > > >
> > > > Is this relationship 1 to N a restriction in Report Builder?
> > > > Do you have a solution?
> > > >
> > > > Thanks in advance
> > > >
> > > >
> > > >|||Sorry, I mean that two id's should be there in your account table not as PK
as FK.
Amarnath
"carolineb" wrote:
> Do you mean that i have to add the PK's as a field in the table
> dbo.FilteredAccount 1
> intsamenwerkingid PK
> impexpid as PK
> This is not possible since the relation is 1 to n in both tables?
> Thanks
>
> "Amarnath" wrote:
> > Report Model can be designed in such a way that one table will act as storing
> > all the PK and FK's of the table.
> > ie taking your example.
> > dbo.FilteredAccount 1
> > account ID as PK
> > dbo.FilteredNew_internatsamenwerking
> > intsamenwerkingid PK
> > accountid as FK
> > dbo.FilteredNew_ImpExpCountry
> > impexpid as PK
> > accountid as FK
> >
> > If you can design in such a way that both the other tables PK should be in
> > FilteredAccount Table then it should work. Since you are refereing just
> > account ID for all the tables it assumes 1 to 1 relation.
> > You can try this and see.
> >
> > Amarnath
> >
> > "carolineb" wrote:
> >
> > > Hi,
> > >
> > > Table dbo.FilteredAccount has a primary key accountid
> > > Table dbo.FilteredNew_internatsamenwerking has a primary key intsamenwerkingid
> > > Table dbo.FilteredNew_ImpExpCountry has a primary key impexpid
> > >
> > > dbo.FilteredAccount 1 to many relation on
> > > dbo.FilteredNew_internatsamenwerking (on the field accountid in both tables)
> > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry (on
> > > the field accountid in both tables)
> > >
> > > I'm I missing something?
> > >
> > > Thanks
> > >
> > > "Amarnath" wrote:
> > >
> > > > Is all your tables connected with a key , then it should not be a problem
> > > >
> > > > Amarnath
> > > >
> > > >
> > > > "carolineb" wrote:
> > > >
> > > > > Hello,
> > > > >
> > > > > I'm trying to create a report on Microsoft CRM on the following tables
> > > > > dbo.FilteredAccount
> > > > > dbo.FilteredNew_internatsamenwerking
> > > > > dbo.FilteredNew_ImpExpCountry
> > > > >
> > > > > I have created a data source view in with the following relations :
> > > > >
> > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_internatsamenwerking
> > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry
> > > > >
> > > > >
> > > > > I can create a report with fields from dbo.FilteredAccount and
> > > > > dbo.FilteredNew_internatsamenwerking and another report with fields from
> > > > > dbo.FilteredAccount and dbo.FilteredNew_ImpExpCountry. But i can't get fields
> > > > > in one report from the 3 tables, dbo.FilteredNew_internatsamenwerking is
> > > > > disabeling dbo.FilteredNew_ImpExpCountry and visa versa.
> > > > >
> > > > > Is this relationship 1 to N a restriction in Report Builder?
> > > > > Do you have a solution?
> > > > >
> > > > > Thanks in advance
> > > > >
> > > > >
> > > > >|||This is not possible because one account can have many records
dbo.FilteredNew_ImpExpCountry and many records in
dbo.FilteredNew_internatsamenwerking.
"Amarnath" wrote:
> Sorry, I mean that two id's should be there in your account table not as PK
> as FK.
> Amarnath
> "carolineb" wrote:
> > Do you mean that i have to add the PK's as a field in the table
> > dbo.FilteredAccount 1
> > intsamenwerkingid PK
> > impexpid as PK
> > This is not possible since the relation is 1 to n in both tables?
> >
> > Thanks
> >
> >
> > "Amarnath" wrote:
> >
> > > Report Model can be designed in such a way that one table will act as storing
> > > all the PK and FK's of the table.
> > > ie taking your example.
> > > dbo.FilteredAccount 1
> > > account ID as PK
> > > dbo.FilteredNew_internatsamenwerking
> > > intsamenwerkingid PK
> > > accountid as FK
> > > dbo.FilteredNew_ImpExpCountry
> > > impexpid as PK
> > > accountid as FK
> > >
> > > If you can design in such a way that both the other tables PK should be in
> > > FilteredAccount Table then it should work. Since you are refereing just
> > > account ID for all the tables it assumes 1 to 1 relation.
> > > You can try this and see.
> > >
> > > Amarnath
> > >
> > > "carolineb" wrote:
> > >
> > > > Hi,
> > > >
> > > > Table dbo.FilteredAccount has a primary key accountid
> > > > Table dbo.FilteredNew_internatsamenwerking has a primary key intsamenwerkingid
> > > > Table dbo.FilteredNew_ImpExpCountry has a primary key impexpid
> > > >
> > > > dbo.FilteredAccount 1 to many relation on
> > > > dbo.FilteredNew_internatsamenwerking (on the field accountid in both tables)
> > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry (on
> > > > the field accountid in both tables)
> > > >
> > > > I'm I missing something?
> > > >
> > > > Thanks
> > > >
> > > > "Amarnath" wrote:
> > > >
> > > > > Is all your tables connected with a key , then it should not be a problem
> > > > >
> > > > > Amarnath
> > > > >
> > > > >
> > > > > "carolineb" wrote:
> > > > >
> > > > > > Hello,
> > > > > >
> > > > > > I'm trying to create a report on Microsoft CRM on the following tables
> > > > > > dbo.FilteredAccount
> > > > > > dbo.FilteredNew_internatsamenwerking
> > > > > > dbo.FilteredNew_ImpExpCountry
> > > > > >
> > > > > > I have created a data source view in with the following relations :
> > > > > >
> > > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_internatsamenwerking
> > > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry
> > > > > >
> > > > > >
> > > > > > I can create a report with fields from dbo.FilteredAccount and
> > > > > > dbo.FilteredNew_internatsamenwerking and another report with fields from
> > > > > > dbo.FilteredAccount and dbo.FilteredNew_ImpExpCountry. But i can't get fields
> > > > > > in one report from the 3 tables, dbo.FilteredNew_internatsamenwerking is
> > > > > > disabeling dbo.FilteredNew_ImpExpCountry and visa versa.
> > > > > >
> > > > > > Is this relationship 1 to N a restriction in Report Builder?
> > > > > > Do you have a solution?
> > > > > >
> > > > > > Thanks in advance
> > > > > >
> > > > > >
> > > > > >|||You should connect a PK to PK and not a non PK key. in your case it is
account id in the other two tables.
Amarnath
"carolineb" wrote:
> This is not possible because one account can have many records
> dbo.FilteredNew_ImpExpCountry and many records in
> dbo.FilteredNew_internatsamenwerking.
> "Amarnath" wrote:
> > Sorry, I mean that two id's should be there in your account table not as PK
> > as FK.
> >
> > Amarnath
> >
> > "carolineb" wrote:
> >
> > > Do you mean that i have to add the PK's as a field in the table
> > > dbo.FilteredAccount 1
> > > intsamenwerkingid PK
> > > impexpid as PK
> > > This is not possible since the relation is 1 to n in both tables?
> > >
> > > Thanks
> > >
> > >
> > > "Amarnath" wrote:
> > >
> > > > Report Model can be designed in such a way that one table will act as storing
> > > > all the PK and FK's of the table.
> > > > ie taking your example.
> > > > dbo.FilteredAccount 1
> > > > account ID as PK
> > > > dbo.FilteredNew_internatsamenwerking
> > > > intsamenwerkingid PK
> > > > accountid as FK
> > > > dbo.FilteredNew_ImpExpCountry
> > > > impexpid as PK
> > > > accountid as FK
> > > >
> > > > If you can design in such a way that both the other tables PK should be in
> > > > FilteredAccount Table then it should work. Since you are refereing just
> > > > account ID for all the tables it assumes 1 to 1 relation.
> > > > You can try this and see.
> > > >
> > > > Amarnath
> > > >
> > > > "carolineb" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > Table dbo.FilteredAccount has a primary key accountid
> > > > > Table dbo.FilteredNew_internatsamenwerking has a primary key intsamenwerkingid
> > > > > Table dbo.FilteredNew_ImpExpCountry has a primary key impexpid
> > > > >
> > > > > dbo.FilteredAccount 1 to many relation on
> > > > > dbo.FilteredNew_internatsamenwerking (on the field accountid in both tables)
> > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry (on
> > > > > the field accountid in both tables)
> > > > >
> > > > > I'm I missing something?
> > > > >
> > > > > Thanks
> > > > >
> > > > > "Amarnath" wrote:
> > > > >
> > > > > > Is all your tables connected with a key , then it should not be a problem
> > > > > >
> > > > > > Amarnath
> > > > > >
> > > > > >
> > > > > > "carolineb" wrote:
> > > > > >
> > > > > > > Hello,
> > > > > > >
> > > > > > > I'm trying to create a report on Microsoft CRM on the following tables
> > > > > > > dbo.FilteredAccount
> > > > > > > dbo.FilteredNew_internatsamenwerking
> > > > > > > dbo.FilteredNew_ImpExpCountry
> > > > > > >
> > > > > > > I have created a data source view in with the following relations :
> > > > > > >
> > > > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_internatsamenwerking
> > > > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry
> > > > > > >
> > > > > > >
> > > > > > > I can create a report with fields from dbo.FilteredAccount and
> > > > > > > dbo.FilteredNew_internatsamenwerking and another report with fields from
> > > > > > > dbo.FilteredAccount and dbo.FilteredNew_ImpExpCountry. But i can't get fields
> > > > > > > in one report from the 3 tables, dbo.FilteredNew_internatsamenwerking is
> > > > > > > disabeling dbo.FilteredNew_ImpExpCountry and visa versa.
> > > > > > >
> > > > > > > Is this relationship 1 to N a restriction in Report Builder?
> > > > > > > Do you have a solution?
> > > > > > >
> > > > > > > Thanks in advance
> > > > > > >
> > > > > > >
> > > > > > >|||Sorry, i cannot follow anymore.
Can you please say which key's in these tables has to be a PK and FK and
what relationship i have to design?
Thanks
"Amarnath" wrote:
> You should connect a PK to PK and not a non PK key. in your case it is
> account id in the other two tables.
> Amarnath
> "carolineb" wrote:
> > This is not possible because one account can have many records
> > dbo.FilteredNew_ImpExpCountry and many records in
> > dbo.FilteredNew_internatsamenwerking.
> >
> > "Amarnath" wrote:
> >
> > > Sorry, I mean that two id's should be there in your account table not as PK
> > > as FK.
> > >
> > > Amarnath
> > >
> > > "carolineb" wrote:
> > >
> > > > Do you mean that i have to add the PK's as a field in the table
> > > > dbo.FilteredAccount 1
> > > > intsamenwerkingid PK
> > > > impexpid as PK
> > > > This is not possible since the relation is 1 to n in both tables?
> > > >
> > > > Thanks
> > > >
> > > >
> > > > "Amarnath" wrote:
> > > >
> > > > > Report Model can be designed in such a way that one table will act as storing
> > > > > all the PK and FK's of the table.
> > > > > ie taking your example.
> > > > > dbo.FilteredAccount 1
> > > > > account ID as PK
> > > > > dbo.FilteredNew_internatsamenwerking
> > > > > intsamenwerkingid PK
> > > > > accountid as FK
> > > > > dbo.FilteredNew_ImpExpCountry
> > > > > impexpid as PK
> > > > > accountid as FK
> > > > >
> > > > > If you can design in such a way that both the other tables PK should be in
> > > > > FilteredAccount Table then it should work. Since you are refereing just
> > > > > account ID for all the tables it assumes 1 to 1 relation.
> > > > > You can try this and see.
> > > > >
> > > > > Amarnath
> > > > >
> > > > > "carolineb" wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Table dbo.FilteredAccount has a primary key accountid
> > > > > > Table dbo.FilteredNew_internatsamenwerking has a primary key intsamenwerkingid
> > > > > > Table dbo.FilteredNew_ImpExpCountry has a primary key impexpid
> > > > > >
> > > > > > dbo.FilteredAccount 1 to many relation on
> > > > > > dbo.FilteredNew_internatsamenwerking (on the field accountid in both tables)
> > > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry (on
> > > > > > the field accountid in both tables)
> > > > > >
> > > > > > I'm I missing something?
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > > "Amarnath" wrote:
> > > > > >
> > > > > > > Is all your tables connected with a key , then it should not be a problem
> > > > > > >
> > > > > > > Amarnath
> > > > > > >
> > > > > > >
> > > > > > > "carolineb" wrote:
> > > > > > >
> > > > > > > > Hello,
> > > > > > > >
> > > > > > > > I'm trying to create a report on Microsoft CRM on the following tables
> > > > > > > > dbo.FilteredAccount
> > > > > > > > dbo.FilteredNew_internatsamenwerking
> > > > > > > > dbo.FilteredNew_ImpExpCountry
> > > > > > > >
> > > > > > > > I have created a data source view in with the following relations :
> > > > > > > >
> > > > > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_internatsamenwerking
> > > > > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry
> > > > > > > >
> > > > > > > >
> > > > > > > > I can create a report with fields from dbo.FilteredAccount and
> > > > > > > > dbo.FilteredNew_internatsamenwerking and another report with fields from
> > > > > > > > dbo.FilteredAccount and dbo.FilteredNew_ImpExpCountry. But i can't get fields
> > > > > > > > in one report from the 3 tables, dbo.FilteredNew_internatsamenwerking is
> > > > > > > > disabeling dbo.FilteredNew_ImpExpCountry and visa versa.
> > > > > > > >
> > > > > > > > Is this relationship 1 to N a restriction in Report Builder?
> > > > > > > > Do you have a solution?
> > > > > > > >
> > > > > > > > Thanks in advance
> > > > > > > >
> > > > > > > >
> > > > > > > >|||Ok, What I did is I created 3 dummy tables, same as yours,
ie
t1 aid PK
t2 tid2 PK ,aid FK
t3 tid3 PK, aid Fk
When I created these tables and created the model I got to see all the 3
tables in the report builder, So what I think you are missing is that you
have not defined the FK to other two tables
ie
dbo.FilteredNew_internatsamenwerking
dbo.FilteredNew_ImpExpCountry
Have you created Fk in the above tables which referes the FilteredAccount
table "accountid" ? then it should work, so basically it all works with
proper key and relations.
Amarnath
"carolineb" wrote:
> Sorry, i cannot follow anymore.
> Can you please say which key's in these tables has to be a PK and FK and
> what relationship i have to design?
> Thanks
> "Amarnath" wrote:
> > You should connect a PK to PK and not a non PK key. in your case it is
> > account id in the other two tables.
> >
> > Amarnath
> >
> > "carolineb" wrote:
> >
> > > This is not possible because one account can have many records
> > > dbo.FilteredNew_ImpExpCountry and many records in
> > > dbo.FilteredNew_internatsamenwerking.
> > >
> > > "Amarnath" wrote:
> > >
> > > > Sorry, I mean that two id's should be there in your account table not as PK
> > > > as FK.
> > > >
> > > > Amarnath
> > > >
> > > > "carolineb" wrote:
> > > >
> > > > > Do you mean that i have to add the PK's as a field in the table
> > > > > dbo.FilteredAccount 1
> > > > > intsamenwerkingid PK
> > > > > impexpid as PK
> > > > > This is not possible since the relation is 1 to n in both tables?
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > > > "Amarnath" wrote:
> > > > >
> > > > > > Report Model can be designed in such a way that one table will act as storing
> > > > > > all the PK and FK's of the table.
> > > > > > ie taking your example.
> > > > > > dbo.FilteredAccount 1
> > > > > > account ID as PK
> > > > > > dbo.FilteredNew_internatsamenwerking
> > > > > > intsamenwerkingid PK
> > > > > > accountid as FK
> > > > > > dbo.FilteredNew_ImpExpCountry
> > > > > > impexpid as PK
> > > > > > accountid as FK
> > > > > >
> > > > > > If you can design in such a way that both the other tables PK should be in
> > > > > > FilteredAccount Table then it should work. Since you are refereing just
> > > > > > account ID for all the tables it assumes 1 to 1 relation.
> > > > > > You can try this and see.
> > > > > >
> > > > > > Amarnath
> > > > > >
> > > > > > "carolineb" wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > Table dbo.FilteredAccount has a primary key accountid
> > > > > > > Table dbo.FilteredNew_internatsamenwerking has a primary key intsamenwerkingid
> > > > > > > Table dbo.FilteredNew_ImpExpCountry has a primary key impexpid
> > > > > > >
> > > > > > > dbo.FilteredAccount 1 to many relation on
> > > > > > > dbo.FilteredNew_internatsamenwerking (on the field accountid in both tables)
> > > > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry (on
> > > > > > > the field accountid in both tables)
> > > > > > >
> > > > > > > I'm I missing something?
> > > > > > >
> > > > > > > Thanks
> > > > > > >
> > > > > > > "Amarnath" wrote:
> > > > > > >
> > > > > > > > Is all your tables connected with a key , then it should not be a problem
> > > > > > > >
> > > > > > > > Amarnath
> > > > > > > >
> > > > > > > >
> > > > > > > > "carolineb" wrote:
> > > > > > > >
> > > > > > > > > Hello,
> > > > > > > > >
> > > > > > > > > I'm trying to create a report on Microsoft CRM on the following tables
> > > > > > > > > dbo.FilteredAccount
> > > > > > > > > dbo.FilteredNew_internatsamenwerking
> > > > > > > > > dbo.FilteredNew_ImpExpCountry
> > > > > > > > >
> > > > > > > > > I have created a data source view in with the following relations :
> > > > > > > > >
> > > > > > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_internatsamenwerking
> > > > > > > > > dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > I can create a report with fields from dbo.FilteredAccount and
> > > > > > > > > dbo.FilteredNew_internatsamenwerking and another report with fields from
> > > > > > > > > dbo.FilteredAccount and dbo.FilteredNew_ImpExpCountry. But i can't get fields
> > > > > > > > > in one report from the 3 tables, dbo.FilteredNew_internatsamenwerking is
> > > > > > > > > disabeling dbo.FilteredNew_ImpExpCountry and visa versa.
> > > > > > > > >
> > > > > > > > > Is this relationship 1 to N a restriction in Report Builder?
> > > > > > > > > Do you have a solution?
> > > > > > > > >
> > > > > > > > > Thanks in advance
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >|||Hi CarolineB,
did you ever resolve your issues?
I have the same problem:
I have three tables:
Table A: PK A_ID
Table B: PK is A_ID, B_ID, FK is A_ID into Table A
Table C: PK is A_ID, C_ID, FK as A_ID into Table A.
I can see all three tables in Report Builder.
I can add fields from Table A and Table B at the same time to a single report.
I can add fields from Table A and Table C at the same time to a single report.
I cannot add fields from Table A and Table B and Table C at the same time,
yet this is a simple requirement.
Think of it as Customers, Orders & Payments.
A Customer may have 0, 1 or more Orders. Each Order has one and one only
Customer. A Customer may have 0, 1 or more Payments. Each Payment is for
one and one only Customer.
Payments and Orders are not directly related.
I'd like to list all customers with outstanding orders, and they payments
they've made. I can't do this using report builder.
"carolineb" wrote:
> Hello,
> I'm trying to create a report on Microsoft CRM on the following tables
> dbo.FilteredAccount
> dbo.FilteredNew_internatsamenwerking
> dbo.FilteredNew_ImpExpCountry
> I have created a data source view in with the following relations :
> dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_internatsamenwerking
> dbo.FilteredAccount 1 to many relation on dbo.FilteredNew_ImpExpCountry
>
> I can create a report with fields from dbo.FilteredAccount and
> dbo.FilteredNew_internatsamenwerking and another report with fields from
> dbo.FilteredAccount and dbo.FilteredNew_ImpExpCountry. But i can't get fields
> in one report from the 3 tables, dbo.FilteredNew_internatsamenwerking is
> disabeling dbo.FilteredNew_ImpExpCountry and visa versa.
> Is this relationship 1 to N a restriction in Report Builder?
> Do you have a solution?
> Thanks in advance
>
>

Report Builder - TimeOut while creating model

How can I avoid the connection TimeOuts while creating a model for Report
Builder? The databases we're using are pretty big (100s of tables) and in
the millions of rows. Is Report Builder just not up for this kind of
processes?Are you trying to create a model that has 100s of tables? The whole point of
Report Builder is to make reporting easier for end users. So why not create
different models that have the data that different users/groups need access
to? (each model having only a few tables, not 100s.) Also, with that much
data, have you considered analysis services?
Mike G.
"SYoung" <SYoung@.discussions.microsoft.com> wrote in message
news:73F8298C-DE21-4F2D-B11B-CF11F284F9A6@.microsoft.com...
> How can I avoid the connection TimeOuts while creating a model for Report
> Builder? The databases we're using are pretty big (100s of tables) and in
> the millions of rows. Is Report Builder just not up for this kind of
> processes?|||I kept timing out while trying to deploy a model and found out the
deployment was being blocked by another process which was 'getting
model information'...the process was hung up for two days before I
found it.

report builder - need help reporting from multiple tables

I created a data view and model that has two tables joined (one to many
relationship). When I go into report builder, I see both entities
available for me. When I click one of the entities, I am able to select
that entities data items to drag onto my report. However, the other
entity disapears. If I delete all the fields from the report, both
entities are available again. So it appears as if I can have as many
entities defined as I want, but can only use one at a time to report
on. I know I am doing something wrong because I have seen samples that
do what I am looking for - I just can't figure out how to do it.its because you don't have relationship between your 2 tables.
if you have some relation, in this case you can go from table A to table B
"directly"
else you have to go through other shared tables (with unexpected results)
"steve" <stevensherman@.comcast.net> wrote in message
news:1165065154.712904.183760@.f1g2000cwa.googlegroups.com...
>I created a data view and model that has two tables joined (one to many
> relationship). When I go into report builder, I see both entities
> available for me. When I click one of the entities, I am able to select
> that entities data items to drag onto my report. However, the other
> entity disapears. If I delete all the fields from the report, both
> entities are available again. So it appears as if I can have as many
> entities defined as I want, but can only use one at a time to report
> on. I know I am doing something wrong because I have seen samples that
> do what I am looking for - I just can't figure out how to do it.
>|||Thanks for your reply. I do have the relationship defined in the
reporting services model. Do I need to depict it somewhere else or am I
missing setting a property or something?|||Once the ralationships are defined in the datasource view, that is all
it takes. Report builder recognizes the relationship and will let you
select from both tables. If the tables are not joined in the datasource
view, then you will only be able to select attributes from one table or
the other - but not both.

Report Builder - filtering data

We have a web application that supports muliple companies (around 500). All
tables in our SQL Server database have a CompanyId field. We want to use
SSRS Report Builder to let end users create Ad Hoc reports. We need to
build a Model/Data View that allows an end user to veiw data from their
company only. How would we filter the data so that our end users do not see
other companies data in the Model that we design?
We can not allow the end user to create a filter for CompanyID at run time.I am trying to do the exact same thing (as I'm sure are many others), so any
assistance from Microsoft on this topic would be greatly appreciated...
Michael Carr
"Eva M." <Eva M.@.discussions.microsoft.com> wrote in message
news:7C18DD4A-8D07-46CC-A837-CAA2D0D5B156@.microsoft.com...
> We have a web application that supports muliple companies (around 500).
> All
> tables in our SQL Server database have a CompanyId field. We want to use
> SSRS Report Builder to let end users create Ad Hoc reports. We need to
> build a Model/Data View that allows an end user to veiw data from their
> company only. How would we filter the data so that our end users do not
> see
> other companies data in the Model that we design?
> We can not allow the end user to create a filter for CompanyID at run
> time.
>

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>
>