ReportBuider and cascading parameters

Is it possible to implement cascading parametrs via Report Builder
filters?
KamelOn Aug 23, 10:21 am, kamel <kwic...@.gmail.com> wrote:
> Is it possible to implement cascading parametrs via Report Builder
> filters?
> Kamel
Hi,
Haven't found out about Report Builder, but i do know the via BI
studio you can.
In order to work with cascading params, you must have more then one
dataset and
i don't see how that's possible with ReportBuilder.
if you need more info how to do it via Business Intelligence Studio,
just tell me.
Greetings
Vinnie|||I know it's possible in Designer;
I'd like to implement it in ReportBuider...
Thank you for your response.

Report: same

Hi There

We created a report from an Informix database stored procedure (with parameters). When we execute the stored procedure in the data page, it returns correct result set with column headings blank. In the datasets page, the field names are: ID, ID_1, ID_2, …

When I preview a report created from the dataset, all the fields shows the same value as field1 (ID). I have no idea on what happened, why it happened, and how to resolve it? Could you please help?

Thanks in advance.

Jane

It's been awhile since I have run into this, so apologies if this isn't exactly right. I believe this occurs when Reporting Services can't get the column metadata from the database, or when all the columns have the same base name (the table.column name may be unique, but the column name is not). So the mapping of values to columns doesn't work correctly.

The workaround for us was to make sure the database query aliased all columns to a unique name.

|||

Thanks for your reply.

You are right, our problem is Reporting Services can't get the column metadata from the stored procedure return result. In the data page, we select Text, and type:

execute procedure proc_name (?)

Because we use stored procedures instead of queries, not sure how to set the column names. Any ideas? Thanks a lot.

Cheers

Jane

Report's Parameter : From Date to Date

I want to add 2 parameters in my report to delimit a date range. The report is based on Analysis Services 2005 and I have created a Time Dimension. What is the best way to do this ?

I would prefer to use a Datetime parameter type because of the calendar component, but then I don't succeed to associate this parameter with the Time Dimension in the filter expression...

I really need an answer to that question, please help me |||You can't really use a datetime parameter (at least not using the built-in prompting) as AS dates are members of a dimension, not scalars. And you aren't really guaranteed that the range between two members will give you what you want. We could add a feature at some point to convert them but that doesn't exist now.|||

Thanks for the answer.

I just found a solution to my problem, even if the solution is not what I hoped for, it may help someone :

I created two Report Parameters "From Date" and "To Date" which use the calendar component to let the user choose a date. And in my Dataset, in the '...' button, in the 'Parameters' bar, I add a parameter whose value is :

="[Temps].[Temps - Date Key].[" & Year(Parameters!FromTempsTempsCalendrier.Value) & "-" & IIF(Month(Parameters!FromTempsTempsCalendrier.Value)<10,"0","") & Month(Parameters!FromTempsTempsCalendrier.Value) & "-" & IIF(Day(Parameters!FromTempsTempsCalendrier.Value)<10, "0","") & Day(Parameters!FromTempsTempsCalendrier.Value) & " 00:00:00]"

That way, I build the UNIQUENAME properties of my Time Dimension.

But an error occurs when the user select a date which does not exist in the Time Dimension.

|||

Thanks for the possible solution. However, I've been working on following your steps, but I am not getting it to work.

Could you explain in a little more detail how to accomplish this?

Report works byitself, but not in a SubReport

Hi All,
I am trying to run a report which has no parameters. it works fine in
design and even on the report server. but as soon as i put it in a
subreport it gives an error
"Error: SubReport could not be shown"
i have tried almost all of the help available on these group, i have
put the report to be of the same size, removed all the parameters(so
there are no parameters).
will highly appreciate any valuable suggestions.
:-)hi,
theboulevardguy1@.gmail.com wrote:
> "Error: SubReport could not be shown"
This is not an Access or VBA error. So take a look at the report events
(On Load, On Open). There must be some piece of code throwing that
exception.
mfG
--> stefan <--|||I presume you are getting the error in the VS designer. Is the calling
report is in the same project as the subreport?
Also you posted this to reporting services group and access. They are
quite different reports. I am assuming this is a reporting services
report.
theboulevardg...@.gmail.com wrote:
> Hi All,
> I am trying to run a report which has no parameters. it works fine in
> design and even on the report server. but as soon as i put it in a
> subreport it gives an error
> "Error: SubReport could not be shown"
> i have tried almost all of the help available on these group, i have
> put the report to be of the same size, removed all the parameters(so
> there are no parameters).
> will highly appreciate any valuable suggestions.
> :-)

report wont refresh when accessed remotely

