Print newly created report later

Hi all,

I am creating reports using crystal report in VB.NET. The reports are created successfully and can be converted to PDF and Word.

After the creation i send generated documents as email. And also have to print them.

I don't want to use Adobe/Word for the printing. I want to create .prn files for printing in the generation process.

Is there any other option which can be used to print the created report.

I can print the reports directly from crystal reports but i want to split the process in two phases
1, Generation
2, Dispatching

Looking for ideaCant you make use of Print button avaliable in the Report?|||Thanks for your reply.

But the scenario is entierly different in my case. I am using Crystal Reports as window service and the process is splited in two phases

1, Generation
2, Dispatching

One process will generate a document and then save it
the other process will print that generated document

I can generate and print in one process with out storing the file on disk. But i want to do it in two steps.

Regards|||What is the difficulty in doing this in two steps?|||The difficulty is,
I have to create a report in Step one and have to save it to the disk. Right in which format i would store it so i can again open it through crystal report and send its print?

Or is there any other format to store the generated report? SO i can print it again through crystal report.

I don't want to use MS Word or Adobe automation for printing.

Regards|||If you show the report in your application, enable print button so that you can print it from CR|||Madhi
Thanks for the reply but i think you are not getting the issue which i am facing.
My application runs as Windows Service it has no GUI.
Also first i have to create a report , save it to the disk. The other process will print that saved report file.

I can save the report in pdf, word and other suported formats but to print pdf i have to use Adobe or to print word i need MS Word. Which i don't want.

I directly want to print the saved file.

Regards|||Well. Which front end application are you using?|||There is no such Front End.

The request is submitted to the data base and the application checks the data base for any new request.

On the new request it generates the report and stor/export in specific format also updates the data base.

The other application picks the stored documents/files and prints then, email or fax them then again update the database.

Email and Faxing is working well but the print is creating problem as i described in my previous reply.|||See if you are able find solution here
http://support.businessobjects.com/

Print Issues with Reporting Services

I developed and deployed a report using VS.net. Reporting Services gives you the option on the web page to print the report or export to another format. When choosing to print, I am unable to get the report to print in landscape mode on standard letter paper. What is the relationship between the margin properties (which seem to have no impact) on the report? the body of the report? and the printer?
The report size doesnt seem to matter (10 x 7.5 inches) tried changing margins here also
The body size doesnt seem to matter (9.75 x 7 inches) and here

Does the issue lie with
a) the printer properties
b) Reporting services
c) IE
Im stumped!!

Hopefully, you are using the Sep. CTP or later, since there was a known issue earlier with landscape printing. After the report server was upgraded, I still had to manually delete the old RSClientPrint Class file on my PC, which was cached under the "Downloaded Program Fles" folder (RTM version is: 2005,90,1399,0).

Print Icon does not function

Hello,

I display my reports through ReportViewer embedded into my ASP.Net application. The Print icon on the ReportViewer works fine on my computer but on other computers. It does not bring the window so that user select the printer. And sometimes I see "Problems with this web page might prevent it from being displayed properly"

Why does this happen and how can I resolve it for all the computers.

Jim H.

For some reason - I like you - you are always encountering a problem - which means you experiment!

Have you installed SP2 of RS?

First of all, tell me your configuration!@.

I can help!

Joe

|||

Once again, have you installed SP2 of RS?

sql

print from toolbar

Hello, I have created an asp.net application using VS .Net 2003, which has a Report Viewer to include reports from my report manager.

The reportviewer has been set to include the standard toolbar, which includes the print button. However, when I use this option, the system prints more pages than it should. If the report is 2 pages long, I end up getting 6 pages, the other four having just the header and footer...(2 blanks pages after each page when port. ana 1 black after each page if landscape)

Any1 know the solution to this problem? I have not coded anything for the print option....

Thanks :)

Check the width of your reports. If it is too wide then printing it will create extra pages.

micro-geek

Print Error in RS2005

