Microsoft SQL Server 2005 Reporting Services -- Error 1303

I am trying to install Microsoft SQL Server 2005 Reporting Services, Receiving the following error

Microsoft SQL Server 2005 Reporting Services -- Error 1303. The installer has insufficient privileges to access this directory: C:\Config.Msi. The installation cannot continue. Log on as administrator or contact your system administrator.

I am already logged in as Administrator and should have all the necessary permissions to install software

Please help me.

I think you accidentally got the wrong forum for this. This is the replication forum. I suggest reposting your question in the SQL Server Reporting Services forum.

Phil Garding

|||Thankssql

Microsoft SQL Server 2000 Reporting Services

I understand that this is available for free but I have not been able to find it for downloading. Can anyone point me in the right direction for this? Do you know does it really require alot of resources like I have been reading. People recomending a seperate SQL box just for thes reporting services. Please advise.

You can download evaluaiton copy from here.

Also you can download SP2 for RS 2000 here.

|||Thank you.... but my understanding was that I could get a regular copy vs. evaluation copy for free. Microsoft was letting SQL 2000 users have the reporting services until they upgraded to SQL 2005 which would have it in it. Do you know where you can get a regular copy?|||I am curious where this was mentioned. As far as your performance question, it is true that processing reports is an intensive task. However, a single box should more than enough to handle low to medium report loads. Besides, it will save you money if you host the database engine on the same server.

Microsoft SQL 2000 Reporting Services

Has anyone who is involved in testing the Beta 2 version of this SQL
add-on (reporting services) needed to implement a calendar control as
a means to obtain parameter criteria?
Is this possible to place and then fire the calendar control on a
report and then populate a field with the date that was selected on
the control.
Cheers
GrantHi
As this is a beta you are probably governed by an NDA, therefore a public
newsgroup is not the appropriate place for a question like this.
John
"GrantS" <sutcliffe_grant@.hotmail.com> wrote in message
news:6963940b.0312221250.5afb1f75@.posting.google.com...
> Has anyone who is involved in testing the Beta 2 version of this SQL
> add-on (reporting services) needed to implement a calendar control as
> a means to obtain parameter criteria?
> Is this possible to place and then fire the calendar control on a
> report and then populate a field with the date that was selected on
> the control.
> Cheers
> Grant|||Oops! OK - Thanks John.

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 reporting Services Support & Changes

Hi We are planning to install the Reporting Services, but have been given a very negative feedback by some companies which planned to move to this.

The type of uncertainities that are coming through are:
1) product may either undergo a signifcant change
2) lose support

Can anyone help me with these questions, as i myself believe that it is hard to imagine such a big change.

Let me know what you think about this?

Thanking you in anticipation,

Kind Regards,
NittoWhat information did those companies base their opinions on? It sounds very subjective to me. The ease of report design/deployment, and flexibility is enough for the two companies I do independant contracting for to proceed full steam with this.|||Hi,
They were not willing to give any concrete answers, but asked us to investiagate more into Microsoft's decisions on changing the product and Support.

Does anyone think that such a big change is possible?

Thanks, Nitto|||As part of the development team, I can assure you that we are moving forward with Reporting Services, as evidenced by our SQL 2005 release. While competitors might like to think otherwise, RS has a bright future.

Brian Welcker
Group Program Manager
Reporting Services

Microsoft Reporting Services - Error - Expects Parameter - Stored Procedure

