Named query not appearing in report builder

I'm having a heck of a time with named queries. At this point I just want a proof of concept in my DSV. I have a bunch of tables added to the DSV, and I would like to add a named query to it so the user can pick from the name query in report builder. What has to be done to make it appear in the report builder?

Nevermind. I didn't realize that the report model definition had to be refreshed.

Named and UnNamed parameters

While creating a report i am running into a problem with parameters.
When building the query i would like to use the same parameter more then
once.
for instance :
select *
from table
where field = @.parameter1
and field = @.Parameter1
and field = @.parameter1
I can runs this Query successfully in the Data tab of the report .however
when i go to the layout or preview tab i get the following error:
The data extension ODBC does not support named parameters. use unnamed
parameters instead.
If i run the query using ? as the parameter i dont have any problems.However
for each ? parameter the user is prompted to supply a value.This is
unacceptable as the user would have to enter the same value numerous times.
select *
from table
where field = ?
and field = ?
and field = ?
Any help would be appreciated.
TIA,
VinnyThere are query parameters and report parameters. RS automatically creates
the report parameters for you. It will create a report parameter for each
unnammed parameter. What you need to do is map each query parameter to a
single report parameter. In the data tab click on the ..., parameters tab.
Map each ? on the left to the same report parameter on the right. Next go to
the layout, report->report parameters and remove the extra unused report
parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vinny Vinn" <VinnyVinn@.discussions.microsoft.com> wrote in message
news:2F9A3C8B-72DA-4CAD-BE4B-5D4D07CB1C4F@.microsoft.com...
> While creating a report i am running into a problem with parameters.
> When building the query i would like to use the same parameter more then
> once.
> for instance :
> select *
> from table
> where field = @.parameter1
> and field = @.Parameter1
> and field = @.parameter1
> I can runs this Query successfully in the Data tab of the report .however
> when i go to the layout or preview tab i get the following error:
> The data extension ODBC does not support named parameters. use unnamed
> parameters instead.
> If i run the query using ? as the parameter i dont have any
> problems.However
> for each ? parameter the user is prompted to supply a value.This is
> unacceptable as the user would have to enter the same value numerous
> times.
> select *
> from table
> where field = ?
> and field = ?
> and field = ?
> Any help would be appreciated.
> TIA,
> Vinny|||Thank you ,that what i needed.
"Bruce L-C [MVP]" wrote:
> There are query parameters and report parameters. RS automatically creates
> the report parameters for you. It will create a report parameter for each
> unnammed parameter. What you need to do is map each query parameter to a
> single report parameter. In the data tab click on the ..., parameters tab.
> Map each ? on the left to the same report parameter on the right. Next go to
> the layout, report->report parameters and remove the extra unused report
> parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Vinny Vinn" <VinnyVinn@.discussions.microsoft.com> wrote in message
> news:2F9A3C8B-72DA-4CAD-BE4B-5D4D07CB1C4F@.microsoft.com...
> > While creating a report i am running into a problem with parameters.
> > When building the query i would like to use the same parameter more then
> > once.
> > for instance :
> >
> > select *
> > from table
> > where field = @.parameter1
> > and field = @.Parameter1
> > and field = @.parameter1
> >
> > I can runs this Query successfully in the Data tab of the report .however
> > when i go to the layout or preview tab i get the following error:
> > The data extension ODBC does not support named parameters. use unnamed
> > parameters instead.
> >
> > If i run the query using ? as the parameter i dont have any
> > problems.However
> > for each ? parameter the user is prompted to supply a value.This is
> > unacceptable as the user would have to enter the same value numerous
> > times.
> >
> > select *
> > from table
> > where field = ?
> > and field = ?
> > and field = ?
> >
> > Any help would be appreciated.
> >
> > TIA,
> > Vinny
>
>|||Bruce,
I am using DB2 so I also have to use unnamed parms in my queries. I have
used your solution for parms that need entries on the report. However - that
doesnt solve the problem that the query on the data tab still has 10 question
marks in it and it would be really helpful to those that have to modify
"others" reports to not have to try and play "match the parameter" ... Is
there a way to place a comment in the query tab? that might be helpful
enough. Thanks! I am posting a much larger ISSUE about dealing with parms
syntax when I need to code the sql as an expression ... please see Parm
Syntax for SQL Expression
"Bruce L-C [MVP]" wrote:
> There are query parameters and report parameters. RS automatically creates
> the report parameters for you. It will create a report parameter for each
> unnammed parameter. What you need to do is map each query parameter to a
> single report parameter. In the data tab click on the ..., parameters tab.
> Map each ? on the left to the same report parameter on the right. Next go to
> the layout, report->report parameters and remove the extra unused report
> parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Vinny Vinn" <VinnyVinn@.discussions.microsoft.com> wrote in message
> news:2F9A3C8B-72DA-4CAD-BE4B-5D4D07CB1C4F@.microsoft.com...
> > While creating a report i am running into a problem with parameters.
> > When building the query i would like to use the same parameter more then
> > once.
> > for instance :
> >
> > select *
> > from table
> > where field = @.parameter1
> > and field = @.Parameter1
> > and field = @.parameter1
> >
> > I can runs this Query successfully in the Data tab of the report .however
> > when i go to the layout or preview tab i get the following error:
> > The data extension ODBC does not support named parameters. use unnamed
> > parameters instead.
> >
> > If i run the query using ? as the parameter i dont have any
> > problems.However
> > for each ? parameter the user is prompted to supply a value.This is
> > unacceptable as the user would have to enter the same value numerous
> > times.
> >
> > select *
> > from table
> > where field = ?
> > and field = ?
> > and field = ?
> >
> > Any help would be appreciated.
> >
> > TIA,
> > Vinny
>
>