I have a report that is based on a straight forward query of
select * from tblx
No parameters ...
tblx gets populated by processes from an application that get invoked from a
command button. In the same process I then invoke the report using my
published url. The report comes up OK. But when I change the data in tblx
and bring up the report, it is still displaying the old data. Do I need to
add parameters to the query for it to refresh the data? Could someone
explain why the report does not refresh with the new data in tblx?
Thanks,
RichThank you for your reply. I am using RS2003 with sql server 2000. I went to
report properties but I don't see a report manager or anything about
execution. I went to the project properties - where I set the URL but I did
not see anything for executive there either. Is there somewhere on the
toolbar I can go to for locating the Report Manager or something about
execution?
Thanks,
Rich
"Chris Conner" wrote:
> This is easily fixed...
> Turn off caching for the report. By default, it is cached for 30 minutes. It
> does this since you will more often view data that is static, i.e. in the
> past, than current real time changes.
> To change the cache setting for the report, go to the report itself and view
> its properties in the report manager. Look to your left and you will see
> "execution settings". click that, next you should see the cache options
> available. Set it to your liking. :)
> Here is what you should see - just select "Do not cache temporary copies of
> this report"
> Always run this report with the most recent data
> Do not cache temporary copies of this report
> Cache a temporary copy of the report. Expire copy of report after
> a number of minutes: Missing expiration value
> The timeout value is not valid. It is either a
> negative integer or it is too large.
>
> Cache a temporary copy of the report. Expire copy of report on
> the following schedule:
> Report-specific schedule
> Shared schedule Select a shared schedule
>
>
> =-Chris
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
> >I have a report that is based on a straight forward query of
> >
> > select * from tblx
> >
> > No parameters ...
> >
> > tblx gets populated by processes from an application that get invoked from
> > a
> > command button. In the same process I then invoke the report using my
> > published url. The report comes up OK. But when I change the data in
> > tblx
> > and bring up the report, it is still displaying the old data. Do I need
> > to
> > add parameters to the query for it to refresh the data? Could someone
> > explain why the report does not refresh with the new data in tblx?
> >
> > Thanks,
> > Rich
>
>|||Report manager is the name of the portal. It is the website provided by RS
to display the reports.
http://YourServer/Reports/Pages/Folder.aspx
Click on a report, click on the properties tab, on the left you will see
execution (I assume it is there for 2000). You will definitely see other
items like General, Security, etc.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
> Thank you for your reply. I am using RS2003 with sql server 2000. I went
> to
> report properties but I don't see a report manager or anything about
> execution. I went to the project properties - where I set the URL but I
> did
> not see anything for executive there either. Is there somewhere on the
> toolbar I can go to for locating the Report Manager or something about
> execution?
> Thanks,
> Rich
> "Chris Conner" wrote:
>> This is easily fixed...
>> Turn off caching for the report. By default, it is cached for 30 minutes.
>> It
>> does this since you will more often view data that is static, i.e. in the
>> past, than current real time changes.
>> To change the cache setting for the report, go to the report itself and
>> view
>> its properties in the report manager. Look to your left and you will see
>> "execution settings". click that, next you should see the cache options
>> available. Set it to your liking. :)
>> Here is what you should see - just select "Do not cache temporary copies
>> of
>> this report"
>> Always run this report with the most recent data
>> Do not cache temporary copies of this report
>> Cache a temporary copy of the report. Expire copy of report
>> after
>> a number of minutes: Missing expiration value
>> The timeout value is not valid. It is either a
>> negative integer or it is too large.
>>
>> Cache a temporary copy of the report. Expire copy of report on
>> the following schedule:
>> Report-specific schedule
>> Shared schedule Select a shared schedule
>>
>>
>> =-Chris
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
>> >I have a report that is based on a straight forward query of
>> >
>> > select * from tblx
>> >
>> > No parameters ...
>> >
>> > tblx gets populated by processes from an application that get invoked
>> > from
>> > a
>> > command button. In the same process I then invoke the report using my
>> > published url. The report comes up OK. But when I change the data in
>> > tblx
>> > and bring up the report, it is still displaying the old data. Do I
>> > need
>> > to
>> > add parameters to the query for it to refresh the data? Could someone
>> > explain why the report does not refresh with the new data in tblx?
>> >
>> > Thanks,
>> > Rich
>>|||Thank you for this advice. Well, to reveal my ignorance,
I typed this in the address bar of my browser
http://myservername/Reports/Pages/Folder.aspx
which did not return anything. So then I tried
http://myservername/ReportServer/Reports/Pages/Folder.aspx
which also did not return anything (good). Then I tried
http://myservername/ReportServer/Reports/Pages/Invoices.aspx
Invoices is the folder where I deploy my report to. But nothing. My
intuitive skills are a little bit less than meager (at best). May I request
if you could show me an example of what specific address I need to type?
Thank again for your reply and for your help.
Rich
"Bruce L-C [MVP]" wrote:
> Report manager is the name of the portal. It is the website provided by RS
> to display the reports.
> http://YourServer/Reports/Pages/Folder.aspx
> Click on a report, click on the properties tab, on the left you will see
> execution (I assume it is there for 2000). You will definitely see other
> items like General, Security, etc.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
> > Thank you for your reply. I am using RS2003 with sql server 2000. I went
> > to
> > report properties but I don't see a report manager or anything about
> > execution. I went to the project properties - where I set the URL but I
> > did
> > not see anything for executive there either. Is there somewhere on the
> > toolbar I can go to for locating the Report Manager or something about
> > execution?
> >
> > Thanks,
> > Rich
> >
> > "Chris Conner" wrote:
> >
> >> This is easily fixed...
> >>
> >> Turn off caching for the report. By default, it is cached for 30 minutes.
> >> It
> >> does this since you will more often view data that is static, i.e. in the
> >> past, than current real time changes.
> >>
> >> To change the cache setting for the report, go to the report itself and
> >> view
> >> its properties in the report manager. Look to your left and you will see
> >> "execution settings". click that, next you should see the cache options
> >> available. Set it to your liking. :)
> >>
> >> Here is what you should see - just select "Do not cache temporary copies
> >> of
> >> this report"
> >>
> >> Always run this report with the most recent data
> >> Do not cache temporary copies of this report
> >> Cache a temporary copy of the report. Expire copy of report
> >> after
> >> a number of minutes: Missing expiration value
> >> The timeout value is not valid. It is either a
> >> negative integer or it is too large.
> >>
> >>
> >> Cache a temporary copy of the report. Expire copy of report on
> >> the following schedule:
> >>
> >> Report-specific schedule
> >> Shared schedule Select a shared schedule
> >>
> >>
> >>
> >>
> >> =-Chris
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
> >> >I have a report that is based on a straight forward query of
> >> >
> >> > select * from tblx
> >> >
> >> > No parameters ...
> >> >
> >> > tblx gets populated by processes from an application that get invoked
> >> > from
> >> > a
> >> > command button. In the same process I then invoke the report using my
> >> > published url. The report comes up OK. But when I change the data in
> >> > tblx
> >> > and bring up the report, it is still displaying the old data. Do I
> >> > need
> >> > to
> >> > add parameters to the query for it to refresh the data? Could someone
> >> > explain why the report does not refresh with the new data in tblx?
> >> >
> >> > Thanks,
> >> > Rich
> >>
> >>
> >>
>
>|||As far as I know every RS installation has report manager. For one thing,
that is how you set up security roles. Plus you use it for other things like
setting credentials for data sources etc.
When you say this did not return anything:
http://myservername/Reports/Pages/Folder.aspx
Did you get any message? Sometimes you need to put in fully qualified server
name http://myservername.whatever.com/Reports/Pages/Folder.aspx
If you have a working Reporting Server then someone in you organization has
to know about this.
Also, even if there, you would need to be in the proper role to be able to
make a change.
If it comes up and there are no folders then that is because you are not in
the correct role.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:D457FC39-F037-4293-9707-452A7B2D27BF@.microsoft.com...
> Thank you for this advice. Well, to reveal my ignorance,
> I typed this in the address bar of my browser
> http://myservername/Reports/Pages/Folder.aspx
> which did not return anything. So then I tried
> http://myservername/ReportServer/Reports/Pages/Folder.aspx
> which also did not return anything (good). Then I tried
> http://myservername/ReportServer/Reports/Pages/Invoices.aspx
> Invoices is the folder where I deploy my report to. But nothing. My
> intuitive skills are a little bit less than meager (at best). May I
> request
> if you could show me an example of what specific address I need to type?
> Thank again for your reply and for your help.
> Rich
>
> "Bruce L-C [MVP]" wrote:
>> Report manager is the name of the portal. It is the website provided by
>> RS
>> to display the reports.
>> http://YourServer/Reports/Pages/Folder.aspx
>> Click on a report, click on the properties tab, on the left you will see
>> execution (I assume it is there for 2000). You will definitely see other
>> items like General, Security, etc.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
>> > Thank you for your reply. I am using RS2003 with sql server 2000. I
>> > went
>> > to
>> > report properties but I don't see a report manager or anything about
>> > execution. I went to the project properties - where I set the URL but
>> > I
>> > did
>> > not see anything for executive there either. Is there somewhere on the
>> > toolbar I can go to for locating the Report Manager or something about
>> > execution?
>> >
>> > Thanks,
>> > Rich
>> >
>> > "Chris Conner" wrote:
>> >
>> >> This is easily fixed...
>> >>
>> >> Turn off caching for the report. By default, it is cached for 30
>> >> minutes.
>> >> It
>> >> does this since you will more often view data that is static, i.e. in
>> >> the
>> >> past, than current real time changes.
>> >>
>> >> To change the cache setting for the report, go to the report itself
>> >> and
>> >> view
>> >> its properties in the report manager. Look to your left and you will
>> >> see
>> >> "execution settings". click that, next you should see the cache
>> >> options
>> >> available. Set it to your liking. :)
>> >>
>> >> Here is what you should see - just select "Do not cache temporary
>> >> copies
>> >> of
>> >> this report"
>> >>
>> >> Always run this report with the most recent data
>> >> Do not cache temporary copies of this report
>> >> Cache a temporary copy of the report. Expire copy of report
>> >> after
>> >> a number of minutes: Missing expiration value
>> >> The timeout value is not valid. It is either a
>> >> negative integer or it is too large.
>> >>
>> >>
>> >> Cache a temporary copy of the report. Expire copy of report
>> >> on
>> >> the following schedule:
>> >>
>> >> Report-specific schedule
>> >> Shared schedule Select a shared schedule
>> >>
>> >>
>> >>
>> >>
>> >> =-Chris
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
>> >> >I have a report that is based on a straight forward query of
>> >> >
>> >> > select * from tblx
>> >> >
>> >> > No parameters ...
>> >> >
>> >> > tblx gets populated by processes from an application that get
>> >> > invoked
>> >> > from
>> >> > a
>> >> > command button. In the same process I then invoke the report using
>> >> > my
>> >> > published url. The report comes up OK. But when I change the data
>> >> > in
>> >> > tblx
>> >> > and bring up the report, it is still displaying the old data. Do I
>> >> > need
>> >> > to
>> >> > add parameters to the query for it to refresh the data? Could
>> >> > someone
>> >> > explain why the report does not refresh with the new data in tblx?
>> >> >
>> >> > Thanks,
>> >> > Rich
>> >>
>> >>
>> >>
>>|||Thank you again. So this time I made sure that I typed in
https://myservername/Reports/Pages/Folder.aspx
and now I did get something:
Error:
The request failed with HTTP status 401: Unauthorized.
I also tried https://...
Well, at least this time I got something besides page can't be found...
What do I need to configure for authorization?
Thanks again,
Rich
"Bruce L-C [MVP]" wrote:
> As far as I know every RS installation has report manager. For one thing,
> that is how you set up security roles. Plus you use it for other things like
> setting credentials for data sources etc.
> When you say this did not return anything:
> http://myservername/Reports/Pages/Folder.aspx
> Did you get any message? Sometimes you need to put in fully qualified server
> name http://myservername.whatever.com/Reports/Pages/Folder.aspx
> If you have a working Reporting Server then someone in you organization has
> to know about this.
> Also, even if there, you would need to be in the proper role to be able to
> make a change.
> If it comes up and there are no folders then that is because you are not in
> the correct role.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:D457FC39-F037-4293-9707-452A7B2D27BF@.microsoft.com...
> > Thank you for this advice. Well, to reveal my ignorance,
> >
> > I typed this in the address bar of my browser
> >
> > http://myservername/Reports/Pages/Folder.aspx
> >
> > which did not return anything. So then I tried
> >
> > http://myservername/ReportServer/Reports/Pages/Folder.aspx
> >
> > which also did not return anything (good). Then I tried
> >
> > http://myservername/ReportServer/Reports/Pages/Invoices.aspx
> >
> > Invoices is the folder where I deploy my report to. But nothing. My
> > intuitive skills are a little bit less than meager (at best). May I
> > request
> > if you could show me an example of what specific address I need to type?
> >
> > Thank again for your reply and for your help.
> >
> > Rich
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Report manager is the name of the portal. It is the website provided by
> >> RS
> >> to display the reports.
> >> http://YourServer/Reports/Pages/Folder.aspx
> >>
> >> Click on a report, click on the properties tab, on the left you will see
> >> execution (I assume it is there for 2000). You will definitely see other
> >> items like General, Security, etc.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
> >> > Thank you for your reply. I am using RS2003 with sql server 2000. I
> >> > went
> >> > to
> >> > report properties but I don't see a report manager or anything about
> >> > execution. I went to the project properties - where I set the URL but
> >> > I
> >> > did
> >> > not see anything for executive there either. Is there somewhere on the
> >> > toolbar I can go to for locating the Report Manager or something about
> >> > execution?
> >> >
> >> > Thanks,
> >> > Rich
> >> >
> >> > "Chris Conner" wrote:
> >> >
> >> >> This is easily fixed...
> >> >>
> >> >> Turn off caching for the report. By default, it is cached for 30
> >> >> minutes.
> >> >> It
> >> >> does this since you will more often view data that is static, i.e. in
> >> >> the
> >> >> past, than current real time changes.
> >> >>
> >> >> To change the cache setting for the report, go to the report itself
> >> >> and
> >> >> view
> >> >> its properties in the report manager. Look to your left and you will
> >> >> see
> >> >> "execution settings". click that, next you should see the cache
> >> >> options
> >> >> available. Set it to your liking. :)
> >> >>
> >> >> Here is what you should see - just select "Do not cache temporary
> >> >> copies
> >> >> of
> >> >> this report"
> >> >>
> >> >> Always run this report with the most recent data
> >> >> Do not cache temporary copies of this report
> >> >> Cache a temporary copy of the report. Expire copy of report
> >> >> after
> >> >> a number of minutes: Missing expiration value
> >> >> The timeout value is not valid. It is either a
> >> >> negative integer or it is too large.
> >> >>
> >> >>
> >> >> Cache a temporary copy of the report. Expire copy of report
> >> >> on
> >> >> the following schedule:
> >> >>
> >> >> Report-specific schedule
> >> >> Shared schedule Select a shared schedule
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> =-Chris
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
> >> >> >I have a report that is based on a straight forward query of
> >> >> >
> >> >> > select * from tblx
> >> >> >
> >> >> > No parameters ...
> >> >> >
> >> >> > tblx gets populated by processes from an application that get
> >> >> > invoked
> >> >> > from
> >> >> > a
> >> >> > command button. In the same process I then invoke the report using
> >> >> > my
> >> >> > published url. The report comes up OK. But when I change the data
> >> >> > in
> >> >> > tblx
> >> >> > and bring up the report, it is still displaying the old data. Do I
> >> >> > need
> >> >> > to
> >> >> > add parameters to the query for it to refresh the data? Could
> >> >> > someone
> >> >> > explain why the report does not refresh with the new data in tblx?
> >> >> >
> >> >> > Thanks,
> >> >> > Rich
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I'm confused, how do you even have anything working? This thread initially
started because of an issue with execution and caching.
Someone has to be an administrator on your Report Server site. Who is that?
They should be either doing this for you or setting you up with the correct
role. In Books Online look up the word roles filtered by SQL Server
Reporting Services.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:8330836A-A842-4B9E-9AD6-B3011DA6D006@.microsoft.com...
> Thank you again. So this time I made sure that I typed in
> https://myservername/Reports/Pages/Folder.aspx
> and now I did get something:
> Error:
> The request failed with HTTP status 401: Unauthorized.
> I also tried https://...
> Well, at least this time I got something besides page can't be found...
> What do I need to configure for authorization?
> Thanks again,
> Rich
> "Bruce L-C [MVP]" wrote:
>> As far as I know every RS installation has report manager. For one thing,
>> that is how you set up security roles. Plus you use it for other things
>> like
>> setting credentials for data sources etc.
>> When you say this did not return anything:
>> http://myservername/Reports/Pages/Folder.aspx
>> Did you get any message? Sometimes you need to put in fully qualified
>> server
>> name http://myservername.whatever.com/Reports/Pages/Folder.aspx
>> If you have a working Reporting Server then someone in you organization
>> has
>> to know about this.
>> Also, even if there, you would need to be in the proper role to be able
>> to
>> make a change.
>> If it comes up and there are no folders then that is because you are not
>> in
>> the correct role.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:D457FC39-F037-4293-9707-452A7B2D27BF@.microsoft.com...
>> > Thank you for this advice. Well, to reveal my ignorance,
>> >
>> > I typed this in the address bar of my browser
>> >
>> > http://myservername/Reports/Pages/Folder.aspx
>> >
>> > which did not return anything. So then I tried
>> >
>> > http://myservername/ReportServer/Reports/Pages/Folder.aspx
>> >
>> > which also did not return anything (good). Then I tried
>> >
>> > http://myservername/ReportServer/Reports/Pages/Invoices.aspx
>> >
>> > Invoices is the folder where I deploy my report to. But nothing. My
>> > intuitive skills are a little bit less than meager (at best). May I
>> > request
>> > if you could show me an example of what specific address I need to
>> > type?
>> >
>> > Thank again for your reply and for your help.
>> >
>> > Rich
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Report manager is the name of the portal. It is the website provided
>> >> by
>> >> RS
>> >> to display the reports.
>> >> http://YourServer/Reports/Pages/Folder.aspx
>> >>
>> >> Click on a report, click on the properties tab, on the left you will
>> >> see
>> >> execution (I assume it is there for 2000). You will definitely see
>> >> other
>> >> items like General, Security, etc.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
>> >> > Thank you for your reply. I am using RS2003 with sql server 2000.
>> >> > I
>> >> > went
>> >> > to
>> >> > report properties but I don't see a report manager or anything about
>> >> > execution. I went to the project properties - where I set the URL
>> >> > but
>> >> > I
>> >> > did
>> >> > not see anything for executive there either. Is there somewhere on
>> >> > the
>> >> > toolbar I can go to for locating the Report Manager or something
>> >> > about
>> >> > execution?
>> >> >
>> >> > Thanks,
>> >> > Rich
>> >> >
>> >> > "Chris Conner" wrote:
>> >> >
>> >> >> This is easily fixed...
>> >> >>
>> >> >> Turn off caching for the report. By default, it is cached for 30
>> >> >> minutes.
>> >> >> It
>> >> >> does this since you will more often view data that is static, i.e.
>> >> >> in
>> >> >> the
>> >> >> past, than current real time changes.
>> >> >>
>> >> >> To change the cache setting for the report, go to the report itself
>> >> >> and
>> >> >> view
>> >> >> its properties in the report manager. Look to your left and you
>> >> >> will
>> >> >> see
>> >> >> "execution settings". click that, next you should see the cache
>> >> >> options
>> >> >> available. Set it to your liking. :)
>> >> >>
>> >> >> Here is what you should see - just select "Do not cache temporary
>> >> >> copies
>> >> >> of
>> >> >> this report"
>> >> >>
>> >> >> Always run this report with the most recent data
>> >> >> Do not cache temporary copies of this report
>> >> >> Cache a temporary copy of the report. Expire copy of
>> >> >> report
>> >> >> after
>> >> >> a number of minutes: Missing expiration value
>> >> >> The timeout value is not valid. It is either
>> >> >> a
>> >> >> negative integer or it is too large.
>> >> >>
>> >> >>
>> >> >> Cache a temporary copy of the report. Expire copy of
>> >> >> report
>> >> >> on
>> >> >> the following schedule:
>> >> >>
>> >> >> Report-specific schedule
>> >> >> Shared schedule Select a shared schedule
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> =-Chris
>> >> >>
>> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
>> >> >> >I have a report that is based on a straight forward query of
>> >> >> >
>> >> >> > select * from tblx
>> >> >> >
>> >> >> > No parameters ...
>> >> >> >
>> >> >> > tblx gets populated by processes from an application that get
>> >> >> > invoked
>> >> >> > from
>> >> >> > a
>> >> >> > command button. In the same process I then invoke the report
>> >> >> > using
>> >> >> > my
>> >> >> > published url. The report comes up OK. But when I change the
>> >> >> > data
>> >> >> > in
>> >> >> > tblx
>> >> >> > and bring up the report, it is still displaying the old data.
>> >> >> > Do I
>> >> >> > need
>> >> >> > to
>> >> >> > add parameters to the query for it to refresh the data? Could
>> >> >> > someone
>> >> >> > explain why the report does not refresh with the new data in
>> >> >> > tblx?
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Rich
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks. I am currently working for a small subscription firm. I am still
relatively new to Reporting Services. The owner's son manages the network
(real young guy), and I did not set up RS. It was already in place. The
only RS I ever set up was the free one from msdn, and I don't recall having
to set up roles. Anwya, I found an introductory article on google about
roles/security for RS. At least I got some direction from this post on which
way to go.
Rich
"Bruce L-C [MVP]" wrote:
> I'm confused, how do you even have anything working? This thread initially
> started because of an issue with execution and caching.
> Someone has to be an administrator on your Report Server site. Who is that?
> They should be either doing this for you or setting you up with the correct
> role. In Books Online look up the word roles filtered by SQL Server
> Reporting Services.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:8330836A-A842-4B9E-9AD6-B3011DA6D006@.microsoft.com...
> > Thank you again. So this time I made sure that I typed in
> >
> > https://myservername/Reports/Pages/Folder.aspx
> >
> > and now I did get something:
> >
> > Error:
> >
> > The request failed with HTTP status 401: Unauthorized.
> >
> > I also tried https://...
> >
> > Well, at least this time I got something besides page can't be found...
> > What do I need to configure for authorization?
> >
> > Thanks again,
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> As far as I know every RS installation has report manager. For one thing,
> >> that is how you set up security roles. Plus you use it for other things
> >> like
> >> setting credentials for data sources etc.
> >> When you say this did not return anything:
> >> http://myservername/Reports/Pages/Folder.aspx
> >> Did you get any message? Sometimes you need to put in fully qualified
> >> server
> >> name http://myservername.whatever.com/Reports/Pages/Folder.aspx
> >>
> >> If you have a working Reporting Server then someone in you organization
> >> has
> >> to know about this.
> >>
> >> Also, even if there, you would need to be in the proper role to be able
> >> to
> >> make a change.
> >>
> >> If it comes up and there are no folders then that is because you are not
> >> in
> >> the correct role.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:D457FC39-F037-4293-9707-452A7B2D27BF@.microsoft.com...
> >> > Thank you for this advice. Well, to reveal my ignorance,
> >> >
> >> > I typed this in the address bar of my browser
> >> >
> >> > http://myservername/Reports/Pages/Folder.aspx
> >> >
> >> > which did not return anything. So then I tried
> >> >
> >> > http://myservername/ReportServer/Reports/Pages/Folder.aspx
> >> >
> >> > which also did not return anything (good). Then I tried
> >> >
> >> > http://myservername/ReportServer/Reports/Pages/Invoices.aspx
> >> >
> >> > Invoices is the folder where I deploy my report to. But nothing. My
> >> > intuitive skills are a little bit less than meager (at best). May I
> >> > request
> >> > if you could show me an example of what specific address I need to
> >> > type?
> >> >
> >> > Thank again for your reply and for your help.
> >> >
> >> > Rich
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Report manager is the name of the portal. It is the website provided
> >> >> by
> >> >> RS
> >> >> to display the reports.
> >> >> http://YourServer/Reports/Pages/Folder.aspx
> >> >>
> >> >> Click on a report, click on the properties tab, on the left you will
> >> >> see
> >> >> execution (I assume it is there for 2000). You will definitely see
> >> >> other
> >> >> items like General, Security, etc.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
> >> >> > Thank you for your reply. I am using RS2003 with sql server 2000.
> >> >> > I
> >> >> > went
> >> >> > to
> >> >> > report properties but I don't see a report manager or anything about
> >> >> > execution. I went to the project properties - where I set the URL
> >> >> > but
> >> >> > I
> >> >> > did
> >> >> > not see anything for executive there either. Is there somewhere on
> >> >> > the
> >> >> > toolbar I can go to for locating the Report Manager or something
> >> >> > about
> >> >> > execution?
> >> >> >
> >> >> > Thanks,
> >> >> > Rich
> >> >> >
> >> >> > "Chris Conner" wrote:
> >> >> >
> >> >> >> This is easily fixed...
> >> >> >>
> >> >> >> Turn off caching for the report. By default, it is cached for 30
> >> >> >> minutes.
> >> >> >> It
> >> >> >> does this since you will more often view data that is static, i.e.
> >> >> >> in
> >> >> >> the
> >> >> >> past, than current real time changes.
> >> >> >>
> >> >> >> To change the cache setting for the report, go to the report itself
> >> >> >> and
> >> >> >> view
> >> >> >> its properties in the report manager. Look to your left and you
> >> >> >> will
> >> >> >> see
> >> >> >> "execution settings". click that, next you should see the cache
> >> >> >> options
> >> >> >> available. Set it to your liking. :)
> >> >> >>
> >> >> >> Here is what you should see - just select "Do not cache temporary
> >> >> >> copies
> >> >> >> of
> >> >> >> this report"
> >> >> >>
> >> >> >> Always run this report with the most recent data
> >> >> >> Do not cache temporary copies of this report
> >> >> >> Cache a temporary copy of the report. Expire copy of
> >> >> >> report
> >> >> >> after
> >> >> >> a number of minutes: Missing expiration value
> >> >> >> The timeout value is not valid. It is either
> >> >> >> a
> >> >> >> negative integer or it is too large.
> >> >> >>
> >> >> >>
> >> >> >> Cache a temporary copy of the report. Expire copy of
> >> >> >> report
> >> >> >> on
> >> >> >> the following schedule:
> >> >> >>
> >> >> >> Report-specific schedule
> >> >> >> Shared schedule Select a shared schedule
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> =-Chris
> >> >> >>
> >> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> >> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
> >> >> >> >I have a report that is based on a straight forward query of
> >> >> >> >
> >> >> >> > select * from tblx
> >> >> >> >
> >> >> >> > No parameters ...
> >> >> >> >
> >> >> >> > tblx gets populated by processes from an application that get
> >> >> >> > invoked
> >> >> >> > from
> >> >> >> > a
> >> >> >> > command button. In the same process I then invoke the report
> >> >> >> > using
> >> >> >> > my
> >> >> >> > published url. The report comes up OK. But when I change the
> >> >> >> > data
> >> >> >> > in
> >> >> >> > tblx
> >> >> >> > and bring up the report, it is still displaying the old data.
> >> >> >> > Do I
> >> >> >> > need
> >> >> >> > to
> >> >> >> > add parameters to the query for it to refresh the data? Could
> >> >> >> > someone
> >> >> >> > explain why the report does not refresh with the new data in
> >> >> >> > tblx?
> >> >> >> >
> >> >> >> > Thanks,
> >> >> >> > Rich
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||The reason you didn't have to set up roles before was because if you
installed everything on your machine and you were a local admin for the
machine, then you automatically are in the administrator role for RS.
One easy way, if they add your userid to the local adminstrators account on
the server then you will be good to go.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:A8B42DAE-07A1-4500-873E-8535FB787DDF@.microsoft.com...
> Thanks. I am currently working for a small subscription firm. I am still
> relatively new to Reporting Services. The owner's son manages the network
> (real young guy), and I did not set up RS. It was already in place. The
> only RS I ever set up was the free one from msdn, and I don't recall
> having
> to set up roles. Anwya, I found an introductory article on google about
> roles/security for RS. At least I got some direction from this post on
> which
> way to go.
> Rich
> "Bruce L-C [MVP]" wrote:
>> I'm confused, how do you even have anything working? This thread
>> initially
>> started because of an issue with execution and caching.
>> Someone has to be an administrator on your Report Server site. Who is
>> that?
>> They should be either doing this for you or setting you up with the
>> correct
>> role. In Books Online look up the word roles filtered by SQL Server
>> Reporting Services.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:8330836A-A842-4B9E-9AD6-B3011DA6D006@.microsoft.com...
>> > Thank you again. So this time I made sure that I typed in
>> >
>> > https://myservername/Reports/Pages/Folder.aspx
>> >
>> > and now I did get something:
>> >
>> > Error:
>> >
>> > The request failed with HTTP status 401: Unauthorized.
>> >
>> > I also tried https://...
>> >
>> > Well, at least this time I got something besides page can't be found...
>> > What do I need to configure for authorization?
>> >
>> > Thanks again,
>> > Rich
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> As far as I know every RS installation has report manager. For one
>> >> thing,
>> >> that is how you set up security roles. Plus you use it for other
>> >> things
>> >> like
>> >> setting credentials for data sources etc.
>> >> When you say this did not return anything:
>> >> http://myservername/Reports/Pages/Folder.aspx
>> >> Did you get any message? Sometimes you need to put in fully qualified
>> >> server
>> >> name http://myservername.whatever.com/Reports/Pages/Folder.aspx
>> >>
>> >> If you have a working Reporting Server then someone in you
>> >> organization
>> >> has
>> >> to know about this.
>> >>
>> >> Also, even if there, you would need to be in the proper role to be
>> >> able
>> >> to
>> >> make a change.
>> >>
>> >> If it comes up and there are no folders then that is because you are
>> >> not
>> >> in
>> >> the correct role.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:D457FC39-F037-4293-9707-452A7B2D27BF@.microsoft.com...
>> >> > Thank you for this advice. Well, to reveal my ignorance,
>> >> >
>> >> > I typed this in the address bar of my browser
>> >> >
>> >> > http://myservername/Reports/Pages/Folder.aspx
>> >> >
>> >> > which did not return anything. So then I tried
>> >> >
>> >> > http://myservername/ReportServer/Reports/Pages/Folder.aspx
>> >> >
>> >> > which also did not return anything (good). Then I tried
>> >> >
>> >> > http://myservername/ReportServer/Reports/Pages/Invoices.aspx
>> >> >
>> >> > Invoices is the folder where I deploy my report to. But nothing.
>> >> > My
>> >> > intuitive skills are a little bit less than meager (at best). May I
>> >> > request
>> >> > if you could show me an example of what specific address I need to
>> >> > type?
>> >> >
>> >> > Thank again for your reply and for your help.
>> >> >
>> >> > Rich
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Report manager is the name of the portal. It is the website
>> >> >> provided
>> >> >> by
>> >> >> RS
>> >> >> to display the reports.
>> >> >> http://YourServer/Reports/Pages/Folder.aspx
>> >> >>
>> >> >> Click on a report, click on the properties tab, on the left you
>> >> >> will
>> >> >> see
>> >> >> execution (I assume it is there for 2000). You will definitely see
>> >> >> other
>> >> >> items like General, Security, etc.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
>> >> >> > Thank you for your reply. I am using RS2003 with sql server
>> >> >> > 2000.
>> >> >> > I
>> >> >> > went
>> >> >> > to
>> >> >> > report properties but I don't see a report manager or anything
>> >> >> > about
>> >> >> > execution. I went to the project properties - where I set the
>> >> >> > URL
>> >> >> > but
>> >> >> > I
>> >> >> > did
>> >> >> > not see anything for executive there either. Is there somewhere
>> >> >> > on
>> >> >> > the
>> >> >> > toolbar I can go to for locating the Report Manager or something
>> >> >> > about
>> >> >> > execution?
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Rich
>> >> >> >
>> >> >> > "Chris Conner" wrote:
>> >> >> >
>> >> >> >> This is easily fixed...
>> >> >> >>
>> >> >> >> Turn off caching for the report. By default, it is cached for 30
>> >> >> >> minutes.
>> >> >> >> It
>> >> >> >> does this since you will more often view data that is static,
>> >> >> >> i.e.
>> >> >> >> in
>> >> >> >> the
>> >> >> >> past, than current real time changes.
>> >> >> >>
>> >> >> >> To change the cache setting for the report, go to the report
>> >> >> >> itself
>> >> >> >> and
>> >> >> >> view
>> >> >> >> its properties in the report manager. Look to your left and you
>> >> >> >> will
>> >> >> >> see
>> >> >> >> "execution settings". click that, next you should see the cache
>> >> >> >> options
>> >> >> >> available. Set it to your liking. :)
>> >> >> >>
>> >> >> >> Here is what you should see - just select "Do not cache
>> >> >> >> temporary
>> >> >> >> copies
>> >> >> >> of
>> >> >> >> this report"
>> >> >> >>
>> >> >> >> Always run this report with the most recent data
>> >> >> >> Do not cache temporary copies of this report
>> >> >> >> Cache a temporary copy of the report. Expire copy of
>> >> >> >> report
>> >> >> >> after
>> >> >> >> a number of minutes: Missing expiration value
>> >> >> >> The timeout value is not valid. It is
>> >> >> >> either
>> >> >> >> a
>> >> >> >> negative integer or it is too large.
>> >> >> >>
>> >> >> >>
>> >> >> >> Cache a temporary copy of the report. Expire copy of
>> >> >> >> report
>> >> >> >> on
>> >> >> >> the following schedule:
>> >> >> >>
>> >> >> >> Report-specific schedule
>> >> >> >> Shared schedule Select a shared schedule
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> =-Chris
>> >> >> >>
>> >> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> >> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
>> >> >> >> >I have a report that is based on a straight forward query of
>> >> >> >> >
>> >> >> >> > select * from tblx
>> >> >> >> >
>> >> >> >> > No parameters ...
>> >> >> >> >
>> >> >> >> > tblx gets populated by processes from an application that get
>> >> >> >> > invoked
>> >> >> >> > from
>> >> >> >> > a
>> >> >> >> > command button. In the same process I then invoke the report
>> >> >> >> > using
>> >> >> >> > my
>> >> >> >> > published url. The report comes up OK. But when I change the
>> >> >> >> > data
>> >> >> >> > in
>> >> >> >> > tblx
>> >> >> >> > and bring up the report, it is still displaying the old data.
>> >> >> >> > Do I
>> >> >> >> > need
>> >> >> >> > to
>> >> >> >> > add parameters to the query for it to refresh the data? Could
>> >> >> >> > someone
>> >> >> >> > explain why the report does not refresh with the new data in
>> >> >> >> > tblx?
>> >> >> >> >
>> >> >> >> > Thanks,
>> >> >> >> > Rich
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