Solution:
This happens to me quite a bit...its because the designer removes the
code that defines what
values are passed to your stored procedure.
You have to select the report you're working on > Right-Click 'Code' >
Locate the <Query> XML tag...and you'll have to re-define the
<QueryParameters>.
<Query>
<DataSourceName>GPS</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>spLRGetLeadRotationSummary</CommandText>
<QueryParameters>
<QueryParameter Name="@.StartDate">
<Value>=Parameters!StartDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@.EndDate">
<Value>=Parameters!EndDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@.RegionID">
<Value>=Parameters!RegionID.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>You can also do this by clicking on the ..., parameters tab. Modifying the
xml is dangerous. Although if you have a lot of query parameters and RS
keeps losing it then I have sometimes saved the section off so I could copy
it back in.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<petejk@.gmail.com> wrote in message
news:1135124852.986963.63390@.f14g2000cwb.googlegroups.com...
> Solution:
> This happens to me quite a bit...its because the designer removes the
> code that defines what
> values are passed to your stored procedure.
> You have to select the report you're working on > Right-Click 'Code' >
> Locate the <Query> XML tag...and you'll have to re-define the
> <QueryParameters>.
>
> <Query>
> <DataSourceName>GPS</DataSourceName>
> <CommandType>StoredProcedure</CommandType>
> <CommandText>spLRGetLeadRotationSummary</CommandText>
> <QueryParameters>
> <QueryParameter Name="@.StartDate">
> <Value>=Parameters!StartDate.Value</Value>
> </QueryParameter>
> <QueryParameter Name="@.EndDate">
> <Value>=Parameters!EndDate.Value</Value>
> </QueryParameter>
> <QueryParameter Name="@.RegionID">
> <Value>=Parameters!RegionID.Value</Value>
> </QueryParameter>
> </QueryParameters>
> </Query>
>

microsoft reporting services

Hi,
In Microsoft Abalysis Manager one can browse the cube data by right
clicking the cube and drag and drop columns to view data. Can the
same be achieved with reporting services.
Thanks in advance
BajiraoI'm not sure if I understand your question perfectly. There is a preview
function that you can use in the Report Designer that allows you to see what
a report would look like, plus you can preview the data set. If you're
asking whether or not you can query OLAP cubes from Reporting Services, the
answer is that you can, but you need to know MDX in order to do so.
We are working on a whitepaper that addresses this topic. It assumes you
already have good knowledge of MDX. Given the number
of inquiries, I've gone ahead and posted it over on the OLAP MSN group. You
can find it in the general discussion are of.
http://groups.msn.com/OLAPServicesDevelopersForum/
Sean
Sean
Sean Boon
SQL Server BI Product Unit
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Bajirao.B.T" <btbajirao@.yahoo.com> wrote in message
news:736f0ba3.0403180730.4e63cfd5@.posting.google.com...
> Hi,
> In Microsoft Abalysis Manager one can browse the cube data by right
> clicking the cube and drag and drop columns to view data. Can the
> same be achieved with reporting services.
> Thanks in advance
> Bajirao|||Thanks for the reply. I my be not clear in expressing what I want.
In microsoft analysis manager on right click, browse cube data > one
form pops up. There we can drag and drop dimensions from the top to work
area. So that the cube takes different shapes.
The same functionality I want to achieve in the web browser useng
Reporting services is that possible or not is my question.
Regards,
Bajirao
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Microsoft Reporting Services

Folks --
Does anyone have any idea as to where I would go to find
help on getting the beta of Reporting Services up and
running?
Thanks
Pete HohenhausTry this page first
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/next/rsdepgd.asp
And this is a chat link on RS
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/trans/sql/sql0625.asp
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"peteh@.180solutions.com" <anonymous@.discussions.microsoft.com> wrote in
message news:022701c3ac94$c4808480$a301280a@.phx.gbl...
> Folks --
> Does anyone have any idea as to where I would go to find
> help on getting the beta of Reporting Services up and
> running?
> Thanks
> Pete Hohenhaus|||Hey, Ray, thanks, man!
>--Original Message--
>Try this page first
>http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/next/rsdepgd.asp
>And this is a chat link on RS
>http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/itcommunity/chats/trans/sql/sql0625.asp
>HTH
>--
>Ray Higdon MCSE, MCDBA, CCNA
>--
>"peteh@.180solutions.com"
<anonymous@.discussions.microsoft.com> wrote in
>message news:022701c3ac94$c4808480$a301280a@.phx.gbl...
>> Folks --
>> Does anyone have any idea as to where I would go to
find
>> help on getting the beta of Reporting Services up and
>> running?
>> Thanks
>> Pete Hohenhaus
>
>.
>

Microsoft Reporting Services

