Search Results

Search found 20045 results on 802 pages for 'reporting services 2005'.

Page 206/802 | < Previous Page | 202 203 204 205 206 207 208 209 210 211 212 213  | Next Page >

• How do I group a SSRS report by month?

  - by Anthony K

  I have a set of data that includes a field with the datetime that events happen. i want to group the events by month. I haven't come across a simple and elegant expression to achieve this. So far all I can come up with is to convert the field to a date, then take the year and month as integers and then convert this back to a string with the day set to 1. In Crystal Reports I would group on the datetime field and then set the period to month, very easy. I am sure there is an easy answer to this that I haven't been able to find.

  Read the article

• SSRS Issue: Rounding to nearest .25

  - by D.R.

  I have an SSRS (2008) report that takes in a raw transactions, then groups and totals them. At the "Total" level, I would like to round the final numbers to the nearest .25, however I cannot find a method to do this. According to what I've read, the Round() function in SSRS only rounds to integers. I have found a couple ways to do it in SQL, but the problem is, I want to do all the calculations with the REAL numbers and just round the result so that I don't introduce a significant amount of error from the real numbers. Here's the best SQL solution I could find: dec(round(number * 4, 0)/4,11,2) as Nearest_Qtr Anyone know how I could do the equivalent in the actual SSRS report? Thanks in advance for the help!

  Read the article

• IIS Active Directory double handshake hickup

  - by AngryHacker

  I have a .net 2.0 click-once application that connects to IIS web services on Windows 2003 R2 64-bits. The IIS is setup with Integrated Windows Authentication. So whenever a web service call is made to IIS web services, there is a double handshake taking place: Client Request #1 GetEmployeeList Server Response #1 <- 401 HTTP/1.1 401 Unauthorized WWW-Authenticate: Negotiate WWW-Authenticate: NTLM Client Request #2 REQUEST Header... Server Response #2 <- 200 Data Received Lately, however, Server Response #1 will sometimes (a good 20 percent of the calls) take a massive amount of time (like 25 to 30 seconds). How do I debug this problem? Is this a Active Directory problem or a Domain Controller problem?

  Read the article

• A good alternative to crystal reports over the internet

  - by Paul

  I have so many problems with using crystal reports over the internet. I admit that the web viewer looks good and the reports you can produce with it are really good but... I have issues with diffrent versions on diffrent servers The development tools are worse than access I dont understand it. Does anyone have any good alternatives for displaying and outputting reports over the web?

  Read the article

• How to handle when SSRS does not automatically update fields based on database query?

  - by badpanda

  So I am trying to change the number of fields in my dataset in SSRS and the refresh button is not picking up the added field from the SQL server. The query is definitely returning the correct data, as I have double checked in the server engine itself. Also, I have tried manually adding the field using the SSRS menu, but as soon as I execute it disappears. Any suggestions or similar experiences?

  Read the article

• Deployment of SSRS 2012 From SSDT Fails - The specified report server URL could not be found

  - by Tony Covarrubias

  I have recently installed SQL Server 2012 Developer on my laptop. I created a simple SSRS report using AdventureWorks201. The report builds fine but will not deploy. I get the error "The specified report server URL http:/localhost/Reports_MSSQLSERVER2012 could not be found" I am able to browse to said URL without issue. I can even upload the report and run it just fine. I am using an administrator account in both cases (on the URL and within SSDT). Is there some reason why SSDT cannot see the URL I am specifying?

  Read the article