Name of User Requesting Report

I have several reports that need a parameter for logon name. How can I get
the name of the user requesting the report so I can use that in a parameter
for the report query?
Thanks for any helpThere is a global value of UserID that you can assign to the report
parameter in an expression. Its value is the domain\userid for the
connected user.
example:
=Globals!UserID
You can assign it to a stored procedure paramter in the parameter tab
of the data set editor. Be sure to use the CommandType of
"StoredProcedure" and not "Text" when configuring the data set.
Regards,
Clayton
Scott Duckworth wrote:
> I have several reports that need a parameter for logon name. How can I get
> the name of the user requesting the report so I can use that in a parameter
> for the report query?
> Thanks for any help|||Thanks for the help.
"SQLMonger" <claytongroom@.gmail.com> wrote in message
news:1120842855.113091.85050@.z14g2000cwz.googlegroups.com...
> There is a global value of UserID that you can assign to the report
> parameter in an expression. Its value is the domain\userid for the
> connected user.
> example:
> =Globals!UserID
> You can assign it to a stored procedure paramter in the parameter tab
> of the data set editor. Be sure to use the CommandType of
> "StoredProcedure" and not "Text" when configuring the data set.
> Regards,
> Clayton
> Scott Duckworth wrote:
> > I have several reports that need a parameter for logon name. How can I
get
> > the name of the user requesting the report so I can use that in a
parameter
> > for the report query?
> >
> > Thanks for any help
>sql

Name of report in title bar?

Hi everybody,
is it possible to show the name of the report in the title bar of
Internet Explorer? My users have muliple IE-applications open, all
with different reports. They would like to see the name of the report
in the windows taskbar instead of "Report Manager - Microsoft Internet
Explorer".
Anybody any thoughts?
Thanks in advance, Vivian.The reason it says Report Manager in the title bar is because the WEB
application sets it to do so. This isnt controlled by the report.
I have a solution for you although it will require some development.
All Reports are generated from the Report.aspx located under the
"ReportManager\Pages\" folder
You CAN add a <title>Report Name</title> title tags in the ASPX file.
The actual ASPX file looks empty, but you can place HTML code in there.
You can write javascript code to read the ItemPath parameter - this is
the parameter for the path of the report. It is in the query string.
This will allow you to get the Report Name.
Then you just use the following code to set the title:
document.title = "Report Name"
regards,
Stas K.|||Here add this into report.aspx:
<script>
function getQueryVariable(variable) {
var query = window.location.search.substring(1);
var vars = query.split("&");
for (var i=0;i<vars.length;i++) {
var pair = vars[i].split("=");
if (pair[0] == variable) {
return pair[1];
}
}
//alert('Query Variable ' + variable + ' not found');
}
</script>
<script>
var query2 = getQueryVariable("ItemPath")
document.title =query2.substring(query2.lastIndexOf('%2f')+3,query2.length);
</script>|||Heh,
I never thought of this. This helped me too. The executives were very
appriciative.
regards,
Stas K.|||Looks good Stas! Will test it first thing monday morning.
Thanx, Vivian|||Great code.
I extended it a bit, to replace the +s between each word with a space.
This is my updated script:
<script>
// function getQueryVariable and page script found at
//
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/39e5747688f51268/d0a6a49f6891dfd4
// function replace found at
//http://www.rgagnon.com/jsdetails/js-0043.html
//Purpose of code: Replace page title "Report Manager" with the report name
in Report Manager
function getQueryVariable(variable) {
var query = window.location.search.substring(1);
var vars = query.split("&");
for (var i=0;i<vars.length;i++) {
var pair = vars[i].split("=");
if (pair[0] == variable) {
return pair[1];
}
}
//alert('Query Variable ' + variable + ' not found');
}
function replace(s, t, u) {
/*
** Replace a token in a string
** s string to be processed
** t token to be found and removed
** u token to be inserted
** returns new String
*/
i = s.indexOf(t);
r = "";
if (i == -1) return s;
r += s.substring(0,i) + u;
if ( i + t.length < s.length)
r += replace(s.substring(i + t.length, s.length), t, u);
return r;
}
</script>
<script>
var query2 = getQueryVariable("ItemPath")
query2 = query2.substring(query2.lastIndexOf('%2f')+3,query2.length);
query2 = replace(query2, '+', ' ');
document.title =query2
</script>
- Again, great idea and great code. :)
Kaisa M. Lindahl Lervik
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1144426083.140501.223890@.v46g2000cwv.googlegroups.com...
> Here add this into report.aspx:
> <script>
> function getQueryVariable(variable) {
> var query = window.location.search.substring(1);
> var vars = query.split("&");
> for (var i=0;i<vars.length;i++) {
> var pair = vars[i].split("=");
> if (pair[0] == variable) {
> return pair[1];
> }
> }
> //alert('Query Variable ' + variable + ' not found');
> }
> </script>
> <script>
> var query2 = getQueryVariable("ItemPath")
> document.title => query2.substring(query2.lastIndexOf('%2f')+3,query2.length);
> </script>
>|||Hello I am trying this function and it is not working for me. I get a
javascript error message that says query2 is null or not an object. What am I
missing?
Thanks!
--
Kevin
"Sorcerdon" wrote:
> Here add this into report.aspx:
> <script>
> function getQueryVariable(variable) {
> var query = window.location.search.substring(1);
> var vars = query.split("&");
> for (var i=0;i<vars.length;i++) {
> var pair = vars[i].split("=");
> if (pair[0] == variable) {
> return pair[1];
> }
> }
> //alert('Query Variable ' + variable + ' not found');
> }
> </script>
> <script>
> var query2 = getQueryVariable("ItemPath")
> document.title => query2.substring(query2.lastIndexOf('%2f')+3,query2.length);
> </script>
>

