Got to be something wrong... http://myserver/reports REALLY slow

Is anyone experiencing the folder.aspx taking a really long time to render
the list of reports? On our server, all other web sites a very quick, but:
opening http://myserver/reports/Pages/Folder.aspx can take as long as 40
seconds to list a few reports!
Thinking it must be an install or configuration issue... any idea?
All comments appreciated.
ThanksThere was a whole thread awhile back that may help you understand the issue:
http://www.msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3031983d-75f9-466c-ad3a-3d76f0bebdc5
--
Adrian M.
MCP
"Rick Matthys" <RickMatthys@.discussions.microsoft.com> wrote in message
news:7B0FF73B-4295-4B3E-AFBA-4B0DF11E9722@.microsoft.com...
> Is anyone experiencing the folder.aspx taking a really long time to render
> the list of reports? On our server, all other web sites a very quick,
> but:
> opening http://myserver/reports/Pages/Folder.aspx can take as long as 40
> seconds to list a few reports!
> Thinking it must be an install or configuration issue... any idea?
> All comments appreciated.
> Thanks|||Try re-starting IIS or ASPNET. I had that problem too, and I
re-started IIS and it helped quite a bit.|||thanks for the response Adrian and John... changed the IIS recycle setting,
restarted IIS, and presto, page comes up a lot faster!
"Adrian M." wrote:
> There was a whole thread awhile back that may help you understand the issue:
> http://www.msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3031983d-75f9-466c-ad3a-3d76f0bebdc5
> --
> Adrian M.
> MCP
>
> "Rick Matthys" <RickMatthys@.discussions.microsoft.com> wrote in message
> news:7B0FF73B-4295-4B3E-AFBA-4B0DF11E9722@.microsoft.com...
> > Is anyone experiencing the folder.aspx taking a really long time to render
> > the list of reports? On our server, all other web sites a very quick,
> > but:
> >
> > opening http://myserver/reports/Pages/Folder.aspx can take as long as 40
> > seconds to list a few reports!
> >
> > Thinking it must be an install or configuration issue... any idea?
> >
> > All comments appreciated.
> >
> > Thanks
>
>sql

Going crazy

Ok, what is the secret, I give.
I have a report with a couple sub reports. The sub reports seem to want to
spread to the complete width of the report plus more causing multiple pages
to be used (for the information that is pushed off the right edge).
I have tried to use tables, rectangles etc. but i cannot get the contents of
the report from spreading. It appears the rectangle works for the report but
the sub reports spread out as much as possible.
I have tried putting the sub reports in rectanges, grids and still have the
problem
I am using vs.net 2005 and sql 2005
Help please.Two things matter here. The design of the subreport and where you put the
subreport on the page. Run the subreport by itself, how big is it? Look at
the layout properties of the subreport.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dave" <dave@.discussions.microsoft.com> wrote in message
news:39888271-A207-4302-843F-16B1CA1E6B74@.microsoft.com...
> Ok, what is the secret, I give.
> I have a report with a couple sub reports. The sub reports seem to want
> to
> spread to the complete width of the report plus more causing multiple
> pages
> to be used (for the information that is pushed off the right edge).
> I have tried to use tables, rectangles etc. but i cannot get the contents
> of
> the report from spreading. It appears the rectangle works for the report
> but
> the sub reports spread out as much as possible.
> I have tried putting the sub reports in rectanges, grids and still have
> the
> problem
> I am using vs.net 2005 and sql 2005
> Help please.
>

glyphs