Hi All
I have 2 questions regarding the printing of the report.
1) I have an asp.net apps in which there are some links which point to
the report.when comming to the printing of the report only one user
facing the problem while printing the report from the print button icon
from the report.he is getting eror "an error occurred during
printing(0X8007F304)"
He is using other application which contain reports and he can able to
print the report from same print button.
I did search on google for this particular error and in one forum they
said to do this
1. Closed all instance of Internet Explorer.
2. Opened Windows Explorer and went to C:\Windows\Downloaded Program
Files\
3. Right clicked on RSClientPrintClass and chose "Remove"
4. Went to my Reporting Services report and tried to print
5. Said "Install" when prompted to install the Reporting Services Print
Control
6. Printing commenced!
Am i supposed to do it on the server or else on the user PC (Kind of a
dumb question)
2) whats the purpose of the percertange box in the tool bar.is it
useful for the viewing the report by decreasing or printing the report
on a decreased percentage view.I thought by decreasing the
precentage,report size also decreases as it does if we decrease the
percentage and print it from the file menu options.
Thanks
vkvHi ,
Some new problem came in to picture.I did the same thing
removing the rsprintclientcalss and installed activex it worked for the
reports that are on th rs2005.
But the application that contains reports which are on rs2000 getting
an error as "An error occured during printing. (0x80004005).
Does rs2005 print activex should work for 2000?.Are there any options
like both the versions activex controls are downloaded so that both the
versions printing works.
Thanks
vkv

Print custom page in asp.net

How could i print a custom page (8.5in X 5.5in) in asp.net 2.0 ?

If you are using ssrs to do the report you can set the margin size by right clicking on the gray area of the body of your report this will bring up properties click on the layout tab you can set the size of your report here.

Please mark as answered if this helps you

Print button is not visible in rdlc report

I am using client side reports (.rdlc) with ASP.Net 2.0 and SQL Server 2000. Reports are generating fine. But there is no print button on report viewer when i generate report. I use browser's print option to print reports but reports does not get printed properly. Can some one tell me how to enable Print button in client side reports.

Local reports in web apps dont support printing . you should write your own print function for that .

you have to render the report and the print generated emf files .here is a sample code but its in win apps.

you should create your own print function

http://msdn2.microsoft.com/en-us/library/ms252091(VS.80).aspx

Primary Key Question

I have been developing a .NET Web app with an SQL Server 2005 Express database. Since I've been testing insert and delete code with a large data source, the Primary Key column which is also an autoincrement integer column is now at very large numbers (starting at over 40,000 now). I've tried doing a shrink on the database, but other then reducing the database size, it has done nothing to reduce the Primary Key numbers. Is there a command way to reduce the starting number back to 1 or do I need to completely reconstruct the database from scratch?

TIA

hi,

in order to "reset" the identity column value, you can "truncate" the table, that will implicitely reset the aut generated identity to your initial value via the
TRUNCATE TABLE schema.object;
statement... you will need high permissions on the object itself, and the table must not be referenced by a foreign key, ...
you can read further about requirements and permissions at http://msdn2.microsoft.com/en-us/library/ms177570.aspx...

or you can execute a
DBCC CHECKIDENT ('schema.object', RESEED);
command... start reading http://msdn2.microsoft.com/en-us/library/ms176057.aspx for further info and requirements..

regards

|||

Thanks - I'll give it a try.

Carl

|||

No dice. Neither of those options does it. That I want is, for example, a way of changing the lowest Primary/Identity Key value from 40,000 to 1. There are no records at lower values than 40,000. I'd also like to move all the Primary/Identity Key values down as well.

I suspect I need to effectively copy all the non-Primary/Identity Key data into a newly created database. If I do that, I think it is a characteristic of the INSERT statement that the Primary/Identity Key values will start at the seed values and autoincrement from there as rows are inserted and the incoming Primary/Identity Keys are ignored. I can then delete the original database and rename the new one to the original name.

Sound right?

Carl

|||

hi,

