Microsoft Reports

I am trying to create some reports in MS Visual Studio Express. Is there way to make report viewer or report templates available in Visual Studio Express ?

Hi,

Do you mean those express editions like Visual Web Developer, right?

Business Intelligence Development Studio is the environment that you will use to develop reports and report models in SQL Server 2005 Reporting Services. Business Intelligence Development Studio is theMicrosoft Visual Studio 2005 environment with enhancements that are specific to SQL Server 2005 business intelligence solutions.

Thanks.

Microsoft Reporting Technologies

It seems there are several current reporting mechanisms related to .net and Visual Studio. There is Crystal Reports, an integrated reporting system in Visual Studio and a somewhat related reporting system in SQL Server. The last two seem to use similar .xml bases but it's unclear how or if they are related. This does not include (or maybe is does) the Sharepoint reporting system.

I have eliminated the Crystal Report for various reasons after trying it for awhile. Therefore is there some good introductions and/or comparisons between the Visual Studio reporting system and the SQL Server or BI reporting systems since they both seem to use .rdlc and .rdl type definitions. How or are they related?

Try this link where you can find the answers for your questions

http://msdn2.microsoft.com/en-us/library/ms170246.aspx

sql

Microsoft help! Trying to send reports via email using RS2000

I keep getting these errorrs. I am using RS 2000. What does this mean and
how do I fix this issue?
2007-09-25 11:00:25 - + [000] Schedule 143 has already been cached by job
0xF155CEC465AE154F8A73A19FB303190D
2007-09-25 11:01:02 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 143
2007-09-25 11:01:02 - + [163] 1 operations applied (0 remaining)
2007-09-25 11:03:32 - + [000] Schedule 144 has already been cached by job
0xEA305CE0F980DA49B68D71B6CC693AA9
2007-09-25 11:04:01 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 144
2007-09-25 11:04:01 - + [163] 1 operations applied (0 remaining)On Sep 25, 10:24 am, OriginalStealth
<OriginalStea...@.discussions.microsoft.com> wrote:
> I keep getting these errorrs. I am using RS 2000. What does this mean and
> how do I fix this issue?
> 2007-09-25 11:00:25 - + [000] Schedule 143 has already been cached by job
> 0xF155CEC465AE154F8A73A19FB303190D
> 2007-09-25 11:01:02 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 143
> 2007-09-25 11:01:02 - + [163] 1 operations applied (0 remaining)
> 2007-09-25 11:03:32 - + [000] Schedule 144 has already been cached by job
> 0xEA305CE0F980DA49B68D71B6CC693AA9
> 2007-09-25 11:04:01 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 144
> 2007-09-25 11:04:01 - + [163] 1 operations applied (0 remaining)
This link might be helpful.
http://support.microsoft.com/kb/295378
Regards,
Enrique Martinez
Sr. Software Consultant

Microsoft CRM Picklist Fields in Reports

Hi,
I have experience with Crystal Report Designer and Microsoft CRM. I am now
writing reports in SQL Reporting Services. In Crystal when you add a
picklist field to a report you are able to pick a field called
CaseTypeCodeName and it automatically associates the IncidentBase table to
the StringMap table so that the values for the picklist field automatically
show up.
I do not see that feature in SQL Reporting Services. What I am wondering is
how did people get around this? Do I need a special SQL query to pull this
information?
Thanks!!Yeah, just create a UDF that pulls the appropriate StringMap value.
"Amy" <Amy@.discussions.microsoft.com> wrote in message
news:F6800BE4-2DA9-4803-88D6-4DBEEB170502@.microsoft.com...
> Hi,
> I have experience with Crystal Report Designer and Microsoft CRM. I am
now
> writing reports in SQL Reporting Services. In Crystal when you add a
> picklist field to a report you are able to pick a field called
> CaseTypeCodeName and it automatically associates the IncidentBase table to
> the StringMap table so that the values for the picklist field
automatically
> show up.
> I do not see that feature in SQL Reporting Services. What I am wondering
is
> how did people get around this? Do I need a special SQL query to pull
this
> information?
> Thanks!!