Name of report in head dynamically

Hi everybody,
does anybody knows if it is possible to create a report where the name
changes. I want to dynamically add a subtitle with data from a database.
E.g. (Static: Adress List, Dynamic: of Town XY). Apparently it is not
possible to insert fields from a dataset in the head of a report, so what
would be a good workaraound?
Thx for your support.
Regards
MichaelMichael,
Place a textbox in the body of the report. For the value of the
textbox, put the data from your DB, (ie
=First(Field!NameOfField.Value)).
Once this textbox has the data you want to display, refer to the
textbox in the header (ie =ReportItems!NameOfTextboxWithDataIWanttoDisplay.Value).

Name multiple sheets in excel export?

I have a report that when exported to Excel creates multiple sheets. Im
doing this on purpose. I wanted know if anyone new a way to
automatically name the Sheets in the Excel export? I wanted to name
them from a field on the report.I don't believe this is possible in the current versions of Reporting
Services. It seems like a functionality that would have a great deal
of value for reporting purposes, so hopefully MS will include this
feature in a future service pack.
pichula wrote:
> I have a report that when exported to Excel creates multiple sheets. Im
> doing this on purpose. I wanted know if anyone new a way to
> automatically name the Sheets in the Excel export? I wanted to name
> them from a field on the report.|||I'm pretty sure you can't do this. I'm very sure you couldn't do it with RS
2000 (tried to find info about it myself a while ago), and I don't think you
can do it in RS 2005 either.
A pity, really, as it would be very usefull!
Kaisa M. Lindahl Lervik
"pichula" <kansas4451@.yahoo.com> wrote in message
news:1162321874.757668.47520@.e64g2000cwd.googlegroups.com...
>I have a report that when exported to Excel creates multiple sheets. Im
> doing this on purpose. I wanted know if anyone new a way to
> automatically name the Sheets in the Excel export? I wanted to name
> them from a field on the report.
>|||Thanks for your replies. If this is not possible in RS 2005, does
anybody know about any workaround to this problem? Maybe using Excel
macros, etc.
elPablo
Kaisa M. Lindahl Lervik wrote:
> I'm pretty sure you can't do this. I'm very sure you couldn't do it with RS
> 2000 (tried to find info about it myself a while ago), and I don't think you
> can do it in RS 2005 either.
> A pity, really, as it would be very usefull!
> Kaisa M. Lindahl Lervik
>
> "pichula" <kansas4451@.yahoo.com> wrote in message
> news:1162321874.757668.47520@.e64g2000cwd.googlegroups.com...
> >I have a report that when exported to Excel creates multiple sheets. Im
> > doing this on purpose. I wanted know if anyone new a way to
> > automatically name the Sheets in the Excel export? I wanted to name
> > them from a field on the report.
> >|||Have you tried to write a post process that runs on your excel sheet and
renames the exported sheets?
=-Chris
"pichula" <kansas4451@.yahoo.com> wrote in message
news:1162321874.757668.47520@.e64g2000cwd.googlegroups.com...
>I have a report that when exported to Excel creates multiple sheets. Im
> doing this on purpose. I wanted know if anyone new a way to
> automatically name the Sheets in the Excel export? I wanted to name
> them from a field on the report.
>