ok. you want to "re-assign" an autogenerated value starting from "1" to existing rows...

you actually do not have to "drop" the database...

just perform a "SELECT ... INTO" another table that will be created on the fly for you, as a temporary storage... then drop all rows from the "real" table and reset the identity value and repopulate the original table from the temp storage...

I mean something like

SET NOCOUNT ON;

USE tempdb;

GO

CREATE TABLE dbo.myData(

Id int NOT NULL IDENTITY PRIMARY KEY,

Data varchar(10) DEFAULT 'test data'

);

GO

PRINT 'this will add some data';

DECLARE @.i int;

SET @.i = 1;

INSERT INTO dbo.myData VALUES ( DEFAULT );

WHILE @.i < 20 BEGIN

INSERT INTO dbo.myData SELECT Data FROM dbo.myData;

SET @.i = @.i + 1;

END;

GO

SELECT COUNT(*) AS [Count], MAX(Id) AS [Max], MIN(Id) AS [Min] FROM dbo.myData;

GO

PRINT 'Deleting rows 1 to 200000';

DELETE FROM dbo.myData WHERE Id < 200000;

GO

SELECT COUNT(*) AS [Count], MAX(Id) AS [Max], MIN(Id) AS [Min] FROM dbo.myData;

PRINT 'now we do have an initial unused ''identity range''';

GO

PRINT 'Move rows to a temp table';

SELECT * INTO dbo.tempTable FROM dbo.myData;

PRINT 'truncating the original myData table';

PRINT 'this will actually reseed the identity value as well';

TRUNCATE TABLE dbo.myData;

SELECT COUNT(*) AS [Count], MAX(Id) AS [Max], MIN(Id) AS [Min] FROM dbo.myData;

GO

PRINT 'move data again to the original table, but this time omitting the Id col';

INSERT INTO dbo.myData (Data) SELECT Data FROM dbo.tempTable ORDER BY Id;

SELECT COUNT(*) AS [Count], MAX(Id) AS [Max], MIN(Id) AS [Min] FROM dbo.myData;

GO

PRINT 'deleting temp table';

DROP TABLE dbo.tempTable;

GO

PRINT 'final clean up';

DROP TABLE dbo.myData;

--<--

this will add some data

Count Max Min

-- -- --

524288 524288 1

Deleting rows 1 to 200000

Count Max Min

-- -- --

324289 524288 200000

now we do have an initial unused 'identity range'

Move rows to a temp table

truncating the original myData table

this will actually reseed the identity value as well

Count Max Min

-- -- --

0 NULL NULL

move data again to the original table, but this time omitting the Id col

Count Max Min

-- -- --

324289 324289 1

deleting temp table

final clean up

but this is usually not an efficient task you should do in production systems as, after all, key values are not interesting to human beings when autogenerated... you usually choose such a primary key for performance reasons or when you can not find an actual natural key in your data modelling desing phase (very bad ), so the actual value is not that big deal at all,, you just need it non repetetive and you get it as expected...

regards

|||

Thank you, Sir.

Yes, it did work and in the process I've learned more about SQL Express and T-SQ, important for a relative newbieL. Not only the original question I asked, but a seperate isuue I wasn't aware I was messing up until I kept getting an error message from the SELECT phrase in the second INSERT statement. I was insisting on putting parens around the column name list and SELECT didn't like that. When I ceased and desited, everything went smoothly. I initially tried this on the smaller of the two existing tables and each time it bombed out, it actually added to the PRIMARY IDENTITY Key. Since I expect more blanks from delete and insert statements as I develop the C# access code, that's not important now and I can fix it later. Reseeding the second table (the big one) went through without a hitch once I knew the right syntax. I expect that I'll need to write a script or something to do this and similar cleanup as I develop this app since I have more big tables to add with similar situations. Hopefully, I won't need to mess with it anymore when the app coding job's done, but at least I know how to do it now.

I'll take your advice on the autogenerated key into account and redesign accordingly. One of the two current tables I can change; the other not based on expected content.

