We use an internal tool that can display ASP pages. I would like to use SQL Reporting Services to create reports in ASP format. The ASP page will access the database to get data. Is this possible possible with Reporting Services?
Ric
Hi,
Reports created in BIDS/ Report Builder in SQL Server 2005 has the following date format:
MM/DD/YYYY 12:00:00: AM
eg: 5/26/2007 12:00:00 AM
Is it possible to create a format in SSRS (similar to the Friendly-Date format in SSAS) such that we can get date format like:
5/26/2007
Any help is appreciated.
Thanks,
Sundar
Hi,
We have developed few reports through SQL Server Reporting Service 2005.
All those reports are columnar graphs (BAR charts).
One of the requirement of the project is to have the ability to export the report in different formats.
Since our reports are columnar graphs we are unable to export it to CSV or MHTML format.
Is there are setting in the report, which allows me to display the values, when exported to csv format?
also is there any setting for MHTML format. Some machine open the report in MHTML format and some machine does not.
Any help would be appreciated.
Thanks in advance!
Having just discovered that linked reports do not retain any print formating applied to the original report I thought I'd check out the forum and see if it was just me having a senile moment or if Microsoft had in fact dropped a clanger of massive proportion.
After reading one or two questions from other RS users it does seem as if Microsoft have stuck again and completely diminished a useful feature by stripping it of anything, well....... useful. Well done MS, you once again have my applause for mind-boggling ineptitude of what should be impossible magnitude. Ah, you've got to laugh.
Maybe this and other bugs with RS2005 will be ironed out in Microsoft Reporting Services 2008 - The Search for More Money.
We are using SQL Server 2005 Reporting Services and looking to render our reports to Microsoft Word format. We€™ve searched around and haven€™t really found any useful information on how to do this.
Is Microsoft planning on releasing a Word rendering extension? If so, when?
Has anyone written a custom rendering extension for Word? Or, does anyone know how to write a custom rendering extension for Word?
We need either a Microsoft solution that€™s already built-in to Reporting Services or a solid, free solution. We are not in the market of buying a third-party product like OfficeWriter.
Any help would be greatly appreciated.
Thanks!
Hi,
I had developed my reports using SQL 2005 reporting service. While crerating the report i set the page size to 8.27in Width x 11.69in Height.
I am calling this report in my aspx pages using report viewer.
But the problem is I can't able to set the size of the page to A4 size. When i set the size of the page to A4 while printing the page is divided into two pages.
Is there any way to override the print option in reportviewer where we can set the page size to A4 ?
Thanks and Regards,
Kalpesh Surve
I tried to export a report to excel format. I am getting the below error(Array Index out of bounds). The report is around 12 pages. Any thoughts on this?
Server Error in '/Reports' Application.
Index was outside the bounds of the array. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: Index was outside the bounds of the array.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[Exception: Index was outside the bounds of the array.]
[Exception: An error occurred during rendering of the report.]
[Exception: An error occurred during rendering of the report.]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +489
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +924
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +153
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +303
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Santhosh
I know that SSRS default rendering formats is HTML. is there anyway we can change this behaviour to render in XM format for specific reports.
View 5 Replies View RelatedHello,
Currently, I have to manully create RS 2005 reports which I export into an Excel later. Is there a way to create a SSIS package that could automate this somehow?
Thanks for sharing your thoughts and ideas!
 i have 4 SSRS reports. each report must be scheduled to run at different time and then send the send the reports in txt format (tab delimited) to a ftp server .I am new to SSIS and SSRS.