n00b question - permissions from website

Hi everyone,

I've inherited a website based on the dotnetnuke frameowork.

this website also uses the reporting services from sqlserver.

When the report button is clicked in the website, the user is prompted

with a login and password (standard windows dialog)

Entering the username/password for the web site fails,

entering username/password for the machine works.

The user - of course - doesn't want to enter enything, let alone see the darn dialog box,

just wants to see the report on the screen.

Does anyone have any ideas on where to start looking for a solution to this problem?

thanks

tony

The settings for the permissions of the report service are in the service's properties in IIS settings in control panel -> administrative tools. You might be able to set it to use the same password as the rest of the website there.

Mysterious gaps on PDFs and prints

Hello, I have a report that looks fine in preview, but when put to PDF or printed contains gaps at the right and bottom.

Here is a picture of the problem: http://northeasttigers.webng.com/pdfproblem.jpg

My tables are the same width as the body, 15.5cm, and the report width is 21cm. Also adding the bottom table's top location attribute to it's height gives the same height as the body.

Any help much appreciated.

Greg

It looks like that might be your margin - have a look at that property (click on the report body to see it).

|||

Thanks, that fixed it! Making the body width + left & right margins = report width fixed my problem.

Thanks very much, much appreciated.

|||

No worries. Posting a pic was a good move, it meant that no guess work was required

mysql to crystal report

i have my db at mysql, but i need to link it to crystal report to make a report for my company.
how can i do it?
thanksYou can use ODBC or OLE DB, but you need to install ODBC or OLE DB driver of MySQL.|||how to install odbc or ole in mysql?|||how to install odbc or ole in mysql?
No, not to install ODBC in your MySQL, but in your PC.
After installation finished, then select your data source to ODBC which
using MySQL ODBC driver.|||Download MySql Connector/ODBC (http://dev.mysql.com/downloads/connector/odbc/3.51.html) and after installation.

Go to ODBC Data Source Adminiostration -> System DSN - >Add -> MySQL ODBC 3.5 Driver and set the server information.

Then you can use this connection in the Crystal Report.

MYSQL and Reporting Server

Hi All,
Not sure if this is the best place to ask this, but how can I use
parameters in a report connecting to a MYSQL database.
Thanks
Michael
Use ? as the parameter marker e.g.
select * from mysqlcode.categories where ID = ?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Michael van der Veeke" <michaelvanderveeke@.borderexpress.com.au> wrote in
message news:41e36ad1$0$96867$c30e37c6@.ken-reader.news.telstra.net...
> Hi All,
> Not sure if this is the best place to ask this, but how can I use
> parameters in a report connecting to a MYSQL database.
> Thanks
> Michael
|||Thank you very much.
Jasper Smith wrote:
> Use ? as the parameter marker e.g.
> select * from mysqlcode.categories where ID = ?
>

MySQL 5.0 Views wont work with crystal reports

I can access my view data through the application, but when i try to create the report in crytal reports and set up the database through an odbc driver 3.51.

If i click on a normal table its fine, but with the views it says

"Error Opening File: There are no fields in the file: "[View name]".Hi,

I've got a similar problem but using a stored proc. (See earlier posting for more info)

After much hair-pulling and soul searching i think that their might be a compatibility problem with MySQL5, MyODBC 3.51 and Crystal.

Have you tried MyODBC 5.0 yet? If it installs and works on yr side that might take yr problem away. And if it does, please let us know what you did cause it dont wanna install here.

Thanks and good luck|||Thanks

I have tried the 5.0 ODBC Connector, but unfortunatly i had no joy. Still the same error.

My Very Own SOAP / Web Service Report Viewer

Well, I've finally done it! The first fully functional prototype of the
report viewer control for Reporting Services 2000 is complete. I am
working on a project that cannot wait until RS 2005, so we bit the
bullet and wrote our own component (URL access will not work for a
number of reasons).
Alon with report selection, I have implemented:
1) Parameter selection (including linked params)
2) Page navigation
3) Zooming
4) Refresh
5) Export to: PDF, Excel, CSV, TIFF, XML, MHTML
6) Printing
I have received a lot of help from the RS community, so may thanks to
those of you who frequent this group!
Kulgan.Congratulations!
I have been struggling to build one too. Would you mind sharing your
code/ideas on how to go on about it?
TIA.
Marlon
"Kulgan" <nickamckenna@.gmail.com> wrote in message
news:1121180309.308222.314710@.g43g2000cwa.googlegroups.com...
> Well, I've finally done it! The first fully functional prototype of the
> report viewer control for Reporting Services 2000 is complete. I am
> working on a project that cannot wait until RS 2005, so we bit the
> bullet and wrote our own component (URL access will not work for a
> number of reasons).
> Alon with report selection, I have implemented:
> 1) Parameter selection (including linked params)
> 2) Page navigation
> 3) Zooming
> 4) Refresh
> 5) Export to: PDF, Excel, CSV, TIFF, XML, MHTML
> 6) Printing
> I have received a lot of help from the RS community, so may thanks to
> those of you who frequent this group!
> Kulgan.
>|||Unfortunately the code belongs to the client I have done the work for,
but I will be doing an open source version shortly (when I return from
holiday in a couple of weeks).
I will keep you posted!
In the meantime, if you get stuck, email me and I'll help wherever I
can.
Cheers,
Kulgan.|||Yes, thats great! I have the exact same issue that I need to resolve, i.e.
using the viewer through SOAP. I would love to see how you did this!
"TechnoSpyke" wrote:
> Congratulations!
> I have been struggling to build one too. Would you mind sharing your
> code/ideas on how to go on about it?
> TIA.
> Marlon
> "Kulgan" <nickamckenna@.gmail.com> wrote in message
> news:1121180309.308222.314710@.g43g2000cwa.googlegroups.com...
> > Well, I've finally done it! The first fully functional prototype of the
> > report viewer control for Reporting Services 2000 is complete. I am
> > working on a project that cannot wait until RS 2005, so we bit the
> > bullet and wrote our own component (URL access will not work for a
> > number of reasons).
> >
> > Alon with report selection, I have implemented:
> >
> > 1) Parameter selection (including linked params)
> > 2) Page navigation
> > 3) Zooming
> > 4) Refresh
> > 5) Export to: PDF, Excel, CSV, TIFF, XML, MHTML
> > 6) Printing
> >
> > I have received a lot of help from the RS community, so may thanks to
> > those of you who frequent this group!
> >
> > Kulgan.
> >
>
>|||Me too.
tnx.
Tom.

