This is a migrated thread and some comments may be shown as answers.

Need Direction on report

1 Answer 121 Views

Report Designer (standalone)

This is a migrated thread and some comments may be shown as answers.

Billie asked on 22 Mar 2012, 02:19 AM

I am an untrained volunteer, attempting to solve a reporting problem.

I am experimenting with the standalone version of the report designer to see if it is a reporting solution that will work for me.

I am able to generate the reports I need individually, by inserting three where variables into the select statement. as follows

Select * from B_MRDATA where System = 'Inglemoor' and Level = 'Rookies' and Split = 'None'
Order By last

There are potentially 309 combinations of the three variables System, Level, and Split. Not all those combinations will be used.. Is there a way to automate a process and generate all the required reports at once?

Here is the xml code for one of the reports - I deleted the connection string.

Thanks in advance for any help you can give me - Billie

(<?xml version="1.0" encoding="utf-8"?>

<Report Width="9.90000025in" Name="report1">

<DataSources>

<SqlDataSource ConnectionString="data 
" SelectCommand="Select * from B_MRDATA where system = 'Bothell' and Level = 'Cubs' and Split = 'Black'
Order By last" Name="sqlDataSource1" />

</DataSources>

<PageSettings PaperKind="Letter" Landscape="True">

<Margins Left="0.5in" Right="0.5in" Top="0.25in" Bottom="0.25in" />

</PageSettings>

<DataSourceRef>sqlDataSource1</DataSourceRef>

<StyleSheet>

<StyleRule>

<Style Color="Black">

<Font Name="Tahoma" Size="20pt" Style="Bold" />

</Style>

<Selectors>

<StyleSelector>

<Type>ReportItemBase</Type>

<StyleName>Title</StyleName>

</StyleSelector>

</Selectors>

</StyleRule>

<StyleRule>

<Style Color="Black" VerticalAlign="Middle">

<Font Name="Tahoma" Size="11pt" Style="Regular" />

</Style>

<Selectors>

<StyleSelector>

<Type>ReportItemBase</Type>

<StyleName>Caption</StyleName>

</StyleSelector>

</Selectors>

</StyleRule>

<StyleRule>

<Style VerticalAlign="Middle">

<Font Name="Tahoma" Size="11pt" Style="Regular" />

</Style>

<Selectors>

<StyleSelector>

<Type>ReportItemBase</Type>

<StyleName>Data</StyleName>

</StyleSelector>

</Selectors>

</StyleRule>

<StyleRule>

<Style VerticalAlign="Middle">

<Font Name="Tahoma" Size="11pt" Style="Regular" />

</Style>

<Selectors>

<StyleSelector>

<Type>ReportItemBase</Type>

<StyleName>PageInfo</StyleName>

</StyleSelector>

</Selectors>

</StyleRule>

</StyleSheet>

<Groups>

<Group Name="labelsGroup">

<GroupHeader>

<GroupHeaderSection PrintOnEveryPage="True" Height="0.20003986in" Name="labelsGroupHeader">

<Items>

<TextBox Value="#" Left="0.02083333in" Top="0in" Width="0.19999949in" Height="0.20000013in" Name="textBox47" />

<TextBox Value="Last Name" Left="0.22091158in" Top="0in" Width="1.17908843in" Height="0.19999981in" Name="textBox48" />

<TextBox Value="First Name" Left="1.4000001in" Top="0in" Width="0.79992135in" Height="0.20000013in" Name="textBox50" />

<TextBox Value="Address" Left="2.21882915in" Top="0in" Width="1.5810922in" Height="0.20000013in" Name="textBox52" />

<TextBox Value="School" Left="4.80007903in" Top="0in" Width="0.99992116in" Height="0.20000013in" Name="textBox55" />

<TextBox Value="Phone" Left="3.80000019in" Top="0in" Width="1in" Height="0.20000013in" Name="textBox57" />

<TextBox Value="DOB" Left="5.80000051in" Top="0in" Width="0.99992116in" Height="0.20000013in" Name="textBox59" />

<TextBox Value="BC" Left="6.80000051in" Top="0in" Width="0.29992167in" Height="0.20000013in" Name="textBox61" />

<TextBox Value="AO" Left="7.10000038in" Top="0in" Width="0.29996109in" Height="0.20000013in" Name="textBox62" />

<TextBox Value="PTS" Left="7.40000025in" Top="0in" Width="0.40000025in" Height="0.20000013in" Name="textBox63" />

<TextBox Value="Wt" Left="7.80000051in" Top="0in" Width="0.49996122in" Height="0.20000013in" Name="textBox64" />

<TextBox Value="Grad" Left="8.30000051in" Top="0in" Width="0.5in" Height="0.20000013in" Name="textBox65" />

<TextBox Value="Ver" Left="8.80000051in" Top="0in" Width="0.29999987in" Height="0.20000013in" Name="textBox66" />

<TextBox Value="AG" Left="9.10000038in" Top="0in" Width="0.29999987in" Height="0.19999981in" Name="textBox67" />

<TextBox Value="textBox68" Left="8.80000051in" Top="0.09992123in" Width="0in" Height="0in" Name="textBox68" />

<TextBox Value="Tot" Left="9.40000025in" Top="0in" Width="0.39988136in" Height="0.19999981in" Name="textBox69" />

</Items>

</GroupHeaderSection>

</GroupHeader>

<GroupFooter>

<GroupFooterSection Height="0.40011819in" Name="labelsGroupFooter">

<Style Visible="False" />

</GroupFooterSection>

</GroupFooter>

</Group>

</Groups>

<Items>

<PageHeaderSection Height="0.28125in" Name="pageHeader">

<Items>

<TextBox Value="Master Roster" Left="0.02083333in" Top="0.02083333in" Width="6.41666667in" Height="0.20000001in" Name="reportNameTextBox" StyleName="PageInfo" />

</Items>

</PageHeaderSection>

<PageFooterSection Height="0.28125in" Name="pageFooter">

<Items>

<TextBox Value="=NOW()" Left="0.02083333in" Top="0.02083333in" Width="3.19791667in" Height="0.20000001in" Name="currentTimeTextBox" StyleName="PageInfo" />

<TextBox Value="=PageNumber" Left="3.23958333in" Top="0.02083333in" Width="3.19791667in" Height="0.20000001in" Name="pageInfoTextBox" StyleName="PageInfo">

<Style TextAlign="Right" />

</TextBox>

</Items>

</PageFooterSection>

<ReportHeaderSection Height="1.51875019in" Name="reportHeader">

<Items>

<TextBox Value="Master Roster" Left="0in" Top="0in" Width="8.99996058in" Height="0.31874998in" Name="titleTextBox" StyleName="Title" />

<TextBox Value="System:" CanGrow="True" Left="0.02083333in" Top="0.31875006in" Width="0.99992116in" Height="0.20000001in" Name="systemCaptionTextBox" StyleName="Caption">

<Style TextAlign="Left" />

</TextBox>

<TextBox Value="=Fields.System" CanGrow="True" Left="1in" Top="0.31875006in" Width="1.19992113in" Height="0.20000001in" Name="systemDataTextBox" StyleName="Data" />

<TextBox Value="=Fields.[Club Rep]" Left="1in" Top="0.51875003in" Width="1.19992113in" Height="0.19999997in" Name="textBox1" />

<TextBox Value="Club Rep:" Left="0.02083333in" Top="0.51875003in" Width="0.99992116in" Height="0.19999997in" Name="textBox3" />

<TextBox Value="=Fields.Level" Left="1in" Top="0.71875in" Width="1.19992129in" Height="0.20000013in" Name="textBox4" />

<TextBox Value="=Fields.Split" Left="1in" Top="0.91875013in" Width="1.19992129in" Height="0.19999981in" Name="textBox5" />

<TextBox Value="Level:" Left="0in" Top="0.71875in" Width="0.99992116in" Height="0.19999997in" Name="textBox6" />

<TextBox Value="Head Coach:" Left="0in" Top="1.1187501in" Width="0.99992116in" Height="0.19999997in" Name="textBox8" />

<TextBox Value="=Fields.[Head Coach]" Left="1in" Top="1.1187501in" Width="1.19992145in" Height="0.20000013in" Name="textBox9" />

<TextBox Value="Assistant:" Left="0in" Top="1.31875006in" Width="0.99992114in" Height="0.19999997in" Name="textBox10" />

<TextBox Value="Split:" Left="0in" Top="0.91875013in" Width="0.99992114in" Height="0.19999997in" Name="textBox11" />

<TextBox Value="Assistant:" Left="2.21882884in" Top="0.31875006in" Width="0.99992114in" Height="0.19999997in" Name="textBox12" />

<TextBox Value="=Fields.[Assistant 1]" Left="1in" Top="1.31875006in" Width="1.17908812in" Height="0.20000013in" Name="textBox13" />

<TextBox Value="Assistant:" Left="2.20000013in" Top="0.51875003in" Width="1.01875019in" Height="0.19999997in" Name="textBox7" />

<TextBox Value="Assistant:" Left="2.21882915in" Top="1.31875006in" Width="0.99992114in" Height="0.19999997in" Name="textBox14" />

<TextBox Value="Assistant:" Left="4.26049582in" Top="0.31875006in" Width="0.70000013in" Height="0.19999997in" Name="textBox15" />

<TextBox Value="Assistant:" Left="2.21882884in" Top="0.71875in" Width="0.99992114in" Height="0.19999997in" Name="textBox16" />

<TextBox Value="Assistant:" Left="2.21882884in" Top="1.1187501in" Width="0.99992114in" Height="0.19999997in" Name="textBox18" />

<TextBox Value="Assistant:" Left="2.21882884in" Top="0.91875013in" Width="0.99992114in" Height="0.19999997in" Name="textBox19" />

<TextBox Value="=Fields.[Assistant 2]" Left="3.30000019in" Top="0.31875006in" Width="0.96041679in" Height="0.19999997in" Name="textBox17" />

<TextBox Value="=Fields.[Assistant 3]" Left="3.30000019in" Top="0.51875003in" Width="0.96041679in" Height="0.19999997in" Name="textBox20" />

<TextBox Value="=Fields.[Assistant 4]" Left="3.30000019in" Top="0.71875in" Width="0.96041648in" Height="0.19999997in" Name="textBox21" />

<TextBox Value="=Fields.[Assistant 5]" Left="3.30000019in" Top="0.91875013in" Width="0.96041648in" Height="0.20000013in" Name="textBox22" />

<TextBox Value="=Fields.[Assistant 6]" Left="3.30000019in" Top="1.1187501in" Width="0.96041679in" Height="0.19999997in" Name="textBox23" />

<TextBox Value="=Fields.[Assistant 7]" Left="3.30000019in" Top="1.31875006in" Width="0.96041648in" Height="0.19999997in" Name="textBox24" />

<TextBox Value="Ball Boy:" Left="4.26049582in" Top="0.71875in" Width="0.70000013in" Height="0.19999997in" Name="textBox25" />

<TextBox Value="Ball Boy:" Left="4.26049582in" Top="0.51875003in" Width="0.70000013in" Height="0.19999997in" Name="textBox26" />

<TextBox Value="First Aid:" Left="4.2604955in" Top="0.91875013in" Width="0.70000013in" Height="0.19999997in" Name="textBox28" />

<TextBox Value="=Fields.[Ball Boy 1]" Left="5in" Top="0.51875003in" Width="1.1770045in" Height="0.19999997in" Name="textBox29" />

<TextBox Value="=Fields.[Assistant 8]" Left="5in" Top="0.31875006in" Width="1.1770045in" Height="0.19999997in" Name="textBox30" />

<TextBox Value="=Fields.[First Aid]" Left="5in" Top="0.91875013in" Width="1.13742065in" Height="0.20000013in" Name="textBox32" />

<TextBox Value="=Fields.[Ball Boy 1]" Left="5in" Top="0.71875in" Width="1.1770045in" Height="0.19999997in" Name="textBox31" />

<TextBox Value="Pt Rng:" Left="4.30007903in" Top="1.1187501in" Width="0.70000011in" Height="0.19999997in" Name="textBox27" />

<TextBox Value="Eq Allow:" Left="4.30007903in" Top="1.31875006in" Width="0.70000011in" Height="0.19999997in" Name="textBox33" />

<TextBox Value="Cap Wt:" Left="6.17708349in" Top="0.31875006in" Width="0.70000011in" Height="0.19999997in" Name="textBox34" />

<TextBox Value="=Fields.[Pt Range]" Left="5.00015767in" Top="1.1187501in" Width="1.17684682in" Height="0.19999997in" Name="textBox35" />

<TextBox Value="=Fields.[Equip Allow]" Left="5.02307447in" Top="1.31875006in" Width="1.17684682in" Height="0.19999997in" Name="textBox36" />

<TextBox Value="=Fields.Capweight" Left="6.87716293in" Top="0.31875006in" Width="1.1228377in" Height="0.20000013in" Name="textBox37" />

<TextBox Value="Home Jer:" Left="6.20000013in" Top="0.91875013in" Width="0.70000011in" Height="0.19999997in" Name="textBox39" />

<TextBox Value="Awy Jer:" Left="6.20000013in" Top="1.1187501in" Width="0.70000011in" Height="0.19999997in" Name="textBox40" />

<TextBox Value="Helmet:" Left="6.17708333in" Top="0.51875003in" Width="0.70000011in" Height="0.19999997in" Name="textBox41" />

<TextBox Value="Pants:" Left="6.20000013in" Top="0.71875in" Width="0.70000011in" Height="0.19999997in" Name="textBox38" />

<TextBox Value="=Fields.Helmet" Left="6.90007909in" Top="0.51875003in" Width="1.09992154in" Height="0.19999997in" Name="textBox42" />

<TextBox Value="=Fields.[Jersey Away]" Left="6.90000025in" Top="1.1187501in" Width="1.09996096in" Height="0.20000013in" Name="textBox43" />

<TextBox Value="=Fields.[Jersey Home]" Left="6.90000025in" Top="0.91875013in" Width="1.10000038in" Height="0.19999981in" Name="textBox44" />

<TextBox Value="=Fields.Pants" Left="6.90007909in" Top="0.71875in" Width="1.09992154in" Height="0.19999997in" Name="textBox45" />

</Items>

</ReportHeaderSection>

<ReportFooterSection Height="0.28125in" Name="reportFooter" />

<DetailSection Height="0.29988162in" Name="detail">

<Items>

<TextBox Value="=Fields.Last" Left="0.19999997in" Top="0in" Width="1.19999997in" Height="0.20000013in" Name="textBox46" />

<TextBox Value="=Fields.[#]" Left="0in" Top="0in" Width="0.20000005in" Height="0.20000013in" Name="textBox49" />

<TextBox Value="textBox51" Left="4.90000025in" Top="0.09988181in" Width="0in" Height="0in" Name="textBox51" />

<TextBox Value="=Fields.First" Left="1.40007877in" Top="0in" Width="0.79984252in" Height="0.20000013in" Name="textBox53" />

<TextBox Value="=Fields.Address" Left="2.21882915in" Top="0in" Width="1.5810922in" Height="0.20000013in" Name="textBox54" />

<TextBox Value="=Fields.School" Left="4.80007903in" Top="0in" Width="0.99992116in" Height="0.19999981in" Name="textBox56" />

<TextBox Value="=Fields.Phone" Left="3.80000019in" Top="0in" Width="1in" Height="0.19999981in" Name="textBox58" />

<TextBox Value="=Fields.BC" Left="6.80000051in" Top="0in" Width="0.29999987in" Height="0.19999981in" Name="textBox70" />

<TextBox Value="=Fields.AO" Left="7.10000038in" Top="0in" Width="0.30000051in" Height="0.19999981in" Name="textBox71" />

<TextBox Value="=Fields.Points" Left="7.40000025in" Top="0in" Width="0.39992078in" Height="0.19999981in" Name="textBox72" />

<TextBox Value="=Fields.Weight" Left="7.80000051in" Top="0in" Width="0.49988238in" Height="0.19999981in" Name="textBox73" />

<TextBox Value="=Fields.Grade" Left="8.30000051in" Top="0in" Width="0.5in" Height="0.19999981in" Name="textBox74" />

<TextBox Value="=Fields.Verified" Left="8.80000051in" Top="0in" Width="0.29999987in" Height="0.19999981in" Name="textBox75" />

<TextBox Value="=Fields.AG" Left="9.10000038in" Top="0in" Width="0.29992104in" Height="0.19999981in" Name="textBox76" />

<TextBox Value="=Fields.TOTAL" Left="9.40000025in" Top="0in" Width="0.39992078in" Height="0.19999981in" Name="textBox77" />

<TextBox Value="=Fields.Expr23" Left="5.80000051in" Top="0in" Width="0.99992116in" Height="0.20000013in" Name="textBox60" />

</Items>

</DetailSection>

</Items>

</Report> )

1 Answer, 1 is accepted

0

answered on 26 Mar 2012, 12:24 PM

Hello Billie,

You can create the report with ReportParameters. Then you can add parameters to your sqlDataSource (instead of hard-coded values). The sqlDataSource parameters will get their values from the report parameters (see Using parameters with sqlDataSource). This way you can easily generate the reports you need with minimum effort. Almost all of our demos are built on this concept, you can review them (there is also a video of the report building process for each demo).

Greetings,
Elian
the Telerik team

NEW in Q1'12: Telerik Report Designer (Beta) for ad-hoc report creation. Download as part of Telerik Reporting Q1 2012. For questions and feedback, use the new Telerik Report Designer Forum.

Tags

Report Designer (standalone)

Asked by

Answers by