When I export reports in pdf, I have glyphs in some textbox, I use Arial
normal 8, and I checked, the font is installed on the server and the client.
I only have the problem in acrobat 5. Any solution?Adobe 5.00 and 5.05 do not render symbols correctly when the Arial font is
used.
This table outlines some testing I did to determine how various Acrobat
versions behave when attempting to render the euro symbol. The results
should apply to symbols in general.
Version Font Handle Euro Notes
5.00 Arial No The text is also trashed when
the euro symbol is in the string, The text renders
5.05 correctly when the euro
symbol is removed.
5.10 Arial Yes The text and euro symbol render
correctly.
6.00
5.00 Tahoma Yes When this font is used the string and
euro symbol
5.50 rendered correctly.
5.10
6.00
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"raph" <raph@.discussions.microsoft.com> wrote in message
news:04488328-BAC7-4DCE-85D4-83A88D11A8E9@.microsoft.com...
> When I export reports in pdf, I have glyphs in some textbox, I use Arial
> normal 8, and I checked, the font is installed on the server and the
> client.
> I only have the problem in acrobat 5. Any solution?|||Thanks for your answer, but I am not using euro symbol, here is the text
"Anal. production, Syst. Décisionnels.â' Consultant". I think the problem is
"-".
Do you thing that changing font will resolve the problem?
"Bruce Johnson [MSFT]" wrote:
> Adobe 5.00 and 5.05 do not render symbols correctly when the Arial font is
> used.
> This table outlines some testing I did to determine how various Acrobat
> versions behave when attempting to render the euro symbol. The results
> should apply to symbols in general.
> Version Font Handle Euro Notes
> 5.00 Arial No The text is also trashed when
> the euro symbol is in the string, The text renders
> 5.05 correctly when the euro
> symbol is removed.
> 5.10 Arial Yes The text and euro symbol render
> correctly.
> 6.00
> 5.00 Tahoma Yes When this font is used the string and
> euro symbol
> 5.50 rendered correctly.
> 5.10
> 6.00
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "raph" <raph@.discussions.microsoft.com> wrote in message
> news:04488328-BAC7-4DCE-85D4-83A88D11A8E9@.microsoft.com...
> > When I export reports in pdf, I have glyphs in some textbox, I use Arial
> > normal 8, and I checked, the font is installed on the server and the
> > client.
> > I only have the problem in acrobat 5. Any solution?
>
>|||Everything is perfect with the font Microsoft Sans Sherif!!
"raph" wrote:
> When I export reports in pdf, I have glyphs in some textbox, I use Arial
> normal 8, and I checked, the font is installed on the server and the client.
> I only have the problem in acrobat 5. Any solution?

Globale Function

Hi !

Is it possible to declare a gloable function in reportServer that all reports could access? For each reports that use the same function i've declared it in the code property of the rapport but it will be easier if i could share the function for all reports.

Thanks !

You could move the functions into a custom assembly. Check the "custom assembly" section of this BOL page: http://msdn2.microsoft.com/en-us/library/ms155798.aspx

-- Robert

Global variable for hyperlinks in reports

We are using Reporting Services 2000. We have several reports that all
contain an "Edit" hyperlink that goes to a URL not related to the report
server url. We cannot directly enter this URL into the "Jump To" section,
because the url is different depending on the environment (dev, test,
production). So, because the reports uploaded in dev, test, and production
need to be identical, we need to get to this url some other way.
Ideally, we could upload a text file or enter some type of global variable
in the Report Manager that all the reports could access. The contents of
that variable/file would then be used to get the value for the "Jump To"
field of the hyperlink.
Does anyone have any ideas on the best way to accomplish this? Thanks!First off, you would want to use Jump to URL, not Jump to Report. The URL
can be an expression.
You could have a Report Parameter but that gets a little cumbersome. What I
suggest is having a dataset that has a single value that determines whether
it is test, dev, production. It could query a table that returns this value.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <dilworth@.newsgroups.nospam> wrote in message
news:F8AD4F01-FB63-44EE-9900-E72F8A2845BD@.microsoft.com...
> We are using Reporting Services 2000. We have several reports that all
> contain an "Edit" hyperlink that goes to a URL not related to the report
> server url. We cannot directly enter this URL into the "Jump To" section,
> because the url is different depending on the environment (dev, test,
> production). So, because the reports uploaded in dev, test, and
> production
> need to be identical, we need to get to this url some other way.
> Ideally, we could upload a text file or enter some type of global variable
> in the Report Manager that all the reports could access. The contents of
> that variable/file would then be used to get the value for the "Jump To"
> field of the hyperlink.
> Does anyone have any ideas on the best way to accomplish this? Thanks!|||That worked great - thanks!
"Bruce L-C [MVP]" wrote:
> First off, you would want to use Jump to URL, not Jump to Report. The URL
> can be an expression.
> You could have a Report Parameter but that gets a little cumbersome. What I
> suggest is having a dataset that has a single value that determines whether
> it is test, dev, production. It could query a table that returns this value.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "David" <dilworth@.newsgroups.nospam> wrote in message
> news:F8AD4F01-FB63-44EE-9900-E72F8A2845BD@.microsoft.com...
> > We are using Reporting Services 2000. We have several reports that all
> > contain an "Edit" hyperlink that goes to a URL not related to the report
> > server url. We cannot directly enter this URL into the "Jump To" section,
> > because the url is different depending on the environment (dev, test,
> > production). So, because the reports uploaded in dev, test, and
> > production
> > need to be identical, we need to get to this url some other way.
> >
> > Ideally, we could upload a text file or enter some type of global variable
> > in the Report Manager that all the reports could access. The contents of
> > that variable/file would then be used to get the value for the "Jump To"
> > field of the hyperlink.
> >
> > Does anyone have any ideas on the best way to accomplish this? Thanks!
>
>