My Table Is Empty

I just created a new report and the table header is visible, as is the
first column, but all of the other columns are blank. The first column
has a product name, and the others have sales data, etc.
I can run the query from the data tab in VS, and it works fine. But
the preview and live version both have blank values in the main part of
hte table.
Why?Hi,
Have you checked the mapping of your query columns with the dataset return
values? Press Ctrl+Alt+D to make then visible if they aren't.
Jan Pieter Posthuma
"John" wrote:
> I just created a new report and the table header is visible, as is the
> first column, but all of the other columns are blank. The first column
> has a product name, and the others have sales data, etc.
> I can run the query from the data tab in VS, and it works fine. But
> the preview and live version both have blank values in the main part of
> hte table.
> Why?
>|||Yep. I even tried to create a new report and it did not work. I'm
totally lost on this one.|||Man, this was all me. My stored procedure had a little glitch. It
really threw me though since the first column was populated correctly.
Thanks for the help Jan Pieter Posthuma

My store procedure returns 2 grids HELP

How do I access the 2nd grid/table in my report?
Basically I have a SP that has a SUM in one grid. The second grid
cotains the data I want to display in RS. Is there a way to get to the
2nd grid without altering the store procedure(Its being used on another
report)?
regards,
Stas K.I just found a similar topic where it says I cannot do this.
Any ideas?|||No, RS can only take a single resultset.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1136923749.664965.81380@.z14g2000cwz.googlegroups.com...
> How do I access the 2nd grid/table in my report?
> Basically I have a SP that has a SUM in one grid. The second grid
> cotains the data I want to display in RS. Is there a way to get to the
> 2nd grid without altering the store procedure(Its being used on another
> report)?
> regards,
> Stas K.
>

My Site option

What permission is required to be able to go into the "My Site" settings in
the Report Manager? Is it looking for a specific permission in the
ReportServer database, config file, or some machine permission?Correction, I meant the "Site Setting" option. What permission is required
to be able to go into the "Site Setting" option?
"David" wrote:
> What permission is required to be able to go into the "My Site" settings in
> the Report Manager? Is it looking for a specific permission in the
> ReportServer database, config file, or some machine permission?|||Hello David,
You need to create a new server side role and grant proper server side
permission.
At least, you need to grant the following:
Execute Report Definitions
Manage report server properties
View report server properties
View shared schedules
Or any other Server Management permission like Manage report server
security,Manage roles, Manage shared schedules.
Once you grant one of these Server management permission to the Role and
assign a user to this Server Side Role, the user could see the 'Site
Setting' in the Report Manager.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

My reports folder