Report Wizard

I am trying to use a stored proc in the report wizard with parameters
Exec usp_AgentSessionSummary @.StartDate, @.EndDate, @.ProjectID, @.AgentID
I get the error below. I want to use the wizard for ease, how do I get
around the error?
There is an error in the query. Implicit conversion from data type
sql_variant to datetime is not allowed. Use the CONVERT function to run this
query.You could try first hard coding the parameters, use the wizard and then
switch it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JW" <JW@.discussions.microsoft.com> wrote in message
news:E1ADCFEF-E23F-41F7-8327-BB5B10C11008@.microsoft.com...
>I am trying to use a stored proc in the report wizard with parameters
> Exec usp_AgentSessionSummary @.StartDate, @.EndDate, @.ProjectID, @.AgentID
> I get the error below. I want to use the wizard for ease, how do I get
> around the error?
> There is an error in the query. Implicit conversion from data type
> sql_variant to datetime is not allowed. Use the CONVERT function to run
> this
> query.

Report with default of all

Have a report with three datasets. The first dataset pulls the
department table and uses this as one of the parameters.
select DEPT from dept
The second dataset pulls the division table and uses that as one of the
parameters.
select DIV from div
The third dataset calls a stored procedure that passes the startdate,
enddate, division and department for the report. With the startdate and
enddate also being parameters.
exec wo_sstm @.startdate, @.enddate, @.division, @.department
How can I set the parameters for @.division and @.department to utilize a
default of all for each.for your first dataset for dept:
select 0 as DeptID, '<All>' as DEPT FROM dept
UNION ALL
select DeptID, DEPT from dept
Then your value will be DeptID and label will be DEPT in Parameters
In your second dataset, same thing:
select 0 AS DivisionID, '<All>' as DIV from div
UNION ALL
select DivisionID, DIV from div
Then in your stored procedure wo_sstm you will process 0 as the indicator
for all.
=-Chris
"chad" <chad.heilig@.gmail.com> wrote in message
news:1163534032.594157.292550@.m73g2000cwd.googlegroups.com...
> Have a report with three datasets. The first dataset pulls the
> department table and uses this as one of the parameters.
> select DEPT from dept
> The second dataset pulls the division table and uses that as one of the
> parameters.
> select DIV from div
> The third dataset calls a stored procedure that passes the startdate,
> enddate, division and department for the report. With the startdate and
> enddate also being parameters.
> exec wo_sstm @.startdate, @.enddate, @.division, @.department
> How can I set the parameters for @.division and @.department to utilize a
> default of all for each.
>|||Chris,
Getting invalid column name 'DeptID'. How does this work with no DeptID
column?
Chris Conner wrote:
> for your first dataset for dept:
> select 0 as DeptID, '<All>' as DEPT FROM dept
> UNION ALL
> select DeptID, DEPT from dept
> Then your value will be DeptID and label will be DEPT in Parameters
> In your second dataset, same thing:
> select 0 AS DivisionID, '<All>' as DIV from div
> UNION ALL
> select DivisionID, DIV from div
>
> Then in your stored procedure wo_sstm you will process 0 as the indicator
> for all.
> =-Chris
> "chad" <chad.heilig@.gmail.com> wrote in message
> news:1163534032.594157.292550@.m73g2000cwd.googlegroups.com...
> > Have a report with three datasets. The first dataset pulls the
> > department table and uses this as one of the parameters.
> > select DEPT from dept
> >
> > The second dataset pulls the division table and uses that as one of the
> > parameters.
> > select DIV from div
> >
> > The third dataset calls a stored procedure that passes the startdate,
> > enddate, division and department for the report. With the startdate and
> > enddate also being parameters.
> > exec wo_sstm @.startdate, @.enddate, @.division, @.department
> >
> > How can I set the parameters for @.division and @.department to utilize a
> > default of all for each.
> >|||No - DeptID is something I made up - Do you have a column that uniquely
identifies your departments? I assumed you would understand that DeptID in
this case was an ID that uniquely identifies that department.
=-Chris
"chad" <chad.heilig@.gmail.com> wrote in message
news:1163601753.813127.152770@.h54g2000cwb.googlegroups.com...
> Chris,
> Getting invalid column name 'DeptID'. How does this work with no DeptID
> column?
>
> Chris Conner wrote:
>> for your first dataset for dept:
>> select 0 as DeptID, '<All>' as DEPT FROM dept
>> UNION ALL
>> select DeptID, DEPT from dept
>> Then your value will be DeptID and label will be DEPT in Parameters
>> In your second dataset, same thing:
>> select 0 AS DivisionID, '<All>' as DIV from div
>> UNION ALL
>> select DivisionID, DIV from div
>>
>> Then in your stored procedure wo_sstm you will process 0 as the indicator
>> for all.
>> =-Chris
>> "chad" <chad.heilig@.gmail.com> wrote in message
>> news:1163534032.594157.292550@.m73g2000cwd.googlegroups.com...
>> > Have a report with three datasets. The first dataset pulls the
>> > department table and uses this as one of the parameters.
>> > select DEPT from dept
>> >
>> > The second dataset pulls the division table and uses that as one of the
>> > parameters.
>> > select DIV from div
>> >
>> > The third dataset calls a stored procedure that passes the startdate,
>> > enddate, division and department for the report. With the startdate and
>> > enddate also being parameters.
>> > exec wo_sstm @.startdate, @.enddate, @.division, @.department
>> >
>> > How can I set the parameters for @.division and @.department to utilize a
>> > default of all for each.
>> >
>

