I have one SQL Query and it is working fine. Now, I want to access another table using One of the columns in this table.How can I access that value and How to put that in the existing SQL Query
View 4 Replies1. I have a GridView on my page and it uses sqldatasource with parameterized query. What I want to do is, on page load (where nothing has been selected so no parameter supplied), I want it to query everything (something like SELECT * FROM [this_table]) but since my SelectCommand is something like
SELECT * FROM [this_table] WHERE [this_column] = @someParameters AND [that_column] = @someParameters.
Can I play around with default value to achieve something like that but how ? Now, when the page loads, it doesn't show anything (No Gridview).
2. On my page, I made something like (username, gender, address, and more) and one single search button. That means, no single control enable auto postback. What I am trying to accomplish is building dynamic query
(if username specifed -> SELECT * FROM [this_table] WHERE [username] LIKE @username).
If both username and gender are specified (SELECT * FROM [this_table] WHERE [username] LIKE @username AND [gender] = @gender) and you know the rest. How can I do this using GridView and SqlDataSource ? To my knowledge, I can only specify one SELECT statement in a sqldatasource.
Iam working on a banking web application developed in asp.net 3.5 and MS SQL Server 2008.My problem is to create reports including some pre-formatted reports,summary reports and some detail reports.I want to know what is the best technique to create these reports.I don't want to use third party reporting tools as they have to be configured on the web server and some times they takes lot of time in generating reports due to their complex structure.Since its a web application having large recordsets so i need a consistent solution keeping in mind the performance and complex nature of the reports which might be demanded by the banks.Can anyone help me please in this regard?
View 2 RepliesI am using ssrs 2008. My Report can generate 5000 Record count , 10000 Records count or more than 10000 records count.
When i am rendering large reoport above 10, 000 record count i am getting timeout Exception error.
how can i avoid that exception..?
i read through some forum can genarate one report into mulitiple reports by dividing the record count.
how best i can work on Rendering Large reports.
I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or something missing.
View 1 Replieswhat would be the user name and password of http://localhost/Reports to access SERVER 2005 Reporting service
View 7 Repliesdifferences between ssrs reports and crystal reports?
View 2 Repliesit possible to pass the query dynamically to sql server report from .net or from any other source.
View 1 RepliesI have table having data like:
ID Date Name
1 1/1/2009 a
2 1/2/2009 b
3 1/3/2009 c
I need to get result something like...
1 1/1/2009 a
2 1/2/2009 b
3 1/3/2009 c
4 1/4/2009 Null
5 1/5/2009 Null
6 1/6/2009 Null
7 1/7/2009 Null
8 1/8/2009 Null
............................
............................
............................
30 1/30/2009 Null
31 1/31/2009 Null
I want query something like..
Select * from tbl **where month(Date)=1 AND year(Date)=2010**
Above is not completed query.
I need to get all the record of particular month, even if some date missing..
I guess there must be equi Join in the query, I am trying to build this query using Equi join
I am somewhat of a novice at ASP.NET, but have a lot of database experience. I want to build a web query interface to allow users to get data back from a database. The idea would be to choose various fields (I have about 20+ fields and 200,000 records in the database, and use either the checkbox, listpicker, radio, etc. to select the fields they want). Then the person could search by date, or search by greater than/less than statements in a particular field.
For example: the user could select: Temerature as the variable, and then Greater than and then enter a value and hit submit. I'd like the option to be able to include all the other fields from the table as well (maybe with a check box or something).
Here is my table and data of these tables
Table name: Code
CID Code
1 abc
2 def
3 xyz
Table Name : Details
ID Name CID
1 a 1
2 b 2
Resultant Table:
ID Code Name
1 abc a
2 abc Null
3 def b
4 def Null
5 xyz Null
6 xyz Null
I nned to get all record from the code table and against each code I have to get all the rows from the details table, if some code have value their need value and if not then Null
I want report generted based on value from querystring.
View 3 RepliesI was very happy that i can generate reports in ie7
after updating to ie 8 things has gone wrong :(
I am generating 9 different reports
user can select one report and can generate the perticular one.
But in ie 8 i can generate only first report
even if i select the second record it generates only the first
It seem some problem.
i can gethe second report if and only if i refresh report page
what can i do?
(note in adavance:I dont have a doc type in my page )
I can display reports as pdf's through the code no problem but my aim is to be able to display multiple reportviewer reports in 1 pdf but even when I fill the memorystream with 2 lot's of reports, it still only displays one as a pdf.
A snippet of my code is below:
byte[] bytes = rptViewer.LocalReport.Render(
"PDF", null, out mimeType, out encoding, out filenameExtension,
out streamids, out warnings);
[code]...
If I have an XML file, can I use it as a datasource for a RDLC file?
View 4 RepliesI am trying to use a parameter field where there is a subreport in my main report but i keep getting the error "subreport cannot be shown" when running the report.
p.s - I have just set the parameters the same in the subreport as the main report.
I'm build a web page in ASP.net is supposed to work just like Query Analyzer. It has basically a textarea to input the sql command, and an Execute button.I'm using SMO to execute the command in the database, as follows:
//Create object SMO
Microsoft.SqlServer.Management.Smo.Server server = new Microsoft.SqlServer.Management.Smo.Server(new Microsoft.SqlServer.Management.Common.ServerConnection(oConn));
//To execute the command
server.ConnectionContext.ExecuteNonQuery(tbx_cmd.Text);
//OR
myDataset = server.ConnectionContext.ExecuteWithResults(tbx_cmd.Text);
The problem is that the textarea command can contain anything, from a stored procedure (with GO's statements) and any select command that return resultsets, just like Query Analyzer.But, if I have GO statements, I only can perform the query using ExecuteNonQuery method. If I use the ExecuteWithResults method, it raises errors because of the GO statements.And if I want the resultsets to be available, of course I can only use the ExecuteWithResults method. how can I do to execute the same command texts at the same time?
I have SSRS (discountasp.net) and I currently display reports on my web page using Reportviewer and use .net code to authenticate them (username/password). Recently I have bought VPS (Windows Server 2008 Web Edition + .net 4.0) and would like to use SSRS the same way as above. I have never done this before so need some guidance on that just to ensure the server is still "safe". Below are some questions that I think are related but feel free to add other comments that I didn't think about.
1) Set up new user? What permissions are required?
2) Configure SSRS to for external connections?
3) Firewall?
I have SSRS reports deployed on report server. Now I want to use these reports in a web application. Is there is any way to show these reports without using the reports viewer control of asp.net.
View 1 RepliesI'm designing some reports to summarize recently compiled research findings. These reports are going to be posted on an ASP.NET page (via the report control) on the web site. I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup. I need alternative solutions to the problem of making a report viewable by everyone who visits a site. I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.
View 3 RepliesI want to create header for reports(.rdls).Now i am designing reports ,all reports have same header ...so i want to create fixed header file for all of my reports.
View 1 RepliesI am using VWD 2008 with VB.Net code-behind. I have multiple parameterized RDLC reports that use tableadapters in a .xsd dataset that I use a reportviewer to view / export the PDF reports.
Lately, we have noticed that the reportviewer is causing many errors on our webserver and sometimes causing the webserver to crash. It has been recommended to me to move the RDLC reports to SSRS, which we also have up and running on another server.
My question is how do I do this? Do I have to convert them to RDL files? What about the fields on the .aspx pages that supply the parameters? Also, what do I do with the tableadapters?
We want to not use the reportviewer but still have the capability to retrieve the RDLC reports in PDF format.
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 programmatically exporting multiple reports to a pdf via the ssrs web services using C#.Net. It exports a single report just fine, I was wondering if there was a way to export multiple reports? I tried block copying the byte arrays from all the reports into a single byte array, but it only displays the last report.
View 1 RepliesDue to a recent hard disk failure, my company issued me Windows 7 (in part for certification testing as we begin to roll it out to the general employee base at the end of the year). As a result, I'm using vwd 2010, where I had been using vwd 2005. The existing site used the reportviewer 2005, but I'm finding it difficult to find information about editing those files in vwd 2010. Can anyone point me to the appropriate place or have some insight as to what must happen in order to manage 2005 reportviewer reports in vwd 2010? I have downloaded and installed the reportviewer 2010 add in. The site is using framework 2.0 even though the web servers are using 3.5 (One of the things I need to do is upgrade the site to 3.5, but I have a support issue to work on first.)
View 3 Replies