Default value or value provided for the report parameter 'ParamaterName' is
not a valid value. (rsInvalidReportParameter)
I am getting this error when I am trying to run a deployed report.
However,
this is driving me mad because in the report preview within VS.Net the
report
works fine and i can choose the same parameter settings from within the dev
environment with no problems. I am populating this parameter with a
dropdown
with valid values from a sproc (and this I've done a thousand times before)
.
I can not figure out why it is throwing this error, particularly since it
works perfectly fine in the preview pane. How could it be crappin out when
I
deploy it?!?! I am going insane!
Pl. put in forum.
regards
Arvind Sharma
--
Message posted via http://www.sqlmonster.comOn the deployed report, in report manager, properties... is the prompt string
blank? If so it will try to render the report without prompting for input
which will throw that error.
"arvind sharma via SQLMonster.com" wrote:
> Default value or value provided for the report parameter 'ParamaterName' is
> not a valid value. (rsInvalidReportParameter)
> I am getting this error when I am trying to run a deployed report.
> However,
> this is driving me mad because in the report preview within VS.Net the
> report
> works fine and i can choose the same parameter settings from within the dev
> environment with no problems. I am populating this parameter with a
> dropdown
> with valid values from a sproc (and this I've done a thousand times before)
> ..
> I can not figure out why it is throwing this error, particularly since it
> works perfectly fine in the preview pane. How could it be crappin out when
> I
> deploy it?!?! I am going insane!
> Pl. put in forum.
> regards
> Arvind Sharma
> --
> Message posted via http://www.sqlmonster.com
>sql

Microsoft Reporting Service and Oracle

Hi,
I am planning to use Microsoft Reporting Service with Oracle as my
database. Is this a possibility? What are the pros and cons. Also
Oracle is going to return me a huge volume of rows max in millions, can
Microsoft Reporting Service handle this?
What is the best alternative. I am aware that the record sets once
generated from Oracle are going to be residing in SQL Server. What is
the configuration of this SQL Server 2000 or 2005?Where would this SQL
Server reside? Would this SQL server reside on the webserver with other
ASP pages. As I plan to use asp .Net to display the report on the web.
Any help to these is greatly appreciated.
Thanks
SBFirst off, if Oracle is going to return millions of rows then do not use RS.
Really I don't think any reporting tool would work with millions of rows
returned very well but I guarantee you that RS will be awful. First off,
though, why would Oracle be returning millions of rows? Querying millions of
rows is no problem. I routinely query millions of rows in Sybase, in SQL
Server I go against a 80 million row table. BUT, the end result is a few
thousand if that. My reports are for humans to read and a human is not going
to read more than a 20-30 pages. Now, I do have sometimes the need for
30-50,000 rows being exported to Excel. Excel, though, can't handle millions
of rows either. So, again, what conceivable reason would you want that many
rows?
I suggest going here and reading up:
http://www.microsoft.com/sql/technologies/reporting/default.mspx
Short course. RS 2005 is a 2.0 framework asp.net application. RS comes with
a portal called Report Manager. It is optional whether you use the Report
Manager. You can integrate with RS two ways: URL integration and web
services. Visual Studio 2005 comes with a webform and a winform control
which I highly recommend if you are integrating RS into your own
application. As an ASP.Net application RS needs IIS somewhere, either on
your web server or on the database server (which means you have to have IIS
running on the database server). RS using SQL Server for its object caching
and metadata store. It can run on a separate machine than Reporting
Services. BUT, if you run in this configuration you need to have a SQL
Server license for the machine where RS is running.
Your data can come from darn near anywhere. I go extensively against Sybase
as well as SQL Server. You can use ODBC, OLEDB and native dotnet drivers
(Oracle and SQL Server only).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<sonali.bhavsar@.gmail.com> wrote in message
news:1141045456.743618.85290@.v46g2000cwv.googlegroups.com...
> Hi,
> I am planning to use Microsoft Reporting Service with Oracle as my
> database. Is this a possibility? What are the pros and cons. Also
> Oracle is going to return me a huge volume of rows max in millions, can
> Microsoft Reporting Service handle this?
> What is the best alternative. I am aware that the record sets once
> generated from Oracle are going to be residing in SQL Server. What is
> the configuration of this SQL Server 2000 or 2005?Where would this SQL
> Server reside? Would this SQL server reside on the webserver with other
> ASP pages. As I plan to use asp .Net to display the report on the web.
> Any help to these is greatly appreciated.
> Thanks
> SB
>|||Thanks Bruce for your information. These reports are going to be for
email archival kept over many years and consolidated information is
reported region and company wise. Due to its volume the need to export
these rows to excel is required.
>From what I gather as mentioned in your reply reporting servicecannot
handle large volume. To use this reporting service is SQL 2005 a must?
Thanks again
SB
Bruce L-C [MVP] wrote:
> First off, if Oracle is going to return millions of rows then do not use RS.
> Really I don't think any reporting tool would work with millions of rows
> returned very well but I guarantee you that RS will be awful. First off,
> though, why would Oracle be returning millions of rows? Querying millions of
> rows is no problem. I routinely query millions of rows in Sybase, in SQL
> Server I go against a 80 million row table. BUT, the end result is a few
> thousand if that. My reports are for humans to read and a human is not going
> to read more than a 20-30 pages. Now, I do have sometimes the need for
> 30-50,000 rows being exported to Excel. Excel, though, can't handle millions
> of rows either. So, again, what conceivable reason would you want that many
> rows?
> I suggest going here and reading up:
> http://www.microsoft.com/sql/technologies/reporting/default.mspx
> Short course. RS 2005 is a 2.0 framework asp.net application. RS comes with
> a portal called Report Manager. It is optional whether you use the Report
> Manager. You can integrate with RS two ways: URL integration and web
> services. Visual Studio 2005 comes with a webform and a winform control
> which I highly recommend if you are integrating RS into your own
> application. As an ASP.Net application RS needs IIS somewhere, either on
> your web server or on the database server (which means you have to have IIS
> running on the database server). RS using SQL Server for its object caching
> and metadata store. It can run on a separate machine than Reporting
> Services. BUT, if you run in this configuration you need to have a SQL
> Server license for the machine where RS is running.
> Your data can come from darn near anywhere. I go extensively against Sybase
> as well as SQL Server. You can use ODBC, OLEDB and native dotnet drivers
> (Oracle and SQL Server only).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> <sonali.bhavsar@.gmail.com> wrote in message
> news:1141045456.743618.85290@.v46g2000cwv.googlegroups.com...
> > Hi,
> >
> > I am planning to use Microsoft Reporting Service with Oracle as my
> > database. Is this a possibility? What are the pros and cons. Also
> > Oracle is going to return me a huge volume of rows max in millions, can
> > Microsoft Reporting Service handle this?
> > What is the best alternative. I am aware that the record sets once
> > generated from Oracle are going to be residing in SQL Server. What is
> > the configuration of this SQL Server 2000 or 2005?Where would this SQL
> > Server reside? Would this SQL server reside on the webserver with other
> > ASP pages. As I plan to use asp .Net to display the report on the web.
> >
> > Any help to these is greatly appreciated.
> >
> > Thanks
> > SB
> >|||Excel cannot take millions of rows. The limit is 64,000 I believe. If you
are going to do this then export in CSV ASCII format. Excel format (or PDF
as well) are order of magnitude slower.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<sonali.bhavsar@.gmail.com> wrote in message
news:1141065580.645968.51100@.z34g2000cwc.googlegroups.com...
> Thanks Bruce for your information. These reports are going to be for
> email archival kept over many years and consolidated information is
> reported region and company wise. Due to its volume the need to export
> these rows to excel is required.
>>From what I gather as mentioned in your reply reporting servicecannot
> handle large volume. To use this reporting service is SQL 2005 a must?
> Thanks again
> SB
> Bruce L-C [MVP] wrote:
>> First off, if Oracle is going to return millions of rows then do not use
>> RS.
>> Really I don't think any reporting tool would work with millions of rows
>> returned very well but I guarantee you that RS will be awful. First off,
>> though, why would Oracle be returning millions of rows? Querying millions
>> of
>> rows is no problem. I routinely query millions of rows in Sybase, in SQL
>> Server I go against a 80 million row table. BUT, the end result is a few
>> thousand if that. My reports are for humans to read and a human is not
>> going
>> to read more than a 20-30 pages. Now, I do have sometimes the need for
>> 30-50,000 rows being exported to Excel. Excel, though, can't handle
>> millions
>> of rows either. So, again, what conceivable reason would you want that
>> many
>> rows?
>> I suggest going here and reading up:
>> http://www.microsoft.com/sql/technologies/reporting/default.mspx
>> Short course. RS 2005 is a 2.0 framework asp.net application. RS comes
>> with
>> a portal called Report Manager. It is optional whether you use the Report
>> Manager. You can integrate with RS two ways: URL integration and web
>> services. Visual Studio 2005 comes with a webform and a winform control
>> which I highly recommend if you are integrating RS into your own
>> application. As an ASP.Net application RS needs IIS somewhere, either on
>> your web server or on the database server (which means you have to have
>> IIS
>> running on the database server). RS using SQL Server for its object
>> caching
>> and metadata store. It can run on a separate machine than Reporting
>> Services. BUT, if you run in this configuration you need to have a SQL
>> Server license for the machine where RS is running.
>> Your data can come from darn near anywhere. I go extensively against
>> Sybase
>> as well as SQL Server. You can use ODBC, OLEDB and native dotnet drivers
>> (Oracle and SQL Server only).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> <sonali.bhavsar@.gmail.com> wrote in message
>> news:1141045456.743618.85290@.v46g2000cwv.googlegroups.com...
>> > Hi,
>> >
>> > I am planning to use Microsoft Reporting Service with Oracle as my
>> > database. Is this a possibility? What are the pros and cons. Also
>> > Oracle is going to return me a huge volume of rows max in millions, can
>> > Microsoft Reporting Service handle this?
>> > What is the best alternative. I am aware that the record sets once
>> > generated from Oracle are going to be residing in SQL Server. What is
>> > the configuration of this SQL Server 2000 or 2005?Where would this SQL
>> > Server reside? Would this SQL server reside on the webserver with other
>> > ASP pages. As I plan to use asp .Net to display the report on the web.
>> >
>> > Any help to these is greatly appreciated.
>> >
>> > Thanks
>> > SB
>> >
>

Microsoft Reporting Service

I have the following Question:

Is it possible to install a Reporting Service at IIS Webserver without
SQL Server 2000 on the same machine.

We have a Enterprise SQL Server at another machine and i don't want to
install another SQL Server at a IIS.

Thank you for all responses

Flecki"flecki" <thorsten.fleckenstein@.de.cpm-int.com> wrote in message
news:f2626ae2.0409222330.309f741f@.posting.google.c om...
>I have the following Question:
> Is it possible to install a Reporting Service at IIS Webserver without
> SQL Server 2000 on the same machine.
> We have a Enterprise SQL Server at another machine and i don't want to
> install another SQL Server at a IIS.
> Thank you for all responses
> Flecki

Yes - you can use a remote database:

http://msdn.microsoft.com/library/d...grs_v1_8k82.asp

Simon

Microsoft Reporting examples

Are there any walkthroughs or examples of Microsoft Reporting NOT issued by Microsoft. I cannot for the life of me get this to work.

And none of MS Tutorials are providing any help for what im trying to accomplish.

Simply put. I want a report with a sub report in it. Its been three days and all i have managed to do is cry.

any examples written by someone that actually explain how it works would help.

thanks

mcm

First, I'm making the assumption that you are talking about Microsoft SQL Server Reporting Services. If this is the case, I understand your pain - I had similar problems when I first attempted to get this up and running. I finally ended up purchasing the following book:

"Microsoft SQL Server 2005 Reporting Services", McGraw Hill Osborne, Brian Larson

Has great examples of what can be accomplished utilizing reporting services.

In a nutshell

Create your master report.|||

no im not using SQL Server Reporting Services im using Microsoft.Reporting.WinForms. which i was led to believe is different. For Sql Server Reporting Services you need the reporting services plugin on the server, this is very similar to what MS Access has as for reports and just uses DataTables generated from any data source.

I have managed to create a parent and child report and link them and set their data tables, but my child report only displays one of 10 records it should. Also there are many differences between this and the Access style reports (ie no Report Header and Footer, just Page header and Footer).

the reports you can create are used with the ReportViewer control available in VS 2005 and they have the extension .rdlc. Perhaps these are the same reports that SQL Server Reporting services generates but i dont know for sure.

thanks for your help.

mcm

|||I just went through learning about Reporting within VS 2005 this past week myself. The reporting available within VS 2005 is basically the same as what is used with SQL Reporting Services but does not have the full spectrum of features.

The following links helped me greatly. The first two are geared toward ASP.NET but I'm sure you can adapt them to WinForms...

http://www.aspfree.com/c/a/ASP.NET/Designing-and-Developing-Reports-in-ASPNET-20/
http://www.aspfree.com/c/a/ASP.NET/Binding-Data-to-the-ReportViewer-Control-Dynamically-in-ASPNET-20/
http://www.ftponline.com/vsm/2005_11/magazine/features/rjennings/default_pf.aspx

Microsoft picture toolbar

Deat all ,

i need someone to help me if can i to put a toolbar for microsofte pictures in my report in reporting service 2005 i think there is a line of code

that let me do that put i search to it but i cant find it

any body can i helpe me i will be grateful

Hi,

to put a toolbar for Microsoft pictures in my report in reporting service 2005

Based on my understanding, do you want to add Images to a ReportViewer Report, right?

If so, there are three kinds of adding ways for you to choose. An image is a report item that contains a reference to an image that is stored on the report server, embedded within the report, or stored in a database. An image can be a logo or picture that appears once on the report or it can be a picture that is repeated with rows of data. You can also use an image as a background for certain report items. You can get images from the following sources, Databases, external file share or website, or embedded locally within the report. I guess you are in the third way. To achieve that , you may following the steps below:

1.How to add an Embedded Image to a Report

2.Open the client report definition (.rdlc) file in graphical design mode.

3.From the Report menu, select Embedded Images and add all of the images that you want to use in the report. If the Report menu is not available, click within the report design area.

4.Drag the image control from the toolbox to the report layout. You must use the image control that is used for ReportViewer reports.

5.Select the image and then open the Properties window in Visual Studio.

6.Set Source to Embedded.

7.Set Value to an image that is embedded in the report definition. You can choose which image to use from a drop-down list.

For more information, see:
http://msdn2.microsoft.com/en-us/library/ms251715(VS.80).aspx

Thanks.

|||

Dear Michael Jin,

My Problem not like this not to add image to report

but after add the image and finish the report and its code in vb.net and call the report

and view it there is a defult toolbar right?

i need to add the Pictures toolbar for microsoft if you know anything about this please tell me i will be grateful

thanks in advance

khalil hamad

|||

Hi,

Could you tell us what do you mean by "i need to add the Pictures toolbar for microsoft"?

Thanks.

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 CRM and SRS

Hello,
I am trying to be an early adapter to SRS for Microsoft CRM reporting.
In particular, I am trying to get the activities that a lead has
associated with it. I am using a subreport and am trying to pass the
lead GUID to the subreport so I can run the activity report for the
lead. I get an invalid type error when I try to do this. Is there a
better way that I might do this? Does SRS have issues with CRM GUIDs?
Thanks in advance.answered in microsoft.public.crm.developer
--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us
"Jeffrey Jones" <jeffjones176@.kc.rr.com> wrote in message
news:usaxaU6lFHA.3144@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I am trying to be an early adapter to SRS for Microsoft CRM reporting.
> In particular, I am trying to get the activities that a lead has
> associated with it. I am using a subreport and am trying to pass the
> lead GUID to the subreport so I can run the activity report for the
> lead. I get an invalid type error when I try to do this. Is there a
> better way that I might do this? Does SRS have issues with CRM GUIDs?
> Thanks in advance.sql

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