How to rename the "My reports" folder. My browser language is in french and
user are speaking french. The report manager only show "My reports" but I
want to see "Mes rapports"
I know that is the "listChildren" method that add My report. Is there a way
to change this?We simply made an .aspx (or it could even be an html) page as the
starting-page for the users with an url-link to their "my reports" content
"Francis Côté" wrote:
> How to rename the "My reports" folder. My browser language is in french and
> user are speaking french. The report manager only show "My reports" but I
> want to see "Mes rapports"
> I know that is the "listChildren" method that add My report. Is there a way
> to change this?
>
>|||Interestingly, this page seems to indicate either that you cannot localize
this, or that the localization should be automatic if the OS hosting the
report server is localized to French:
http://msdn2.microsoft.com/en-us/library/aa972255(SQL.80).aspx -- while this
page may be outdated, there is a similar set of paragraphs in BOL for 2005.
I quote:
A few items are always articulated in the language that corresponds to the
operating system language setting, regardless of client application locale.
The following table describes these items.
Predefined roles
Reporting Services installs with several predefined roles (Browser,
Publisher, Content Manager, My Reports, System Administrator, and System
User) that are articulated in the language resource of the operating system
that runs the report server.
Users folder, and My Reports folder
These folder names are reserved when the My Reports feature is enabled. This
feature requires a fixed folder structure. Because the report server manages
reserved names, reserved folder names are articulated in the language
resource of the operating system that runs the report server.
<<
So... what is the regional setting of the OS, in your case?
>L<
"Francis Côté" <francis.cote@.uqat.ca> wrote in message
news:u2seBrchHHA.4300@.TK2MSFTNGP05.phx.gbl...
> How to rename the "My reports" folder. My browser language is in french
> and user are speaking french. The report manager only show "My reports"
> but I want to see "Mes rapports"
> I know that is the "listChildren" method that add My report. Is there a
> way to change this?
>

My report wont work :-) with a date param

Hi All,
I have inherited a report that at the Dataset level works fine. It takes a
date param eg. 02-Dec-2005 and returns 3 rows as I would expect.
The report page has the date param defined as Datetime and when I enter the
date ie. 02-Dec-2005 it returns 0 rows. I have tried inputting different date
formats
to no avail. kinda puzzled.
Any clues as to the cause of the problem.
Thanx in advancewell,i had kind of this problem.
I never use parm as datetime always as string and inside the dataset i use
CONVERT(datetime,@.FromTime,103) it works 4 me...
"Scotchy" wrote:
> Hi All,
> I have inherited a report that at the Dataset level works fine. It takes a
> date param eg. 02-Dec-2005 and returns 3 rows as I would expect.
> The report page has the date param defined as Datetime and when I enter the
> date ie. 02-Dec-2005 it returns 0 rows. I have tried inputting different date
> formats
> to no avail. kinda puzzled.
> Any clues as to the cause of the problem.
> Thanx in advance
>|||It sounds to me like your query parameter is not hooked up to your report
parameter. In the dataset click on the ..., parameters tab. Your query
parameters should be listed on the left and the report parameter they map to
on the right.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scotchy" <Scotchy@.discussions.microsoft.com> wrote in message
news:B64FE999-9EA6-40C0-896E-984BBDC4BDC4@.microsoft.com...
> Hi All,
> I have inherited a report that at the Dataset level works fine. It takes a
> date param eg. 02-Dec-2005 and returns 3 rows as I would expect.
> The report page has the date param defined as Datetime and when I enter
> the
> date ie. 02-Dec-2005 it returns 0 rows. I have tried inputting different
> date
> formats
> to no avail. kinda puzzled.
> Any clues as to the cause of the problem.
> Thanx in advance
>|||Thanks Bruse, but no, all params are mapped as required. Something else going
on here I think, might try a string param instead , although Ive not had this
issue before in Date param'd reps. Guess thats the problem when inheriting
others work. Thanx for your and others input. Much appreciated
"Bruce L-C [MVP]" wrote:
> It sounds to me like your query parameter is not hooked up to your report
> parameter. In the dataset click on the ..., parameters tab. Your query
> parameters should be listed on the left and the report parameter they map to
> on the right.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Scotchy" <Scotchy@.discussions.microsoft.com> wrote in message
> news:B64FE999-9EA6-40C0-896E-984BBDC4BDC4@.microsoft.com...
> > Hi All,
> >
> > I have inherited a report that at the Dataset level works fine. It takes a
> > date param eg. 02-Dec-2005 and returns 3 rows as I would expect.
> >
> > The report page has the date param defined as Datetime and when I enter
> > the
> > date ie. 02-Dec-2005 it returns 0 rows. I have tried inputting different
> > date
> > formats
> > to no avail. kinda puzzled.
> >
> > Any clues as to the cause of the problem.
> >
> > Thanx in advance
> >
>
>

My Report Manager is missing...Need help ASAP!