Microsoft Atlas in Reports?

Can Atlas popups be used in reporting services?

Currently I have a javascript pop-up link that opens a new window. What I would like to do is change this to open an Atlas popup.

Thanks

can this be done?

Microsoft Atlas in Reports?

Can Atlas popups be used in reporting services?

Currently I have a javascript pop-up link that opens a new window. What I would like to do is change this to open an Atlas popup.

Thanks

can this be done?

Microsft Development Environment - Missing Toolbox Items

Hi,
I had some problems with the MDE application used to create reporting services reports, and rectified the problem by running the program with the command switch /resetskippkgs. Since doing this, my toolbox has lost all the controls used to design a reporting services report (e.g. Matrix, Table, Image etc).
Anyone know how I can get these back? I've tried doing a repair on the installation of the application, but no joy.
Thanks.
SimonRight-click in the toolbox, choose Add/Remove Items, and click the Reset
button.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:F7117049-4270-49A4-A9D0-08CDAB6D70A9@.microsoft.com...
> Hi,
> I had some problems with the MDE application used to create reporting
services reports, and rectified the problem by running the program with the
command switch /resetskippkgs. Since doing this, my toolbox has lost all
the controls used to design a reporting services report (e.g. Matrix, Table,
Image etc).
> Anyone know how I can get these back? I've tried doing a repair on the
installation of the application, but no joy.
> Thanks.
> Simon

MICR Font Issue When Exporting to PDF

Hi,

I'm using Reporting Service to print checks. Everything seems ok when I design and deploy and view the reports. But when I try to export to pdf, the MICR font I'm using does not work. I've tried a couple of different MICR fonts from the web and they either get replaced by a standard font or disappear altogether. I would love to know why that is.

Thanks in advance,

Tom

Hi Tom,

I am having the same problem did you by any chance solve this problem?

Thanks

|||

We don't embed fonts in the PDF. This means the font needs to be installed on the machine you are opening the pdf on.

|||

Hi Tom

Thanks for replying

But i tryed even to Open the PDF on the same mechine that i am running the SSRS Report From that has the micr font in it , and still dont see the Micr Font in the PDF at all not even substitute with a other font what could be the problem?

Thanks

|||anyone have a answer for this?|||Microsoft tech support says the font must be a True Type font. Also, for some reason, the fonts seem not to work at 12pt or above. 10 and 11 pt seems to work fine.|||Witch font are you using that works with 10 and 11 pt becuase my font dose not work with this either so can you tell me witch micr font are you using?|||so can you please tell me which micr font will work by pdf export?|||

Like Ryan said, make sure you have the font installed on both the server and on the client.

I have seen several barcode fonts that do not include the correct spacing or at least do not report the correct spacing through the Win32 APIs our PDF renderer calls. It's also very possible we have a bug in that area.

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

I am facing the same problem. The text in MICR Font disappears when i render the report to PDF.

Is there any solution/workaround for this problem?

|||

Ok... we found a solution.

Increase the height and width of the textbox, which contains the text in MICR font.

that solved our issue

|||Could you help me fix my MICR report like you fixed yours? I tried increasing the height and width of the text box. I need help ASAP. Thanks|||Make sure the MICR font is on the same mechine that you open the pdf and leva space fot the height and the width and try woth Size 12 max this worked by me|||I tried that. Could you send me a .rdl file by email? I would appreciate that.|||

can also be that your rdl file is corupted so try the same on a other rdl file with same font and a text box the hight be bigger than the font and see then

also check the pdf file by CTRL-D fonts tab check if the pdf has the font in it, if it dose you shuld be good to go just play around with the Height if the text box

btw: no email address is specified

MICR Font Issue When Exporting to PDF

Hi,

I'm using Reporting Service to print checks. Everything seems ok when I design and deploy and view the reports. But when I try to export to pdf, the MICR font I'm using does not work. I've tried a couple of different MICR fonts from the web and they either get replaced by a standard font or disappear altogether. I would love to know why that is.

Thanks in advance,

Tom

Hi Tom,

I am having the same problem did you by any chance solve this problem?

Thanks

|||

