Search results for query: *

I was just about to add the same, Group By journal_number, Left(posting_code,2) Thanks Adam Adam Blackwell Development Manager http://www.shu.ac.uk/

http://www.dundas.com is the link. Adam Blackwell Business Intelligence Analyst http://www.uk.insight.com/

Try Dundas. They do a plug-in which is very good. I think they have a host of different products, charts, dashboards, etc. Not sure of the price but well worth a look. Adam Blackwell Business Intelligence Analyst http://www.uk.insight.com/

Sorted it. The middle matrix didn't have a Static Group whereas the one ont he right did. This matrix was therefore smaller in height than botht the table and the 2nd matrix. Having added in a Static Group, it now aligns fine. Thanks everyone for your suggestions. Adam Blackwell Business...

Ok, this is width of each item table = 19.82936cm matrix1 = 3.5cm matrix2 = 8cm Total = 31.32936 My report width was set to 29.7cm. As each of the matrix can change in width, what would I need to change this to? Adam Blackwell Business Intelligence Analyst http://www.uk.insight.com/

Thanks Geoff, Just tried hosting in rectangles and moving them so they are further apart. Still no joy Rgds Adam Blackwell Business Intelligence Analyst http://www.uk.insight.com/

I'm hoping that someone can help and this is not just a "feature" of RS. I have a report that is rendered as follows: table matrix matrix All looks ok when developing and the top of each is lined up. However, when the report is uploaded, the middle matrix is lower than the other 2 and...

I wonder if someone could help. I have a query which returns the following: Vendor Revenue ------ ------- Vendor1 100 Vendor2 25 Vendor3 75 I then have a pie chart for this data and currently, the label for each is set to: =format(Fields!Revenue.Value,"#0") & " - " &...

Have a look at data-driven subscriptions (http://msdn2.microsoft.com/en-us/library/ms159150.aspx). With a data driven subscription you can hold the details of your customers in a table with an email address. The report will then be scheduled to use the customer number to run their own...

Are you using a table? If so, enter the same calculation into the table footer, i.e. =sum(fields!InvoiceExtendedPrice.Value,"Customer")/sum(Fields!InvoiceExtendedPrice.Value, "DataSource") Thanks Adam Blackwell Business Intelligence Analyst http://www.uk.insight.com/

In the format propoerty, you need to type dd/MM/yyyy. Remember to use uppercase MM Thanks Adam Blackwell Business Intelligence Analyst http://www.uk.insight.com/

Did you ever get a reply to this? I am having the same issue and it's driving me mad! Thanks Adam Blackwell Information Analyst http://www.workinglinks.co.uk/

When it creates the csv file, any values within the Group will be displayed in fields within each record, i.e. a count of records per group will appear as a column and the value will be on every record. If you rename the textboxes to meaningful names, this will then appear as the column...

You could put an expression in the Pending column: =IIF(Fields!Status.Value = "Open",Fields!Amount.Value,"") Then in the Collected column, you will need another expression that does the same but for whatever the Status should be. Hope this makes sense Adam Adam Blackwell Information Analyst...

Try the following select c.ItemID, c.CollectorID, c.CollectorStatus from Chases c where c.CollectorID in (Select c1.CollectorID from Chases c1 where c1.CollectorStatus = 2) Hope this helps Thanks Adam Blackwell Information Analyst http://www.workinglinks.co.uk/

Hi, I have produced graphs where the Max of the Y-axis changes dependant on the max value. On the Chart Properties, set the Scale Minimum to 0 and leave the Scale Maximum blank. Hope this helps Thanks Adam Adam Blackwell Information Analyst http://www.workinglinks.co.uk/

I've just found this on the Microsoft website which should hopefully answer your queries regarding the "Select All" option http://msdn2.microsoft.com/en-us/library/ms143380.aspx Thanks Adam Adam Blackwell Information Analyst http://www.workinglinks.co.uk/

This was an option in RS2005 but was taken out by Microsoft. As far as I am aware, they are to reintroduce it in the next Service Pack (whenever that will be). Hope this helps Thanks Adam Adam Blackwell Information Analyst http://www.workinglinks.co.uk/

I've just tried the following code in the expression of a textbox and it returns Nov 2006 which is the previous month =Format(DateAdd("m",-1,DateTime.Now),"MMM yyyy") Thanks Adam Adam Blackwell Information Analyst http://www.workinglinks.co.uk/

Try the following and see if this works: =Format(DateAdd("m",-1,DateTime.Now),"MMM yyyy") Hope this helps Adam Adam Blackwell Information Analyst http://www.workinglinks.co.uk/