Cannot find the report manager. I tried starting the Report Manager from the
start menu on the server and received this error "Page cannot be displayed".
I then tried from the authoring comupter start menu and got the same message.
I then tried to deploy a report to the site and received and error "cannot
connect to the report server". I have never gotten these messages before.
There was some recent work on the server but that shouldn't affect RS should
it. Any ideas?
Thanks in advance.What version are you on?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"OriginalStealth" <OriginalStealth@.discussions.microsoft.com> wrote in
message news:380BDB1A-AAF2-43B3-BE79-E525E6D2E260@.microsoft.com...
> Cannot find the report manager. I tried starting the Report Manager from
> the
> start menu on the server and received this error "Page cannot be
> displayed".
> I then tried from the authoring comupter start menu and got the same
> message.
> I then tried to deploy a report to the site and received and error "cannot
> connect to the report server". I have never gotten these messages before.
> There was some recent work on the server but that shouldn't affect RS
> should
> it. Any ideas?
> Thanks in advance.|||I am using RS 2003. I retrieved this from the log files. How do I fix this.
Will reinstall fix it.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__10_18_2007_10_13_30.log</Path>
<SystemName>EAVARCHSQLR01</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!servicecontroller!50c!10/18/2007-10:13:30:: Service
controller exiting.
ReportingServicesService!crypto!bec!10/18/2007-10:13:30:: i INFO:
Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!bec!10/18/2007-10:13:30:: i INFO: Exporting
public key
ReportingServicesService!crypto!bec!10/18/2007-10:13:30:: i INFO: Performing
sku validation
ReportingServicesService!crypto!bec!10/18/2007-10:13:30:: i INFO: Importing
existing encryption key
ReportingServicesService!library!bec!10/18/2007-10:13:30:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
ReportingServicesService!library!bec!10/18/2007-10:13:30:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!bec!10/18/2007-10:13:30:: Attempting to
start service again...
"Bruce L-C [MVP]" wrote:
> What version are you on?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "OriginalStealth" <OriginalStealth@.discussions.microsoft.com> wrote in
> message news:380BDB1A-AAF2-43B3-BE79-E525E6D2E260@.microsoft.com...
> > Cannot find the report manager. I tried starting the Report Manager from
> > the
> > start menu on the server and received this error "Page cannot be
> > displayed".
> > I then tried from the authoring comupter start menu and got the same
> > message.
> > I then tried to deploy a report to the site and received and error "cannot
> > connect to the report server". I have never gotten these messages before.
> > There was some recent work on the server but that shouldn't affect RS
> > should
> > it. Any ideas?
> >
> > Thanks in advance.
>
>|||Sounds like you restored your reporting services database to another
server!
If security was set up then you need the keys from the initial server.
Alternatively, do a clean install of reporting services and reload the
reports via visual studio...
This way is alot cleaner and simpler with the nice way one can
"deploy" reports.
Regards,
Tom Bizannes
Reporting Services Designer
Sydney, Australia

My Report Manager Broke "The underlying connection was closed"