We don't embed fonts in the PDF. This means the font needs to be installed on the machine you are opening the pdf on.

|||

Hi Tom

Thanks for replying

But i tryed even to Open the PDF on the same mechine that i am running the SSRS Report From that has the micr font in it , and still dont see the Micr Font in the PDF at all not even substitute with a other font what could be the problem?

Thanks

|||anyone have a answer for this?|||Microsoft tech support says the font must be a True Type font. Also, for some reason, the fonts seem not to work at 12pt or above. 10 and 11 pt seems to work fine.|||Witch font are you using that works with 10 and 11 pt becuase my font dose not work with this either so can you tell me witch micr font are you using?|||so can you please tell me which micr font will work by pdf export?|||

Like Ryan said, make sure you have the font installed on both the server and on the client.

I have seen several barcode fonts that do not include the correct spacing or at least do not report the correct spacing through the Win32 APIs our PDF renderer calls. It's also very possible we have a bug in that area.

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

I am facing the same problem. The text in MICR Font disappears when i render the report to PDF.

Is there any solution/workaround for this problem?

|||

Ok... we found a solution.

Increase the height and width of the textbox, which contains the text in MICR font.

that solved our issue

|||Could you help me fix my MICR report like you fixed yours? I tried increasing the height and width of the text box. I need help ASAP. Thanks|||Make sure the MICR font is on the same mechine that you open the pdf and leva space fot the height and the width and try woth Size 12 max this worked by me|||I tried that. Could you send me a .rdl file by email? I would appreciate that.|||

can also be that your rdl file is corupted so try the same on a other rdl file with same font and a text box the hight be bigger than the font and see then

also check the pdf file by CTRL-D fonts tab check if the pdf has the font in it, if it dose you shuld be good to go just play around with the Height if the text box

btw: no email address is specified

MICR Font Issue When Exporting to PDF

Hi,

I'm using Reporting Service to print checks. Everything seems ok when I design and deploy and view the reports. But when I try to export to pdf, the MICR font I'm using does not work. I've tried a couple of different MICR fonts from the web and they either get replaced by a standard font or disappear altogether. I would love to know why that is.

Thanks in advance,

Tom

Hi Tom,

I am having the same problem did you by any chance solve this problem?

Thanks

|||

We don't embed fonts in the PDF. This means the font needs to be installed on the machine you are opening the pdf on.

|||

Hi Tom

Thanks for replying

But i tryed even to Open the PDF on the same mechine that i am running the SSRS Report From that has the micr font in it , and still dont see the Micr Font in the PDF at all not even substitute with a other font what could be the problem?

Thanks

|||anyone have a answer for this?|||Microsoft tech support says the font must be a True Type font. Also, for some reason, the fonts seem not to work at 12pt or above. 10 and 11 pt seems to work fine.|||Witch font are you using that works with 10 and 11 pt becuase my font dose not work with this either so can you tell me witch micr font are you using?|||so can you please tell me which micr font will work by pdf export?|||

Like Ryan said, make sure you have the font installed on both the server and on the client.

I have seen several barcode fonts that do not include the correct spacing or at least do not report the correct spacing through the Win32 APIs our PDF renderer calls. It's also very possible we have a bug in that area.

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

I am facing the same problem. The text in MICR Font disappears when i render the report to PDF.

Is there any solution/workaround for this problem?

|||

Ok... we found a solution.

Increase the height and width of the textbox, which contains the text in MICR font.

that solved our issue

|||Could you help me fix my MICR report like you fixed yours? I tried increasing the height and width of the text box. I need help ASAP. Thanks|||Make sure the MICR font is on the same mechine that you open the pdf and leva space fot the height and the width and try woth Size 12 max this worked by me|||I tried that. Could you send me a .rdl file by email? I would appreciate that.|||

can also be that your rdl file is corupted so try the same on a other rdl file with same font and a text box the hight be bigger than the font and see then

also check the pdf file by CTRL-D fonts tab check if the pdf has the font in it, if it dose you shuld be good to go just play around with the Height if the text box

btw: no email address is specified

MICR Font Issue When Exporting to PDF