global constant for multiple reports

I have a set of 25 reports that contain the links to the other application
(URL). Is there a way to define a single "global" string for all the reports
to quickly replace that url with the right one? Let's say it's
http://testingserver/app for testing, and http://production/app for
production. I hate to change the link value on every report. Using custom
assemblies to keep such common references looks like too much overhead. Are
there any other global report configuration options I'm missing?
--
Regards,
Dmitry DuginovHello Dmitry,
You could do this in the VS.NET 2005 IDE.
Click the Edit -> Find and Replace -> Replace in Files.
Type the http://testingserver/app in the Find what section, and type
http://production/app in the Replace with section.
Then, click the Find options and type *.rdl in the Look at these file types.
And then, you could click replace all button and all the files in your
solutionn will be modified.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Sorry, but this "approach" just doesn't sound right. It's
"hardcode-change-redeploy". How it's better than "hardcode-change-recomplie"
for regular applications? It's not; that's why we are always trying to keep
some variables in config files: to change them, not the source code...
D.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:zH9Hlb%239GHA.4432@.TK2MSFTNGXA01.phx.gbl...
> You could do this in the VS.NET 2005 IDE.
> Click the Edit -> Find and Replace -> Replace in Files.
> Type the http://testingserver/app in the Find what section, and type
> http://production/app in the Replace with section.
> Then, click the Find options and type *.rdl in the Look at these file
types.
> And then, you could click replace all button and all the files in your
> solutionn will be modified.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
>
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Dmitry,
You could not do this in the Reporting Services Designer.
Since the RDL file is a XML format file, you could modify the xml file
before you deploy to the report server.
This is the only approach you could do in the reporting services.
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.

global code