Thanks for the help. I think I'm off and running again

Carl

|||

hi Carl,

Speedo wrote:

....

I'll take your advice on the autogenerated key into account and redesign accordingly. One of the two current tables I can change; the other not based on expected content.

wait before redesigning... I did not say that autogenearated keys are bad ..

they are just another (available) candidate key in our entity definition.. it should not be the only one, but such a candidate key can be good primary key, as it's very compact (and this is very usefull in relation where the referencing table must map to the referenced table) and this is a "nice to have" feature in indexes implementation...

very often database architechts implement a surrogate key in the design phase.. sometime these surrogate keys become primary keys and sometime not...

a nice article about nautural vs surrogate keys is available at http://www.informit.com/articles/article.asp?p=25862&redir=1&rl=1 , even if related to GUID columns..

regards

Primary Key Question

I have been developing a .NET Web app with an SQL Server 2005 Express database. Since I've been testing insert and delete code with a large data source, the Primary Key column which is also an autoincrement integer column is now at very large numbers (starting at over 40,000 now). I've tried doing a shrink on the database, but other then reducing the database size, it has done nothing to reduce the Primary Key numbers. Is there a command way to reduce the starting number back to 1 or do I need to completely reconstruct the database from scratch?

TIA

hi,

in order to "reset" the identity column value, you can "truncate" the table, that will implicitely reset the aut generated identity to your initial value via the
TRUNCATE TABLE schema.object;
statement... you will need high permissions on the object itself, and the table must not be referenced by a foreign key, ...
you can read further about requirements and permissions at http://msdn2.microsoft.com/en-us/library/ms177570.aspx...

or you can execute a
DBCC CHECKIDENT ('schema.object', RESEED);
command... start reading http://msdn2.microsoft.com/en-us/library/ms176057.aspx for further info and requirements..

regards

|||

Thanks - I'll give it a try.

Carl

|||

No dice. Neither of those options does it. That I want is, for example, a way of changing the lowest Primary/Identity Key value from 40,000 to 1. There are no records at lower values than 40,000. I'd also like to move all the Primary/Identity Key values down as well.

I suspect I need to effectively copy all the non-Primary/Identity Key data into a newly created database. If I do that, I think it is a characteristic of the INSERT statement that the Primary/Identity Key values will start at the seed values and autoincrement from there as rows are inserted and the incoming Primary/Identity Keys are ignored. I can then delete the original database and rename the new one to the original name.

Sound right?

Carl

|||

hi,

ok. you want to "re-assign" an autogenerated value starting from "1" to existing rows...

you actually do not have to "drop" the database...

just perform a "SELECT ... INTO" another table that will be created on the fly for you, as a temporary storage... then drop all rows from the "real" table and reset the identity value and repopulate the original table from the temp storage...

I mean something like

SET NOCOUNT ON; USE tempdb; GO CREATE TABLE dbo.myData( Id int NOT NULL IDENTITY PRIMARY KEY, Data varchar(10) DEFAULT 'test data' ); GO PRINT 'this will add some data'; DECLARE @.i int; SET @.i = 1; INSERT INTO dbo.myData VALUES ( DEFAULT ); WHILE @.i < 20 BEGIN INSERT INTO dbo.myData SELECT Data FROM dbo.myData; SET @.i = @.i + 1; END; GO SELECT COUNT(*) AS [Count], MAX(Id) AS [Max], MIN(Id) AS [Min] FROM dbo.myData; GO PRINT 'Deleting rows 1 to 200000'; DELETE FROM dbo.myData WHERE Id < 200000; GO SELECT COUNT(*) AS [Count], MAX(Id) AS [Max], MIN(Id) AS [Min] FROM dbo.myData; PRINT 'now we do have an initial unused ''identity range'''; GO PRINT 'Move rows to a temp table'; SELECT * INTO dbo.tempTable FROM dbo.myData; PRINT 'truncating the original myData table'; PRINT 'this will actually reseed the identity value as well'; TRUNCATE TABLE dbo.myData; SELECT COUNT(*) AS [Count], MAX(Id) AS [Max], MIN(Id) AS [Min] FROM dbo.myData; GO PRINT 'move data again to the original table, but this time omitting the Id col'; INSERT INTO dbo.myData (Data) SELECT Data FROM dbo.tempTable ORDER BY Id; SELECT COUNT(*) AS [Count], MAX(Id) AS [Max], MIN(Id) AS [Min] FROM dbo.myData; GO PRINT 'deleting temp table'; DROP TABLE dbo.tempTable; GO PRINT 'final clean up'; DROP TABLE dbo.myData; --<-- this will add some data Count Max Min -- -- -- 524288 524288 1 Deleting rows 1 to 200000 Count Max Min -- -- -- 324289 524288 200000 now we do have an initial unused 'identity range' Move rows to a temp table truncating the original myData table this will actually reseed the identity value as well Count Max Min -- -- -- 0 NULL NULL move data again to the original table, but this time omitting the Id col Count Max Min -- -- -- 324289 324289 1 deleting temp table final clean up