Hi,

I'm using Reporting Service to print checks. Everything seems ok when I design and deploy and view the reports. But when I try to export to pdf, the MICR font I'm using does not work. I've tried a couple of different MICR fonts from the web and they either get replaced by a standard font or disappear altogether. I would love to know why that is.

Thanks in advance,

Tom

Hi Tom,

I am having the same problem did you by any chance solve this problem?

Thanks

|||

We don't embed fonts in the PDF. This means the font needs to be installed on the machine you are opening the pdf on.

|||

Hi Tom

Thanks for replying

But i tryed even to Open the PDF on the same mechine that i am running the SSRS Report From that has the micr font in it , and still dont see the Micr Font in the PDF at all not even substitute with a other font what could be the problem?

Thanks

|||anyone have a answer for this?|||Microsoft tech support says the font must be a True Type font. Also, for some reason, the fonts seem not to work at 12pt or above. 10 and 11 pt seems to work fine.|||Witch font are you using that works with 10 and 11 pt becuase my font dose not work with this either so can you tell me witch micr font are you using?|||so can you please tell me which micr font will work by pdf export?|||

Like Ryan said, make sure you have the font installed on both the server and on the client.

I have seen several barcode fonts that do not include the correct spacing or at least do not report the correct spacing through the Win32 APIs our PDF renderer calls. It's also very possible we have a bug in that area.

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

I am facing the same problem. The text in MICR Font disappears when i render the report to PDF.

Is there any solution/workaround for this problem?

|||

Ok... we found a solution.

Increase the height and width of the textbox, which contains the text in MICR font.

that solved our issue

|||Could you help me fix my MICR report like you fixed yours? I tried increasing the height and width of the text box. I need help ASAP. Thanks|||Make sure the MICR font is on the same mechine that you open the pdf and leva space fot the height and the width and try woth Size 12 max this worked by me|||I tried that. Could you send me a .rdl file by email? I would appreciate that.|||

can also be that your rdl file is corupted so try the same on a other rdl file with same font and a text box the hight be bigger than the font and see then

also check the pdf file by CTRL-D fonts tab check if the pdf has the font in it, if it dose you shuld be good to go just play around with the Height if the text box

btw: no email address is specified

MICR Font Issue When Exporting to PDF

Hi,

I'm using Reporting Service to print checks. Everything seems ok when I design and deploy and view the reports. But when I try to export to pdf, the MICR font I'm using does not work. I've tried a couple of different MICR fonts from the web and they either get replaced by a standard font or disappear altogether. I would love to know why that is.

Thanks in advance,

Tom

Hi Tom,

I am having the same problem did you by any chance solve this problem?

Thanks

|||

We don't embed fonts in the PDF. This means the font needs to be installed on the machine you are opening the pdf on.

|||

Hi Tom

Thanks for replying

But i tryed even to Open the PDF on the same mechine that i am running the SSRS Report From that has the micr font in it , and still dont see the Micr Font in the PDF at all not even substitute with a other font what could be the problem?

Thanks

|||anyone have a answer for this?|||Microsoft tech support says the font must be a True Type font. Also, for some reason, the fonts seem not to work at 12pt or above. 10 and 11 pt seems to work fine.|||Witch font are you using that works with 10 and 11 pt becuase my font dose not work with this either so can you tell me witch micr font are you using?|||so can you please tell me which micr font will work by pdf export?|||

Like Ryan said, make sure you have the font installed on both the server and on the client.

I have seen several barcode fonts that do not include the correct spacing or at least do not report the correct spacing through the Win32 APIs our PDF renderer calls. It's also very possible we have a bug in that area.

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

I am facing the same problem. The text in MICR Font disappears when i render the report to PDF.

Is there any solution/workaround for this problem?

|||

Ok... we found a solution.

Increase the height and width of the textbox, which contains the text in MICR font.

that solved our issue

|||Could you help me fix my MICR report like you fixed yours? I tried increasing the height and width of the text box. I need help ASAP. Thanks|||Make sure the MICR font is on the same mechine that you open the pdf and leva space fot the height and the width and try woth Size 12 max this worked by me|||I tried that. Could you send me a .rdl file by email? I would appreciate that.|||