Report with 3 parameters used together or individually

I am having trouble with a report and would like some help. I have a report with 3 parameters: Region, Branch, and Officer. I would like the report to have the ability to be run using one OR two OR all of the parameters. For example selecting just a branch or just an officer or an officer and a branch, etc. I am using a stored procedure that has these 3 parameters. I have assigned them default values in case the user does not select them. Everything seems it should work but when I hit View Report nothing happens. The stored procedure isn't even run, no error either. It is almost like all 3 parameters have to be selected for the report to run. Any suggestions would be helpful?Have you checked to make sure your report parameters allow null values? If they don't allow the nulls, the report won't run (and you won't get any message).|||

Well with all due respect - I never Use NULL parameters!

Are you using Reporting Services 2000 or the NEW Reporting Services within SQL 2005 CTP?

There are different answers for both!

|||I am using Reporting Services 2000. I eventually figured it out by using NULL parameters for all of my parameters but also taking care of the value in my stored procedure with IF statements depending on which value was NULL and such. A pain but it does work.|||

Forget the answer to allowing NULL values!

NULLS are neither"here" or "there" and I just cannot belive that <NULLS> are acceptable inany database or any life environment!

<NULLS> are not the answer to your problem!

Please be a little more specific and I will certainly do the best I can do to help!

