Underlay Following Sections

Mar 5, 2008

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

View 1 Replies

General SQL - Need Same Inner Select In FROM And WHERE Sections...

Feb 29, 2008

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

View 5 Replies View Related

Cleaning Up Hardcode Sections

Jan 5, 2005

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

View 4 Replies View Related

SQL XML :: How To Parse Different Sections XML With OPENXML

Aug 26, 2015

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"?>

View 11 Replies View Related

Hiding Sections Of Text

Feb 15, 2008

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

View 1 Replies View Related

Hiding/Collapsing Report Sections

May 16, 2007

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

View 3 Replies View Related

Multiple Sections In SQL Server Reports..

Nov 15, 2007

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

View 7 Replies View Related

Creating Sections And Subsections In Report

Feb 26, 2008

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

View 9 Replies View Related

Retrieving Random Sections From A Data File

Jun 2, 2007

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?

View 3 Replies View Related