can also be that your rdl file is corupted so try the same on a other rdl file with same font and a text box the hight be bigger than the font and see then

also check the pdf file by CTRL-D fonts tab check if the pdf has the font in it, if it dose you shuld be good to go just play around with the Height if the text box

btw: no email address is specified

Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserName'

my goal is to show reports in sharepoint services 3.0 and use this update Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint

i have this problem:

After update my sql server 2005 to sp2 ctp with SQLServer2005SP2-KB921896-x86-ENU.exe and upate reporting services, try to::1010/reportserver" href="http://links.10026.com/?link=http://_3A1010/reportserver">http://<localserver>:1010/reportserver show the message.

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserName()'.

i this problem is in the Microsoft.ReportingServices.Diagnostics.dll i see the method and in version (9.0.3027.0) dont have, and have in 9.0.1399, what i can do to this work rigth

Just try Microsoft.ReportingServices.Diagnostics.dll 9.0.3033.0 still dont working...........

More Details.........

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3033.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__12_26_2006_12_16_30.log</Path>
<SystemName>CRM</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!1!26-12-2006-12:16:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.MissingMethodException: Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.set_CacheUserName(Boolean)'.
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing EnableRemoteErrors to default value of 'False' because it was not specified in Server system properties.
w3wp!library!1!26-12-2006-12:16:31:: Unhandled exception was caught: System.MissingMethodException: Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserName()'.
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
w3wp!library!1!26-12-2006-12:16:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.MissingMethodException: Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserName()'.
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
End of inner exception stack trace

Dont understand what happend but i was forcing to work, modifing the web.config and them assum the 9.0.3033.00 and works fine ? now can make reports?

But what happen? i think the problem he was assuming 9.00.1399.00 not 9.0.3033.00..... but if anyone have a better explination, please report i lose more then a week to solve this problem.

Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserNa

my goal is to show reports in sharepoint services 3.0 and use this update Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint

i have this problem:

After update my sql server 2005 to sp2 ctp with SQLServer2005SP2-KB921896-x86-ENU.exe and upate reporting services, try to::1010/reportserver" href="http://links.10026.com/?link=http://_3A1010/reportserver">http://<localserver>:1010/reportserver show the message.

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserName()'.

i this problem is in the Microsoft.ReportingServices.Diagnostics.dll i see the method and in version (9.0.3027.0) dont have, and have in 9.0.1399, what i can do to this work rigth

Just try Microsoft.ReportingServices.Diagnostics.dll 9.0.3033.0 still dont working...........

More Details.........

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3033.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__12_26_2006_12_16_30.log</Path>
<SystemName>CRM</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!1!26-12-2006-12:16:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.MissingMethodException: Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.set_CacheUserName(Boolean)'.
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing EnableRemoteErrors to default value of 'False' because it was not specified in Server system properties.
w3wp!library!1!26-12-2006-12:16:31:: Unhandled exception was caught: System.MissingMethodException: Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserName()'.
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
w3wp!library!1!26-12-2006-12:16:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.MissingMethodException: Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserName()'.
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
End of inner exception stack trace

Dont understand what happend but i was forcing to work, modifing the web.config and them assum the 9.0.3033.00 and works fine ? now can make reports?

But what happen? i think the problem he was assuming 9.00.1399.00 not 9.0.3033.00..... but if anyone have a better explination, please report i lose more then a week to solve this problem.

Metadata documentation