|||

Sorry to be reprtitive !!!

If you allow parameters within your selections of parameters (In RS Parameter Selection) why is there ever an option for <NULLS> versus <ALL> or the <Selected Values that exist> ?

Ok - if by chance there are some <nulls> within the fields within your table -- which beyond the life of me there would be any there ......

I really think that you need to ensure the UI (User Interface) that presents (data) to the data layer there are edits to prevent this from happening - or -

I just = cannot understand = why you would allow a parameter selection from RS allow a NULL to be accepted into a text SQL script or a stored procedure ---

I am mising nothing in this post - <nulls> are void within the programming and everyday life world!

Report Viewer/Default Parameters

Is it possible for one report to have different default parameters, based on the user viewing the report, when the report is accessed via the Report Viewer?

Thanks.

accessed
acceded
accused
accedes
accursed
Edit...
Ignore all
Add to dictionary(No suggestions)
Edit...
Ignore all
Add to dictionary

accessed
acceded
accused
accedes
accursed
Edit...
Revert to "accesed"

Assuming you are asking for viewing report through report server: default values can be (1) constant, (2) expression-based, or (3) dataset based.

Regarding (2): you could determine the default value based on the current userid, e.g =iif(User!UserId="abc", "Default1", "Default2")

Regarding (3): you could use the current user information in the query commandtext or as parameter into a stored procedure to dynamically determine the default value.