Our company recently re-located the servers and somehow in the process of
disconnecting -> reconnecting the Report Server the Report Manager now cannot
be run. All we get is the error:
"The underlying connection was closed: Unable to connect to the remote
server."
Interestingly, this affects ONLY the Report Manager, the Report Service is
running OK and all reports run fine via our web application and in Visual
Studio IDE etc...
Any clues?Hi!
We had a similar problem and resolved it by correcting the Applications
Extensions Mapping for the ReportServer virtual directory. Information about
configuring Reporting Services' virtual directories is available here:
http://support.microsoft.com/Default.aspx?kbid=867872
Good luck,
Bob
"neokortex" wrote:
> Our company recently re-located the servers and somehow in the process of
> disconnecting -> reconnecting the Report Server the Report Manager now cannot
> be run. All we get is the error:
> "The underlying connection was closed: Unable to connect to the remote
> server."
> Interestingly, this affects ONLY the Report Manager, the Report Service is
> running OK and all reports run fine via our web application and in Visual
> Studio IDE etc...
> Any clues?|||thanks for the tip,
but Im not quite sure this will help me. I checked the extensions for our
ReportServer virtual directory and they are already mapped exactly as
specified in the Support article. Also, ReportServer is working fine in so
far as reports can still be run through it.
It is only the Report Manager Web UI that is flaking out.
"bobhug" wrote:
> Hi!
> We had a similar problem and resolved it by correcting the Applications
> Extensions Mapping for the ReportServer virtual directory. Information about
> configuring Reporting Services' virtual directories is available here:
> http://support.microsoft.com/Default.aspx?kbid=867872
> Good luck,
> Bob
> "neokortex" wrote:
> > Our company recently re-located the servers and somehow in the process of
> > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > be run. All we get is the error:
> >
> > "The underlying connection was closed: Unable to connect to the remote
> > server."
> >
> > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > running OK and all reports run fine via our web application and in Visual
> > Studio IDE etc...
> >
> > Any clues?|||I am having the exact same problem. ReportServer is working fine, but report
manager web interface gives The underlying connection was closed. was there a
resolution to this problem?
"neokortex" wrote:
> thanks for the tip,
> but Im not quite sure this will help me. I checked the extensions for our
> ReportServer virtual directory and they are already mapped exactly as
> specified in the Support article. Also, ReportServer is working fine in so
> far as reports can still be run through it.
> It is only the Report Manager Web UI that is flaking out.
> "bobhug" wrote:
> > Hi!
> > We had a similar problem and resolved it by correcting the Applications
> > Extensions Mapping for the ReportServer virtual directory. Information about
> > configuring Reporting Services' virtual directories is available here:
> > http://support.microsoft.com/Default.aspx?kbid=867872
> >
> > Good luck,
> > Bob
> >
> > "neokortex" wrote:
> >
> > > Our company recently re-located the servers and somehow in the process of
> > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > be run. All we get is the error:
> > >
> > > "The underlying connection was closed: Unable to connect to the remote
> > > server."
> > >
> > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > running OK and all reports run fine via our web application and in Visual
> > > Studio IDE etc...
> > >
> > > Any clues?|||No resolution yet. Since that was a test server and we were/are in the
process of migrating to a production server, it is not a emergency for us. I
do know this is a general web service error, not necessarily specfic to RS.
However if you find the answer please respond. I am curious.
"Paul" wrote:
> I am having the exact same problem. ReportServer is working fine, but report
> manager web interface gives The underlying connection was closed. was there a
> resolution to this problem?
> "neokortex" wrote:
> > thanks for the tip,
> >
> > but Im not quite sure this will help me. I checked the extensions for our
> > ReportServer virtual directory and they are already mapped exactly as
> > specified in the Support article. Also, ReportServer is working fine in so
> > far as reports can still be run through it.
> >
> > It is only the Report Manager Web UI that is flaking out.
> >
> > "bobhug" wrote:
> >
> > > Hi!
> > > We had a similar problem and resolved it by correcting the Applications
> > > Extensions Mapping for the ReportServer virtual directory. Information about
> > > configuring Reporting Services' virtual directories is available here:
> > > http://support.microsoft.com/Default.aspx?kbid=867872
> > >
> > > Good luck,
> > > Bob
> > >
> > > "neokortex" wrote:
> > >
> > > > Our company recently re-located the servers and somehow in the process of
> > > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > > be run. All we get is the error:
> > > >
> > > > "The underlying connection was closed: Unable to connect to the remote
> > > > server."
> > > >
> > > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > > running OK and all reports run fine via our web application and in Visual
> > > > Studio IDE etc...
> > > >
> > > > Any clues?|||Hi ,
I figured out the solution to this problem. Follwoing 3 things should be
made sure of:
1. Never reinstall reporting services without first uninstalling it
completely... i.e first remove the registry entiries manually then only
reporting services uninstallation is complete.
2. In the RSWebApplication.Config file in Reports Manager , the
ReportServerURL key should have a value as https:/IP(of the report manager
virtual directory)/ReportServer . If in other Report Server and Report
manager .Config files, you find localhost... replace it with the IP of the
virtual directory where reports manager and report server are installed.
3. When you deploy the report, in the configuration properties for the
project .. in the deployment path, again specify the IP instaed of
localhost...
If all these 3 things are taken care of.. then this error will not occur...
When i fixed all these, it worked for me.
pmud
"neokortex" wrote:
> No resolution yet. Since that was a test server and we were/are in the
> process of migrating to a production server, it is not a emergency for us. I
> do know this is a general web service error, not necessarily specfic to RS.
> However if you find the answer please respond. I am curious.
> "Paul" wrote:
> > I am having the exact same problem. ReportServer is working fine, but report
> > manager web interface gives The underlying connection was closed. was there a
> > resolution to this problem?
> >
> > "neokortex" wrote:
> >
> > > thanks for the tip,
> > >
> > > but Im not quite sure this will help me. I checked the extensions for our
> > > ReportServer virtual directory and they are already mapped exactly as
> > > specified in the Support article. Also, ReportServer is working fine in so
> > > far as reports can still be run through it.
> > >
> > > It is only the Report Manager Web UI that is flaking out.
> > >
> > > "bobhug" wrote:
> > >
> > > > Hi!
> > > > We had a similar problem and resolved it by correcting the Applications
> > > > Extensions Mapping for the ReportServer virtual directory. Information about
> > > > configuring Reporting Services' virtual directories is available here:
> > > > http://support.microsoft.com/Default.aspx?kbid=867872
> > > >
> > > > Good luck,
> > > > Bob
> > > >
> > > > "neokortex" wrote:
> > > >
> > > > > Our company recently re-located the servers and somehow in the process of
> > > > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > > > be run. All we get is the error:
> > > > >
> > > > > "The underlying connection was closed: Unable to connect to the remote
> > > > > server."
> > > > >
> > > > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > > > running OK and all reports run fine via our web application and in Visual
> > > > > Studio IDE etc...
> > > > >
> > > > > Any clues?

My Report feature

Currently - our Reporting Services site is setup so that all Domain Users can access it. We are starting to use Report Builder now. I have enabled the My Reports folder feature that that creates a user folder for anyone that logs onto the site. Is there a way to just create the user folders for certain people?

Yes. You do not have to use the "My Reports" function at all. Just create a folder for each user under the Home folder and then assign them at least browser rights to that folder. Also, be sure they have browser rights to the Home folder or they will not be able to see their own folder as this follows a hierachial structure.