We're getting ready to launch Reporting Services and are looking for a way to
document the business logic and metadata behind the reports. Does reporting
Svc. offer a quick & easy way to do this?You have access to the RDL, which is stored in the database, along with the
other metadata... Perhaps you can write something to do what you wish...
What exactly do you want to do?
--
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
"BL" <BL@.discussions.microsoft.com> wrote in message
news:41C4F351-A803-4445-8F15-B855B74DD86F@.microsoft.com...
> We're getting ready to launch Reporting Services and are looking for a way
> to
> document the business logic and metadata behind the reports. Does
> reporting
> Svc. offer a quick & easy way to do this?
>|||We want to be able to document the business logic behind the report, and
store it with the report so that it's readily available.
What's the RDL stand for?|||RDL = Report Definition Language
See also: http://www.microsoft.com/sql/reporting/techinfo/rdlspec.mspx
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"BL" <BL@.discussions.microsoft.com> wrote in message
news:B23DC42D-CAE1-4AE0-A391-40F27C121AC5@.microsoft.com...
> We want to be able to document the business logic behind the report, and
> store it with the report so that it's readily available.
> What's the RDL stand for?
>|||Hi,
I am also interested in metadata documentation and report specification.
Did you find any useful tools, or does anyone else know of any?
Richard
"BL" wrote:
> We want to be able to document the business logic behind the report, and
> store it with the report so that it's readily available.
> What's the RDL stand for?
>

messed up password

I changed the password for the reporting service account on the AD server,
now I can't access my reports. I keep getting logon failed, and every 5
seconds I get logon failures on teh sql server. If I stop the service on
the sql server, the errors go away. I changed the password for the service,
which did not help. Where can I fix this?
Thanks,
Robert ElderThis is a multi-part message in MIME format.
--=_NextPart_000_00DC_01C50F79.58A0A670
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Have you tried this...?
To change Reporting Services access to DB after password changed for =Windows Authentication:
At a Command Prompt, run:
rsconfig -c -u <<The RS UserID>> -p <<The RS User's Password>> -s =<<The RS Server Name>> - d ReportServer -a windows
Should get:
The command completed successfully
BTW: "-d ReportServer" is the name of the database in SQL Server. "-a =windows" says "Windows Authentication"
If you need help on rsconfig, type "rsconfig -h" at the command =prompt.
"Robert Elder" <bobe@.realtechllc.com> wrote in message =news:Oe$c5twDFHA.392@.TK2MSFTNGP14.phx.gbl...
> I changed the password for the reporting service account on the AD =server, > now I can't access my reports. I keep getting logon failed, and every =5 > seconds I get logon failures on teh sql server. If I stop the service =on > the sql server, the errors go away. I changed the password for the =service, > which did not help. Where can I fix this?
> > Thanks,
> Robert Elder > >
--=_NextPart_000_00DC_01C50F79.58A0A670
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Have you tried this...?
To change Reporting Services access to DB after =password changed for Windows Authentication:
At a Command Prompt, run:
rsconfig -c -u <> -p <> -s <> - d ReportServer -a windows
Should get:
The command completed successfully
BTW: "-d ReportServer" is the name of =the database in SQL Server. "-a windows" says "Windows =Authentication"
If you need help on rsconfig, type ="rsconfig -h" at the command prompt.
"Robert Elder" =wrote in message news:Oe$c5twDFHA.392@.TK2MSFTNGP14.phx.gbl...> I =changed the password for the reporting service account on the AD server, > =now I can't access my reports. I keep getting logon failed, and every 5 => seconds I get logon failures on teh sql server. If I stop the =service on > the sql server, the errors go away. I changed the =password for the service, > which did not help. Where can I fix =this?> > Thanks,> Robert Elder > > =

---

--=_NextPart_000_00DC_01C50F79.58A0A670--

Message for Blank Reports

Sometimes there are cases where no records match the selection criteria. When that occurs, I want to display a message such as "No Data This Report". Preferably this would be where you would expect to see the first detail line.
I would appreciate any ideas on this. Thanks.If you call the report fron Front end, check whether there are records for the query used in CR. If there are no records then call the Blank Report which display "No Records Found". So you have to have two records; one actual report and other one is dummy|||Tried it and it works great. Thanks a bunch!

Message Box In Reporting services

Hello,

I am using sql reporting services 2000. I have tried to put a message box in my reports using a VB function. If the report contains 10 pages, the message box pops up 10 times. What do i need to do to make the message box pop up only once during the start of the report? Also, if I click CANCEL(vbOkCancel), the cursor should go back to the parameter box prompting me to enter a parameter again. In this case, I enter a date and check whether it is a MONDAY or not. VB function is as below...