but this is usually not an efficient task you should do in production systems as, after all, key values are not interesting to human beings when autogenerated... you usually choose such a primary key for performance reasons or when you can not find an actual natural key in your data modelling desing phase (very bad ), so the actual value is not that big deal at all,, you just need it non repetetive and you get it as expected...

regards

|||

Thank you, Sir.

Yes, it did work and in the process I've learned more about SQL Express and T-SQ, important for a relative newbieL. Not only the original question I asked, but a seperate isuue I wasn't aware I was messing up until I kept getting an error message from the SELECT phrase in the second INSERT statement. I was insisting on putting parens around the column name list and SELECT didn't like that. When I ceased and desited, everything went smoothly. I initially tried this on the smaller of the two existing tables and each time it bombed out, it actually added to the PRIMARY IDENTITY Key. Since I expect more blanks from delete and insert statements as I develop the C# access code, that's not important now and I can fix it later. Reseeding the second table (the big one) went through without a hitch once I knew the right syntax. I expect that I'll need to write a script or something to do this and similar cleanup as I develop this app since I have more big tables to add with similar situations. Hopefully, I won't need to mess with it anymore when the app coding job's done, but at least I know how to do it now.

I'll take your advice on the autogenerated key into account and redesign accordingly. One of the two current tables I can change; the other not based on expected content.

Thanks for the help. I think I'm off and running again

Carl

|||

hi Carl,

Speedo wrote:

....

I'll take your advice on the autogenerated key into account and redesign accordingly. One of the two current tables I can change; the other not based on expected content.

wait before redesigning... I did not say that autogenearated keys are bad ..

they are just another (available) candidate key in our entity definition.. it should not be the only one, but such a candidate key can be good primary key, as it's very compact (and this is very usefull in relation where the referencing table must map to the referenced table) and this is a "nice to have" feature in indexes implementation...

very often database architechts implement a surrogate key in the design phase.. sometime these surrogate keys become primary keys and sometime not...

a nice article about nautural vs surrogate keys is available at http://www.informit.com/articles/article.asp?p=25862&redir=1&rl=1 , even if related to GUID columns..

regards

sql

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.
>

Preview/Print/Save reports

Hi

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 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 error

