Preventing Deadlock: preview

Showing posts with label preview. Show all posts

Wednesday, March 28, 2012

Print button doesn't work in ReportServer 2005

I can preview reports on the server fine. The first time I clicked the
print button, I got a message asking me to install SQL Server? I said
yes, then after a few minutes I got a print error.
Now, every time I click the print button on the RS toolbar, I get this
message:
Print Error
An error occured trying to get the current window.
Besides the fact that occurred is spelled wrong, why is this error
happening? I tried deleting all RSClient* files from \Windows\Downloaded
Program Files, but that doesn't help.
How do I fix this?
TIA,
Mike RodriguezCan you try deleting the ActiveX control via IE.
Go to Tools->Internet Options
Click the Settings button
Click the View Objects button.
Delete the RSClientPrint control
I would also clear out my internet cache to make sure you are getting the
latest cab file.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Rodriguez" <mike@.nospam.com> wrote in message
news:eb%23LX2B$FHA.3636@.TK2MSFTNGP10.phx.gbl...
>I can preview reports on the server fine. The first time I clicked the
>print button, I got a message asking me to install SQL Server? I said
>yes, then after a few minutes I got a print error.
> Now, every time I click the print button on the RS toolbar, I get this
> message:
> Print Error
> An error occured trying to get the current window.
> Besides the fact that occurred is spelled wrong, why is this error
> happening? I tried deleting all RSClient* files from \Windows\Downloaded
> Program Files, but that doesn't help.
> How do I fix this?
> TIA,
> Mike Rodriguez
>|||Hi Daniel,
Ok, I did that. Unfortunately, I still get the same error.
Any other ideas?
Mike
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:eO9RFNC$FHA.216@.TK2MSFTNGP15.phx.gbl...
> Can you try deleting the ActiveX control via IE.
> Go to Tools->Internet Options
> Click the Settings button
> Click the View Objects button.
> Delete the RSClientPrint control
> I would also clear out my internet cache to make sure you are getting the
> latest cab file.
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Michael Rodriguez" <mike@.nospam.com> wrote in message
> news:eb%23LX2B$FHA.3636@.TK2MSFTNGP10.phx.gbl...
>>I can preview reports on the server fine. The first time I clicked the
>>print button, I got a message asking me to install SQL Server? I said
>>yes, then after a few minutes I got a print error.
>> Now, every time I click the print button on the RS toolbar, I get this
>> message:
>> Print Error
>> An error occured trying to get the current window.
>> Besides the fact that occurred is spelled wrong, why is this error
>> happening? I tried deleting all RSClient* files from \Windows\Downloaded
>> Program Files, but that doesn't help.
>> How do I fix this?
>> TIA,
>> Mike Rodriguez
>>
>|||Are you viewing reports through a hosted IE control? That is is this a
winforms app or are your going to the ReportServer through IE?
If it is in a hosted win forms then this is expected and the print
functionality is not supported there.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Rodriguez" <mike@.nospam.com> wrote in message
news:etvrvsC$FHA.2036@.TK2MSFTNGP14.phx.gbl...
> Hi Daniel,
> Ok, I did that. Unfortunately, I still get the same error.
> Any other ideas?
> Mike
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:eO9RFNC$FHA.216@.TK2MSFTNGP15.phx.gbl...
>> Can you try deleting the ActiveX control via IE.
>> Go to Tools->Internet Options
>> Click the Settings button
>> Click the View Objects button.
>> Delete the RSClientPrint control
>> I would also clear out my internet cache to make sure you are getting the
>> latest cab file.
>>
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Michael Rodriguez" <mike@.nospam.com> wrote in message
>> news:eb%23LX2B$FHA.3636@.TK2MSFTNGP10.phx.gbl...
>>I can preview reports on the server fine. The first time I clicked the
>>print button, I got a message asking me to install SQL Server? I said
>>yes, then after a few minutes I got a print error.
>> Now, every time I click the print button on the RS toolbar, I get this
>> message:
>> Print Error
>> An error occured trying to get the current window.
>> Besides the fact that occurred is spelled wrong, why is this error
>> happening? I tried deleting all RSClient* files from
>> \Windows\Downloaded Program Files, but that doesn't help.
>> How do I fix this?
>> TIA,
>> Mike Rodriguez
>>
>>
>|||Hi Daniel,
Actually, the print button works in my winforms app. It doesn't work in the
IE web application that ReportServer created for me.
What can I do?
Mike
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:OwcNYeE$FHA.2320@.TK2MSFTNGP11.phx.gbl...
> Are you viewing reports through a hosted IE control? That is is this a
> winforms app or are your going to the ReportServer through IE?
> If it is in a hosted win forms then this is expected and the print
> functionality is not supported there.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Michael Rodriguez" <mike@.nospam.com> wrote in message
> news:etvrvsC$FHA.2036@.TK2MSFTNGP14.phx.gbl...
>> Hi Daniel,
>> Ok, I did that. Unfortunately, I still get the same error.
>> Any other ideas?
>> Mike
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:eO9RFNC$FHA.216@.TK2MSFTNGP15.phx.gbl...
>> Can you try deleting the ActiveX control via IE.
>> Go to Tools->Internet Options
>> Click the Settings button
>> Click the View Objects button.
>> Delete the RSClientPrint control
>> I would also clear out my internet cache to make sure you are getting
>> the latest cab file.
>>
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Michael Rodriguez" <mike@.nospam.com> wrote in message
>> news:eb%23LX2B$FHA.3636@.TK2MSFTNGP10.phx.gbl...
>>I can preview reports on the server fine. The first time I clicked the
>>print button, I got a message asking me to install SQL Server? I said
>>yes, then after a few minutes I got a print error.
>> Now, every time I click the print button on the RS toolbar, I get this
>> message:
>> Print Error
>> An error occured trying to get the current window.
>> Besides the fact that occurred is spelled wrong, why is this error
>> happening? I tried deleting all RSClient* files from
>> \Windows\Downloaded Program Files, but that doesn't help.
>> How do I fix this?
>> TIA,
>> Mike Rodriguez
>>
>>
>>
>