-- Robert

|||

If you are using the ReportViewer control in ASP.NET, you can set the value of the parameter programatically based on the current user identity:

this.ReportViewer1.ServerReport.ReportPath = "/SampleReports/Employee Sales Summary";

ReportParameter p = new ReportParameter("EmpID", "20");

this.ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { p });

Report Viewer web part (sp2)

Does anyone know how to pass parameters through to the Sharepoint
Report Viewer web part?
Thanks,
Paul.Go to the site:
http://blogs.sqlxml.org/bryantlikes/articles/628.aspx
It's give some advices. I hope that will help you

Report Viewer trying to get it running and having problems

I have a website with two textboxes. I am passing those text boxes as parameters into the Report Viewer. I receive this error: "An error has occurred during report processing. ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'GetData' that has no parameters."

I thought I had the xsd and rdlc set up properly but obviously I am missing something. If you can step me through this I would appreciate it.

Look in the control ObjectDataSource this control have the Property Select Method and Select Parmaters .

The Select Method must be with the parameters EJ: GetData(idcity)

In Select Parameters you have to add the parameter -- one for each textbox

You can send me the code for more help :victormartineze@.gmail.com

Sorry i dont speack english

report viewer not behaving as expected

Greetings,
i'm using ms ReportViewer which was provided. heres the deal, in my report
parameters if i leave "prompt" empty and unchecked "allow null value" and
click in preview, i do not see the parameters being shown at the header.
WHICH IS WHAT I WANT. GOOD. but then, if i were to use the report viewer in
the web enviroment, and having set Parameters=true OR false makes not
difference... with true it still shows the parameter as textbox and if i set
it to false, my other parameter will not be visiable. so i NEED to set it to
TRUE.
can someone please advice me?
thanks.
Asha.You need to go to the properties tab of the report in ReportManager. Click
the parameters sub tab. For the parameter you want hidden, make sure
'Prompt User' is checked and that there is no prompt string.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Asha" <Asha@.discussions.microsoft.com> wrote in message
news:A957E9D1-DE64-4158-A4B2-1651AF467E87@.microsoft.com...
> Greetings,
> i'm using ms ReportViewer which was provided. heres the deal, in my report
> parameters if i leave "prompt" empty and unchecked "allow null value" and
> click in preview, i do not see the parameters being shown at the header.
> WHICH IS WHAT I WANT. GOOD. but then, if i were to use the report viewer
in
> the web enviroment, and having set Parameters=true OR false makes not
> difference... with true it still shows the parameter as textbox and if i
set
> it to false, my other parameter will not be visiable. so i NEED to set it
to
> TRUE.
> can someone please advice me?
> thanks.
> Asha.sql