This is my first report. I used VS.NET 2003 wizard to create the report,
which consisted of a very simple select query report.
When I switch to preview tab in IDE, I am getting the following error.
Processing Errors:
An error has occurred during report processing.
Cannot create a connecttion to data source 'xxx'.
Login failed for user 'yy'
Any ideas of why this is happening? I looked at rdl file in notepad. The
credentials supplied during report creation is not stored in that file.
Please help ASAP.
Thanks,
Live_Love_LaughIf you are using a shared data source, in solution explorer, double click on
the datasource file. Select the credentials tab. The problem is likely here.
If you are using SQL authentication, either enter a password or select the
option to prompt for a password. Let me know if this helps.
"Live_Love_Laugh" wrote:
> This is my first report. I used VS.NET 2003 wizard to create the report,
> which consisted of a very simple select query report.
> When I switch to preview tab in IDE, I am getting the following error.
> Processing Errors:
> An error has occurred during report processing.
> Cannot create a connecttion to data source 'xxx'.
> Login failed for user 'yy'
> Any ideas of why this is happening? I looked at rdl file in notepad. The
> credentials supplied during report creation is not stored in that file.
> Please help ASAP.
> Thanks,
> Live_Love_Laugh
>
>|||I am not using a shared data source. On the data tab, I can see the tables
and my query. But when I switch to preview tab to fetch the data, it is
giving the error. Also on the data tab, I can run the query and see the
results.
Thanks,
Live_Love_Laugh
"vmp_pdx" <vmppdx@.discussions.microsoft.com> wrote in message
news:60D5F30E-F474-4AA3-B6B9-5805A046B898@.microsoft.com...
> If you are using a shared data source, in solution explorer, double click
on
> the datasource file. Select the credentials tab. The problem is likely
here.
> If you are using SQL authentication, either enter a password or select the
> option to prompt for a password. Let me know if this helps.
> "Live_Love_Laugh" wrote:
> > This is my first report. I used VS.NET 2003 wizard to create the report,
> > which consisted of a very simple select query report.
> > When I switch to preview tab in IDE, I am getting the following error.
> >
> > Processing Errors:
> >
> > An error has occurred during report processing.
> > Cannot create a connecttion to data source 'xxx'.
> > Login failed for user 'yy'
> >
> > Any ideas of why this is happening? I looked at rdl file in notepad. The
> > credentials supplied during report creation is not stored in that file.
> >
> > Please help ASAP.
> >
> > Thanks,
> > Live_Love_Laugh
> >
> >
> >|||Can anybody help with this?
Thanks,
Live_Love_Laugh
"Live_Love_Laugh" <OnlineSubscribe@.yahoo.com> wrote in message
news:%23NTAPMvpEHA.2588@.TK2MSFTNGP12.phx.gbl...
> I am not using a shared data source. On the data tab, I can see the tables
> and my query. But when I switch to preview tab to fetch the data, it is
> giving the error. Also on the data tab, I can run the query and see the
> results.
> Thanks,
> Live_Love_Laugh
> "vmp_pdx" <vmppdx@.discussions.microsoft.com> wrote in message
> news:60D5F30E-F474-4AA3-B6B9-5805A046B898@.microsoft.com...
> > If you are using a shared data source, in solution explorer, double
click
> on
> > the datasource file. Select the credentials tab. The problem is likely
> here.
> > If you are using SQL authentication, either enter a password or select
the
> > option to prompt for a password. Let me know if this helps.
> >
> > "Live_Love_Laugh" wrote:
> >
> > > This is my first report. I used VS.NET 2003 wizard to create the
report,
> > > which consisted of a very simple select query report.
> > > When I switch to preview tab in IDE, I am getting the following error.
> > >
> > > Processing Errors:
> > >
> > > An error has occurred during report processing.
> > > Cannot create a connecttion to data source 'xxx'.
> > > Login failed for user 'yy'
> > >
> > > Any ideas of why this is happening? I looked at rdl file in notepad.
The
> > > credentials supplied during report creation is not stored in that
file.
> > >
> > > Please help ASAP.
> > >
> > > Thanks,
> > > Live_Love_Laugh
> > >
> > >
> > >
>|||Could you email to me your RDL?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Live_Love_Laugh" <OnlineSubscribe@.yahoo.com> wrote in message
news:OZEmZy$pEHA.2900@.TK2MSFTNGP12.phx.gbl...
> Can anybody help with this?
> Thanks,
> Live_Love_Laugh
> "Live_Love_Laugh" <OnlineSubscribe@.yahoo.com> wrote in message
> news:%23NTAPMvpEHA.2588@.TK2MSFTNGP12.phx.gbl...
>> I am not using a shared data source. On the data tab, I can see the
>> tables
>> and my query. But when I switch to preview tab to fetch the data, it is
>> giving the error. Also on the data tab, I can run the query and see the
>> results.
>> Thanks,
>> Live_Love_Laugh
>> "vmp_pdx" <vmppdx@.discussions.microsoft.com> wrote in message
>> news:60D5F30E-F474-4AA3-B6B9-5805A046B898@.microsoft.com...
>> > If you are using a shared data source, in solution explorer, double
> click
>> on
>> > the datasource file. Select the credentials tab. The problem is likely
>> here.
>> > If you are using SQL authentication, either enter a password or select
> the
>> > option to prompt for a password. Let me know if this helps.
>> >
>> > "Live_Love_Laugh" wrote:
>> >
>> > > This is my first report. I used VS.NET 2003 wizard to create the
> report,
>> > > which consisted of a very simple select query report.
>> > > When I switch to preview tab in IDE, I am getting the following
>> > > error.
>> > >
>> > > Processing Errors:
>> > >
>> > > An error has occurred during report processing.
>> > > Cannot create a connecttion to data source 'xxx'.
>> > > Login failed for user 'yy'
>> > >
>> > > Any ideas of why this is happening? I looked at rdl file in notepad.
> The
>> > > credentials supplied during report creation is not stored in that
> file.
>> > >
>> > > Please help ASAP.
>> > >
>> > > Thanks,
>> > > Live_Love_Laugh
>> > >
>> > >
>> > >
>>
>

