I would like to create the dynamic ServerReport, thru which end users can select the required fields according to the required conditions.The required fields and conditions has to be decided in ASP. NET page(aspx. cs)
View 3 RepliesI'm using ReportViewer in Asp.net 2.0 to view a SSRS report. I need the value of the selected parameter to use in a vb query. The parameters are populated on the server and its a single selection. Doing searches I've come across ReportViewer1.ServerReport.GetParameters() but I can't figure out if I can use this to determine which value the user has selected in the parameter dropdownlist.
View 2 RepliesI have created a dataset in the ASP.Net. I'd like to use the same dataset with my SSRS Report.I am aware it is possible with the ReportViewer.LocalReport with the following code:ReportViewer.LocalReport.DataSources.Add(ds).What I'd like to do is to associate the dataset with ReportViewer.ServerReport so I can avoid calling the stored procedure and save on performance time.
View 5 RepliesI am new to SSRS and i wanna sample projects for generating praogramatically dymaic rdl repots in c#.....
I have checked in www.dynamicrdl.com but din't get correct guidance , like how to start with?
I just got recruited in a company, My boss told me to do some research in Sql Server Reporting Service, I managed to create report, that too in the format required...(In Visual Studio 2010 Reporting application)But now my boss want to make some more research and come up with a mechanism to do dynamic reporting,(in Visual studio)If we give the Sql, Column Names, and GroupBy Field Names it should be able to give a report dynamically...Is that possible...i think he is just tryeng to scare me off...if its possible where should i start working....
View 3 RepliesI have a requirement to create a XML file from sql server data.I need to schedule this job to run at specific intervals of time.I don't know, if I could do with Reporting services.I would like to know, if it's possible with Sql server reporting services? how to do that.
View 2 RepliesI'm trying to call ReportViewer.ServerReport.Render similar to what we did in VB.NET or C# this way,
exportBytes = ReportViewer1.ServerReport.Render("PDF",None,mimeType,encoding,fileNameExtension,streamids,
Warning)
But I'm getting this error "expected Reference,but found null"
im creating dynamic buttons on page load and on the click event of button1 handlere iam creating more buttons this is going fine but on click event of button 2 work is not done so how to maintain a chain of creation of button on click events
protected void Button2_Click(object sender, EventArgs e)//
{
ClientScript.RegisterClientScriptBlock(this.GetType(), ((Button)sender).ID, "<script>alert('Button_Click');</script>");
Response.Write(DateTime.Now.ToString() + ": " + ((Button)sender).ID + " was clicked");
}
protected void Button_Click(object sender, EventArgs e)//this button click will call all the items related to department
[code]....
I have a project where I need to create menu buttons from a list in SQL Server. The problem I am having is that I need to add code to the text of those buttons. So there would be a birthday button and it should display the number of birthdays within the next two weeks or a button with the number of upcoming events.
Clarification:
There is no code yet, just some requirements. What I am doing is querying a table to get the list of buttons to display. Now each of these buttons may have dynamic text, for things like count of birthdays, events,etc... I am trying to see what the best way would be to handle this. Should I embed a snippet of code to go along with the menu item to execute when I iterate over the menu items? Maybe I should build a javascript file to go along with the code, which I add code to query a service for certain menu items?
I'am looking for a dynamic reporting tool for Asp.Net. Tool should support drag drop of data fields, simple grouping and simple expressions. Actually end users will use this tool for data listing. Rendering to html and pdf is enough.
View 2 RepliesI have a report that is supposed to have a check box selected if the Lead value is -1. Else it is supposed to be unchecked. I already know that rdlc's do not have check boxes. Now I have the two check box images in a ftp directory, one image looks selected and the other looks unselected. I have the problem in my if statement when I render the report it gives me the error of No Colons. But I need colons 'ftp://' in my IIF Statement.
View 1 RepliesI have only just started to use Reporting Servcies and would like to know is there any way of putting IF statments into the SQL statment depending on the value of a selected parameter.
[Code]....
What I would like to do is when "Parameter!RP_Area.value" = 99 then miss that part of the sql statment out, something like this.
[Code]....
if this is possible and if it is how would I go about doing it?
I my application i have generated dynamic rows that contains some textbox values, i need to take those values and display in reports. I am storing that dynamically added values in another table.
View 1 RepliesI am having sp which is an dynamic sql to fetch an end result, when I called that to report wizard in both report builder and winform dataset. it was able to create the required parameter but was unable to fetch the data fields used in that sp. How to fetch that fields into the dataset .
View 3 Repliesi am making a report.rdlc which depend on the statment
[Code]....
which doesn't have a specific column name
how can i fill the table in the report
column value in table =Fields!columnname.Value (how can i get columnname, it is dynamic)
i want to pass sql select statement dynamically from asp.net web page to report server.Depending upon this report has to be generated.
View 1 Replieshow to dynamically change the Report design InteractiveSize property? I want to use a radiobutton list which has two options (complete list, paginated list) which changes the height of the Report display. I wonder if I need to use the Report Parameters but how do I change and refresh to display the selected option.
View 2 RepliesI need to create stored procedure to use it for multi value parameter.. I createdd new data set and changed the type to stored procedure but how can I write my select statement in it?
View 4 RepliesI would like to know how to build interactive dashboards using sql server reporting services. I am using the .rdl reports where I can generate a static gauge report but I want my user to interact with gauge at runtime to see its effects .I hope am making myself clear.
View 1 RepliesI want to create fast loading reports like ActiveReports or DevExpress but the problem is I don't know where to start. Also I want it to be light and take less space in setup file.
Does anybody tried to do this? Can I write this component with .net?
This must not be so hard?
I am new to MDX and Sql Server Analysis Service and I've searched this high and low and read a lot of articles, but cannot figure out how.I know this is tough after reading so many articles online, and thus I am only trying my slim chance of getting something helpful from here. I need to create a sales report and want to parameterize the region, so, I'd like to have something likeSELECT blah blahFROM [MySsasWarehouse]WHERE @regionThe @region may take values such as [USA].[Northeast].[New Hampshire], for example.How do I make this happen with MDX? I learned that I can doSELECT blah blahFROM [MySsasWarehouse]WHERE STRTOMEMBER('[USA].[Northeast].[New Hampshire]')But, I have no idea how to have something like STRTOMEMBER(@region)and to be able to pass values to that @region variable.
In the end I would like to create a SSRS report using this MDX query and pass different values to @region. Do NOT point me to articles about how to pass parameters to SSRS, because I know how to do it through the URL query string.My question is How to create parameters for MDX query per se, and I haven't been successful in attempting to do so.
i was trying to create rdlc report on the fly based on the fields selected.
after some research i found using rdlc/matrix i could create the reports on the fly. i found it from this link.
[URL]
but rdlc/matrix report is based on the xslt templte. How can i create the xslt matrix tempalte for this purpose.
I am using rdlc in asp.net 2.0 .Is there any way to Create table of content in rdlc ?
View 1 RepliesI need to create a subscription for my SSRS reports in an asp.net page.I can show the reports in a reportviewer using Reporting.WebForms. SSRS is on the another computer in my network. For reportviewer, I use "admin" and "pass" for credentials which is the SSRS machine's admin username and password and it's ok. And admin has all the roles for SSRS reports. But when I try to createSubscription via ReportingService2006 web service I can't make it. I'm not a professional nor amateur. searched the web a lot. tried this and the odetocode version of this: 1. technet - something similar 1
View 1 RepliesI am trying to create a ad-hoc reporting system and plan to create the report rdl programatically using a wizard where user selects the attributes of the report.
point me to any documentation, sample application that I can refer to on how to create the rdl file programatically?