Report Viewer control ignores parameters

I have a Report Viewer control on an asp.net page. The report shows the
parameters. When I choose a value from the drop down and then click on "View
report", the screen gets refreshed and the parameters are reset. It's like
no parameters have been selected from the drop down and no data is shown. If
I run the same report from report manager, or from VS, everything works. Has
anybody had this issue?
Thanks,
GilgameshOn Aug 28, 4:27 pm, "Gilgamesh" <gilgamesh4e...@.aol.com> wrote:
> I have a Report Viewer control on an asp.net page. The report shows the
> parameters. When I choose a value from the drop down and then click on "View
> report", the screen gets refreshed and the parameters are reset. It's like
> no parameters have been selected from the drop down and no data is shown. If
> I run the same report from report manager, or from VS, everything works. Has
> anybody had this issue?
> Thanks,
> Gilgamesh
You might want to check your parameter mappings to the main
datasource. It sounds like there's a breakdown there somewhere. Also,
make sure that you are not receiving an error in the database
connection string, etc. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Report viewer control & FireFox

Hi,
We have a problem with multi-value and datetime parameters in the Report
Viewer control when using FireFox browser. The problem is that when user
expands combobox or calendar control in parameters section of the report, it
immediately collapses back.
I realize that this problem may have something to do with IFrames but have
no idea how to fix this behavior. I can sure write my own parameters control
but it would be nice if the Report Viewer worked right out of the box.
We use SQL Server 2005 SP1 RS.
Thanks in advance for every info that can help.
Regards,
AlexHi again, I just found a workaround - simply remove this line:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
and calendars work.
Regards
Krzysztof Ogniewski
"Krzysztof Ogniewski" wrote:
> Hi all,
> has anybody found a solution for this issue?
> Thanks
> Krzysztof Ogniewski
> "Alex Korygin" wrote:
> > Hi,
> >
> > We have a problem with multi-value and datetime parameters in the Report
> > Viewer control when using FireFox browser. The problem is that when user
> > expands combobox or calendar control in parameters section of the report, it
> > immediately collapses back.
> >
> > I realize that this problem may have something to do with IFrames but have
> > no idea how to fix this behavior. I can sure write my own parameters control
> > but it would be nice if the Report Viewer worked right out of the box.
> >
> > We use SQL Server 2005 SP1 RS.
> >
> > Thanks in advance for every info that can help.
> >
> > Regards,
> >
> > Alex
> >|||Hi all,
has anybody found a solution for this issue?
Thanks
Krzysztof Ogniewski
"Alex Korygin" wrote:
> Hi,
> We have a problem with multi-value and datetime parameters in the Report
> Viewer control when using FireFox browser. The problem is that when user
> expands combobox or calendar control in parameters section of the report, it
> immediately collapses back.
> I realize that this problem may have something to do with IFrames but have
> no idea how to fix this behavior. I can sure write my own parameters control
> but it would be nice if the Report Viewer worked right out of the box.
> We use SQL Server 2005 SP1 RS.
> Thanks in advance for every info that can help.
> Regards,
> Alex
>

Report Viewer - tell it not to run until parameters are entered

I have this reportviewer control in an asp.net page -
I've added a parameter of startdate
How do I change the properties of the ReportViewer control so that it waits
for the date input, and doesn't try to run when the page is loaded?
I keep getting this error when running the page:
a.. The property 'DefaultValue' of report parameter 'StartDate' doesn't
have the expected type.On Jan 18, 12:05 pm, "Elmo Watson" <s...@.here.com> wrote:
> I have this reportviewer control in an asp.net page -
> I've added a parameter of startdate
> How do I change the properties of the ReportViewer control so that it waits
> for the date input, and doesn't try to run when the page is loaded?
> I keep getting this error when running the page:
> a.. The property 'DefaultValue' of report parameter 'StartDate' doesn't
> have the expected type.
The easiest way to control the automatic running of the report is to
modify the SSRS report itself to not have a default value (set Default
Values to Null) for the startdate parameter. This should follow
through to the report viewer control. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

report via url with parameters: strange issue....

Hi all,

I'm testing my report via a url, with report parameters.
But i have a strange issue:

If I open a new browser, and I do:
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False" (thus without parameters)
Then it takes the default values that are configured in the report.
This returns 3 records, which is OK

If I open a new browser, and I do:
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False&STAmonth=6"
This returns 5 records, which is OK

If I open a new browser, and I do:
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False&STAmonth=5"
This returns 0 records, which is OK

BUT HERE COMES THE STRANGE THING:
If i try to go to two url's after eachother in the same browser, it gives bad result....
thus:
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False&STAmonth=5"
this returns 0 records, this is OK
but if I do hereafter (in the same browser)
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False" (thus without parameters)
it still returns 0 records, while it should return 3 records.

Anyone experienced this also?
What can I do or what am I doing wrong?

Thanks

Hi sttke,

This looks to be a by-product of keeping the session open and caching information. You can add rs:ClearSession=true to the url and it should clear the parameters.

|||that does the job !!!
thanks a lot, Brad !!!

Report Title above parameters (Urgent)

Hi All,

I have created a report in SQL Server Business Intelligence Development Studio 2005. I need to add a report title above the parameters area. Is that possible?. please help me

The output should be like

_

Report Title

_

Report Parameters Section View Report button

Report Body part.

Hi.

Under the current implementation of Reporting Services, any parameters for a report are generated as part of the report viewer controls (i.e. above the page number and export format controls). I do not know of any way of inserting your own title above those.

I can think of a couple of workarounds/solutions.

Firstly you could add another parameter to the report, call it something like Title and make it a string and ensure it is top of the parameter list. Then just give this a single non query value where the label is your report title (e.g. My Report) and set the value to 0; then set the default value to be non query as =0. When the report is generated you will then have a parameter above all the others, with a description of Title and a single (non changeable) value which is your report title.

Not perfect but it might suit your purpose.

The second way would be to create your own web page (e.g. in ASP.NET) which has whatever titles you want at the top then embed the report underneath, so you get your parameters after the title.