Preview a Report in Design Mode (VS 2005)

I am working with SQL Server Reporting Services and Visual Studio .Net 2005 Beta 2. In VS 2003 you could preview a report in design mode by clicking on the preview tab. There is no such tab in 2005 Beta 2. Does anyone know how to preview a report in design mode? Thanks.When you are using the Report Controls in local mode (embedded), there is no preview since your application is responsible for creating the data set to bind into the control. You will need to execute your application to preview.

Designer preview is only present in report server mode.

Preview a Report in Design Mode (VS 2005)

I am working with SQL Server Reporting Services and Visual Studio .Net 2005 Beta 2. In VS 2003 you could preview a report in design mode by clicking on the preview tab. There is no such tab in 2005 Beta 2. Does anyone know how to preview a report in design mode? Thanks.When you are using the Report Controls in local mode (embedded), there is no preview since your application is responsible for creating the data set to bind into the control. You will need to execute your application to preview.

Designer preview is only present in report server mode.

Preventing unauthorized access

I am building a windows forms VB .NET project that connects to an SQL server
database. The problem we have is that since we are using windows-based aut
hentication, anyone with access or even excel can connect to the sql server
and fiddle with the data.
I looked into application roles but using this we lose flexibility for givin
g (or removing) rights from specific users.
This problem wouldn't exist if we were building web apps, as we could set th
ings up in a way the web server would be the only one to connect to the data
base.
What do people use in enterprises to prevent users from connecting to databa
ses with unauthorized apps ?
Thanks in advance.Use only stored procedures to access the database in your application. Do
not grant any permissions on tables or views to users; only grant
permissions on stored procedures. This will effectively block access to the
database from any source except your application (or a keen user who knows
how to properly call the stored procedures).
"/dev/null" <anonymous@.discussions.microsoft.com> wrote in message
news:4AD3A344-840C-47B4-A9DE-9968BF748D0C@.microsoft.com...
> I am building a windows forms VB .NET project that connects to an SQL
server database. The problem we have is that since we are using
windows-based authentication, anyone with access or even excel can connect
to the sql server and fiddle with the data. I looked into application roles
but using this we lose flexibility for giving (or removing) rights from
specific users.
> This problem wouldn't exist if we were building web apps, as we could set
things up in a way the web server would be the only one to connect to the
database.
> What do people use in enterprises to prevent users from connecting to
databases with unauthorized apps ?
> Thanks in advance.