I would like to know if there are any good MDX query builder tools out there. The one that is shipped with AS does not suffice in that it does not support more than 2 axes. Also if there are any are there any that make life a little easier in that they are drag and drop and all but create the statement for you?
I need to create a matrix in SSRS using cubes and in doing so need to write MDX queries, not my strong point. Are there any tools that can help me "auto create" the statement with drag and drop functionality?
Hi people!I'm looking for an SQL query builder application that helps me constructSELECT queries with full respect of underlaying relational model. It wouldbe nice if the app is database independant because my work covers MSSQL,mySQL and Oracle DB.OpenSource and/or comercial suggestions are welcome!*** thanx ***
Trying to type a define formula in report builder and keep getting a (not valid: if) statement. I have to count field columns and i'm trying to sum one if there is an amount in that column instead of getting the sum of both columns.
here is the current formula that i have that is not working If(Loan Funded Month=0,0,Loan Loan Amount)
Writing this formula but have a question on it...IF(AND(DATEONLY(LOAN FUNDED DATE)>=#12/1/2007#,DATEONLY(LOAN FUNDED DATE)<=#12/19/2007#), SUM (LOAN AMOUNT),0)
1) What can I change #12/19/2007# to use the current date and not have to change it daily?
2) When I run this report the report doesn't sum the total amount of all the loans in one line but it puts all the loan amounts on indiviual lines. What can i change to make all the loan amounts to add together and in one line?
Trying to add a column that states the ranking of a specific sales person. So if they are the person that has sold the most then 1 would show and so on down the list.
Hi. I have just started to use Report Builder and I have a question about how you add parameter values to a title on the report.
For example, I have a parameter set up for a range of dates. But I would like the title to show these parameters e.g. Title should display "Sales from 01/05/2007 to 10/05/07" where the dates on the title are the parameters I have chosen.
I can easily do this through Visual Studio, but just wondering if Report Builder had the capability of doing this?
Hi All, I want to build following code into expression builder . I don't know how to write that things into expression builder. so can you help me out from this problems.
I have successfully deployed a standard Report (i.e. non Report Builder) to our Report Server using a Shared Data Source to an iSeries Access for Windows Driver. The Data Source has the following properties:
However when I try to run a Report Builder Report based on a Report Builder Model that uses this same shared connection I get the following error:
An attempt has been made to use a data extension 'OLEDB' that is not registered for this report server. ---------------------------- Cannot create command for data source 'dataSource1'. ---------------------------- An error has occurred during report processing.
For the models I have created, there are tables (X and Y) which have multiple rows per emplid (which is the key that links these tables to the other tables). I want to be able to join on those tables in report builder and have the results only return only the most recent records in the table. Do you know how to do this and can you show me?
I am attempting to create a report using the report builder. I can see the button for the report builder on my report server but nothing happens when you click it. I also attempted to go directly to the url but once again nothing.
Finally, I attempted to run the application directly from the file structure and in doing so there I got the following errors. Could not find file 'reportbuilder.chm.deploy'. I created a junk text file with the same file name and attemted to run the app again and this time I got a error that said: Could not find file 'reportbuilder.exe.deploy'. After that I created another junk text file and named it the same as that.
This is part of the errors that I recieved. This doesn't suprise me based on the hack I did to get to this point. Below is a summary of the errors, details of these errors are listed later in the log. * Activation of Reporting ServicesReportServerReportBuilderReportBuilder.application resulted in exception. Following failure messages were detected: + Exception occurred loading manifest from file ReportBuilder.exe: the manifest may not be valid or the file could not be opened. + File ReportBuilder.exe is not a valid Portable Executable (PE) file. + PE file does not have enough data.
I'm not sure what the overall issue is and why these files would be missing. Any guidance in relation to this situation would be great. Thanks.
OK so I've developed quite a few reports using report server projects. Now I'd like to see what is available to the end-user after I, as a developer, am sick to tears of making and customizing reports. So I went to Report Builder.
I open Report Builder and see the list of my five entities. Then when I drag and drop a field from one of the entities to the report designer, ALL of the four other entities DISAPPEAR!
Can you not design a report in Report Builder using fields from multiple entities? The design of our databases have much to be desired, so that would make using Report Builder impossible...
I'd like to integrate SQL CE 3.5 into a platform builder image(using PB 5 targeting CE 5), but I don't see it in the catalog. Is it currently possible to Sysgen an image with 3.5? Can I somehow deploy the files from the .cab files? Sorry if this has been answered before, I searched around a bit but didn't find anything.
Trying to put a date into my report but the date I'm placing in there has a timestamp as well. How do i get rid of the time and only have the date? Using the function DATEONLY but it still gives the time.
Hi, I have a table A with column say col1, col2,col3. I have a query which has self join on this table. But I can not add same table twice to model from the list of tables ! When I click the table in left pane to right....its no more in left pane ...to select it again !!
Does anyone know how to get the column markers to show up in the report designer? MSDN documentation indicates that they can be used to freeze columns in the report. I can't seem to get them to appear.
Is Report Builder capable of building any complex reports that Visual Studio Report Designer can build? What are the limitations of using Report Builder with SQL Server Databases?
Does anybody know of an easy way to give lots of end-users of MS CRM 3.0 permission to create reports using the Report Builder? Heck, what's an efficient way to give lots of non-admin type users (regardless of CRM) the capability to use the Report Builder? Right now it seems that every Windows user has to be granted rights on an individual basis.
Based on various documentation, it appears that assigning the Report Builder role is meaningless unless users are defined under Site-Wide Settings as being either a System Administrator or System User. I know CRM creates a user called ReportingGroup, but assigning it a site-wide setting of System User with a Report Builder role doesn't flow to the individual members of ReportingGroup.
According to some other documentation I came across, ReportBuilder is a clickonce app that essentially needs to verify that the actual individual Windows user is permitted to access ReportBuilder. Given this fact, then it would seem to me that granting a group appropriate permissions to Report Builder is pointless.
In general, I'm failing to find solid information on SSRS2005 security and CRM 3.0, specifically as it relates to Report Builder permissions.
HI, in a lookup component, when I want to use the query builder, it will show tables from a different connection manager than the one I picked for being the lookup source. E.g. connection manager A points to a schema that contains table1 and table2 and connection manager B points to a schema that contains table 5 and table 6.
When I configure the lookup component to use connection manager B, I still see connection manager A tablles; isntead of seeing table 5 and 6 I see table 1 and 2.
hi,i can do"select * from products where name = @name" kind of statements in query builder but"select * from products where name LIKE @name" dosen't work!" any ideas? i'm using sql server express. thanks
Hi All, For one of our projects, we are supposed to write a query builder to display reports in tabular format. For the filter criteria ( i.e where clause ) user can select from a list of predefined columns and assign conditions to it. For example, user can select 'CustomerName' as the column and specify condition where name begines with 'A'. Similarly he can also select ouput columns Problem The columns that user selects can come from different tables. We are planning to store mapping between tables and columns and also their primary and foreign keys in an xml file. But I would want to understand how to build the join clause. For example, say there are 4 tables customer, customer address, order, and items. Say user wants the number of items purchased by each customer who stays in 'Delhi'. 1. In output column he selects customer.name and count(items.id) 2. In filter criteria he selects address.city = 'delhi' How would the query builder know that to join customer and items, order also has to be joined. Any pointers would be helpful.
I hope you mind a questions from an inexperienced SQL 2000 user.
I don't have much experience with building queries for SQL2000. So I am lookinf for a software tool that will help me create simple queries. I'm also looking for an online (either on the web or a downloadable program) query reference to help remine me how to make these queries.
I am trying to emulate the "Find unmatched Records" Access Query using DTS. I have a small table with a list of codes that I need to use to exclude records in my text export.
I have created a left outer join and set the criteria for the joined field in the 'right' table to be null. I am repeatedly getting no records as a result.
Wouldn't the joined field in the right table for unmatched records by default be null? I'm stumped as to why this seamingly simple process won't work for me. I have attached the select statement for your review.
I restore ReportServer and REportServerTempdb in SQL 2000 to the new server SQL 2005. All the reports are working , however i don't see the "Report Builder" feature in SQL 2005 anymore. Please help me what i need to do to turn on this feature. (I saw it before i restore the 2 above databases.
I am having problems launching the Report Builder. I click the button and nothing happens. I did see the other suggestions about re-installing the .NET 2.0 Framework but that did not help. I tried to launch it directly from the address bar and I am getting the same reponse as when I click on the Report Builder button. I can access the Report Builder from other machines and it works fine. I did just recently install IE 7 and I tried to uninstall it and go back to IE 6 but I got the same results.
I have a very simple condition in the new field but it kept prompting me the error message when I run the report in Report Builder. For example : I have 1 field called City inside Entity Name Location, in the new field I want to set something very simple. If the City is "California" then "Yes" else "No"
But when I created this new field under Report Builder, and use the condition below : IF(City = "California","Yes",No")
And then I put this City field into column inside Matrix, but when I run the report it keeps prompting me this error message :
A grouping expression must be either a scalar field or an entity. ---------------------------- Semantic query execution failed. ---------------------------- Query execution failed for data set 'dataSet'. ---------------------------- An error has occurred during report processing.
