Hi,
I am new to Microsoft SQL Server Reporting Services.
Please tell how to create sections and subsections in the report.
Pls provide if any document is there ..
Thanks
Rajiv Gupta
I have lot of information to display on one report. I am trying to come up with a reasonable layout, that could include all the information on one page without over whelming the user. Essentially I would like to divide the report in three sections, ideally with a collapse/expand functionality. Is it possible with Reporting services. How?
- Section1 Heading....(Expanded/Visible)
<Table, text boxes, lists go here>
<data region>
<data region>
<...>
<...>
+ Section2 Heading (Collapsed/Hidden)
<Table and other data regions are hidden>
+ Section3 Heading (Collapsed/Hidden)
<Table and other data regions are hidden>
Any help will be appreciated.
Thanks.
DNG
Hello there.
With my team we have to convert all our CrystalReports-Reports to ReportingServices-Reports.
Now i have a problem with on functionality in CR.
I just have a table. One group, two columns. like this:
Column1 Column2
-----------------------------------------------------------
GroupTextBox1 empty
-----------------------------------------------------------
empty DetailTextBox1
-----------------------------------------------------------
Now i want to underlay the following DetailRows to the Group.
There can be many DetailRows and the GroupTextBox1 is bigger than one line.
If its possible i dont want to use subreports
Can somebody help me?
Thanks in advance, Tobi
Hi, I've got the query below which works as needed, but it performs the same inner select twice at present. What is the best way of eliminating the second evaluation of the inner select statement?
SELECT TOP 1 condition FROM
(SELECT condition, COUNT(condition) AS total FROM [JCM].[dbo].[jcmresults] GROUP BY condition)
WHERE total = (SELECT MIN(total) FROM
(SELECT condition, COUNT(condition) AS total FROM [JCM].[dbo].[jcmresults] GROUP BY condition))
Thanks,
Andrew
Hey,
Does anyone know of a neat and easy way to modify this section of hardcode:
SELECT CASE dbo.requestsbyyeartemp.themonth when '1' then 'January' when '2' then 'Febuary' when '3' then 'March'
when '4' then 'April' when '5' then 'May' when '6' then 'June' when '7' then 'July' when '8' then 'August'
when '9' then 'September' when '10' then 'October' when '11' then 'November' when '12' then 'December' end as 'themonth', etc...
Requestsbyyeartemp is a table where the numbers corresponding to the months are stored. This statement is used to make a new table where the months are stored with the proper names and not numbers.
I would sooner not have any hardcode at all if there is a simple way to do it.
Thanks
I am learning how to parse XML data into SQL table. Below partial XML data contains multiple sections. I used OPENXML to parse one section but need to parse the remaining sections into a table. For example, below openxml code can only retrieve elements under "NewHires/Newhire/EmployeeInfo/PersonName" section. I also need to parse elements under "NewHires/Newhire/EmployeeInfo/ContactMethod" sections. Notice that there are three subsections underneath the ContactMethod section ("/Telephone", "/InternatEmailAddress", and "/PostalAddress") sections. Not to mention there are EmergencyContact section follow behind.
OpenXML can only extract one section at a time. Does it mean I have to write multiple OpenXML, store them into multiple temp tables then merge them into a single table? If that is the case, how to save all these data into a single table?
parse all the elements in lieu of OpenXML?
Here is the partial XML data:
<?xml version="1.0" encoding="UTF-8"?>
I'm new at Reporting Services. I need to know if the Reporting Services will meet my needs.
I need to create a report that looks much like a Word document with large sections of text. Is it possible to hide some sections of text based on boolean fields in a SQL table/query?
Alternatively.. will it handle rich text? I could then select the appropreate section to display by query.
Thanks in advance
New ssrs istall. I think they loaded sp2. It's a cluster, but ssrs was not clustered (I think)
When I attempt to open report manager, i just get
SQL Server Reporting Services
Home
with no option for creating a folder etc, like i have on development
When I attempt to deploy to ther server I get :
Deploying to http://amsqlclusterxx/reportserver/
Error rsItemAlreadyExists : The item '/Retailer' already exists.
How do I create an ssrs reports folder?
Also, and this is strange, but in vs.net I had to create a new shared datasource after removing the old one on the report with the same name. The report renders fine when I do an f5 pointing to a new datasource, but I no longer have the RUN "!" icon available while in the data tag to run my query. Why is this?
Thanks for any help or information.
Hi,
Am using SQL Server Reporting service to generate reports.Actually i want is a reports containng two sections,How can i achieve that?
Cheers
Jan
On my company's website, we have a quote of the day. I would like to be able to type a hundred or so quotes into a mdf file. Then, I would like to have code that randomly selects one of the quotes every day and posts it.
....What I want is very similar to the "Image Of the Day" section on many websites.
Any ideas?
Hi,
I have a table of data that looks something like: -
County Name Sport
----- ----- -----
Kent Fred Cycling
Kent Fred Hockey
Kent Fred Football
Kent Fred Squash
Surrey Anne Hockey
Surrey Anne Squash
Surrey Anne Netball
Surrey Tara Cycling
Surrey Tara Squash
I am looking to present the data in a tabular format where I would have the data laid out something like: -
County Name Cycling Hockey Football Squash Netball
------ ----- ----- ------ ------ ---- -----
Surrey Fred Yes Yes Yes Yes No
Kent Anne No Yes No Yes Yes
Tara Yes No No Yes No
Where I group by county and then use the unique records from the sport column to dynamically create the headings
All help greatly appreciated
HI
I want to create a report template in SQL Server 2005 Reporting Services.
The template will have a fixed header and footer.I want to use this template in all my reports.
How to do so?
We have created a report called "update" that we want to run every hour and place in a directory called d:infoupdate.pdf
We would like to call the report from a procedure and have the proc generate the report in PDF format in the directory d:info
Does anyone know how to do this?
I'm building my report using the Report Designer in the SQL Server Business Intelligence Development Studio. At the moment I've got a single report which consists of 2 tables. The top table shows some summary data and the bottom table shows more detail.
What I'd like to do is design the report so that when the summary data (in the top table) appears, the user can click on a row in the table and this takes them to a new screen which shows more detail about that item, extracted from the bottom table.
Is this possible? I know it's possible to create a drill-through report if you have the high-level summary data in one report and the low-level detailed data in a separate report, but is it possible to create a drill-through report if all the data is in one single report (albeit in 2 separate tables)?
Hi,
I have only recently started playing around with Reporting Services (2005), and I am having some problems creating a basic report.
What I want to display is a table which shows product names in the first column, sales for a specific period this year in the second column, and sales for the same period last year in the third column. The 'specific period' is determined by specifying a start week and an end week which I have set up as parameters.
I have managed to produce the first 2 column with no trouble. However, for the third column I need to subtract 52 weeks from the parameters and use them as new parameter in the third column.
Can anyone offer any suggestions?
Dave
Hi
I'm not sure if this is possible, i want to create a report from a stored procedure, all the stored procedure does is select data from my database, however, the code is 1800+ lines of code, it executes in about 1 minute, which is fine. My problem is that i can't paste 1800+ lines of code into the dataset in Reporting Services, so is it possible to get the values from my stored procedure into reporting services so that i can use them to design and execute my report?
Or musst i find an alternative way to do this?
Any help or suggestions will be greatly appreaciated and welcome.
Thanks in advance
Kind Regards
Carel Greaves
Can anyone help me?
I've read the instructions on the following page
http://msdn2.microsoft.com/en-us/library/ms159118.aspx
about how to generate a report model from a cube.
I can set up the cube as a data source but when I look at the properties there is no option to "Generate Model".
I am running SQL 2005 DE SP2(CTP).
The option is just not there for me. Any ideas?
Thanks in advance
Hi,
Some of you might remember me posting a question about importing data from a csv. Well I've managed to do that now by writing a vb.net service.
Now all I need to do is have some kind of method of exporting the data as a report via email every night.
The tables are as follows...
CDetails
cNumber
ClName
FE
Disb_1
cNumber
type
dateReq
payee
amount
vat
total
chequeReq
Disb_2 - Disb_20
"Same as Disb_1"
The report structure I need is...
cNumber ClName FE type dateReq payee amount vat total chequeReq
With data from each disb on a new line, i.e. cNumber could be the same for 20 rows! (don't blame me, it's what they want!)
The records should only be shown though when the dateReq is equal to today. I think I can do that with the DateDiff function.
The problem I have is knowing how to set the report up and what to do it in, Reporting services or Business Intelligence. The report only has to be an email, would it even be simpler to write an extra class into my service?
Steve
Hi all,
I'm just getting started with Reporting Services and have a question.
I'm trying to set up a report model based on a UDB data source. However when I use the report model wizard, I get presented with:
[DB2/SUN] SQL0104N An unexpected token "SET TRANSACTION" was found following "BEGIN-OF-STATEMENT" ... SQLSTATE 42601.
I think that this is trying to set transaction isolation levels however this is not valid SQL for a UDB database.
Is there something that I'm missing with my configuration to make RS know that this is a non-SQLServer database?
Many thanks,
JK
Has anyone found out how to dynamically create report width.
If I have 20 columns on a report all of 2cm, then report will be 40cm width.
If I display the columns based on specific criteria using the iif function and then setting the an expression for the Visibility Hidden property, the report could potentially reduce in width.
I cannot see how to build an expression for the report width or table width, to accommodate the potential change in the width of the report when columns are not shown, thus it pages incorrectly, leaving huge white space on the right of the report when columns are hidden... has anyone come across this requirement, and hopefully a solution for it?
Many Thanks people
Hey All,
I am attempting to create a report on SQL Reporting Services that uses a local XML file as its datasource. Although i did not find a way to directly do this, I found an MSDN article that walks a person through on how to use a report parameter to paste in your XML data from the page. When I set up the report in this way, I get an "Invalid URI" error when I go to the preview tab.
http://msdn2.microsoft.com/en-us/library/aa964129.aspx
What would be the best way for me to use an XML file as a datasource using reporting services? Is there a way that I can use a local file and use a parameter to point at that file?
Any info, links, tuts, etc. would help. Thanks!
Nathan
Trying to create a dataset for a report. I need to bring back percentage in the result set. The fields that I am using to get the percentage have valid data but the result field is 0.00%. Is there reason I cant bring back a percentage field?
Code:
SELECT JobNum, Mailed, LT_7, BT_6_10, GT_10,
Format([LT_7]/[Mailed], 'p') AS PctScaned1,
Format([BT_6_10]/[Mailed], 'p') AS PctScaned2,
Format([GT_10]/[Mailed], 'p') AS PctScaned3,
[Code] ....
in my report model project, i'm able to successfully create and deploy a report model based on a data source view that is in turn based on a table object in my data store.
but if i try to create a report model that's based on a a data source view that is in turn based on a view in my data store, well then, the report model that gets created comes up blank - i.e. shows no objects.
What gives? Is it not possible to create a report based on a view? that can't be right!
I'm receiving the following message after I've created a datasource and datasource view:
[DB2/SUN] SQL0104N An unexpected token "SET TRANSACTION" was found following "BEGIN-OF-STATEMENT" ... SQLSTATE 42601.
My application uses 2 databases from 2 different server. When i create a report model in business intellegence development studio I can only create 1 datasource for each database, and 1 datasource view for each datasource. Then when I create a new report, I can only use one datasource.
Is it possible that my report can be built on more than one databases?
thanks in advance
I am trying to create SSRS report with tabs. Something like this
Tab 1
Tab2
Tab 3
Tab4
Tab5
The end user will input a value which will be passed to all the DataSets (my case each Tab will display some information from a DataSet). So when the user clicks on Tab1, it will display relevant information form DataSet1 and when the user clicks Tab2, it will hide the Tab1 information and should display the Tab2 information from DataSet2.I am able to achieve the following:
1. Making the tab clickable
2. Navigating from one tab to another (dispalying relevant information for each Tab) - Using Go to BookMark or Go to Report Option in the Action Property
But I am not able to hide the inactive tab report data. I am building reports and deploying it in SharePoint 2010.
I am new to report builder. I have created a report with a calculated cell that returns a true or false value based on a true or false value from another column (from a dataset field). I want to create a filter for the calculated field (which is a ReportItem), that will only show cells that are True.
I have tried several ways to add this filter, but each time, I get an error message saying that filter or sorting cannot be created for ReportItems.
thanks
View 4 Replies View RelatedHi
View 43 Replies View Relatedhi
i have been tasked with creating a record of all the reports ( 200+ ) within each folder ( bout 20 ) and all the subscriptions (including parameters) for our SSRS i was wondering what the best way of doing this was (SQL query?)
i have tried creating a site map with visio but im struggling to get the subscriptions details
anyone done this before (or have any ideas) i would be very grateful
thanks
Jake
I have the following query that will serve as a basis for SSRS report
SELECT TOP (1000) d.Project_Name, d.Status, d.Country, d.Region, p.Period, p.Quarter, p.Year, d.Brand, d.Store_Opens_Actual, d.DA, d.DPN, d.StoreNumber,
CONVERT(VARCHAR(10), CASE WHEN ISDATE(d .Store_Opens_Actual) = 1 THEN d .Store_Opens_Actual WHEN ISDATE(d .Store_Opens_Forecast) = 1 AND
ISDATE(d .Store_Opens_Actual) = 0 THEN d .Store_Opens_Forecast WHEN ISDATE(d
[Code] ....
This returns a dataset, that I need to convert into a PIVOT table that should look like the attached spreadsheet.
Having trouble writing the PIVOT table query. I feel like I am missing something conceptually as I am not doing any summing or aggregation. I don't know if dynamics SQL is the solution here or which route to take. I don't know if there is such things as PIVOTING without aggregation. CROSS TAB came to my mind as well.
In MS Visual Studio, when creating a new Report Model Project, after defining a datasource to an Oracle database (and successfully testing it), and a simple datasource view (1 table), when I click "Run" in Report Model Wizard, I receive the following error:
"ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }"
It does not appear that one can create Report Models from an Oracle database (since the SQL being used to query the Oracle database cannot be edited and contains syntax errors?). Is this the case?
Thank you.
Hi,
Is there a possible way to create multiple folders in a report project so that different reports can be categorized and arranged in separate folders. Apparently, it seems not. Is there a workaround?
Thanks.