Function CheckDay(ByVal S As DateTime) As Integer
Dim GivenDate as Date
Dim GivenDay as Integer
Dim intMsg as Integer
GivenDate = S
GivenDay = WeekDay(GivenDate)
If NOT GivenDay = 2
intMsg = MsgBox("The selected day is not a Monday", VbOKCancel, "The selected date is not a Monday.")
End IF

Return GivenDay
End Function

Thanks......

I recommend to use the ReportViewer control (www.gotreportviewer.com) of VS 2005 instead and build your own parameter user interface to perform the validation. Once, the validation succeeds, you would use the ReportViewer control to display the report.

The approach you are currently trying won't work. Also keep in mind that the message box pop up will only work when running that report in preview. It won't work for reports deployed on a report server.

-- Robert

message box in reporting services

I have used this code pasted below to show message box in reports in Reporting services 2000.It works and pops up but only in development environment but not in production.I mean to say it works in Preview mode but when I have deployed the report it doesn't work.Doesn't even show any error message.

I don't know what would be the code and which assembly file should i Include. Any Ideas ......

Public Function FixDigits(ByVal s As string)
dim msg1 as string
msg1="Parameter is not a 20 digit number"
dim msg2 as string
msg2= "Parameter is not a number"

Dim title As String
title="Attention"
Dim style As MsgBoxStyle
Dim response As MsgBoxResult

style = MsgBoxStyle.OKONLY
if len(s)<>20 then
response = MsgBox(msg1, style, title)

elseif IsNumeric(s)=false then
response = MsgBox(msg2, style, title)

else
end if

End Function

It depends on the client you use to generate the reports. If it is an IDE (Visual Studio), the message box is displayed as it has VB runtime loaded on it. If it is a browser or a client application thru web services, it cannot be communicated to the client as they dont have VB runtime (it is available only on the report server).

Shyam

|||I guess that this is actually releated to another problem. The Messagebox command is executed on the server not on the client, so if the server and the client is one box (as in local development) you probably see the error message while after deploying the report to the report server you won′t see it.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Thanks a lot .Now it makes sense to me .

Merging two reports into one excel workbook.

