Report Issue

I created a report that has 2 sub-reports. The main report has a
dataset that uses the auto-filtering on the "Quote" entity. The sub-
reports get passed the "quoteid" as a parameter, and get the
"QuoteDetail" items, and related "Account".

When I test the report (SQL 2005 & VS 2005), everything comes back
correctly, and it looks like a really nice quote that we can send to
clients.

When I upload this through the Report Manager in CRM, and attempt to
run the report, I get the "Advanced Find" view to filter the "Quotes".
At this point, everything fails, and it tells me that there is no such
Object Named "FilteredQuote".

My query for the main report is pretty easy:
SELECT quoteid FROM FilteredQuote AS CRMAF_FilteredQuote

Any thoughts?

Thanks.

-Adam Moniz-Rivera

0
Adam
7/5/2007 3:17:14 PM
crm 35858 articles. 1 followers. Follow

1 Replies
617 Views

Similar Articles

[PageSpeed] 37

CRM report manager has issues with reports developed in SQL Server 2005 and 
VS 2005. Usually the whole report will bomb because the .rdl file's xmlns 
reads like:

<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" 
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

It should be:

<Report 
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" 
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">


"Adam" wrote:

> I created a report that has 2 sub-reports. The main report has a
> dataset that uses the auto-filtering on the "Quote" entity. The sub-
> reports get passed the "quoteid" as a parameter, and get the
> "QuoteDetail" items, and related "Account".
> 
> When I test the report (SQL 2005 & VS 2005), everything comes back
> correctly, and it looks like a really nice quote that we can send to
> clients.
> 
> When I upload this through the Report Manager in CRM, and attempt to
> run the report, I get the "Advanced Find" view to filter the "Quotes".
> At this point, everything fails, and it tells me that there is no such
> Object Named "FilteredQuote".
> 
> My query for the main report is pretty easy:
> SELECT quoteid FROM FilteredQuote AS CRMAF_FilteredQuote
> 
> Any thoughts?
> 
> Thanks.
> 
> -Adam Moniz-Rivera
> 
> 
0
Utf
7/5/2007 5:08:00 PM
Reply:

Similar Artilces:

reports that print after the stock count
Hello: To the best of my knowledge, the only report that automatically prints at the end of a stock count is the exceptions report. A client claimed that, during last month's stock count, a "quantity report" of some sort automatically printed. They conducted a stock count this month and were surprised not to see this "quantity report" automatically print. I don't think that there is a such thing as a "quantity report" printed after a stock count. Is there? I advised the client to print the Historical Stock Status Report, since this other report...

Is Crystal Report ver:11.5.8.826 supported?
Please tell me: Do reports made in CR Professional ver: 11.5.8.826 supported by RMS v2.0? hi Asad, the Last version support is Crystal 8.5 also not worked with 9,10 or 11. "Asad" wrote: > Please tell me: Do reports made in CR Professional ver: 11.5.8.826 supported > by RMS v2.0? Well, I've checked it myself. Crystal Report11 doesnt work with RMs v2.0. Haven't checked ver 9, 10. "Akber Alwani" wrote: > hi Asad, the Last version support is Crystal 8.5 also not worked with 9,10 or > 11. > > > > "Asad" wrote: > > ...

Can't Get CRM 3.0 Reports To Work
In the readme file that comes with server installation in the early access program it mentions under Known Issues: ************************************************ Microsoft CRM Server Privileges Required for Installing Microsoft CRM and Using an Existing Microsoft SQL Server Reporting Services Server The user installing Microsoft CRM and connecting to an existing Microsoft SQL 2000 Server Reporting Services Server must have as a minimum the Content Manager Role privileges at the Root Folder Level, and System Administrator privileges at the Site Wide Setting Level. ***********************...

Sales Pipeline report
I know you used to be able to view the sales pipeline report by product, but I don't seem to have that option available in the "group by" ddl. Am I missing something? HELP! Viewing the sales pipeline by product is an important requirement. I haven't used this report, but it should be relatively easy to build your own SQL view for the report to group the output by product (clone the existing report and modify the where clause). Thanks for the reply. According to the help files, this group by option should be available. I opened the report in Visual Studio, and low-and-...

report format portrait and lanscape
Is it possible to have one command to change report between portait or lanscape? If not, probably the best solution will be 2 reports. Your information is great appreciated, Your report is probably designed in portrait. This means it is designed to print 8-1/2" - the left and right margins wide. If you change the printout to landscape it is still going to print less than 8-1/2" wide on the left side of the paper leaving more than 3-1/2" blank on the roght side of the paper. To fill the paper you would have to write code to reposition and stretch out each con...