• How to implement Self-host WCF data serivces (http://localhost:1234/myDataService.svc/...)

  - by warmcold

  I have a project that needs to implement WCF data services (OData) to retrieve data from a control system (.NET Framework Application). The WCF data service needs to be hosted by the .NET application (No ASP.NET and NO IIS). I have seen many WCF Data Service examples recently; they are all hosted by ASP.NET application. I also see the self-host (console application) examples, but it is for WCF Service (not WCF Data Service). Here is my question: It is possible to have a standalone .NET Applications to host WCF Data Services ((http://localhost:1234/mydataservice.svc/...). If yes, can someone provide an example? Thanks.

  Read the article

• Eclipse BIRT - Unnecessary inline style with external CSS when rendering HTML

  - by Etienne

  Hello! I am designing a report using external CSS with BIRT 2.5. When BIRT renders the html report, it creates copies of each external style to inline styles (name style_x) in the resulting html. The report.design contains: <list-property name="cssStyleSheets"> <structure> <property name="fileName">… mycss.css</property> <property name="externalCssURI"> http://.../mycss.css </property> </structure> </list-property> The resulting html contains: <style type="text/css"> .style_0 {…} .style_1 {…} …. </style> <link rel="stylesheet" type="text/css" href="http://.../mycss.css"></link> For each reference of my styles, the rendered html elements use both styles usually like this: <div class="style_x myclass" …. > …. </div> Is there any way to get rid of the useless inline styles when rendering html?

  Read the article

• Lookup function not working (RS SP2)

  - by Al Reyes

  Hi, I made the upgrade to SP2. I'm trying to use the Lookup function to link data from two different servers. I'm trying first a simple exercise linking data from two datasets from the same server, having one dataset with journals and the other with the account description. My Expression looks like this at a field on the table I have: =Lookup(Fields!ACTINDX.Value,Fields!ACTINDX.Value,Fields!ACTDESCR.Value,"ACCTINFO") I made sure of the names and using only uppercases for datasets and fields but I'm receiving the following message when I try to preview: "An error occurred during local report processing. The definition of the report '/DETAIL' is invalid. The Value expression for the text box 'ACTINDX' refers to the field 'ACTDESCR'. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope". I'll appreciate any suggestions. Regards, Al

  Read the article

• Grouping Categorized Data In WPF.

  - by VoidDweller

  Here is what I am trying to do. Dynamic Category: Columns can be 0 or more. Must contain 1 or more Type Columns. Will only be displayed if any row contains Type Column data associated with it. Data Rows: Will be added Asynchronously. Will be grouped by a Common Category column. Will add a Dynamic Category if it does not yet exist. Will add a Type Column if it does not yet exist within its appropriate Dynamic Category. Platform Info: WPF .Net 3.5 sp1 C# MVVM I have a few partially functional prototypes, but each has it's own major set of problems. Can any of you give me some guidance on this? Envision this nicely styled. :-) -------------------------------------------------------------------------- |[ Common Category ]|[ Dynamic Category 0 ]|[ Dynamic Category N ]| -------------------------------------------------------------------------- |[Header 1]|[Header 2]|[ Type 0 ]|[ Type N ]|[ Type 0 ]|[ Type N ]| -------------------------------------------------------------------------- |[Data 2 Group] | -------------------------------------------------------------------------- | Data A | Data 2 || Null | Data 1 || Data 0 | Data 1 || | Data B | Data 2 || Data 0 | Null || Data 0 | Data 1 || -------------------------------------------------------------------------- |[Data 1 Group] | -------------------------------------------------------------------------- | Data C | Data 1 || Null | Data 1 || Data 0 | Data 1 || | Data D | Data 1 || Null | Null || Data 0 | Null || -------------------------------------------------------------------------- Edit: Sorting and Paging is not necessary. I have looked at nested ListViews and DataGrids, dynamically building a Grid. Dynamically building a Grid and leveraging the SharedSizeGroup property seems the most promising strategy, but I am concerned about performance. Would a better approach be to consider this a dynamic report? If so, what should I be looking at? Thanks for your help.

  Read the article

• How to use Jasper reports without templates

  - by Khanser

  Hi I would like to use Jasper reports and build the report without templates. How can i get started? I have all the necessary libraries but I don't know how to start and I couldn't find anything. Thanks

  Read the article

• programming with business intelligence studio

  - by every_answer_gets_a_point

  does BI studio come bundled with another software? i am trying to create a report server for SSRS but am not able to find BI on my computer and cannot find a place where to download. thank you!

  Read the article

• Building a service for a Drupal site to duplicate a node to another Drupal site in a multi-site setu

  - by EricP

  I'm trying to set up one of my Drupal sites to push a node to another Drupal site in a multi-site configuration. It looks like I need to do this with services somehow, but I can't find any tutorials out there and I need at least to be pointed in the right direction. What I believe I need is set up Services on the receiving site to accept a call from the sending site which will be sending the node object via Json or serialized PHP using a Key that was set up on the receiving site. Can anyone show me an example of this working or give me some insight? thanks

  Read the article

• MTD Expression on a single column - SSRS

  - by Eric

  I need a bit of help here. I have been unable to create an 'Month To Date' expression to a single column on SSRS. I tested the following expression from a similar question in the forum, but it gives me a squiggly line below the variable 'd' =IIF(Fields!CreateDate.Value >= DateAdd(d,-7,Today()), Sum(Fields!Sales.Value), 0) If I run it, of course I got an error telling me that 'd' is not declared. ;) I changed it to ... DateAdd("d",-7,Today()), Sum(Fields!Sales.Value) ... following the example and the squiggly goes below the brackets of "today()" and needless to say it...but still not working. I tried a Dateadd(mm..Datediff ... and still nothing. My report has the following columns: Country | CustomerName | Sales | InvNotProcessed | Open Order | Orders | TotalbyCust What I need is to show the new MTD sales only in the column named "Sales" while the other three shows the rest of the query, which should be open as some orders may take quite a while to manufacture and invoice. the last column sums the totals of all other columns. Any help will be much appreciated. Regards, Eric

  Read the article

• How to quantify your "slow" development machine?

  - by lance

  ( Please provide the question this one duplicates. I'm disappointed I couldn't find it. ) My development machine is "slow". I wait on it "a lot". I've been asked by decision makers who want to help to fairly and accurately measure that time. How do you quantify the amount of time you spend waiting on the computer (during compiles, waiting for apps to open every day, etc). Is there software which effectively reports on this sort of thing? Is there an OS metric (I/O something something, pagefile swapping frequency, etc, etc) that captures and communicates this particularly well? Some sort of benchmark you'd recommend me testing against?

  Read the article

• ms access negative page numbers

  - by FrustratedWithFormsDesigner

  I have an access report that generates 36505 pages (un filtered, and about half of each page is taken up by group headers and page headers) , though the footer at the bottom of the report page says "36505 of -29031". This looks like an overflow problem maybe, though I'm confused how it got the current page number of the last page OK, but failed to get total page count. Has anyone dealt with this before?

  Read the article

• BIRT PDF report : fixed table heigth?

  - by kiwifrog

  Hi, I am trying to display a table to display of products (rows) in a single A4 fixed layout page. I manage to add a table with header/detail/footer sections but I can not set a minimum heigth for the detail section (150mm for example). If I set a 150mm heigth on the detail row, then Each row will have that 150mm heigth. Whereas I would like, each row to have a minimal heith (could be on several line if the content of some columns is wrapped). +---------+--------+--------------+ Tbl Hdr | col1 | col2 | col3 | +---------+--------+--------------+ Tbl Dtl | [val1] | [val2] | [val3] | +---------+--------+--------------+ | | <-should have a variable heigth +---------+--------+--------------+ Tbl Ftr | | | Total | +---------+--------+--------------+ If a set not heigth on the detail row then the footer comes, right beneath the detail rows, instead of sticking at the bottom of the page :-( I hope this makes sense (if not I could provide more details). Any help would be greatly appreciated. Thanks in advance.

  Read the article

• SSRS - Sort table based on column value

  - by Ehsan

  I am trying to sort the following table: hYear hSale ------------------------------------ [year] =Count(Fields!sale.Value) The table only has one row group (year) and no column group. I'd like to: -initially sort the table based on the calculated value; is it possible? -add interactive sort to calculated column based on the value. I assume I should sort 'Detail rows', but what will be the sort expression?

  Read the article

• How to start a disabled windows service from command line?

  - by Rob Ferno

  How do I start a disabled windows service from command line NET START "Service" doesn't work on disabled services

  Read the article

• Draw chart for every row of the dataset in SSRS. Loop through dataset rows

  - by Rushme

  Hi, Could anyone help me with how can we create chart for every row of the dataset in SSRS (rdl) ! Suppose the dataset has the following data Name Age ------- ------- A 25 B 26 C 22 3 chart needs to be drawn for the x-axis/y-axis combination of A/25, B/26, C/22. How can I loop through rows of the dataset. And how can I restrict the chart to that particular data point. What would be the xsl expression corresponding to this functionality.

  Read the article

• HowTo: Conditional Page Break in SSRS 2010 ?

  - by SwissCoder

  Hi there I just migrated a project from .NET 3.5 to 4.0, accordingly the reports now use SSRS included in .net 4.0/VS2010. Before conditionally setting a rectangles visibility did the trick for me. (inside the rectangle I put a rectangle with a pagebreak) But this stopped working now.. any help appreciated

  Read the article

• An error has Occurred During Report proccesing

  - by Erez

  hi , When I'm running the report I'm getting that message above. The Report Works fine when I press the "Run Report" Button but I want also to avoid that annoying message that appears when the page loads. I've tried to set the report viewer control to Enable = false; and only after hitting the button to Enable = true; but it didn't work.

  Read the article

• Passing table data to PRPT from xaction

  - by Manoj

  I am getting data from a query and processing it using Javascript in the xaction file. Now I want to pass the processed data (a 2D array) down to a prpt where it will be used to generate graph and table. What is the format in which Javascript would generate the data and how is it passed to and received by the prpt file from the xaction. Thanks...

  Read the article

• How to use SSRS to retrieve HTML snippets with embedded images the easy way

  - by Ram

  I have a web-app that retrieves reports from our SSRS server dynamically - we hit a URL and out pops some HTML4.0 which I stuff into a div for the user to view. I recently tried adding a report that has an embedded image (in the RDL itself) and the image doesn't make it through. What does make it through is an IMG SRC reference back to the SSRS box but we do not allow end users to hit the SSRS box directly... users query the web-app and the web-app interacts with the SSRS service. There is an option to render in MHTML (note that we typically use rs:command=RenderHTML with rs:format=HTML4.0) - the blob returned appears to be valid MIME but does not seem friendly for stuffing into a DIV... am I missing something obvious? My next step is to parse the MIME, swizzle the references and stuff the whole thing back into the page but I feel like this is the hardway. What is the easy way to retrieve HTML snippet reports out of SSRS with embedded images?

  Read the article

• SQL Server query

  - by carrot_programmer_3

  Hi, I have a SQL Server DB containing a registrations table that I need to plot on a graph over time. The issue is that I need to break this down by where the user registered from (e.g. website, wap site, or a mobile application). the resulting output data should look like this... [date] [num_reg_website] [num_reg_wap_site] [num_reg_mobileapp] 1 FEB 2010,24,35,64 2 FEB 2010,23,85,48 3 FEB 2010,29,37,79 etc... The source table is as follows... UUID(int), signupdate(datetime), requestsource(varchar(50)) some smple data in this table looks like this... 1001,2010-02-2:00:12:12,'website' 1002,2010-02-2:00:10:17,'app' 1003,2010-02-3:00:14:19,'website' 1004,2010-02-4:00:16:18,'wap' 1005,2010-02-4:00:18:16,'website' Running the following query returns one data column 'total registrations' for the website registrations but I'm not sure how to do this for multiple columns unfortunatly.... select CAST(FLOOR(CAST([signupdate]AS FLOAT ))AS DATETIME) as [signupdate], count(UUID) as 'total registrations' FROM [UserRegistrationRequests] WHERE requestsource = 'website' group by CAST(FLOOR(CAST([signupdate]AS FLOAT ))AS DATETIME)

  Read the article

< Previous Page | 202 203 204 205 206 207 208 209 210 211 212 213  | Next Page >