Is there a place where I can put custom code so that all reports in a
solution can access the same code?
I now copy the code into every new report I createYou can have assemblies that are shared between reports. Search books on
line for custom code and it will tell you all about it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Servé La" <blabla@.bestaatniet.nl> wrote in message
news:uTpyCPrCFHA.3924@.TK2MSFTNGP15.phx.gbl...
> Is there a place where I can put custom code so that all reports in a
> solution can access the same code?
> I now copy the code into every new report I create
>|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schreef in bericht
news:%2393IKdsCFHA.3376@.TK2MSFTNGP12.phx.gbl...
> You can have assemblies that are shared between reports. Search books on
> line for custom code and it will tell you all about it.
Thats not what I meant. The code for calling the assemblies will have to be
duplicated in every report one creates.|||Servé La wrote:
> Thats not what I meant. The code for calling the assemblies will have
> to be duplicated in every report one creates.
I did'nt understand your question. Each report is like a single programm.
If i need an assembly in two programms, i have to write
IMPORTS myassemblyclass
in BOTH programms
frank|||I haven't done this but I think it would work. It looks to me that
report.rdl in this directory:
C:\Program Files\Microsoft SQL Server\80\Tools\Report
Designer\ProjectItems\ReportProject
Is what is used by the report wizard. My guess is if you change this then
all the new reports would have the code. Save a copy of it just in case. Let
me know if that works for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Servé La" <blabla@.bestaatniet.nl> wrote in message
news:uS0vSqsCFHA.3324@.TK2MSFTNGP15.phx.gbl...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schreef in bericht
> news:%2393IKdsCFHA.3376@.TK2MSFTNGP12.phx.gbl...
> > You can have assemblies that are shared between reports. Search books on
> > line for custom code and it will tell you all about it.
> Thats not what I meant. The code for calling the assemblies will have to
be
> duplicated in every report one creates.
>|||"Frank Matthiesen" <fm@.xax.de> schreef in bericht
news:36hi9eF50g2hqU1@.individual.net...
> Servé La wrote:
> > Thats not what I meant. The code for calling the assemblies will have
> > to be duplicated in every report one creates.
> I did'nt understand your question. Each report is like a single programm.
> If i need an assembly in two programms, i have to write
> IMPORTS myassemblyclass
> in BOTH programms
Suppose you have created a component where you have to set a few properties
and then calculate some value.
You create a function for this like the following:
Function Compute(name as String, x as Integer, y as Integer, z as Integer)
as Integer
Dim obj as new MyComponents.Component(name)
obj.X = x
obj.Y = y
obj.Z = z
Try
Compute = obj.Compute()
Catch e as OopsException
Compute = -1
End Try
End Function
You then want to use this function in a few reports. Right now I see no
other way then to put that code in every report and call it, while I
expected to put that function somewhere globally where all reports could
access it. In reality the code gets a lot more complex very fast.|||Could you not store the function as a 'stored procedure' in the database
then just call the stored procedure as you need it?
Dale
"Servé La" <blabla@.bestaatniet.nl> wrote in message
news:%23whb6AtCFHA.1188@.tk2msftngp13.phx.gbl...
> "Frank Matthiesen" <fm@.xax.de> schreef in bericht
> news:36hi9eF50g2hqU1@.individual.net...
> > Servé La wrote:
> > > Thats not what I meant. The code for calling the assemblies will have
> > > to be duplicated in every report one creates.
> >
> > I did'nt understand your question. Each report is like a single
programm.
> > If i need an assembly in two programms, i have to write
> > IMPORTS myassemblyclass
> > in BOTH programms
> Suppose you have created a component where you have to set a few
properties
> and then calculate some value.
> You create a function for this like the following:
> Function Compute(name as String, x as Integer, y as Integer, z as Integer)
> as Integer
> Dim obj as new MyComponents.Component(name)
> obj.X = x
> obj.Y = y
> obj.Z = z
> Try
> Compute = obj.Compute()
> Catch e as OopsException
> Compute = -1
> End Try
> End Function
> You then want to use this function in a few reports. Right now I see no
> other way then to put that code in every report and call it, while I
> expected to put that function somewhere globally where all reports could
> access it. In reality the code gets a lot more complex very fast.
>|||You are not being consistent here. On the one hand you said you understood
about using custom assemblies. On the other hand you posted this. Your code
can go in a custom assembly once. Then all you have to do is reference that
assembly in your reports. You do not have to have that function defined in
each and every report.
As I suggested before, read up on custom code. You can do custom code two
ways, code behind report and in your own assembly. What you are talking
about here is code behind report.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Servé La" <blabla@.bestaatniet.nl> wrote in message
news:%23whb6AtCFHA.1188@.tk2msftngp13.phx.gbl...
> "Frank Matthiesen" <fm@.xax.de> schreef in bericht
> news:36hi9eF50g2hqU1@.individual.net...
> > Servé La wrote:
> > > Thats not what I meant. The code for calling the assemblies will have
> > > to be duplicated in every report one creates.
> >
> > I did'nt understand your question. Each report is like a single
programm.
> > If i need an assembly in two programms, i have to write
> > IMPORTS myassemblyclass
> > in BOTH programms
> Suppose you have created a component where you have to set a few
properties
> and then calculate some value.
> You create a function for this like the following:
> Function Compute(name as String, x as Integer, y as Integer, z as Integer)
> as Integer
> Dim obj as new MyComponents.Component(name)
> obj.X = x
> obj.Y = y
> obj.Z = z
> Try
> Compute = obj.Compute()
> Catch e as OopsException
> Compute = -1
> End Try
> End Function
> You then want to use this function in a few reports. Right now I see no
> other way then to put that code in every report and call it, while I
> expected to put that function somewhere globally where all reports could
> access it. In reality the code gets a lot more complex very fast.
>|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schreef in bericht
news:uvhbbYtCFHA.2540@.TK2MSFTNGP09.phx.gbl...
> You are not being consistent here. On the one hand you said you understood
> about using custom assemblies. On the other hand you posted this. Your
code
> can go in a custom assembly once. Then all you have to do is reference
that
> assembly in your reports. You do not have to have that function defined in
> each and every report.
> As I suggested before, read up on custom code. You can do custom code two
> ways, code behind report and in your own assembly. What you are talking
> about here is code behind report.
I guess I meant code behind then. I have some cases where methods need to be
called from code behind in a certain order so it would be nice to have this
functionality in one single function defined somewhere globally.
I take it the answer is "no you cant do this" then :)|||You are still missing the point. You can have code behind and you can have
custom assemblies. You can definitely put your common functions in a custom
assembly that all your reports will use. You can have both code behind and
custom assemblies. The tricky part of custom assemblies is deployment of the
assembly.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Servé La" <blabla@.bestaatniet.nl> wrote in message
news:%233S6lYODFHA.3256@.tk2msftngp13.phx.gbl...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schreef in bericht
> news:uvhbbYtCFHA.2540@.TK2MSFTNGP09.phx.gbl...
> > You are not being consistent here. On the one hand you said you
understood
> > about using custom assemblies. On the other hand you posted this. Your
> code
> > can go in a custom assembly once. Then all you have to do is reference
> that
> > assembly in your reports. You do not have to have that function defined
in
> > each and every report.
> >
> > As I suggested before, read up on custom code. You can do custom code
two
> > ways, code behind report and in your own assembly. What you are talking
> > about here is code behind report.
> I guess I meant code behind then. I have some cases where methods need to
be
> called from code behind in a certain order so it would be nice to have
this
> functionality in one single function defined somewhere globally.
> I take it the answer is "no you cant do this" then :)
>|||"BruceLC" <brucelc@.newsgroup.nospam> schreef in bericht
news:OOGvMxRDFHA.1040@.TK2MSFTNGP09.phx.gbl...
> You are still missing the point. You can have code behind and you can have
> custom assemblies. You can definitely put your common functions in a
custom
> assembly that all your reports will use. You can have both code behind and
> custom assemblies. The tricky part of custom assemblies is deployment of
the
> assembly.
I am talking about calling a custom assembly from code behind! It's about
both!!
The methods in the custom assembly need to be called within a certain order
so this has to be done in code behind.|||Try putting your common code in a custom assembly and then placing it into
GAC
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Servé La" <blabla@.bestaatniet.nl> wrote in message
news:uTpyCPrCFHA.3924@.TK2MSFTNGP15.phx.gbl...
> Is there a place where I can put custom code so that all reports in a
> solution can access the same code?
> I now copy the code into every new report I create
>