XML Serialization Issue
I recently added a new property to a base object that had a property with a protected set. After adding the new propery to the class that inherited from that class, I get the below error. This web service was working until this change. System.InvalidOperationException: Unable to generate a temporary class (result=1). error CS0272: The property or indexer 'USI.Data.Common.BizBase.IsValid' cannot be used in this context because the set accessor is inaccessible error CS0272: The property or indexer 'USI.Data.Common.BizBase.IsValid' cannot be used in this context because the...

Creating a Report using Tables (that have no relationships)
Im looking to create an invoice report that uses data from three different tables that are created dynamically by a query. The data for these will change but I would like to simply pull the data from these tables to create a report. The tables have the following information: 1. Company Info (name, address) 2. Customer Info (address, name, etc) 3. Customer Order (products, price, other info) 4. Invoice Info (ID, GST #, etc) I realize I could have created a table with relationships but the data above is dynamic as there are 4 different companies and based upon user inp...

Change order of fields in a report to a custom arrangement
In a report, I want to list sections in a certain way that is not alphabetical or numerical. Is there a way to do this? Curerntly, it is alphabetical as below: **Staff Section** Chief of Staff Command Counsel G1 G2 G3 Public Affairs Special Staff ** I would like for the fields to be organized as below: ***Staff Section*** G1 G2 G3 Chief of Staff Command Counsel Special Staff Public Affairs Thanks! Glen Try going to Sorting and Grouping. It is one of your buttons on the command bar. You should be able to set it anyway you wish. -- Milton Purdy ACCES...

MS CRM 1.2 and MS SQL SERVER REPORTING SERVICES
CAN MS CRM 1.2 CO-EXIST WITH MS SQL SERVER 2000 REPORTING SERVICES? WE CAN ONLY GET EITHER CRM OR REPORT SERVICES TO WORK NOT BOTH. THANKS. Yes, they can co-exist. Also, please DON'T SHOUT. Matt Parks MVP - Microsoft CRM ---------------------------------------- ---------------------------------------- On Fri, 8 Jul 2005 16:08:02 -0700, HEC <HEC@discussions.microsoft.com> wrote: CAN MS CRM 1.2 CO-EXIST WITH MS SQL SERVER 2000 REPORTING SERVICES? WE CAN ONLY GET EITHER CRM OR REPORT SERVICES TO WORK NOT BOTH. THANKS. Could you please enlighten us Matt? If one has CRM 1.2 in...

issue with ex2k7 ccr cluster and ntbackup
hi ng have a problem with my ex2k7 ccr cluster and ntbackup. because there is not a backup software available which support ex2k7, we use ntbackup for online backup. we backup every single database. the backup is running without problems and the eventlog seems to be clean but the logs will not deleted. on a single mailbox server, which hold the public folders, i see that ntbackup works fine and the logs are deleted after a succesful full backup. has anybody heard about such a behaviour? any hint will be appreciated. regards olaf Are you by chance backing up the passive cluster node with N...

Parent Child report #2
Hi there does anyone have a parent child report? To list items by parent? Or by Matrix for that matter? Ivan The Reports Library has these two below: This report displays the Item Quantity List grouped by matrix code. Only matrix items are displayed, and each matrix code is displayed with its corresponding components. (April 26th, 2004) https://mbs.microsoft.com/downloads/customer/Custom_Matrix_Quantity_List.zip This report displays the Item Quantity List for Parent Child items. Only parent child items are displayed, and each parent code is displayed with its corresponding child ...

Draw continous vertical line in report detail section
My report has a report header approx 1.5" tall, a page header approx 0.5" tall, followed by the detail section. How can I print a fixed height detail section with verticle lines even if there are only a few records? Essentially, trying to replicate a paper form. The line starts at the bottom of the page header and continues to the top of page footer. In a post a couple days ago, Allen Browne recommended the below for drawing a line down the entire page.....this close, and I am trying to figure out a similar approach for the detail section. Private Sub Report_Page() Me....

Sales Targets Reports
I filled in the CRM Targets. How do i make a report to check the target against the pipeline? ...

Timesheet reporting
I'm currently studying how to use Project Server 2007 for time sheets calculation and reporting To calculate the timesheet cost, we will use the hours spent x resource rate (custom field in resource) by task and project. The cost will also be broken down by direct and indirect cost using the % (custom field in the project). However for certain type of projects (identified by a custom field in project), the direct and indirect cost is based on the % (custom field) in resources. Is it easily done using exsiting cube or data analysis provided by Project Server 2007 and how...

Unable to View Reports in Business Portal 2.5
Does anyone have an idea why the reports will not display? The reports seem to be generating properly from Great Plains 8.0 and I am able to access the GP screens through terminal services. Can anyone help me? Regards, Brad Brad -- Are you trying to view the reports on a Center page? If so, you will need to check the following. 1. You have the share folder to publish reports to setup with the correct security. (This can be found in the BP Installation Manual on your CD). 2. You have published the Reports via Reports Scheduler within Great Plains. 3. The Reports have been set...

Public Folder Permissions Issue
Under our Public Folder store in ESM(Exchange System Manager) the inherit permissions under security was unchecked to remove inherited permissions. Now, NOBODY has access to view it, read it, or even list it our public folder structure. Not even the system, or the domain administrator etc. Note, the pub1.edb file where the public folder structure is stored is still intact. How can I get the public folders back to its original state? I have been researching this problem in multiple Exchange News Groups and received information about a tool called ”PFDavAdmin” which errors out. Any i...

Duplication Detection Reports
Hello, We are a little confused. We run a duplicate detection report on all contacts and for some reason it will show some contacts in the top pane, but then say "Potential duplicate records: None" Why would it show it in the duplicate pane up top if there are no duplicates? Thanks in advance for the help. Thanks, Chris That is strange, if there are duplicates, then it will list them on the top, and the bottom portion will list out the records are match with the duplicate rules. Is this a new installation? Is this the same for Lead and Account? Frank Lee, Microsoft Dyna...

To MVP John Spencer - Report
Hey! Sorry my bad English! My Name Is Per Erik Løkken, and comes from Norway. I have been in contact with MVP Duane Hookom regarding an issue with a report in Access 2007. She tells me that you've had a post regarding the ranking query: “I believe you can do this without the subquery but using a totals query and a self join. MVP John Spencer has posted this type of ranking query in the past. You will get a more efficient and functional result as needed in the report record source.” My report is made with a subquery: SELECT A.VEKT, A.NAVN, A.KLUBB, A.KLASSE, (S...

SFO Client Synch Issues
I know that this has been posted before, but I figured I would it again. We are running MSCRM Server 1.2 with SQL Server 2000 Enterprise Edition. The Outlook clients are 2k and better with all needed patches. On a handful of laptops running Windows XP SP2 the SFO client will not go offline, and the following error comes up when you try to. "CRM Sales for Outlook can not go offline. The Microsoft CRM Server was not found." I can ping the server by IP and name and do a succesful nslookup so DNS is OK. On my laptop it was working fine until SP2 was installed. Once I tried to go...

copy report project
hi, I have a report project in server a and now I want to move all the reports to server b, how to do that? please advice. thanks. HI, dint quite get the intention behind copying the project. Install the Reporting service at both A and B. and then deploy the reports in both the servers. Does that sound good. Regards VB "someone@js.com" wrote: > hi, I have a report project in server a and now I want to move all the > reports to server b, how to do that? please advice. thanks. > > > > . > Thanks, Yes, that works. ...

Issue Bulk mention in Subject line with Quick campaign
We have started to Bulk email and all going well in version 4.0. However when we received a reply from the customers, the subject indicated [Bulk] This looks very unprofessional and unpersonal to our idea. Any ideas how to disable this mention of "Bulk" when sending mails through Quick Campaigns. Haven't tried yet with Regular Campaigns but would assume same is taking place.. Any ideas would be greatly appreciated! Hi JS, If you have the tracking token enabled, crm will just add the tracking token at the end on the subject. Otherwise, the subject will not be changed. Ca...

Custom VS Report for CRM 4.0
I Have a problem and I couldn't find it on any other forum topic. I created a custom SQL report using VS 2005 and it tests just fine and when I deploy it to the report server it opens up just fine from the Http://localhost/reports page. I then try to import this SQL report file inside CRM 4.0 and it comes out with the error An error has occurred during report processing. Query execution failed for data set 'Lead_Capture'. The SELECT permission was denied on the object 'LeadBase', database 'XXXX_MSCRM', schema 'dbo'. Now I know it has something to do...

customized reports
i need help customizing reports in hq i am operating aclothing stores need help specially for inventory turn and top performers section please help.shawn@2cuteny.com HI shawn., it is night here, tommrow morning i will forward you all the reports. I got already your email. "shawn" wrote: > i need help customizing reports in hq > i am operating aclothing stores need help specially for inventory turn and > top performers section > please help.shawn@2cuteny.com > Would like the same - if possible. Sbinder@venus.com "Akber Alwani" wrote: > HI sha...

Reporting services export to excel
We have found that the new reporting services product direct export to excel only works with xp or office 2003. Has anyone gotten this to work with excel 2000? and if so, how? ...

REPORT is BAD REQUEST
Hello I have the Server Performance Report being sent to my email address. Every time I get the report it says Bad request (Invalid Host Name). It was working fine but all of a sudden it stopped working correctly. Anyone know what I need to do to fix this issue? thanks for any help. ...