Saturday, February 25, 2012

previewing sub report on list element? HELP PLEASE

I am not sure why i am having this problem as it has worked before. I have
placed a sub report on a list element.
When i preview the report the subreport (and table within) is pushed to the
second page while the entire list element remains on the first page.
Wat is going on here? (when viewed html it looks ok, it is only when i
'preview' or export to 'pdf' do i see the problem.
any help would be greatly appreciated.Likely due to the difference in how HTML vs. PDF renderers handle
pagination.
From designer, go to Report / Report Properties while in the Layout Tab.
Here you will be able to change the page width, page height and the margins.
The PDF export pays attention to these settings very diligently. Either
change the size of elements on your report or page size settings so report
can fit in a single page.
Alternatively, might try overriding the page size settings by passing in
parameters with the desired page height / width via URL (or via the
webservice call if you're rendering that way) when rendering to PDF.
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"dave" <dave@.discussions.microsoft.com> wrote in message
news:7DDB15B7-F78B-40E1-B984-EC27CDD75546@.microsoft.com...
>I am not sure why i am having this problem as it has worked before. I have
> placed a sub report on a list element.
> When i preview the report the subreport (and table within) is pushed to
> the
> second page while the entire list element remains on the first page.
> Wat is going on here? (when viewed html it looks ok, it is only when i
> 'preview' or export to 'pdf' do i see the problem.
> any help would be greatly appreciated.

Previewing reports - MissingMethodException

Hi, after installing RS SP1, when I want to preview a report in VS.NET 2003,
I get an error- MissingMethodException: Method not found: System.String
Microsoft.ReportingServices.Diagnostics.Globals.GetCurrentWindowsUserName().
I guess its because Microsoft.ReportingServices.Diagnostics.dll is somehow
wrongly registered, I tried to register it with regsvr32.exe (both copies,
one in Documents and Setting and one under RS home directory) but I didnt
succeed.
The report renders allright in Report Manager, but I really miss the
Preview, because it slows down the developing so much.
Any help would be appreciated.I even tried to unisnstall Reporting Services and did a clean install again,
but it didnt help. I really dont feel like reinstalling Windows now...
"Nikola Tepper" wrote:
> Hi, after installing RS SP1, when I want to preview a report in VS.NET 2003,
> I get an error- MissingMethodException: Method not found: System.String
> Microsoft.ReportingServices.Diagnostics.Globals.GetCurrentWindowsUserName().
> I guess its because Microsoft.ReportingServices.Diagnostics.dll is somehow
> wrongly registered, I tried to register it with regsvr32.exe (both copies,
> one in Documents and Setting and one under RS home directory) but I didnt
> succeed.
> The report renders allright in Report Manager, but I really miss the
> Preview, because it slows down the developing so much.
> Any help would be appreciated.|||--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nikola Tepper" <Nikola Tepper@.discussions.microsoft.com> wrote in message
news:8766C01C-9FA8-4C21-BC00-71627266FDA9@.microsoft.com...
> I even tried to unisnstall Reporting Services and did a clean install
again,
> but it didnt help. I really dont feel like reinstalling Windows now...
> "Nikola Tepper" wrote:
> > Hi, after installing RS SP1, when I want to preview a report in VS.NET
2003,
> > I get an error- MissingMethodException: Method not found: System.String
> >
Microsoft.ReportingServices.Diagnostics.Globals.GetCurrentWindowsUserName().
> > I guess its because Microsoft.ReportingServices.Diagnostics.dll is
somehow
> > wrongly registered, I tried to register it with regsvr32.exe (both
copies,
> > one in Documents and Setting and one under RS home directory) but I
didnt
> > succeed.
> > The report renders allright in Report Manager, but I really miss the
> > Preview, because it slows down the developing so much.
> > Any help would be appreciated.|||Sorry, hit "Send" too soon. Did you try reinstalling the .NET framework?
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:ODFBI7IjEHA.3632@.TK2MSFTNGP09.phx.gbl...
>
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Nikola Tepper" <Nikola Tepper@.discussions.microsoft.com> wrote in message
> news:8766C01C-9FA8-4C21-BC00-71627266FDA9@.microsoft.com...
> > I even tried to unisnstall Reporting Services and did a clean install
> again,
> > but it didnt help. I really dont feel like reinstalling Windows now...
> >
> > "Nikola Tepper" wrote:
> >
> > > Hi, after installing RS SP1, when I want to preview a report in VS.NET
> 2003,
> > > I get an error- MissingMethodException: Method not found:
System.String
> > >
>
Microsoft.ReportingServices.Diagnostics.Globals.GetCurrentWindowsUserName().
> > > I guess its because Microsoft.ReportingServices.Diagnostics.dll is
> somehow
> > > wrongly registered, I tried to register it with regsvr32.exe (both
> copies,
> > > one in Documents and Setting and one under RS home directory) but I
> didnt
> > > succeed.
> > > The report renders allright in Report Manager, but I really miss the
> > > Preview, because it slows down the developing so much.
> > > Any help would be appreciated.
>

Previewing RDL without Designer

Folks,
Is there a way to preview the "RDL" Reports programatically without
deploying to the report Server.
We needs this ability for the creation of ad-hoc reports where user designs
the contents of the report...
Any idea...? Appreciated...!
RakeshWith the new controls in local mode you can do this. The next beta for
Widbey (Visual Studio) will have both a web and winform control. They will
work both with and without Server. In local mode you can give it the rdl and
the dataset. The next beta should be available before too long. There is no
other way available until then.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rakesh" <Rakesh@.discussions.microsoft.com> wrote in message
news:034B4A2B-6DAE-4253-8A9C-568EBC298082@.microsoft.com...
> Folks,
> Is there a way to preview the "RDL" Reports programatically without
> deploying to the report Server.
> We needs this ability for the creation of ad-hoc reports where user
designs
> the contents of the report...
> Any idea...? Appreciated...!
> Rakesh
>
>|||Hey Rakesh
I am working on something similar at the moment, and have had reasonable
results using the following.
Use the webservice interface to temporarily create a hidden folder, Create a
report from the RDL, render the report, then delete the report and folder.
All these actions are available through the SOAP interface. Its long winded
but does seem to work fine.
Regards
Quagmire|||Take a look at the RDL Project: http://www.fyireporting.com/
It has a control for viewing locally.
HTH,
Alfred Gary Myers Jr.
www.yuma.com.br
"Rakesh" <Rakesh@.discussions.microsoft.com> wrote in message
news:034B4A2B-6DAE-4253-8A9C-568EBC298082@.microsoft.com...
> Folks,
> Is there a way to preview the "RDL" Reports programatically without
> deploying to the report Server.
> We needs this ability for the creation of ad-hoc reports where user
> designs
> the contents of the report...
> Any idea...? Appreciated...!
> Rakesh
>
>

Preview/Print/Save reports

I have done many Reports using SQL 2005 Reporting Services and I can access them by:

http://localhost/Reports

In my ASP.NET application, I have 3 buttons:

Preview, Print and Save

If the user clicks on Preview the report is displayed

if the user clicks on Print,the report is sent automatically to the printer

if the user clicks on Save,the report is Exported in Pdf format to C:/

Can anyone give me some tutorials on how to manage Reports(.rdc) from ASP.NET

Hi,

From your description, it seems that you are wondering how to embed your report in ASP.Net application, right?

Generally, you can add a report viewer to your aspx page. You can follow the steps below to add your report viewer.

Open the Toolbox window. From the Data group, drag a ReportViewer control onto the page.

If it is not already open, open the ReportViewer Tasks smart tag panel by clicking the triangle in the upper right corner of the ReportViewer control on the Web page. In the Choose Report box, select the fully qualified file name for Report.rdlc.

When you select a report, instances of data sources used in the report are created automatically. Code is generated to instantiate each DataTable (and its DataSet container) and an ObjectDataSource control corresponding to each data source used in the report. This data source control is configured automatically.

And then, you can preview and print reports from reportviewer in the following way:
http://msdn2.microsoft.com/en-us/library/ms251693(VS.80).aspx

For more information on embed a report in your website, see:
http://msdn2.microsoft.com/en-us/library/ms252123(VS.80).aspx

Thanks.

preview tab does not display bound data

I have a table in my report that is bound to a dataset which in turn is bound
to a stored procedure. When I preview the report, the table remains blank,
despite the fact that I have bound the columns from my dataset to the table
on my report.
I get the following warning in my debug summary:
The data set â'DatasetNameâ' contains a definition for the field â'FieldName.
This field is missing from the returned result set from the data source.
However, I'm sure the result set is returning this field.
Any ideas on what could cause this?
Thanks.i figured out what the problem was. i did not properly bind the dataset.
"momo" wrote:
> I have a table in my report that is bound to a dataset which in turn is bound
> to a stored procedure. When I preview the report, the table remains blank,
> despite the fact that I have bound the columns from my dataset to the table
> on my report.
> I get the following warning in my debug summary:
> The data set â'DatasetNameâ' contains a definition for the field â'FieldName.
> This field is missing from the returned result set from the data source.
> However, I'm sure the result set is returning this field.
> Any ideas on what could cause this?
> Thanks.

preview reports?

In crystal reports you can just preview reports quickly can you do this
anyway in report services? I need to test out reports quickly as I build
them...When designing the report in Visual Studio, you just click the Preview
tab. Is that not working for you?
-Josh
Smokey Grindel wrote:
> In crystal reports you can just preview reports quickly can you do this
> anyway in report services? I need to test out reports quickly as I build
> them...|||Are you developing with the new controls in VS 2005 in local mode? If so
then the answer is no, you have to use your app to see the report.
If you are developing with Report Designer then yes you can preview.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smokey Grindel" <nospam@.nospam.com> wrote in message
news:OswPlwEzGHA.4092@.TK2MSFTNGP04.phx.gbl...
> In crystal reports you can just preview reports quickly can you do this
> anyway in report services? I need to test out reports quickly as I build
> them...
>

Preview report drastically different than export or deployed

I have been noticing this for a while now and wanted to see if I could bring it to Microsoft's attention. On a lot of my reports, the preview looks one way, then when the report is deployed and run or exported, it looks different. And not just a few aesthetics, but lines, columns, colors, etc. I have spent numerous hours trying to fix a problem in the preview that never existed in the export or deployed version.

Does anyone have this issue? Is Microsoft aware of this issue?

What format are you trying to export to?

The "preview" in Visual Studio uses a different output format than the HTML displayed in the web control, so you may see some differences there.

Different renderers have different characteristics regarding pagination and capabilities; some differences are expected. If you supply some more details about exactly what problems your experiencing we may be able to give you some specific guidance.

Preview Problem!

I've set the pagesize to 11in, 8.5in and the body width to 10.5 to compensate
for the margins. the preview views in landscape but when i try to export to
pdf i get an "index out of range error." If I change the pagesize to 11in,
15in it works ok unless i drill down before the export, then i get the same
error again.Could you send me your RDL and preview cache file ( its name is
<reportname>.rdl.data) for investigation?
Thank you
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"VC" <VC@.discussions.microsoft.com> wrote in message
news:79011CE7-9208-4EF7-9F80-A793393F0A6D@.microsoft.com...
> I've set the pagesize to 11in, 8.5in and the body width to 10.5 to
> compensate
> for the margins. the preview views in landscape but when i try to export
> to
> pdf i get an "index out of range error." If I change the pagesize to
> 11in,
> 15in it works ok unless i drill down before the export, then i get the
> same
> error again.|||It did not happen on SP1.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"VC" <VC@.discussions.microsoft.com> wrote in message
news:10DD33E1-3EDD-46B3-97E0-B58024702F12@.microsoft.com...
> Yes, that would be great. How do i send them to you?
> "Lev Semenets [MSFT]" wrote:
>> Could you send me your RDL and preview cache file ( its name is
>> <reportname>.rdl.data) for investigation?
>> Thank you
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "VC" <VC@.discussions.microsoft.com> wrote in message
>> news:79011CE7-9208-4EF7-9F80-A793393F0A6D@.microsoft.com...
>> > I've set the pagesize to 11in, 8.5in and the body width to 10.5 to
>> > compensate
>> > for the margins. the preview views in landscape but when i try to
>> > export
>> > to
>> > pdf i get an "index out of range error." If I change the pagesize to
>> > 11in,
>> > 15in it works ok unless i drill down before the export, then i get the
>> > same
>> > error again.
>>

Preview pane not showing data

I have a problem within the Report Designer in Visual Studio .NET. I a new
report, I define a dataset that returns data via a SQL query fine. I design
the report without issues, but when I try to preview the report, no data is
displayed.
This error seems to have occured after applying reporting services SP1 to my
machine. No errors are reported, and nothing appears in the event log.
Any ideas as to how I can correct this problem out there?
Thanks in advance.
MattIs there an .rdl.data file in the same directory as your .rdl file? If so, delete it and try again.
Also, does hitting the Refresh button in the preview pane have any effect?
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt Pothier" <Matt.Pothier@.sonepar-us.com> wrote in message
news:eEtr8WvfEHA.596@.TK2MSFTNGP11.phx.gbl...
> I have a problem within the Report Designer in Visual Studio .NET. I a new
> report, I define a dataset that returns data via a SQL query fine. I design
> the report without issues, but when I try to preview the report, no data is
> displayed.
> This error seems to have occured after applying reporting services SP1 to my
> machine. No errors are reported, and nothing appears in the event log.
> Any ideas as to how I can correct this problem out there?
> Thanks in advance.
> Matt
>|||Thanks for the response. There were .rdl.data files in the same directory.
I tried deleting them, but got the same results. The refresh button did not
help either.
In a moment of frustration I uninstalled reporting services; performed a
repair install on VS .Net, reinstalled Reporting services; applied the
service pack and started over again. Everything seems to be working now.
"Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:%23iGKIuvfEHA.3556@.TK2MSFTNGP12.phx.gbl...
> Is there an .rdl.data file in the same directory as your .rdl file? If
so, delete it and try again.
> Also, does hitting the Refresh button in the preview pane have any effect?
> --
> Thanks.
> Donovan R. Smith
> Software Test Lead
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Matt Pothier" <Matt.Pothier@.sonepar-us.com> wrote in message
> news:eEtr8WvfEHA.596@.TK2MSFTNGP11.phx.gbl...
> > I have a problem within the Report Designer in Visual Studio .NET. I a
new
> > report, I define a dataset that returns data via a SQL query fine. I
design
> > the report without issues, but when I try to preview the report, no data
is
> > displayed.
> >
> > This error seems to have occured after applying reporting services SP1
to my
> > machine. No errors are reported, and nothing appears in the event log.
> >
> > Any ideas as to how I can correct this problem out there?
> >
> > Thanks in advance.
> >
> > Matt
> >
> >
>

Preview only returning one record of report

I'm new to reporting services so I assume this is a stupid question however here it goes.

I created a report that will produce a simple customer invoice. I use a stored procedure to return the data. When I run the dataset in the data section it returns 5 records. When I run the report in preview mode it only returns the first record of data in the report. I did notice that when I drag and drop the dataset fields into a report it appends the record with "First(Fields!..." I assume that this will only return the first record which it appears to do. When I remove the "First" it only returns the last record in the report. How do I return all 5 of the records in the preview pane. The paging section in the preview pane in all scenerios always says 1of1 with the next page arrow grayed out.

Thanks in advance..

Hi,

use tables in stead of text boxes to visualize tabular data.

Cheers,

Yani

|||

I don't want tabular data.

I want Name, Address, City State Zip of customer #1 on Page 1 Followed by detail (I use tabular data here) for that customer

Name, Address, City State Zip of customer #2 on Page 2 Followed by detail for that customer

All I get is Customet #1 (Or #5 if I remove the first stated in the original question..)

Etc..

|||

Okay,

did u try setting up all controls related to a customer into aListControl.

The contained info by a List Control is repeated for reach data row, this way you could achieve your need.

Cheers

|||

I'm totally lost at your suggestion??

I want to produce 5 invoices.

The Stored procedure returns data for those 5 invoices.( Name, address, city, state, zip etc..)

The report should return 5 pages with a customer invoice on each page so I can print them.

I'm not sure where a list control come into play here.

|||

If You don't want ur report in a tabular form then you will have to use list control.Drop textboxes into

the list control .

|||

Thank you,

I think I got it now.

One additional question I have with Formatting and Printing. Is there any type of formatting control for printing. In my research so far It appears that printing directly from the control is not an option. For now I will print to a PDF and then print. The problem I have is the PDF is creating what appears to be about a 1" margin on the page. I need the reports to print with about a .25" margin. Is there any place to control this. I will be doing checks next and the positiong will become more critical.

Thanks in advance.

|||

Go to Report Menu->Report properties -> Layout Tab.

I think this will help.

May

preview layout diferent than server layout

i am using reporting serveces :
i created a DataExtension to get a dataset's value in the report as an
xml input file (this works)
1. i am designing the report using this dataset's values and some
calculated expressions like "runningvalue" everything works fine in
the preview button but when the report is called from my c#
application the "runningvalue" is not being calculated while all the
other data is calculated.
2. the data in my report table is in groups were some groups must be
desplayed others hidden ,acccording to the xml values, as well as some
tables must be displayed otheres hidden in the preview button of the
report this works but also when the report is called from my c#
application all the tables and the groups are displaued which MUST NOT
HAPPEN
what can i do to fix this?
pls help
i need it urgently and i have been working on it for like a lot
by the way,
this is how i am calling the render: from my c# application :
proxyParameters[0] = new STB.testlab02.ParameterValue();
proxyParameters[0].Name = "DataSource";
//System.Data.DataSet dsetReport = new System.Data.DataSet();
DataSet dsReportMO = new DataSet();
dsReportMO.ReadXml("c:\\DataExt\\dsReport.xml");//dsReportMO.GetXml();
proxyParameters[0].Value = dsReportMO.GetXml();
// Build device info based on the start page
deviceInfo = String.Format(@."<DeviceInfo><OutputFormat>{0}</OutputFormat></DeviceInfo>",
"emf");
//Exectute the report and get page count.
try
{
// Renders the first page of the report and returns streamIDs for
// subsequent pages
firstPage = repServ.Render(reportPath, format,
null,deviceInfo,proxyParameters,null,null,out encoding,out
mimeType,out reportHistoryParameters, out warnings, out streamIDs);
.
.
.i still cant find a solution pls help!!!!!!!
how can this work
////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
mireille.azar@.ifsal.com (Mireille) wrote in message news:<63c1f241.0408250057.12d85680@.posting.google.com>...
> i am using reporting serveces :
> i created a DataExtension to get a dataset's value in the report as an
> xml input file (this works)
> 1. i am designing the report using this dataset's values and some
> calculated expressions like "runningvalue" everything works fine in
> the preview button but when the report is called from my c#
> application the "runningvalue" is not being calculated while all the
> other data is calculated.
> 2. the data in my report table is in groups were some groups must be
> desplayed others hidden ,acccording to the xml values, as well as some
> tables must be displayed otheres hidden in the preview button of the
> report this works but also when the report is called from my c#
> application all the tables and the groups are displaued which MUST NOT
> HAPPEN
> what can i do to fix this?
> pls help
> i need it urgently and i have been working on it for like a lot
>
> by the way,
>
> this is how i am calling the render: from my c# application :
>
> proxyParameters[0] = new STB.testlab02.ParameterValue();
> proxyParameters[0].Name = "DataSource";
> //System.Data.DataSet dsetReport = new System.Data.DataSet();
> DataSet dsReportMO = new DataSet();
> dsReportMO.ReadXml("c:\\DataExt\\dsReport.xml");//dsReportMO.GetXml();
> proxyParameters[0].Value = dsReportMO.GetXml();
> // Build device info based on the start page
> deviceInfo = String.Format(@."<DeviceInfo><OutputFormat>{0}</OutputFormat></DeviceInfo>",
> "emf");
> //Exectute the report and get page count.
> try
> {
> // Renders the first page of the report and returns streamIDs for
> // subsequent pages
> firstPage = repServ.Render(reportPath, format,
> null,deviceInfo,proxyParameters,null,null,out encoding,out
> mimeType,out reportHistoryParameters, out warnings, out streamIDs);
> .
> .
> .|||i found the solution...

Preview is better than web browser in this case

I like the functionality in the preview - that if all the parameters
have a valid value... it starts the query without pressing 'View
Report'.
Whereas in a published report in a browser, I always have to press the
'view report'.
In some cases one is better than the other - specially if the query is
small... but navigation needs to be faster.
I have repeatedly asked this question - without any answers.
But if it works in Preview... why not in the browser...'
Seems like there is setting... but no documentation...
I think we need both the options.Yes, we have struggled to answer this questions ourselves. We keep coming
back to this and will take your comments into consideration for sure. To
explain:
The problem is that on the server, there is really no way to stop the
execution of the query that was spawned by requesting a particular report.
So if you have all the defaults specified, then (for a live report) the
server will immediately kick off a report execution. This will inturn
execute the query. That query could take some time to run. Now, if the
user wants to change the values from default before the report finishes
executing, s/he might just click stop on the browser, change the paramters,
and click view report. Now due to how the browser works, the server
doesn't know the user has changed their minds. To the server it is just
another request. So now you have 2 report executions occuring for the same
user. The orignal request eventually will be killed on the report server
(once we realize the connection is closed/stale) but that still leaves the
long running query on the DB server.
So in effect by automatically running the report with the default parameters
you're increasing load significantly on the server. Now imagine how this
affects the system when you scale to 1000's of users.
In the designer, you don't have the same problem so you're more free to do
increase responsivness.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407221045.28cb83ac@.posting.google.com...
>I like the functionality in the preview - that if all the parameters
> have a valid value... it starts the query without pressing 'View
> Report'.
> Whereas in a published report in a browser, I always have to press the
> 'view report'.
> In some cases one is better than the other - specially if the query is
> small... but navigation needs to be faster.
> I have repeatedly asked this question - without any answers.
> But if it works in Preview... why not in the browser...'
> Seems like there is setting... but no documentation...
> I think we need both the options.|||I would say - give those controls to the designer.
Let him/her decide -
1. On Default parameters - should execute immediately or not
2. On Change selection - should execute immediately or not
- parameter wise control. I.e. decide whether a particular
parameter should execute the report immediately or not
Provide with a control with each parameter.
Cascading parameters should have that option also - Specially if
selection of Parameter 1 leads to default of Parameter 2.
- In which case - first of all the "dependency" should be explicitly
defined.
- And then - whether to execute the report immediately or not - could
also be a designers choice.
Just some thoughts...

Preview has data but no columns returned

In my SSIS package, I connect to an external SQL server database. This external database supports a stored procedure that I need to execute to "retrieve data". So in my package, I set the DataAccess Mode property of my OLEDB datasource to "SQL Command" and I provide the command EXEC <proc_name> <Param>,<output_param>. (The proc has an output parameter). The preview shows all the columns and data, but somehow no columns are returned....so when I try to link this data source to a copy column task, I get an error saying the source does not have any columns...any idea why this could be happening. Thanks - Manmeet

I just ran a test on my side and it actually worked. I create a simple sp with a query (select * from adventureworks.production.productcategory) and the use it in the OLE DB. The preview worked fine and when connecting to a copy column transform I was able to see all the columns. However there is another thread going on now about the same issue and they say there are some work arounds:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=786591&SiteID=1

In case you need it this is the xml code of my package

<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property DTS:Name="VersionComments"></DTS:Property><DTS:Property DTS:Name="CreatorName">MARINER\rsalas</DTS:Property><DTS:Property DTS:Name="CreatorComputerName">MARINERLAPTOP14</DTS:Property><DTS:Property DTS:Name="CreationDate" DTS:DataType="7">10/4/2006 8:05:36 AM</DTS:Property><DTS:Property DTS:Name="PackageType">5</DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</DTS:Property><DTS:Property DTS:Name="VersionMajor">1</DTS:Property><DTS:Property DTS:Name="VersionMinor">0</DTS:Property><DTS:Property DTS:Name="VersionBuild">3</DTS:Property><DTS:Property DTS:Name="VersionGUID">{28EC0411-DE09-4FBE-AA35-FA11901A0511}</DTS:Property><DTS:Property DTS:Name="EnableConfig">0</DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</DTS:Property>

<DTS:ConnectionManager><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">ETLRafLab</DTS:Property><DTS:Property DTS:Name="DTSID">{82682565-2AB7-4AE8-AB84-A06FBB937955}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">OLEDB</DTS:Property><DTS:ObjectData><DTS:ConnectionManager><DTS:Property DTS:Name="Retain">0</DTS:Property><DTS:Property DTS:Name="ConnectionString">Data Source=MARINERLAPTOP14;Initial Catalog=ETLRafLabDev;Provider=SQLNCLI.1;Integrated Security=SSPI;</DTS:Property></DTS:ConnectionManager></DTS:ObjectData></DTS:ConnectionManager>

<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsControlFlowDiagram><dwd:BoundingTop>2593</dwd:BoundingTop><dwd:Layout><dds>

<font>

</font>

</mouseicon>

</diagram>

</layoutmanager>

</control>

</ddsxmlobj>

</layoutobject>

</ddscontrol>

</dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{5B6C56E1-90E4-4B8E-85C0-E150AF873875}</DTS:Property><DTS:Property DTS:Name="DTSID">{D803BA1C-C91E-408F-9D6F-1226D9333CD0}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>

<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><ConnectionManager xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DataSourceID>ETLRafLab</dwd:DataSourceID></ConnectionManager></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{82682565-2AB7-4AE8-AB84-A06FBB937955}</DTS:Property><DTS:Property DTS:Name="DTSID">{CDC092B4-325E-4283-8E03-88E168C82372}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>

<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><TaskHost xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsDataFlowDiagram><dwd:BoundingTop>1667</dwd:BoundingTop><dwd:Layout><dds>

<font>

</font>

</mouseicon>

</diagram>

</layoutmanager>

</control>

</ddsxmlobj>

</layoutobject>

</ddscontrol>

</control>

</ddsxmlobj>

</layoutobject>

</ddscontrol>

</ddsxmlobj>

</control>

</ddsxmlobj>

</layoutobject>

</connector>

</ddscontrol>

</dds></dwd:Layout></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{B59730D8-9045-4EB3-A965-95240CC97D28}</DTS:Property><DTS:Property DTS:Name="DTSID">{A8831B5B-654F-43D4-BAA9-605512FCCDB0}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>

<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DestinationName>Copy Column Input</dwd:DestinationName><dwd:SourceName>OLE DB Source Output</dwd:SourceName></PipelinePath></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{B59730D8-9045-4EB3-A965-95240CC97D28}-86</DTS:Property><DTS:Property DTS:Name="DTSID">{2C57A2EE-F8A6-4FD6-8BAF-54C95E9E30B7}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">1033</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>

<DTS:Executable DTS:ExecutableType="DTS.Pipeline.1"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact">Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1</DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>

<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">Data Flow Task</DTS:Property><DTS:Property DTS:Name="DTSID">{B59730D8-9045-4EB3-A965-95240CC97D28}</DTS:Property><DTS:Property DTS:Name="Description">Data Flow Task</DTS:Property><DTS:Property DTS:Name="CreationName">DTS.Pipeline.1</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><pipeline id="0" name="pipelineXml" description="pipelineXml" defaultBufferMaxRows="10000" engineThreads="5" defaultBufferSize="10485760" BLOBTempStoragePath="" bufferTempStoragePath="" runInOptimizedMode="true">

<property id="5" name="SqlCommand" dataType="System.String" state="default" isArray="false" description="The SQL command to be executed." typeConverter="" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None">Exec sp_SelectFromProductCategory</property>

<property id="8" name="AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default" isArray="false" description="Forces the use of the DefaultCodePage property value when describing character data." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>

</outputs>

</component>

</inputs>

</outputs>

</component>

</components>

<paths>

</paths></pipeline></DTS:ObjectData></DTS:Executable><DTS:Property DTS:Name="ObjectName">OLEDB source with SP</DTS:Property><DTS:Property DTS:Name="DTSID">{5B6C56E1-90E4-4B8E-85C0-E150AF873875}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property></DTS:Executable>

|||yeah I have a similar package connecting to another database (and executing a stored procedure) and that works just fine. But the package that I described in my last email just refuses to get going...btw..thanks for the other link - let me check if tweaking the procedure helps - appreciate your help!!|||

Manmeet Panigrahi wrote:
In my SSIS package, I connect to an external SQL server database. This external database supports a stored procedure that I need to execute to "retrieve data". So in my package, I set the DataAccess Mode property of my OLEDB datasource to "SQL Command" and I provide the command EXEC <proc_name> <Param>,<output_param>. (The proc has an output parameter). The preview shows all the columns and data, but somehow no columns are returned....so when I try to link this data source to a copy column task, I get an error saying the source does not have any columns...any idea why this could be happening. Thanks - Manmeet

I think the root cause of the problem here is that sprocs don't own their own metadata like tables and views do. It is theoretically possible to return completely different result sets from the same sproc depending on what parameters you pass it so there is no real metadata to bind to. Adam Machanic has a great discussion about this here:

Stored procedures are not parameterized views
(http://www.sqljunkies.com/WebLog/amachanic/archive/2006/05/29/21482.aspx)

Try the workaround that I suggested on the other thread.

-Jamie

|||

ok...now there is a new twist to the tale. I just found out that the select statement in the stored procedure that returns the data does a select on a temp table. And that is the reason why the columns are not being detected correctly. I also found out from another developer that they had the same issue in DTS (2000) and hence they built the DTS package using disconnected edit and it works fine!

So assuming that we are not able to change the proc, is there a way we can do the disconnected edit kind of workaround in SSIS? -Manmeet

|||

Manmeet Panigrahi wrote:

ok...now there is a new twist to the tale. I just found out that the select statement in the stored procedure that returns the data does a select on a temp table. And that is the reason why the columns are not being detected correctly. I also found out from another developer that they had the same issue in DTS (2000) and hence they built the DTS package using disconnected edit and it works fine!
So assuming that we are not able to change the proc, is there a way we can do the disconnected edit kind of workaround in SSIS? -Manmeet

There's similar. You could set the sql dynamically at runtime using an expression. That might be a very clever workaround actually. I'd be interested to see if it works.

-Jamie

|||Unfortunately that didnt work too...this is what I did...I now have this variable that stores the command to execute the proc that returns the data (EXEC pr_....). (This variable is populated at run time). Also this variable becomes the Data Access Mode of my OLEDB data source. Now at design time, I have this variable populated with a select statement that returns data in the correct schema format..so that I am able to setup my source destination mappings. So when the package runs, the variable gets populated (at runtime) with the EXEC statement...but unfortunately SSIS revalidates the schema (and detects that the EXEC does not return any columns) and gives me the "VS_NEEDSNEWMETADATA" errror....sigh...Unfortunately the proc is owned by a different set of ppl and it will take a lot of time for me to convince them to change it..

Preview has data but no columns returned

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=786591&SiteID=1

In case you need it this is the xml code of my package

<font>

</font>

</mouseicon>

</diagram>

</layoutmanager>

</control>

</ddsxmlobj>

</layoutobject>

</ddscontrol>

<font>

</font>

</mouseicon>

</diagram>

</layoutmanager>

</control>

</ddsxmlobj>

</layoutobject>

</ddscontrol>

</control>

</ddsxmlobj>

</layoutobject>

</ddscontrol>

</ddsxmlobj>

</control>

</ddsxmlobj>

</layoutobject>

</connector>

</ddscontrol>

</outputs>

</component>

</inputs>

</outputs>

</component>

</components>

<paths>

Manmeet Panigrahi wrote:
In my SSIS package, I connect to an external SQL server database. This external database supports a stored procedure that I need to execute to "retrieve data". So in my package, I set the DataAccess Mode property of my OLEDB datasource to "SQL Command" and I provide the command EXEC <proc_name> <Param>,<output_param>. (The proc has an output parameter). The preview shows all the columns and data, but somehow no columns are returned....so when I try to link this data source to a copy column task, I get an error saying the source does not have any columns...any idea why this could be happening. Thanks - Manmeet

Stored procedures are not parameterized views
(http://www.sqljunkies.com/WebLog/amachanic/archive/2006/05/29/21482.aspx)

Try the workaround that I suggested on the other thread.

-Jamie

|||

So assuming that we are not able to change the proc, is there a way we can do the disconnected edit kind of workaround in SSIS? -Manmeet

|||

Manmeet Panigrahi wrote:

ok...now there is a new twist to the tale. I just found out that the select statement in the stored procedure that returns the data does a select on a temp table. And that is the reason why the columns are not being detected correctly. I also found out from another developer that they had the same issue in DTS (2000) and hence they built the DTS package using disconnected edit and it works fine!
So assuming that we are not able to change the proc, is there a way we can do the disconnected edit kind of workaround in SSIS? -Manmeet

There's similar. You could set the sql dynamically at runtime using an expression. That might be a very clever workaround actually. I'd be interested to see if it works.

-Jamie

Wednesday, March 28, 2012

Print button doesn't work in ReportServer 2005

Saturday, February 25, 2012

previewing sub report on list element? HELP PLEASE

Previewing reports - MissingMethodException

Previewing RDL without Designer

Preview/Print/Save reports

preview tab does not display bound data

preview reports?

Preview report drastically different than export or deployed

Preview Problem!

Preview pane not showing data

Preview only returning one record of report

preview layout diferent than server layout

Preview is better than web browser in this case

Preview has data but no columns returned

Preview has data but no columns returned

Preventing Deadlock

Blog Archive

About Me