Datasource cannot be found after report redeployment

We have an application using the winforms report viewer, and it displays all our reports perfectly untill I need to redeploy a report.

As soon as a report is re-deployed a refresh of the report in the viewer shows the following error message:

An error has occured during report processing. The data souce 'mydatasource' cannot be found.

This error occurs irrespective of electing to re-deploy ot not re-deploy the datasource, and the only solution seems to be to close the report viewer down and restart it.

I can reproduce the same problem hosting the reports in a web browser as well, with a slightly different error message

An error has occurred during report processing. (rsProcessingAborted). The data source 'mydatasource' cannot be found. (rsDataSourceNotFound)

Under RS2000 any changes that were made to a report, would automatically be shown to the user if the report was refreshed, without having to close the browser/application down and restart it.

Can I configure RS2005 to prevent this error occuring ? I have read that RS2005 seems to work a lot more within the IIS session for the user and cache things it thinks are usefull, so can I turn this behaviour off, or make it run like RS 2000 did, which provided me with a stable reporting platform?

If I cannot do this from the RS end of the system, is there any advice on using the winforms control to get around this issue - i've only just started using the control so I am not familiar with all its aspects !

Thanks

Andy

Hi Andy, did you ever resolve this? (I'm experiencing the same problem)

Cheers,

George

Datasource cannot be found after report redeployment

We have an application using the winforms report viewer, and it displays all our reports perfectly untill I need to redeploy a report.

As soon as a report is re-deployed a refresh of the report in the viewer shows the following error message:

An error has occured during report processing. The data souce 'mydatasource' cannot be found.

This error occurs irrespective of electing to re-deploy ot not re-deploy the datasource, and the only solution seems to be to close the report viewer down and restart it.

I can reproduce the same problem hosting the reports in a web browser as well, with a slightly different error message

An error has occurred during report processing. (rsProcessingAborted). The data source 'mydatasource' cannot be found. (rsDataSourceNotFound)

Under RS2000 any changes that were made to a report, would automatically be shown to the user if the report was refreshed, without having to close the browser/application down and restart it.

Can I configure RS2005 to prevent this error occuring ? I have read that RS2005 seems to work a lot more within the IIS session for the user and cache things it thinks are usefull, so can I turn this behaviour off, or make it run like RS 2000 did, which provided me with a stable reporting platform?

If I cannot do this from the RS end of the system, is there any advice on using the winforms control to get around this issue - i've only just started using the control so I am not familiar with all its aspects !

Thanks

Andy

Hi Andy, did you ever resolve this? (I'm experiencing the same problem)

Cheers,

George

Dataset Run finds 24 results, Preview displays 1 results

Hello All,
I am a newbie here coming from a Crystal development background and
intermediate skills with SQL. I seem to have various issues creating
all sorts of RS reports. I'm trying to start with "more modest"
reports to ease myself into the groove of using RS, but some things
that seem simple stump me.
I have a simple query that brings back 24 results. I used the wizard
to create a simple layout using 1 group (I expect 12 "subsections" by
using this group) with the details displayed under each group.
For whatever odd reason, even tho' running the query finds the 24
results, the Preview shows 1 result. I even removed the group and ran
all the details (tried refreshing) and only 1 result again.
Any ideas?
Thank you in advance
-ColleenOn Apr 27, 10:58 am, Colleen <colleenleon...@.gmail.com> wrote:
> Hello All,
> I am a newbie here coming from a Crystal development background and
> intermediate skills with SQL. I seem to have various issues creating
> all sorts of RS reports. I'm trying to start with "more modest"
> reports to ease myself into the groove of using RS, but some things
> that seem simple stump me.
> I have a simple query that brings back 24 results. I used the wizard
> to create a simple layout using 1 group (I expect 12 "subsections" by
> using this group) with the details displayed under each group.
> For whatever odd reason, even tho' running the query finds the 24
> results, the Preview shows 1 result. I even removed the group and ran
> all the details (tried refreshing) and only 1 result again.
> Any ideas?
> Thank you in advance
> -Colleen
It sounds kind-of like your group had the Property 'Page break at end'
set. Also, make sure you don't have a filter set. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I think grouping has done with 1 row than 24
what you do is create a new project->report and place the same query and see
whether you get the same results. ofcourse place a table control and just
drag and drop a couple of fields and see whether you get 24 rows.?
Amarnath
"Colleen" wrote:
> Hello All,
> I am a newbie here coming from a Crystal development background and
> intermediate skills with SQL. I seem to have various issues creating
> all sorts of RS reports. I'm trying to start with "more modest"
> reports to ease myself into the groove of using RS, but some things
> that seem simple stump me.
> I have a simple query that brings back 24 results. I used the wizard
> to create a simple layout using 1 group (I expect 12 "subsections" by
> using this group) with the details displayed under each group.
> For whatever odd reason, even tho' running the query finds the 24
> results, the Preview shows 1 result. I even removed the group and ran
> all the details (tried refreshing) and only 1 result again.
> Any ideas?
> Thank you in advance
> -Colleen
>|||My guess is that you dragged and dropped your fields onto an empty canvas.
If you do this you will see only one record because you did not put either a
table or list control on the canvas first.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Colleen" <colleenleonard@.gmail.com> wrote in message
news:1177689534.303004.210340@.r30g2000prh.googlegroups.com...
> Hello All,
> I am a newbie here coming from a Crystal development background and
> intermediate skills with SQL. I seem to have various issues creating
> all sorts of RS reports. I'm trying to start with "more modest"
> reports to ease myself into the groove of using RS, but some things
> that seem simple stump me.
> I have a simple query that brings back 24 results. I used the wizard
> to create a simple layout using 1 group (I expect 12 "subsections" by
> using this group) with the details displayed under each group.
> For whatever odd reason, even tho' running the query finds the 24
> results, the Preview shows 1 result. I even removed the group and ran
> all the details (tried refreshing) and only 1 result again.
> Any ideas?
> Thank you in advance
> -Colleen
>|||Other things to check might be that you are not pulling the "first" value in your expression. In your Datasets drill down it may only offer the choice to pull your first value.
From http://www.developmentnow.com/g/115_2007_4_0_0_964026/Dataset-Run-finds-24-results-Preview-displays-1-results.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||On Apr 29, 8:45 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> My guess is that you dragged and dropped your fields onto an empty canvas.
> If you do this you will see only one record because you did not put either a
> table or list control on the canvas first.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Colleen" <colleenleon...@.gmail.com> wrote in message
> news:1177689534.303004.210340@.r30g2000prh.googlegroups.com...
>
> > Hello All,
> > I am a newbie here coming from a Crystal development background and
> > intermediate skills with SQL. I seem to have various issues creating
> > all sorts of RS reports. I'm trying to start with "more modest"
> > reports to ease myself into the groove of using RS, but some things
> > that seem simple stump me.
> > I have a simple query that brings back 24 results. I used the wizard
> > to create a simple layout using 1 group (I expect 12 "subsections" by
> > using this group) with the details displayed under each group.
> > For whatever odd reason, even tho' running the query finds the 24
> > results, the Preview shows 1result. I even removed the group and ran
> > all the details (tried refreshing) and only 1resultagain.
> > Any ideas?
> > Thank you in advance
> > -Colleen- Hide quoted text -
> - Show quoted text -|||On Apr 29, 8:45 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> My guess is that you dragged and dropped your fields onto an empty canvas.
> If you do this you will see only one record because you did not put either a
> table or list control on the canvas first.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Colleen" <colleenleon...@.gmail.com> wrote in message
> news:1177689534.303004.210340@.r30g2000prh.googlegroups.com...
>
> > Hello All,
> > I am a newbie here coming from a Crystal development background and
> > intermediate skills with SQL. I seem to have various issues creating
> > all sorts of RS reports. I'm trying to start with "more modest"
> > reports to ease myself into the groove of using RS, but some things
> > that seem simple stump me.
> > I have a simple query that brings back 24 results. I used the wizard
> > to create a simple layout using 1 group (I expect 12 "subsections" by
> > using this group) with the details displayed under each group.
> > For whatever odd reason, even tho' running the query finds the 24
> > results, the Preview shows 1result. I even removed the group and ran
> > all the details (tried refreshing) and only 1resultagain.
> > Any ideas?
> > Thank you in advance
> > -Colleen- Hide quoted text -
> - Show quoted text -
---
Not sure how to reply to ALL here... thank you ALL for your help.
I could not find evidence that I selected pulling the "first" value in
the expression
I did not populate my report on an "empty canvas" as I have been using
the Report Wizard for now until I become more acclimated.
I DID try and recreate my report from scratch and did not use the
group feature in the Report Wizard and *got the desired results*. I
didn't even set up the parameter and magically somehow the report
picked it up on its own (I've has issues with other reports that even
forcefully adding the parameters to the report still doesn't seem to
"use" them). So I added the group after I had all the details
displayed and so far it works, the output looks a little different
creating the group after you create the report vs creating the group
in the wizard, but I can't be picky at this point. 280+ report left
to convert!
Thank you all very much for your ideas... I wish I understood better
how to fix the problem vs starting over, but if that is what works
then so be it.
Thanks again
-Colleen|||One point to be aware of when testing.
When you preview the report in development it will cache the data and reuse
that unless a parameter value changes. This can cause you to see something
different in preview versus deployment. If you look at where your rdl files
are you will see a .data file. This file can be deleted to force it to hit
the server for the data. Or, if your report has a parameter then just pick a
different value.
Just a heads up.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Colleen" <colleenleonard@.gmail.com> wrote in message
news:1178028225.392190.64460@.c35g2000hsg.googlegroups.com...
> On Apr 29, 8:45 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> My guess is that you dragged and dropped your fields onto an empty
>> canvas.
>> If you do this you will see only one record because you did not put
>> either a
>> table or list control on the canvas first.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Colleen" <colleenleon...@.gmail.com> wrote in message
>> news:1177689534.303004.210340@.r30g2000prh.googlegroups.com...
>>
>> > Hello All,
>> > I am a newbie here coming from a Crystal development background and
>> > intermediate skills with SQL. I seem to have various issues creating
>> > all sorts of RS reports. I'm trying to start with "more modest"
>> > reports to ease myself into the groove of using RS, but some things
>> > that seem simple stump me.
>> > I have a simple query that brings back 24 results. I used the wizard
>> > to create a simple layout using 1 group (I expect 12 "subsections" by
>> > using this group) with the details displayed under each group.
>> > For whatever odd reason, even tho' running the query finds the 24
>> > results, the Preview shows 1result. I even removed the group and ran
>> > all the details (tried refreshing) and only 1resultagain.
>> > Any ideas?
>> > Thank you in advance
>> > -Colleen- Hide quoted text -
>> - Show quoted text -
> ---
> Not sure how to reply to ALL here... thank you ALL for your help.
> I could not find evidence that I selected pulling the "first" value in
> the expression
> I did not populate my report on an "empty canvas" as I have been using
> the Report Wizard for now until I become more acclimated.
> I DID try and recreate my report from scratch and did not use the
> group feature in the Report Wizard and *got the desired results*. I
> didn't even set up the parameter and magically somehow the report
> picked it up on its own (I've has issues with other reports that even
> forcefully adding the parameters to the report still doesn't seem to
> "use" them). So I added the group after I had all the details
> displayed and so far it works, the output looks a little different
> creating the group after you create the report vs creating the group
> in the wizard, but I can't be picky at this point. 280+ report left
> to convert!
> Thank you all very much for your ideas... I wish I understood better
> how to fix the problem vs starting over, but if that is what works
> then so be it.
> Thanks again
> -Colleen
>

dataset query based on a global parameter

I need to create a report that displays data based on the userid. all the
records have a userid field filled with many userid values. how can I use the
global paramerer userid in the criteria for my dataset. so when a user run
the report olny records with his or her userid are showncreate a parameter with default value the global parameter. then use that
parameter in the query. ofcourse you can't use caching for those reports
"DJJIII" wrote:
> I need to create a report that displays data based on the userid. all the
> records have a userid field filled with many userid values. how can I use the
> global paramerer userid in the criteria for my dataset. so when a user run
> the report olny records with his or her userid are shown|||You do not have to have a 1:1 mapping between query parameters and report
parameters. Doing it the way suggested here means you have to muck around
with hiding it (since you don't want people to change it).
Have your query parameter, let's call it @.UserID. RS will automatically
recreate a report parameter called UserID but we won't use it. Click on the
..., go to parameters. Map the query parameter @.UserID to the global . The
parameter dialog box has a name and value columns. On the value side switch
it to expression. This brings you to the expression builder where you can
pick the User!UserID global variable. One thing to note, this variable has
the domain as well as the user id, so if you don't want this you will have
to strip it off.
Now, go you your layout, Report->Parameters and delete the now unneeded
UserID report parameter.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Antoon" <Antoon@.discussions.microsoft.com> wrote in message
news:04C477F1-17E5-47C5-BB11-9EF31278F1CE@.microsoft.com...
> create a parameter with default value the global parameter. then use that
> parameter in the query. ofcourse you can't use caching for those reports
> "DJJIII" wrote:
>> I need to create a report that displays data based on the userid. all
>> the
>> records have a userid field filled with many userid values. how can I use
>> the
>> global paramerer userid in the criteria for my dataset. so when a user
>> run
>> the report olny records with his or her userid are shown|||great tip, that is indeed a lot more practical
"Bruce L-C [MVP]" wrote:
> You do not have to have a 1:1 mapping between query parameters and report
> parameters. Doing it the way suggested here means you have to muck around
> with hiding it (since you don't want people to change it).
> Have your query parameter, let's call it @.UserID. RS will automatically
> recreate a report parameter called UserID but we won't use it. Click on the
> ..., go to parameters. Map the query parameter @.UserID to the global . The
> parameter dialog box has a name and value columns. On the value side switch
> it to expression. This brings you to the expression builder where you can
> pick the User!UserID global variable. One thing to note, this variable has
> the domain as well as the user id, so if you don't want this you will have
> to strip it off.
> Now, go you your layout, Report->Parameters and delete the now unneeded
> UserID report parameter.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Antoon" <Antoon@.discussions.microsoft.com> wrote in message
> news:04C477F1-17E5-47C5-BB11-9EF31278F1CE@.microsoft.com...
> > create a parameter with default value the global parameter. then use that
> > parameter in the query. ofcourse you can't use caching for those reports
> >
> > "DJJIII" wrote:
> >
> >> I need to create a report that displays data based on the userid. all
> >> the
> >> records have a userid field filled with many userid values. how can I use
> >> the
> >> global paramerer userid in the criteria for my dataset. so when a user
> >> run
> >> the report olny records with his or her userid are shown
>
>

DataSet Problems

Hi,
We have noticed a problem with following:
1. creating a new report
2. adding a DataSet which pulls from a shared data source and displays
information correctly
3. choosing 'Save' and not pulling the fields into the layout form
When we open the report again the dataset is there but all references to the
table we selected are gone.
Is this supposed to happen? We have tried this on 2 separate installations,
one with SP2 and one without.
Any suggestions?Sometimes RS does not recognize that anything has changed in the data tab
and does not save. Just go to the layout tab and click on save all and you
will be good to go.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"KDogg" <KDogg@.discussions.microsoft.com> wrote in message
news:B3D6B39F-12D0-4F95-A998-1CF4A83B231F@.microsoft.com...
> Hi,
> We have noticed a problem with following:
> 1. creating a new report
> 2. adding a DataSet which pulls from a shared data source and displays
> information correctly
> 3. choosing 'Save' and not pulling the fields into the layout form
> When we open the report again the dataset is there but all references to
> the
> table we selected are gone.
> Is this supposed to happen? We have tried this on 2 separate
> installations,
> one with SP2 and one without.
> Any suggestions?|||Bruce - Thank you, that worked! Would this be fixed in a future release?
Although we were working on a small dataset I would hate to have lost
development time on a larger query?!
"Bruce L-C [MVP]" wrote:
> Sometimes RS does not recognize that anything has changed in the data tab
> and does not save. Just go to the layout tab and click on save all and you
> will be good to go.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "KDogg" <KDogg@.discussions.microsoft.com> wrote in message
> news:B3D6B39F-12D0-4F95-A998-1CF4A83B231F@.microsoft.com...
> > Hi,
> > We have noticed a problem with following:
> > 1. creating a new report
> > 2. adding a DataSet which pulls from a shared data source and displays
> > information correctly
> > 3. choosing 'Save' and not pulling the fields into the layout form
> > When we open the report again the dataset is there but all references to
> > the
> > table we selected are gone.
> > Is this supposed to happen? We have tried this on 2 separate
> > installations,
> > one with SP2 and one without.
> >
> > Any suggestions?
>
>|||I have no idea. I have lost work so I do this compulsively now. I'll
probably keep doing it when the bug no longer exists.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"KDogg" <KDogg@.discussions.microsoft.com> wrote in message
news:DC256683-1D12-4C55-B578-8A4440F1B41E@.microsoft.com...
> Bruce - Thank you, that worked! Would this be fixed in a future release?
> Although we were working on a small dataset I would hate to have lost
> development time on a larger query?!
> "Bruce L-C [MVP]" wrote:
>> Sometimes RS does not recognize that anything has changed in the data tab
>> and does not save. Just go to the layout tab and click on save all and
>> you
>> will be good to go.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "KDogg" <KDogg@.discussions.microsoft.com> wrote in message
>> news:B3D6B39F-12D0-4F95-A998-1CF4A83B231F@.microsoft.com...
>> > Hi,
>> > We have noticed a problem with following:
>> > 1. creating a new report
>> > 2. adding a DataSet which pulls from a shared data source and displays
>> > information correctly
>> > 3. choosing 'Save' and not pulling the fields into the layout form
>> > When we open the report again the dataset is there but all references
>> > to
>> > the
>> > table we selected are gone.
>> > Is this supposed to happen? We have tried this on 2 separate
>> > installations,
>> > one with SP2 and one without.
>> >
>> > Any suggestions?
>>