View 3 Replies View RelatedHey Everyone,
I am new to SQL 2005 and Reports. How can I create an automated weekly report for a database to show Disk usage and top 10 tables. I am after to something similar to the Summary report in SQL 2005. Advantage would be to have it email as well.
Cheers,
Mark Bayliss
Hi All,
Am new to Reporting Services. I need to create some drill down reports. Am unable to find any guidance or tutorials. Anyone please help me to create drill down reports
Thanks in advance
Regards
Nataraj.C
Hi all,
Am new to SQL Server Reporting services. I need to create some Drill down reports. Am unable to find any guidance or tutorials for that. Please help me to create variety of drill down reports.
Thanks in advance.
Regards
Nataraj.C
Is it possible to create reports with Sql Express edition i.e. like you can with SQL full edition? If not are there any other add on free tools that allow you to do this?
Thanks
I am writing a VB6/SQL Server database app.I know I can't add charts to data reports.What is the best means of creating printable reports containing charts -should I simply create a form which contains the required charts & make itpossible to print this out ?.TIA,woodglass...
View 2 Replies View RelatedHi Folks,
I have SSRS and Asp.net2.0. i have been asked to create the dashboard reports for our organization. please give me some tips, how to develop the dashboard reports using this technology?
Is there anyother resources avilable to develop this dashboard reports? thanks in advance..
Thanks,
Senthil
From what I read about the versions, VS 2005 Standard allows for SSRS development.
If I create a new project, I don't see the option to create anything from the BI section to create a report project.
I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.
Do I have to run an .exe file or something?
Thanks!
I seem to be missing something rather obvious... I cannot find a way to create subfolder in my reports project in Visual Studio (2005).
Can someone help me out here?
I have some reports in the same project.
Is it possible to create a global variable that will be used in the different reports?
Thanks in advance.
Hi to all,
I am newbie to Reporting Services technology
I am trying to develop some reports in Reporting Services using Visual Studio Management Express.
Is there a way to create some charts and graphs inside a report?
Have I to use Report Builder?
Thanks a lot
Bye
I have a requirement to create dynamic reports for my client.
once i create these reports then the user will choose columns of there choice.
so the columns may belong to multiple tables.
Now the report should get generated with the layout etc. is it possible.
since our project is totally on the webserver(webbased.)
please if you can provide me with any links with dynamic report creation wizards.
and also we only use Stored procedures via database.
which is best is writing the entire queries right behind the layouit or calling the entire logic via Stored procedure. i am a bit confused. this is my first project working on reports itself.
Thank you all for the helpful information.
Hi all.
Any body give me one example,how to create drill Through reports in Reporting Services.
Regards.
Hi I need to create 6 different reports using Business Intelligence.
Therefore I have to use it 6 times
Is there a way it can be done in one go??
cheers
Can I get ordinary users to create reports rather than admin using a web browser interface?
View 2 Replies View Related
Hi,
I would like to know if is possible to create dynamic reports based on cubes. What i mean is,after creating a cube with a couple of dimensions and measure if is there any way to give the normal users on the report manager or report builder the freedom to choose their own dimensions/measure so they can output the report with the choosen criteria.
Thanks.
Im new / novice user to writing SQL scripting. I have two tables and table1 has two columns
uslid and groupid,
uslid1, group1
uslid1, group2
uslid1, group3
uslid3, group1
uslid3, group3 etc
the second table2 has three columns
uslid, name, and location
uslid1, john, bldg 4
uslid2, jane, accounting
uslid3, joe, mail room
. I am trying to do a inner join but not working and not sure if this will work to create new temp table.
example of what i am trying to get in new temp table on one row:
uslid, name, location, groupid1, groupid2, groupid3
uslid1, john, bldg 4, group1, group2, group3
uslid3, joe, mail room, goup1, , group3
Hope i explained this ok. Im using 2003 server sql 2000 ver 7, thank you in advance.
Situation: If possible, create one stored procedure for Crystal Reports(CR). For any CR users ou
there, looking for coding suggestion also. Thank you for your assistance.
Currently, CR has a header(Report Header) coming from 1 to 1 tables, there is a parameter
which is passed in, allowing it to retrieve one record for the header(report header or RH).
The CR then has 4 subreports in which each has its own stored procedure. This I believe happens
because the Report Header records relationship to the subreport is 1 to many. The 3 remaining
subreports relationship to the Report Header is also a 1 to many. The main problem is the
subreports is that there may or may not have any records based on this, the subreport is
suppressed within CR and thus there can be alot of unused white space on the 1st page and one
of the subreports prints on a 2nd page when it could have been on the 1st page.
Example:
Main Stored Procedure(sp)
RH Tables: aaa, bbb, ccc, ddd are 1 to 1 record tables and have a @xyz parameter.
Results of subreports and their associated procedure are varchar(8000) decriptions. Each line
should be counted in some manner in the stored procedure(sp) and then should be counted in CR
to avoid excess white space. To complicate matters subreport 2 to has font, bold, showbox but
can have different font sizes. These variations could cause different line space requirements.
Any ideas?
Each line should be counted in some manner in the stored procedure and then should be counted
in CR. There is a count of records for each the main stored procedure.
RH has 1 record to many records in subreport 1 with same @xyz parameter.
RH has 1 record to many records in subreport 2 with same @xyz parameter.
RH has 1 record to many records in subreport 3 with same @xyz parameter.
RH has 1 record to many reords in subreport 4 with same @xyz parameter.
Because of the relationships, its seems impossible to create one stored procedure which give
in one select statement with all the 1 to 1, 1 to many relationsips, as stated above. I thought
concatinating i.e. 3 records together and then parsing it out some how in CR, along with
utilizing the i.e. 3 record count to help count lines. Thought of some how creating a temporary
table matrix for 8pt - 28pt for line and spacing considerations.
Hi,
I need to create letter type reports using the report builder, is this possible?. I am trying to create a letter that embeds some variable fields, i.e,. name, address, contact number. I can't seem to find a way to create page headers, and embed report data fields within text. Is this not possible within the report builder? it seems that the only thing you can do within the report builder is add fields to their predesignated areas. I am being forced to use the report builder instead of the report designer in order to give the end user the ability to make modifications to the report/letter. This is very frustrating. not being able to allow the user to edit report designer files, and then having force them to use report builder which doesn't seem to support some simple features..
Any suggestions would be appreciated...
I have an access table that has a primary key (entitled "ID Number"), no duplicates, the field is an integer.And, importantly, the value is set to "increment".The format is "phd"000 - so it starts out phd001, phd002, and so on...How to do this in an SQL table? Can that format be done? Or is it better not to do it via SQL but in coding instead?
View 1 Replies View RelatedI see this all over for creating a Format file:
bcp Northwind.dbo.Products format nul -c -f "c:Products.fmt" -T
Or this for XML
bcp AdventureWorks.HumanResources.Department format nul -c -x -f department.xml -T -S servername
I get an error saying "cannot open a connection to SQL SERVER"
The SQL Server is local on my laptop.
Here is the exact code I am using:
bcp OrderDb.CompanyDepartment foramt nul -c -x -f c:CompanyDepartment.fmt -t, -T
And I have tried :
bcp OrderDb.CompanyDepartment foramt nul -c -x -f c:CompanyDepartment.xml -t, -T
Also, some say to put the server name at the end, but then I get an unknown argument on command line error
We are using an old version of Numara TrackIT for our helpdesk software, and it doesn't have much in the way of configurable options. There is no way to set validation or formatting on the text fields in the program.
There is a field, WO_TEXT1, Which I would like to be formatted as 6 characters, 3 integers + a period + 2 integers. The first the integers would be padded with zeros on the left, and the last 2 integers would be padded with zeros on the right.
IE, if someone enters 2, it would actually end up being 002.00
If someone enters 3.5 it would end up being 003.50
If someone enters 12.1 it would end up being 012.10
If someone enters 172.80 it would end up being 172.80
I was hoping to achieve this via an update trigger.
Below is the guts of the trigger I created, mostly as a proof of concept.
-- This update properly formats the Estimated Hours field
Update t SET WO_TEXT1 = (SELECT RIGHT('000000' + CONVERT(VARCHAR(6), WO_TEXT1), 6) FROM inserted)
FROM dbo.TASKS as t
Where (EXISTS (SELECT * FROM inserted WHERE WOID = 24773));
I expected that this update trigger would only affect the Work Order with a WOID of 24773. Unfortunately, it updated all 21000 work orders in our system, wiping out all of the actual estimated hours that had been inserted by technicians!
Luckily I had a report that I could quick dump the 300 or so active work order's estimated hours back into the DB from (all the other Work orders are closed, and no one really cares about their estimated hours).
My question is three fold,
1) Why did my trigger update every record in the tasks table instead of just WO 24773?
2) Is using a trigger the best way of accomplishing what I'm trying to do?
3) if a trigger is the best way of accomplishing this, what should my trigger look like?
Hi,
Why is taking so long to open/create/render the reports for the first time? Is there any configuration to change this? I don€™t think this behavior is related to Report Execution or cache! I think there is something else going on! Thanks.
I have a date file with no delimiter like bellow
0080970393102312072981103378000004329392643958
0080970393102312072981103378000004329392643958
I just know 5 first number in a line is for example "ID of bank"
or 6th and 7th number in a line is for example "ID of employee"
How can I create a XML format file?