Showing posts with label datasource. Show all posts
Showing posts with label datasource. Show all posts

Sunday, February 19, 2012

Blank Row comming out from Excel Source?

Hi,

I use an excel datasource to populate some simple dimensions, but when i extract the excel file i get alot of blank rows from the excel files...

How can i overcome this issue? Is this normal?

I never had problems like this using DTS in the 2000 version

Best Regards,

Luis Sim?es

Perhaps, your Excel file has empty rows in the spreadsheet.

You should not see any difference when using DTS or SSIS wizard if the same source file is used.

Thanks.

|||

How do i know there are empty rows?

Posted by Flores at 2:43 AM 0 comments
Labels: , , , , , , , , , , , , , , ,

blank report - problems with datasource?

I creted a web project with visual studio 2005 express but the report
is blank.
My report's source is on MySql; I connect runtime and send datatable
to the report.
this is the rdlc file; I canceled some rows
[code]
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/
2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/
SQLServer/reporting/reportdesigner">
<PageWidth>21cm</PageWidth>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>21cm</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Textbox Name="comune">
<Left>0.25cm</Left>
<Top>0.25cm</Top>
<rd:DefaultName>comune</rd:DefaultName>
<ZIndex>1</ZIndex>
<Width>14.25cm</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.63492cm</Height>
<Value>=First(Fields!comune.Value)</Value>
</Textbox>
<Textbox Name="textbox2">
<Left>15cm</Left>
<Top>0.25cm</Top>
<rd:DefaultName>textbox2</rd:DefaultName>
<Width>3.99471cm</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>1.00529cm</Height>
<Value>Scheda cliente</Value>
</Textbox>
</ReportItems>
<Height>25cm</Height>
</Body>
<rd:ReportID>2c8fb28d-af14-4a5f-b557-de3fbbfb5378</rd:ReportID>
<DataSources>
<DataSource Name="reminder_local">
<ConnectionProperties>
<ConnectString />
<DataProvider>OLEDB</DataProvider>
</ConnectionProperties>
<rd:DataSourceID>47284d9e-3aa3-4350-9732-405dc3c0abbf</
rd:DataSourceID>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="DSCliente">
<rd:DataSetInfo>
<rd:TableAdapterGetDataMethod>GetData</
rd:TableAdapterGetDataMethod>
<rd:DataSetName>dbDataSet</rd:DataSetName>
<rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod>
<rd:TableAdapterName>ProductsTableAdapter</
rd:TableAdapterName>
<rd:TableName>tbCliente</rd:TableName>
</rd:DataSetInfo>
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select * from tbCliente</CommandText>
<DataSourceName>reminder_local</DataSourceName>
</Query>
<Fields>
<Field Name="id">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>id</DataField>
</Field>
<Field Name="ragsoc">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ragsoc</DataField>
</Field>
<Field Name="via">
<rd:TypeName>System.String</rd:TypeName>
<DataField>via</DataField>
</Field>
<Field Name="comune">
<rd:TypeName>System.String</rd:TypeName>
<DataField>comune</DataField>
</Field>
<Field Name="prov">
<rd:TypeName>System.String</rd:TypeName>
<DataField>prov</DataField>
</Field>
</Fields>
... fields tolti...
</DataSet>
</DataSets>
<Width>20.25cm</Width>
<InteractiveHeight>29.7cm</InteractiveHeight>
<Language>en-US</Language>
<PageHeight>29.7cm</PageHeight>
</Report>
[/code]
and this is the page code loading the report
[code]
protected void Page_Load(object sender, EventArgs e)
{
DataSet dsCliente = new DataSet();
dsCliente.DataSetName = "DsCliente";
MySqlConnection mycnn = new
MySqlConnection(ConfigurationManager.ConnectionStrings["reminder_local"].ToString());
MySqlCommand cmd = new MySqlCommand();
MySqlDataAdapter DA = new MySqlDataAdapter();
cmd.Connection = mycnn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("P_ID", 1));
cmd.Parameters.Add(new MySqlParameter("P_AncheAnnullati",
"True"));
cmd.CommandText = "spSelectClienteByID";
DA.SelectCommand = cmd;
DA.Fill(dsCliente);
dsCliente.Tables[0].TableName = "tbCliente";
rwScheda.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
rwScheda.LocalReport.ReportPath = MapPath("SchedeClienti.rdlc");
ReportDataSource rptDS = new ReportDataSource();
rptDS.Name = "DSCliente";
rptDS.Value = dsCliente.Tables[0];
rwScheda.LocalReport.DataSources.Add(rptDS);
rwScheda.DataBind();
//rwScheda.LocalReport.Refresh();
}
[/code]
I've already seen that in the table there is one record.
Why I don't see anything'I answer myself
I put the property AsyncRendering="false" on the reportviewer object
in the aspx page
and now works fine.
Posted by Flores at 2:42 AM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Blank Pages following report