Hallo all,
Its vey urgent for me ,please help me to solve the problem.
I am having two reports in a report project. when exporting to excel , I
have to export these two reports into a single excel workbook. Each report
should be exported to different sheets in same workbook. How is it possible?
Please help me.
I am really badly in need of help
thanks in advance to all
miikaOk, it can be done. Place a Subreport control in the main report (Report1)
and refer the other report(Report2) and place a Rectangle on the subreport
and on the properties check "insert before rectangle" there by it gives
pagination, which is the main thing for creating multiple sheets. now export
the main report you get both the reports in a single workbook but 2 sheets.
Check out.
Amarnath, MCTS.
"aka" wrote:
> Hallo all,
> Its vey urgent for me ,please help me to solve the problem.
> I am having two reports in a report project. when exporting to excel , I
> have to export these two reports into a single excel workbook. Each report
> should be exported to different sheets in same workbook. How is it possible?
> Please help me.
> I am really badly in need of help
> thanks in advance to all
> miika|||Hi,
Thanks alot for your valuable suggestion.
It worked fine, but I am having parameters in the two reports.
So If I make any one of the two as main report,and the second one that is
declared as subreport cannot be run as the parameter is null.It is gtting
exported into same excel workbook in two dofferent sheets. The sub report is
displaying only header part as the parameter is null.
How can I deal with parameters?
Can you please reply be as soon as possible.
Its very urgent to fix this task.
thanks in advance
miika
"Amarnath" wrote:
> Ok, it can be done. Place a Subreport control in the main report (Report1)
> and refer the other report(Report2) and place a Rectangle on the subreport
> and on the properties check "insert before rectangle" there by it gives
> pagination, which is the main thing for creating multiple sheets. now export
> the main report you get both the reports in a single workbook but 2 sheets.
> Check out.
> Amarnath, MCTS.
> "aka" wrote:
> > Hallo all,
> > Its vey urgent for me ,please help me to solve the problem.
> > I am having two reports in a report project. when exporting to excel , I
> > have to export these two reports into a single excel workbook. Each report
> > should be exported to different sheets in same workbook. How is it possible?
> > Please help me.
> > I am really badly in need of help
> >
> > thanks in advance to all
> > miika|||And also When exported to excel,in excel sheet ,I am having the main report
page header in the subreport also.
How can I avoid the main report page header in the subreport sheet?
Can you please help me?
I also want to have the sheet1 and sheet2 names as report names.
not simply sheet1 and sheet2.
IS it possible?
Please help me as soon as possible.
waiting for your suggestions
miika
"aka" wrote:
> Hi,
> Thanks alot for your valuable suggestion.
> It worked fine, but I am having parameters in the two reports.
> So If I make any one of the two as main report,and the second one that is
> declared as subreport cannot be run as the parameter is null.It is gtting
> exported into same excel workbook in two dofferent sheets. The sub report is
> displaying only header part as the parameter is null.
> How can I deal with parameters?
> Can you please reply be as soon as possible.
> Its very urgent to fix this task.
> thanks in advance
> miika
>
> "Amarnath" wrote:
> > Ok, it can be done. Place a Subreport control in the main report (Report1)
> > and refer the other report(Report2) and place a Rectangle on the subreport
> > and on the properties check "insert before rectangle" there by it gives
> > pagination, which is the main thing for creating multiple sheets. now export
> > the main report you get both the reports in a single workbook but 2 sheets.
> > Check out.
> >
> > Amarnath, MCTS.
> >
> > "aka" wrote:
> >
> > > Hallo all,
> > > Its vey urgent for me ,please help me to solve the problem.
> > > I am having two reports in a report project. when exporting to excel , I
> > > have to export these two reports into a single excel workbook. Each report
> > > should be exported to different sheets in same workbook. How is it possible?
> > > Please help me.
> > > I am really badly in need of help
> > >
> > > thanks in advance to all
> > > miika|||Aka, sorry for the late reply. You need to have group header in subreport so
that you dont have to rely on the main header. Unfortunately you dont get the
sheet's name. it will be sheet1, sheet2 etc... If the parameters are similiar
then you can select the parameter from the subreport properties from the
expression. if not then you need to hard code it, there is no way.
Amarnath,MCTS
"aka" wrote:
> And also When exported to excel,in excel sheet ,I am having the main report
> page header in the subreport also.
> How can I avoid the main report page header in the subreport sheet?
> Can you please help me?
> I also want to have the sheet1 and sheet2 names as report names.
> not simply sheet1 and sheet2.
> IS it possible?
> Please help me as soon as possible.
> waiting for your suggestions
> miika
>
> "aka" wrote:
> > Hi,
> > Thanks alot for your valuable suggestion.
> > It worked fine, but I am having parameters in the two reports.
> > So If I make any one of the two as main report,and the second one that is
> > declared as subreport cannot be run as the parameter is null.It is gtting
> > exported into same excel workbook in two dofferent sheets. The sub report is
> > displaying only header part as the parameter is null.
> > How can I deal with parameters?
> > Can you please reply be as soon as possible.
> > Its very urgent to fix this task.
> > thanks in advance
> > miika
> >
> >
> > "Amarnath" wrote:
> >
> > > Ok, it can be done. Place a Subreport control in the main report (Report1)
> > > and refer the other report(Report2) and place a Rectangle on the subreport
> > > and on the properties check "insert before rectangle" there by it gives
> > > pagination, which is the main thing for creating multiple sheets. now export
> > > the main report you get both the reports in a single workbook but 2 sheets.
> > > Check out.
> > >
> > > Amarnath, MCTS.
> > >
> > > "aka" wrote:
> > >
> > > > Hallo all,
> > > > Its vey urgent for me ,please help me to solve the problem.
> > > > I am having two reports in a report project. when exporting to excel , I
> > > > have to export these two reports into a single excel workbook. Each report
> > > > should be exported to different sheets in same workbook. How is it possible?
> > > > Please help me.
> > > > I am really badly in need of help
> > > >
> > > > thanks in advance to all
> > > > miika