Hope this helps,

Gary.

Report that has parameters doesnt show up with report viewer.

My webhost had several tutorials on how to use report viewer. The first being
<%@.PageLanguage="vb"aspcompat="true"AutoEventWireup="false"debug="true" %>
<%@.RegisterTagPrefix="cc1"Namespace="Microsoft.Samples.ReportingServices"Assembly="ReportViewer" %>

<formid="Form1"method="post"runat="server">
<cc1:ReportViewerid="ReportViewer1"style="Z-INDEX: 101; LEFT: 56px; POSITION: absolute; TOP: 32px"
runat="server"Width="1050px"Height="1050px"ServerUrl=http://site.com/reportserver ReportPath="/myreport/report1"></cc1:ReportViewer>

</form
but with this I could never get pass the IIS authentication pop up. It was annoying so my host had recently put up a new page that uses a different namespace and tag.

<%@.RegisterAssembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"Namespace="Microsoft.Reporting.WebForms"TagPrefix="rsweb" %><%@.RegisterAssembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"Namespace="Microsoft.Reporting.WebForms"TagPrefix="rsweb" %>
<formid="form1"runat="server"><div>

<rsweb:ReportViewerID="ReportViewer1"runat="server"Style="positionstatic"ProcessingMode="Remote"Width="100%"AsyncRendering="False"><ServerReportDisplayName="report viewer demo"ReportPath="/myreport/report1"ReportServerUrl="http://site.com/reportserver"/></rsweb:ReportViewer>

</div></form>

I figured they'd work the same but they don't. My .rdl has a parameter field set up so I don't want to pass it through the url. I want the user to access the .rdl and then that'll prompt them for the missing parameter and then click report. However, with the new setup, it just refreshes the page and does nothing. Are these two types functionally different? As long as I can get the 2nd script to stop refreshing the page and displaying nothing that would be fine.

Any ideas?

Anyone?

|||

if u report server has any credentials, u need to pass it in the code behind..

|||

Everything is passed on the report server itself so that I don't need any credentials. Whenever I use the second script it works and the interface shows up but when I select an item from the drop down menu and click report. It brings back nothing. It just refreshes the page.

|||

Why do u have this listed twice

<%@.RegisterAssembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"Namespace="Microsoft.Reporting.WebForms"TagPrefix="rsweb" %><%@.RegisterAssembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"Namespace="Microsoft.Reporting.WebForms"TagPrefix="rsweb" %>

and can u pls post ur code behind for this page..

Regards

Karen

|||

Yea... about that.. sorry. My host put that twice, i just realized it was a duplicate.

my report.asx.vb

Imports System.NetImports System.Security.PrincipalImports Microsoft.Reporting.WebFormsPartialClass _DefaultInherits System.Web.UI.PageProtected Sub ReportViewer1_Init(ByVal senderAs Object,ByVal eAs System.EventArgs)Handles ReportViewer1.InitEnd Sub <Serializable()> _Public NotInheritable Class MyReportServerCredentialsImplements IReportServerCredentialsPublic ReadOnly Property ImpersonationUser()As WindowsIdentity _Implements IReportServerCredentials.ImpersonationUserGet Return Nothing End Get End Property Public ReadOnly Property NetworkCredentials()As ICredentials _Implements IReportServerCredentials.NetworkCredentialsGet' Put your login and password hereDim userNameAs String ="admin"Dim passwordAs String ="pass"Dim domainAs String ="report3"Return New NetworkCredential(userName, password, domain)End Get End Property Public Function GetFormsCredentials(ByRef authCookieAs System.Net.Cookie,ByRef userNameAs String,ByRef passwordAs String,ByRef authorityAs String)As Boolean Implements Microsoft.Reporting.WebForms.IReportServerCredentials.GetFormsCredentialsEnd Function End Class Public Function GetFormsCredentials(ByRef authCookieAs Cookie, _ByRef userNameAs String, _ByRef passwordAs String, _ByRef authorityAs String) _As Boolean authCookie =Nothing userName =Nothing password =Nothing authority =Nothing'Not using form credentialsReturn False End Function Protected Sub form1_Load(ByVal senderAs Object,ByVal eAs System.EventArgs)Handles form1.Load ReportViewer1.ServerReport.ReportServerCredentials =New MyReportServerCredentials()End SubEnd Class

And my web.config

ersion="1.0"?><configuration><system.web><httpHandlers><add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/></httpHandlers><compilation debug="true" strict="false" explicit="true"><buildProviders><add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/></buildProviders></compilation><pages><namespaces><clear/><add namespace="System"/><add namespace="System.Collections"/><add namespace="System.Collections.Specialized"/><add namespace="System.Configuration"/><add namespace="System.Text"/><add namespace="System.Text.RegularExpressions"/><add namespace="System.Web"/><add namespace="System.Web.Caching"/><add namespace="System.Web.SessionState"/><add namespace="System.Web.Security"/><add namespace="System.Web.Profile"/><add namespace="System.Web.UI"/><add namespace="System.Web.UI.WebControls"/><add namespace="System.Web.UI.WebControls.WebParts"/><add namespace="System.Web.UI.HtmlControls"/></namespaces></pages> </system.web></configuration>

So this is the script that my host provides its users. I tried breaking it down to figure out why it wasn't working but maybe you guys can point what if i'm missing something.|||

after

this line... ReportViewer1.ServerReport.ReportServerCredentials =New MyReportServerCredentials()

try giving this line.

ReportViewer1.ServerReport.ReportServerUrl =New Uri("http://Ipaddress/myreportserver") and also the report path.

|||

I put that it in and still nothing. Everything 'technically' does load. If I remove the parameter drop down menu I have in my .rdl then it'll display the report. However, its when I have the parameter dropdown and I select and item and report it. It just refreshes that page.

|||

how are u populating the parameters. is it thru a sproc... if so check the sproc for some bugs,,, and if u run this report in the report manager does it act the same way....

|||

its in my data source. I select the radio button that says, credentials stored securely in the report server.

then i enter in my username and password. and I never have to enter in the user info. I can run the reports fine from the report server. (By the way i use an online host, not locally) its just when I try to run it through the vbscripts. its not working the way it stuppose to.

Report SQL Server 2005 - Parameters

I am having difficulties with my parameters. In the layout field I am able to make parameters, but when I execute the report it is not just pulling certain parameters it is pulling all.

Example

If I wanted to pull all of the case that are closed, but it is still adding in the open ones as well.

Can someone guide me in the right direction?

Thanks

did you set the parameters from Report Parameter dialog box. If not select Report | Report Parameters fro the Main menu and set the fields.

kushpaw

Report Service 2005 parameter at Date

I set Report Parameters ,

Properties

Name : StartDate

Data Type : DateTime

Prompt : StartDate

Default values = Format(Today(),"yyyy/MM/dd")

But have error (An error occurred during local report rpocessing. The properly "DefaultValue" of report parameter 'EndDate' doesn't have the expected type.)

The Result show : like "2007/05/01"

Thanks help

Moving to SQL Server Reporting Services forum. This is not an SSIS issue.|||

Hi,

I think the Format function converts your value into String datatype & that is why you're getting the error.

Just use CDate of your expression, that is:

CDate(Format(Today(),"yyyy/MM/dd")

That should get rid of the error.

-Aayush.

|||

=CDate(Format(Today(),"yyyy/MM/dd")

had error

[rsCompilerErrorInExpression] The Value expression for the report parameter ‘endDate’ contains an error: [BC30198] ')' expected.

Thanks help

|||

Oops.. I missed out a bracket Sorry for that.

Try =CDate(Format(Today(),"yyyy/MM/dd"))

-Aayush

|||Thanks You very much|||

Thanks all

The command is right, but I look in client pc, i see the date is "06/11/2007"

The =Cdate(format(today(),"yyyy/MM/dd")) could not work.

|||You're right I overlooked the fact that CDate converts it back to the default date format. So this fix does not work. Actually the expression =Format(Today(),"yyyy/MM/dd") would work but it would require you to change the Data Type of the parameter from 'DateTime' to 'String'. So I don't think it is very feasible.|||

Thanks

But not work