I have a report that uses 7 subreports. Some reports show, some don't
depending on the data received from the Shared Datasource. My initial report
appears fine in the viewer, however I have a single page following the last
page with data containing only the header. When I create a pdf, I have 4
pages at the end with only headers. The main report and the first subreport
should be the only ones outputting data.
Ideas?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1I have found my problem, but no solution. When the subreports run, they are
given "space" on the report even if their visibility is set to False. This
is what is generating my "blank pages". This poses a new and even uglier
issue for me, What Now? My requirements are to have a single report that
gives alternate data depending on the needs of the user. I have two ideas:
1) Can I manually launch a subreport in code WITHOUT navigating away from
the parent report?
2) Is it possible to dynamically add a Subreport to the main report via VB
Code so only the subreports needed are run?
I am researching both avenues, but any advice you could offer would be WELL
received!
Rick wrote:
>I have a report that uses 7 subreports. Some reports show, some don't
>depending on the data received from the Shared Datasource. My initial report
>appears fine in the viewer, however I have a single page following the last
>page with data containing only the header. When I create a pdf, I have 4
>pages at the end with only headers. The main report and the first subreport
>should be the only ones outputting data.
>Ideas?
Message posted via http://www.sqlmonster.com|||I am also running into the same issue and finding no solution. Any help is
appreciated.
"Rick via SQLMonster.com" wrote:
> I have found my problem, but no solution. When the subreports run, they are
> given "space" on the report even if their visibility is set to False. This
> is what is generating my "blank pages". This poses a new and even uglier
> issue for me, What Now? My requirements are to have a single report that
> gives alternate data depending on the needs of the user. I have two ideas:
> 1) Can I manually launch a subreport in code WITHOUT navigating away from
> the parent report?
> 2) Is it possible to dynamically add a Subreport to the main report via VB
> Code so only the subreports needed are run?
> I am researching both avenues, but any advice you could offer would be WELL
> received!
> Rick wrote:
> >I have a report that uses 7 subreports. Some reports show, some don't
> >depending on the data received from the Shared Datasource. My initial report
> >appears fine in the viewer, however I have a single page following the last
> >page with data containing only the header. When I create a pdf, I have 4
> >pages at the end with only headers. The main report and the first subreport
> >should be the only ones outputting data.
> >
> >Ideas?
>
> --
> Message posted via http://www.sqlmonster.com
>|||Has Microsoft any answer to this problem as this is something has been faced
by many people and doesnt seem to find any solution.
Setting page size and margine is one part of avoiding blank pages but with
sub reports, it not only introduce blank pages and sometimes change the whole
look of the report.
"manish" wrote:
> I am also running into the same issue and finding no solution. Any help is
> appreciated.
> "Rick via SQLMonster.com" wrote:
> > I have found my problem, but no solution. When the subreports run, they are
> > given "space" on the report even if their visibility is set to False. This
> > is what is generating my "blank pages". This poses a new and even uglier
> > issue for me, What Now? My requirements are to have a single report that
> > gives alternate data depending on the needs of the user. I have two ideas:
> >
> > 1) Can I manually launch a subreport in code WITHOUT navigating away from
> > the parent report?
> >
> > 2) Is it possible to dynamically add a Subreport to the main report via VB
> > Code so only the subreports needed are run?
> >
> > I am researching both avenues, but any advice you could offer would be WELL
> > received!
> >
> > Rick wrote:
> > >I have a report that uses 7 subreports. Some reports show, some don't
> > >depending on the data received from the Shared Datasource. My initial report
> > >appears fine in the viewer, however I have a single page following the last
> > >page with data containing only the header. When I create a pdf, I have 4
> > >pages at the end with only headers. The main report and the first subreport
> > >should be the only ones outputting data.
> > >
> > >Ideas?
> >
> >
> > --
> > Message posted via http://www.sqlmonster.com
> >|||This is a good question, I see this issue often on many boards I post to. In
this case, it was my error. I was setting sub reports to hidden, however the
Rectangle they were in were not being set to hidden. Hence the blank pages.
When I set the Rectangle to invisible, it works like a charm. If you run
into this issue, I suggest you look at the container you placed your Sub
Report in, that just might be your error.
manish wrote:
>Has Microsoft any answer to this problem as this is something has been faced
>by many people and doesnt seem to find any solution.
>Setting page size and margine is one part of avoiding blank pages but with
>sub reports, it not only introduce blank pages and sometimes change the whole
>look of the report.
>> I am also running into the same issue and finding no solution. Any help is
>> appreciated.
>[quoted text clipped - 22 lines]
>> > >
>> > >Ideas?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200511/1|||Also, if you set the subreport (or its container) to be invisible
conditionally, any pagebreaks selected for that subreport or container
will be ignored. For me, it is a really anoying "feature".
Posted by Flores at 2:37 AM 0 comments
Labels: , , , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)