Global and Shared variables of Crystal

I have been converting a crystal report to MSRS. Crystal allows sharing variables (called shared variables) between main reports and it's subreports. Also, it has a concept of global variables which are available throughout a report. Many decisions (e.g. hiding the footer of a report) are based on these type of variables.
How can we achieve this in MSRS ? Do we have something i can add to Report Code which works as a global variable/shared variable Or there is any worwround available in general.
Imperative to mention that i shall be using seperate datasets for subreports of CR for performance reasons as suggested in BOL.
Thanks.Variables can not be shared across multiple reports. You can pass parameters
between reports however...When you call a subreport, pass whatever
information you need as parameters.
You can also use parameters as global variables within a single report...
SP1 allows parameters to be hidden so they do not appear on the user
selection list... Create the parameter and hide it... Then use the
Parameters collection to refer to it...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"push" <push@.discussions.microsoft.com> wrote in message
news:3E941DF6-2AEE-4F24-9145-D7A5CCDDDDAB@.microsoft.com...
> I have been converting a crystal report to MSRS. Crystal allows sharing
variables (called shared variables) between main reports and it's
subreports. Also, it has a concept of global variables which are available
throughout a report. Many decisions (e.g. hiding the footer of a report) are
based on these type of variables.
> How can we achieve this in MSRS ? Do we have something i can add to Report
Code which works as a global variable/shared variable Or there is any
worwround available in general.
> Imperative to mention that i shall be using seperate datasets for
subreports of CR for performance reasons as suggested in BOL.
> Thanks.