I have a DataSet which is defined as "SELECT * FROM Table". There are MANY
records in Table. However, the report only shows a single record/page. I
placed the fields on the report in the "Body". What am I missing here?Nevermind... Got it. It's the List item.
"Dan" wrote:
> I have a DataSet which is defined as "SELECT * FROM Table". There are MANY
> records in Table. However, the report only shows a single record/page. I
> placed the fields on the report in the "Body". What am I missing here?|||When you place the fields on the blank layout surface you are not using any
of the controls that know about multiple rows. You need to place either a
table control or a list control and then drag and drop onto them.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:7F61EA6A-DB25-43FC-9117-84A2E7E037AA@.microsoft.com...
>I have a DataSet which is defined as "SELECT * FROM Table". There are MANY
> records in Table. However, the report only shows a single record/page. I
> placed the fields on the report in the "Body". What am I missing here?sql
Showing posts with label showing. Show all posts
Showing posts with label showing. Show all posts
Monday, March 26, 2012
Report not showing up in IE but works in VS.net
Hey guys,
Anyone know why my main report works but when i click on a link i've created
on the main report to link to another report, the other report doesn't show
up (IE just says 'done' and nothing is displayed)?
The reports link and load correctly when i'm using the preview tab within
VS.net though.
ACK!
Thanks guys,
AlI've run into this when my drillthrough (second) report takes
parameters based on the first, but is pointing to a different database,
thereby returning no results. Try to manually load the second report
using any valid parameter values from the first and see if you can
replicate this error.
Just be sure that both reports are going against the same database.
I've run into this when using key values which are different between
DEV and QA environments.
Mike
Anyone know why my main report works but when i click on a link i've created
on the main report to link to another report, the other report doesn't show
up (IE just says 'done' and nothing is displayed)?
The reports link and load correctly when i'm using the preview tab within
VS.net though.
ACK!
Thanks guys,
AlI've run into this when my drillthrough (second) report takes
parameters based on the first, but is pointing to a different database,
thereby returning no results. Try to manually load the second report
using any valid parameter values from the first and see if you can
replicate this error.
Just be sure that both reports are going against the same database.
I've run into this when using key values which are different between
DEV and QA environments.
Mike
report not showing information in rows
Hello,
I have several reports that work fine other then when the values for a
column is the same as the one below it the the value dose not show up? Is
this something I can turn off?
For example I have a column that might have several rows of 0 but only one 0
will there and then blank rows till the next value.Hi John,
It sounds like the rows have the property "Hide Duplicates" assigned to the
column or field that is repeating the value. You can toggle this attribute
in the property dialogue of the field in question.
Rodney Landrum
Author - Pro SQL Reporting Services (Apress)
"John" <John@.discussions.microsoft.com> wrote in message
news:9C51915F-4DA6-4C3F-8106-7ECB8E89C98D@.microsoft.com...
> Hello,
> I have several reports that work fine other then when the values for a
> column is the same as the one below it the the value dose not show up? Is
> this something I can turn off?
> For example I have a column that might have several rows of 0 but only one
> 0
> will there and then blank rows till the next value.
>|||I create the report in code but that sound like it is my problem thanks
"Rodney" wrote:
> Hi John,
> It sounds like the rows have the property "Hide Duplicates" assigned to the
> column or field that is repeating the value. You can toggle this attribute
> in the property dialogue of the field in question.
> Rodney Landrum
> Author - Pro SQL Reporting Services (Apress)
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:9C51915F-4DA6-4C3F-8106-7ECB8E89C98D@.microsoft.com...
> > Hello,
> > I have several reports that work fine other then when the values for a
> > column is the same as the one below it the the value dose not show up? Is
> > this something I can turn off?
> > For example I have a column that might have several rows of 0 but only one
> > 0
> > will there and then blank rows till the next value.
> >
>
>
I have several reports that work fine other then when the values for a
column is the same as the one below it the the value dose not show up? Is
this something I can turn off?
For example I have a column that might have several rows of 0 but only one 0
will there and then blank rows till the next value.Hi John,
It sounds like the rows have the property "Hide Duplicates" assigned to the
column or field that is repeating the value. You can toggle this attribute
in the property dialogue of the field in question.
Rodney Landrum
Author - Pro SQL Reporting Services (Apress)
"John" <John@.discussions.microsoft.com> wrote in message
news:9C51915F-4DA6-4C3F-8106-7ECB8E89C98D@.microsoft.com...
> Hello,
> I have several reports that work fine other then when the values for a
> column is the same as the one below it the the value dose not show up? Is
> this something I can turn off?
> For example I have a column that might have several rows of 0 but only one
> 0
> will there and then blank rows till the next value.
>|||I create the report in code but that sound like it is my problem thanks
"Rodney" wrote:
> Hi John,
> It sounds like the rows have the property "Hide Duplicates" assigned to the
> column or field that is repeating the value. You can toggle this attribute
> in the property dialogue of the field in question.
> Rodney Landrum
> Author - Pro SQL Reporting Services (Apress)
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:9C51915F-4DA6-4C3F-8106-7ECB8E89C98D@.microsoft.com...
> > Hello,
> > I have several reports that work fine other then when the values for a
> > column is the same as the one below it the the value dose not show up? Is
> > this something I can turn off?
> > For example I have a column that might have several rows of 0 but only one
> > 0
> > will there and then blank rows till the next value.
> >
>
>
Friday, March 23, 2012
report model project problem - entity not showing up
I have a client table and a clientdoctors table.
In the data source view i see all the needed tables in the diagram organizer
pane. I also see the relationship between the clientdoctors table (which
holds clientid and doctorid), as well as client table and doctor table.
That all looks fine. The problem however is that when in my report model i
do not see those relationships at all between the client - client doctor -
doctor tables. There are a few situations just like this that i cannot
explain.
I am new to the report model project but i dont know why i dont see these
relationships inthe report model or while using report builder.
Any ideas please'Have you deployed properly? I mean you didn;t get any error. After deploying
you get to see in Report Builder. Just check.
Amarnath
"dave" wrote:
> I have a client table and a clientdoctors table.
> In the data source view i see all the needed tables in the diagram organizer
> pane. I also see the relationship between the clientdoctors table (which
> holds clientid and doctorid), as well as client table and doctor table.
> That all looks fine. The problem however is that when in my report model i
> do not see those relationships at all between the client - client doctor -
> doctor tables. There are a few situations just like this that i cannot
> explain.
> I am new to the report model project but i dont know why i dont see these
> relationships inthe report model or while using report builder.
> Any ideas please'|||Yes everything deployed properly. It seems like the problem was related to
keys on the tables. i.e. i had to place keys on the middle table.
"Amarnath" wrote:
> Have you deployed properly? I mean you didn;t get any error. After deploying
> you get to see in Report Builder. Just check.
> Amarnath
>
> "dave" wrote:
> > I have a client table and a clientdoctors table.
> >
> > In the data source view i see all the needed tables in the diagram organizer
> > pane. I also see the relationship between the clientdoctors table (which
> > holds clientid and doctorid), as well as client table and doctor table.
> >
> > That all looks fine. The problem however is that when in my report model i
> > do not see those relationships at all between the client - client doctor -
> > doctor tables. There are a few situations just like this that i cannot
> > explain.
> >
> > I am new to the report model project but i dont know why i dont see these
> > relationships inthe report model or while using report builder.
> >
> > Any ideas please'|||You need to have key relationship otherwise it wont select tables in the
report model itself. If you have completed the wizard of creating report
model. then it would have asked for keys when you select tables for
relations. So just check if all the keys are in place and deploy.
Amarnath
"dave" wrote:
> Yes everything deployed properly. It seems like the problem was related to
> keys on the tables. i.e. i had to place keys on the middle table.
>
> "Amarnath" wrote:
> > Have you deployed properly? I mean you didn;t get any error. After deploying
> > you get to see in Report Builder. Just check.
> >
> > Amarnath
> >
> >
> > "dave" wrote:
> >
> > > I have a client table and a clientdoctors table.
> > >
> > > In the data source view i see all the needed tables in the diagram organizer
> > > pane. I also see the relationship between the clientdoctors table (which
> > > holds clientid and doctorid), as well as client table and doctor table.
> > >
> > > That all looks fine. The problem however is that when in my report model i
> > > do not see those relationships at all between the client - client doctor -
> > > doctor tables. There are a few situations just like this that i cannot
> > > explain.
> > >
> > > I am new to the report model project but i dont know why i dont see these
> > > relationships inthe report model or while using report builder.
> > >
> > > Any ideas please'
In the data source view i see all the needed tables in the diagram organizer
pane. I also see the relationship between the clientdoctors table (which
holds clientid and doctorid), as well as client table and doctor table.
That all looks fine. The problem however is that when in my report model i
do not see those relationships at all between the client - client doctor -
doctor tables. There are a few situations just like this that i cannot
explain.
I am new to the report model project but i dont know why i dont see these
relationships inthe report model or while using report builder.
Any ideas please'Have you deployed properly? I mean you didn;t get any error. After deploying
you get to see in Report Builder. Just check.
Amarnath
"dave" wrote:
> I have a client table and a clientdoctors table.
> In the data source view i see all the needed tables in the diagram organizer
> pane. I also see the relationship between the clientdoctors table (which
> holds clientid and doctorid), as well as client table and doctor table.
> That all looks fine. The problem however is that when in my report model i
> do not see those relationships at all between the client - client doctor -
> doctor tables. There are a few situations just like this that i cannot
> explain.
> I am new to the report model project but i dont know why i dont see these
> relationships inthe report model or while using report builder.
> Any ideas please'|||Yes everything deployed properly. It seems like the problem was related to
keys on the tables. i.e. i had to place keys on the middle table.
"Amarnath" wrote:
> Have you deployed properly? I mean you didn;t get any error. After deploying
> you get to see in Report Builder. Just check.
> Amarnath
>
> "dave" wrote:
> > I have a client table and a clientdoctors table.
> >
> > In the data source view i see all the needed tables in the diagram organizer
> > pane. I also see the relationship between the clientdoctors table (which
> > holds clientid and doctorid), as well as client table and doctor table.
> >
> > That all looks fine. The problem however is that when in my report model i
> > do not see those relationships at all between the client - client doctor -
> > doctor tables. There are a few situations just like this that i cannot
> > explain.
> >
> > I am new to the report model project but i dont know why i dont see these
> > relationships inthe report model or while using report builder.
> >
> > Any ideas please'|||You need to have key relationship otherwise it wont select tables in the
report model itself. If you have completed the wizard of creating report
model. then it would have asked for keys when you select tables for
relations. So just check if all the keys are in place and deploy.
Amarnath
"dave" wrote:
> Yes everything deployed properly. It seems like the problem was related to
> keys on the tables. i.e. i had to place keys on the middle table.
>
> "Amarnath" wrote:
> > Have you deployed properly? I mean you didn;t get any error. After deploying
> > you get to see in Report Builder. Just check.
> >
> > Amarnath
> >
> >
> > "dave" wrote:
> >
> > > I have a client table and a clientdoctors table.
> > >
> > > In the data source view i see all the needed tables in the diagram organizer
> > > pane. I also see the relationship between the clientdoctors table (which
> > > holds clientid and doctorid), as well as client table and doctor table.
> > >
> > > That all looks fine. The problem however is that when in my report model i
> > > do not see those relationships at all between the client - client doctor -
> > > doctor tables. There are a few situations just like this that i cannot
> > > explain.
> > >
> > > I am new to the report model project but i dont know why i dont see these
> > > relationships inthe report model or while using report builder.
> > >
> > > Any ideas please'
Wednesday, March 7, 2012
Report is not showing
hai friends
i deployed my report and in preview using vs.net i can see the report.
but once i deployed
the report is being generated screen is comming but it is not showing
report.i waited and waited still that report is being generated screen only
i am using evaluation copy is this the limitation of trial ver.we cannot see
the deployed report.
also how can i know how many days left in my evaluation version.I too have the same problem.
Though it works fine with an SQL db. The problem only occurs when using an
Oracle DB. I am using the 8i client. It works fine on my dev machine in
Visual Studio. It hangs when the report is run from a Report Services.
Its quite possible that both issues are related ?
"vishak" wrote:
> hai friends
> i deployed my report and in preview using vs.net i can see the report.
> but once i deployed
> the report is being generated screen is comming but it is not showing
> report.i waited and waited still that report is being generated screen only
> i am using evaluation copy is this the limitation of trial ver.we cannot see
> the deployed report.
> also how can i know how many days left in my evaluation version.|||Oracle is pretty unique and complicated. From the designer if you are using
the graphical query designer then OLEDB is used. If you use the generic
designer then a dotnet managed provider is used. I thought the managed
provider requires 9i or greater but I am not sure of that. When deployed it
uses the managed provider. I am guessing that this is where you problem is
coming from. To test the theory out, switch to generic query mode (the
button is to the right of the ...) and try executing from there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kamlesh Parmar" <KamleshParmar@.discussions.microsoft.com> wrote in message
news:0A3C89B2-BC98-4307-9CEB-201E8E6C7AA1@.microsoft.com...
> I too have the same problem.
> Though it works fine with an SQL db. The problem only occurs when using an
> Oracle DB. I am using the 8i client. It works fine on my dev machine in
> Visual Studio. It hangs when the report is run from a Report Services.
> Its quite possible that both issues are related ?
> "vishak" wrote:
> > hai friends
> > i deployed my report and in preview using vs.net i can see the report.
> > but once i deployed
> > the report is being generated screen is comming but it is not showing
> > report.i waited and waited still that report is being generated screen
only
> >
> > i am using evaluation copy is this the limitation of trial ver.we cannot
see
> > the deployed report.
> >
> > also how can i know how many days left in my evaluation version.
i deployed my report and in preview using vs.net i can see the report.
but once i deployed
the report is being generated screen is comming but it is not showing
report.i waited and waited still that report is being generated screen only
i am using evaluation copy is this the limitation of trial ver.we cannot see
the deployed report.
also how can i know how many days left in my evaluation version.I too have the same problem.
Though it works fine with an SQL db. The problem only occurs when using an
Oracle DB. I am using the 8i client. It works fine on my dev machine in
Visual Studio. It hangs when the report is run from a Report Services.
Its quite possible that both issues are related ?
"vishak" wrote:
> hai friends
> i deployed my report and in preview using vs.net i can see the report.
> but once i deployed
> the report is being generated screen is comming but it is not showing
> report.i waited and waited still that report is being generated screen only
> i am using evaluation copy is this the limitation of trial ver.we cannot see
> the deployed report.
> also how can i know how many days left in my evaluation version.|||Oracle is pretty unique and complicated. From the designer if you are using
the graphical query designer then OLEDB is used. If you use the generic
designer then a dotnet managed provider is used. I thought the managed
provider requires 9i or greater but I am not sure of that. When deployed it
uses the managed provider. I am guessing that this is where you problem is
coming from. To test the theory out, switch to generic query mode (the
button is to the right of the ...) and try executing from there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kamlesh Parmar" <KamleshParmar@.discussions.microsoft.com> wrote in message
news:0A3C89B2-BC98-4307-9CEB-201E8E6C7AA1@.microsoft.com...
> I too have the same problem.
> Though it works fine with an SQL db. The problem only occurs when using an
> Oracle DB. I am using the 8i client. It works fine on my dev machine in
> Visual Studio. It hangs when the report is run from a Report Services.
> Its quite possible that both issues are related ?
> "vishak" wrote:
> > hai friends
> > i deployed my report and in preview using vs.net i can see the report.
> > but once i deployed
> > the report is being generated screen is comming but it is not showing
> > report.i waited and waited still that report is being generated screen
only
> >
> > i am using evaluation copy is this the limitation of trial ver.we cannot
see
> > the deployed report.
> >
> > also how can i know how many days left in my evaluation version.
Saturday, February 25, 2012
Report Headers showing on blank page
I hope someone will have time to answer a really basic RS question.
I have a simple report, the query will only return a few rows (16 - 20), my header is repeating on a 2nd blank page. I'm sure it's because I grouped on a column from the record set. I can not find where you delete the grouping.
Anyone have any good suggestions on RS books?
Thanks
Hey Marc,
There are a couple of places to check:
When you click on the table, are there rows that have little numbers on them (1,2, etc)? If so, you should be able to right-click on these and select Delete Groups.
Another place could be the Properties of the table (Select the table, right click on the Properties option). Select the Grouping tab. Delete any of the groups in there (usually named something like "details_group")
Good luck!
Jessica
Subscribe to:
Posts (Atom)