data sources for subscriptions, linked reports, how it can all wor

I think I must be missing something here...
I, as the developer, create Report1 and Report2: they use DataSouceA.
DataSourceA is set to use windows integrated security.
My on-demade reports run fine. The username (selected from the db, not from the Globals collection) is used to filter out options on the parameter screen, so users can only see data in their respective division.
Now: I want my USERS to be able to schedule reports.
I am able to schedule reports by taking Report1 and Report2 and either customizing the data source or pointing it to a new data source: BUT I AM DOING THAT FOR ALL USERS who are on the system!!! Now, anyone who goes to run Report1 or Report2 does not need to have any security to access the database, they are all using my id!
If I create a LINKED report, you do not seem to have the option of changing the data source...it is not even on the left menu anymore. '
So: I am confused. If I have to set up all reports to used a saved data source (lets just say it is my username and password), what is the sense of having any security? I must be missing something here.
What I want is the NT integrated security for on-demand. Then if a user has the ability to schedule reports, they would need to make a linked copy of the report, change the data source (and remember there is no way to copy a data source, so my users will have to ALL be trained on creating them - which seems a bit odd) to point to a datasource with stored credentials (preferrably their own login and password), and create a schedule.Unfortunately there is not a good solution for this in V1. Integrated
reports can not be scheduled. We are hoping to change this in a future
version.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"asc_rmc" <asc_rmc@.discussions.microsoft.com> wrote in message
news:9FD821AD-F312-473A-B20F-FD639B3D75FA@.microsoft.com...
> I think I must be missing something here...
> I, as the developer, create Report1 and Report2: they use DataSouceA.
> DataSourceA is set to use windows integrated security.
> My on-demade reports run fine. The username (selected from the db, not
from the Globals collection) is used to filter out options on the parameter
screen, so users can only see data in their respective division.
> Now: I want my USERS to be able to schedule reports.
> I am able to schedule reports by taking Report1 and Report2 and either
customizing the data source or pointing it to a new data source: BUT I AM
DOING THAT FOR ALL USERS who are on the system!!! Now, anyone who goes to
run Report1 or Report2 does not need to have any security to access the
database, they are all using my id!
> If I create a LINKED report, you do not seem to have the option of
changing the data source...it is not even on the left menu anymore. '
> So: I am confused. If I have to set up all reports to used a saved data
source (lets just say it is my username and password), what is the sense of
having any security? I must be missing something here.
> What I want is the NT integrated security for on-demand. Then if a user
has the ability to schedule reports, they would need to make a linked copy
of the report, change the data source (and remember there is no way to copy
a data source, so my users will have to ALL be trained on creating them -
which seems a bit odd) to point to a datasource with stored credentials
(preferrably their own login and password), and create a schedule.
>sql

Data Sources

Why do the data sources appear in Report Manager when deploying reports. How can they be hidden from the users?

In the properties window - choose "Hide in list view" - it will not be seen in the list view.
If you want to actually secure them - change the permissions to the data source to not include your end users. Only report publishers need to have access to the datasources.

Tudor

Data Sources

Why do the data sources appear in Report Manager when deploying reports. How can they be hidden from the users?

In the properties window - choose "Hide in list view" - it will not be seen in the list view.
If you want to actually secure them - change the permissions to the data source to not include your end users. Only report publishers need to have access to the datasources.

Tudor

sql

Data Source question

How would be the best way to do this? We are creating reports (the development teams) that run against a Development SQL server (2005). We then send the rdl files to our QA team who then upload the files to their ReportServer (which we do not have access to and this is why we are not deploying the reports). They created their datasource on their ReportServer (using the report manager), but when they go into our reports and try to point to their datasource, they are getting errors.

This is the rdl:

<DataSources>

<DataSource Name="QADataSource">

<DataSourceReference>QADataSource</DataSourceReference>

<rd: DataSourceID>6a2ce78a-db44-4f00-8ec9-6658459ea989</rd: DataSourceID>

</DataSource>

</DataSources>

When I went in and deleted the <rd: DataSourceID> reference, this seemed to work.

Any suggestions?

That is because the dataset is referenced within the current project. If you open the WebBrowser and change the data source pointer to the data source on the report server, it should be fine. The changes to the reference is automatically changed during the VS deployment process.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

So what I should be able to do is to supply a user with an rdl file and then they will set up their datasource on their report manager, upload the rdl file and then they should be able to set their own datasource that they created?

This is the functionality that we want.

|||Let them upload the rdl file you provide from Visual Studio and change them the data source to the actual olne on the server.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

What we do is to create a set number of datasources on the report server that point to the various DB's we use.

E.g

Datasource 1

Datasource 2

Datasource 3

When creating a report, we set up a shared datasource with the same name as the datasource on the report server. This means when we upload the report, it will use the selected datasource and use the connection details that are stored within it. it doesnt matter what connection details we set in the shared data source within visual studio, it will use the details on the report server.

Data source problem. Help! - remote report server

Hi guys,

I have project A with the data source name called 'dsyellow', which is a shared data source. The reports in this project were deployed and working fine.I created a new project(project B) and used the same dataset name (i.e.dsyellow), however this data source points to a different database. Accidentaly when I deploy project B, I overwrote the data source of Project B and I am unable to run the reports in project A. I am getting the following error message. I tried to re-deploy the the first datasource by overwriting the latest data source, however, when I run the report, I am getting the same problem. Please this is urgent. Let me know if you have any idea.

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'dsyellow'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

From Report Manager you can create a second data source that will work for Project B. Then go to the properties page for the report and select the Data Source tab and point it to this new Data source. For the Project A report, also make sure that on the Data Source tab you are pointing to the dsYellow shared data source, then go to the properties tab for the dsYellow shared datasource and make sure that the connection string and user information are what you expect.

I hope this helps.

|||

I think what you said make sense. However, I am having one more issue that prevent me to do that. The issue is that I am not seeing the Data Source folder from the content page of the Report Manager. I think it seems that it is hidden. I hope I will be able to solve the problem if I am able to see the Data Source folder first. Do you have any idea about this?

Appreciate it.

|||

hey! I figured out how to get back the hidden data source folder. I think I can do it now.

Thanks for your help.

|||Items are only hidden in the list view, if you click on the Detail View button, all items are visible. Is this what you found?|||

Yea, that was what I found. But the issue is still there. Here is the thing,I created a new project with some reports in it. My data source is from a remote server. The report is also deployed on the same remote server. I am able to run the report from my development machine. However, the error comes after deploying it on the remote server and try to run it from the report server. I checked that my report is pointing to the right server name and database name. But no luck. Ohhhhhh it makes me crazy.

|||Can you run the report on the actual report server so you can get the full error?|||

I did. This is the error message:

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'dsyellow'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

|||The error is stating that you are not local so therefore it is not showing the full error stack. Can you look in the RS log files to get the actual error?|||Do you know which table shows the errors?|||

Daniel is suggesting to look in the RS log files. They are located here:

{Drive}:\Program Files\Microsoft SQL Server\MSSQL.{Instance_of_RS}\Reporting Services\LogFiles

Jarret

|||

Hey guys,

It may sounds crazy but I am having some previllage issue to access the report server machine to get the log file. Anyhow, let me put the problem this way. I have three servers, assume ServerA,ServerB, and ServerC. ServerA is where the database(datasource) is located. ServerB is used as a report server and Server C is my local machine where I design reports. So obviously I deployed the reports from my local machine(server C) to the remote report server(server B). Deployement was successful but I got the following error when I run the report from the report server. You might think that the report is not pointing to the right data source, I checked that several times and it is pointing to the right data source.

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'dsCallB'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

Going along with Daniel's suggestion earlier, you should open up Internet Explorer from ServerB's desktop (the RS server), and go to http://localhost/ReportServer. Then navigate to your report and see if you get more information about your error.

Another thing to check... Make sure your report's data source is setup correctly by doing this:

Open http://ServerB/Reports and navigate to your report.
Click on the 'Properties' tab, then select 'Data Source' from the left side.
Double check your data source and initial catalog in your connection string.
Then, select 'Credentials stored securely in the report server' in the 'Connect using...' section.
Type in a domain account with sysadmin privileges (for this test) like DOMAIN\USERNAME, with its respective password.
Check the box for 'Use as Windows credentials when connecting to the data source'.
Click 'Apply' at the bottom, and then click the 'View' tab to run the report.

Hope this helps.

Jarret

|||I did that so many times, but no luck.|||

Hmmmm...

Open up Reporting Services Configuration Manager and connect to ServerB. Click 'Database Setup' from the left pane. Make sure that the Server Name, Database Name, Credentials Type, Account Name, and Password are all correct.

Log into ServerB directly and browse to http://localhost/Reports and paste the message you get when you try to run this report. It should give more information about your error.

Do any other reports work from ServerB? If so, can you create another report pointing to the same database as dsCallB, with "select top 1 Name from sys.objects". Deploy it and see if it returns any data.

Jarret

sql

Data source problem. Help!

Hi guys,

I have project A with the data source name called 'dsyellow', which is a shared data source. The reports in this project were deployed and working fine.I created a new project(project B) and used the same dataset name (i.e.dsyellow), however this data source points to a different database. Accidentaly when I deploy project B, I overwrote the data source of Project B and I am unable to run the reports in project A. I am getting the following error message. I tried to re-deploy the the first datasource by overwriting the latest data source, however, when I run the report, I am getting the same problem. Please this is urgent. Let me know if you have any idea.

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'dsyellow'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

From Report Manager you can create a second data source that will work for Project B. Then go to the properties page for the report and select the Data Source tab and point it to this new Data source. For the Project A report, also make sure that on the Data Source tab you are pointing to the dsYellow shared data source, then go to the properties tab for the dsYellow shared datasource and make sure that the connection string and user information are what you expect.

I hope this helps.

|||

I think what you said make sense. However, I am having one more issue that prevent me to do that. The issue is that I am not seeing the Data Source folder from the content page of the Report Manager. I think it seems that it is hidden. I hope I will be able to solve the problem if I am able to see the Data Source folder first. Do you have any idea about this?

Appreciate it.

|||

hey! I figured out how to get back the hidden data source folder. I think I can do it now.

Thanks for your help.

|||Items are only hidden in the list view, if you click on the Detail View button, all items are visible. Is this what you found?|||

Yea, that was what I found. But the issue is still there. Here is the thing,I created a new project with some reports in it. My data source is from a remote server. The report is also deployed on the same remote server. I am able to run the report from my development machine. However, the error comes after deploying it on the remote server and try to run it from the report server. I checked that my report is pointing to the right server name and database name. But no luck. Ohhhhhh it makes me crazy.

|||Can you run the report on the actual report server so you can get the full error?|||

I did. This is the error message:

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'dsyellow'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

|||The error is stating that you are not local so therefore it is not showing the full error stack. Can you look in the RS log files to get the actual error?|||Do you know which table shows the errors?|||

Daniel is suggesting to look in the RS log files. They are located here:

{Drive}:\Program Files\Microsoft SQL Server\MSSQL.{Instance_of_RS}\Reporting Services\LogFiles

Jarret

|||

Hey guys,

It may sounds crazy but I am having some previllage issue to access the report server machine to get the log file. Anyhow, let me put the problem this way. I have three servers, assume ServerA,ServerB, and ServerC. ServerA is where the database(datasource) is located. ServerB is used as a report server and Server C is my local machine where I design reports. So obviously I deployed the reports from my local machine(server C) to the remote report server(server B). Deployement was successful but I got the following error when I run the report from the report server. You might think that the report is not pointing to the right data source, I checked that several times and it is pointing to the right data source.

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'dsCallB'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

Going along with Daniel's suggestion earlier, you should open up Internet Explorer from ServerB's desktop (the RS server), and go to http://localhost/ReportServer. Then navigate to your report and see if you get more information about your error.

Another thing to check... Make sure your report's data source is setup correctly by doing this:

Open http://ServerB/Reports and navigate to your report.
Click on the 'Properties' tab, then select 'Data Source' from the left side.
Double check your data source and initial catalog in your connection string.
Then, select 'Credentials stored securely in the report server' in the 'Connect using...' section.
Type in a domain account with sysadmin privileges (for this test) like DOMAIN\USERNAME, with its respective password.
Check the box for 'Use as Windows credentials when connecting to the data source'.
Click 'Apply' at the bottom, and then click the 'View' tab to run the report.

Hope this helps.

Jarret

|||I did that so many times, but no luck.|||

Hmmmm...

Open up Reporting Services Configuration Manager and connect to ServerB. Click 'Database Setup' from the left pane. Make sure that the Server Name, Database Name, Credentials Type, Account Name, and Password are all correct.

Log into ServerB directly and browse to http://localhost/Reports and paste the message you get when you try to run this report. It should give more information about your error.

Do any other reports work from ServerB? If so, can you create another report pointing to the same database as dsCallB, with "select top 1 Name from sys.objects". Deploy it and see if it returns any data.

Jarret

Data source problem. Help!

Hi guys,

I have project A with the data source name called 'dsyellow', which is a shared data source. The reports in this project were deployed and working fine.I created a new project(project B) and used the same dataset name (i.e.dsyellow), however this data source points to a different database. Accidentaly when I deploy project B, I overwrote the data source of Project B and I am unable to run the reports in project A. I am getting the following error message. I tried to re-deploy the the first datasource by overwriting the latest data source, however, when I run the report, I am getting the same problem. Please this is urgent. Let me know if you have any idea.

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'dsyellow'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

From Report Manager you can create a second data source that will work for Project B. Then go to the properties page for the report and select the Data Source tab and point it to this new Data source. For the Project A report, also make sure that on the Data Source tab you are pointing to the dsYellow shared data source, then go to the properties tab for the dsYellow shared datasource and make sure that the connection string and user information are what you expect.

I hope this helps.

|||

I think what you said make sense. However, I am having one more issue that prevent me to do that. The issue is that I am not seeing the Data Source folder from the content page of the Report Manager. I think it seems that it is hidden. I hope I will be able to solve the problem if I am able to see the Data Source folder first. Do you have any idea about this?

Appreciate it.

|||

hey! I figured out how to get back the hidden data source folder. I think I can do it now.

Thanks for your help.

|||Items are only hidden in the list view, if you click on the Detail View button, all items are visible. Is this what you found?|||

Yea, that was what I found. But the issue is still there. Here is the thing,I created a new project with some reports in it. My data source is from a remote server. The report is also deployed on the same remote server. I am able to run the report from my development machine. However, the error comes after deploying it on the remote server and try to run it from the report server. I checked that my report is pointing to the right server name and database name. But no luck. Ohhhhhh it makes me crazy.

|||Can you run the report on the actual report server so you can get the full error?|||

I did. This is the error message:

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'dsyellow'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

|||The error is stating that you are not local so therefore it is not showing the full error stack. Can you look in the RS log files to get the actual error?|||Do you know which table shows the errors?|||

Daniel is suggesting to look in the RS log files. They are located here:

{Drive}:\Program Files\Microsoft SQL Server\MSSQL.{Instance_of_RS}\Reporting Services\LogFiles

Jarret

|||

Hey guys,

It may sounds crazy but I am having some previllage issue to access the report server machine to get the log file. Anyhow, let me put the problem this way. I have three servers, assume ServerA,ServerB, and ServerC. ServerA is where the database(datasource) is located. ServerB is used as a report server and Server C is my local machine where I design reports. So obviously I deployed the reports from my local machine(server C) to the remote report server(server B). Deployement was successful but I got the following error when I run the report from the report server. You might think that the report is not pointing to the right data source, I checked that several times and it is pointing to the right data source.

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'dsCallB'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

Going along with Daniel's suggestion earlier, you should open up Internet Explorer from ServerB's desktop (the RS server), and go to http://localhost/ReportServer. Then navigate to your report and see if you get more information about your error.

Another thing to check... Make sure your report's data source is setup correctly by doing this:

Open http://ServerB/Reports and navigate to your report.
Click on the 'Properties' tab, then select 'Data Source' from the left side.
Double check your data source and initial catalog in your connection string.
Then, select 'Credentials stored securely in the report server' in the 'Connect using...' section.
Type in a domain account with sysadmin privileges (for this test) like DOMAIN\USERNAME, with its respective password.
Check the box for 'Use as Windows credentials when connecting to the data source'.
Click 'Apply' at the bottom, and then click the 'View' tab to run the report.

Hope this helps.

Jarret

|||I did that so many times, but no luck.|||

Hmmmm...

Open up Reporting Services Configuration Manager and connect to ServerB. Click 'Database Setup' from the left pane. Make sure that the Server Name, Database Name, Credentials Type, Account Name, and Password are all correct.

Log into ServerB directly and browse to http://localhost/Reports and paste the message you get when you try to run this report. It should give more information about your error.

Do any other reports work from ServerB? If so, can you create another report pointing to the same database as dsCallB, with "select top 1 Name from sys.objects". Deploy it and see if it returns any data.

Jarret

Data Source For Report Model Project

When I tried to generate ad-hoc reports with Microsoft reporting services
2005 (april CTP), it generally ask for the tables and views. Is there a way
that I can just put in a stored procedure and use the results as a data
feeder for the report model? Thanks.I don't think this is supported out of the box
You can however create a named query as part of the data source view
"Geek" wrote:
> When I tried to generate ad-hoc reports with Microsoft reporting services
> 2005 (april CTP), it generally ask for the tables and views. Is there a way
> that I can just put in a stored procedure and use the results as a data
> feeder for the report model? Thanks.sql

Data Source file on Reporting Services server question

In the Reporting Services Manager, when the user selects the folder where the
reports reside there is a file that contains the connection string
information along with a user name and password (Data Source).
Is there a way to keep the file from being selected by the user ?
Thanks.There is a setting in the properties of the data source to "Hide in List
View". Unfortunately the users can just click on the "Show Details"
option and see the datasource. Depending on the permissions you gave
them they will only be able to view the information.
I sent an question out some time ago seeing if there was away to remove
the "Show Details" for some users but no one replied.
Mike wrote:
> In the Reporting Services Manager, when the user selects the folder where the
> reports reside there is a file that contains the connection string
> information along with a user name and password (Data Source).
> Is there a way to keep the file from being selected by the user ?
>
> Thanks.|||You can use a datasource in another location. It's a faff because you
have to change it manually for each deployed report affected. Also
everytime you deploy the report it will create the datasources in the
deployment folder if it can, so you have to remove it each time.
Having said that, this would essentially cure your problem.
Chris
Bon733 wrote:
> There is a setting in the properties of the data source to "Hide in
> List View". Unfortunately the users can just click on the "Show
> Details" option and see the datasource. Depending on the permissions
> you gave them they will only be able to view the information.
> I sent an question out some time ago seeing if there was away to
> remove the "Show Details" for some users but no one replied.
> Mike wrote:
> > In the Reporting Services Manager, when the user selects the folder
> > where the reports reside there is a file that contains the
> > connection string information along with a user name and password
> > (Data Source).
> >
> > Is there a way to keep the file from being selected by the user ?
> >
> >
> > Thanks.

Data Retrieval for Reports from Summary table.

Hi,

I have asummary table like this

Field1Field2Field3Field4Field5AAA11value1value2value3value4value5AAB23value6value7value8value9value10BCD14value11value12value13value14value15GFD12value16value17value18value19value20SDL25value21value22value23value24value25AUD56value26value27value28value29value30BER11value31value32value33value34value35

Columns are obviously fixed, but not rows.

I want to show this data using lables and SqlDataReader for report purpose like;

Label1.text=dr("value16").toString()

Label2.text=dr("value28").toString()

Label3.text=dr("value31").toString() etc

Do you have any idea how i can do it or am I approaching it in the wrong way??

Thanks.

Michelle

Hi Michelle,

Are you trying to put the values of the table to a set of Label controls?

If so, you have to use field name as argument, like

Label1.Text = dr("Field1").ToString()

When you need to advance to the next row, you have to call dr.Read(). So the best way is to put this in a loop.

If you want to put the whole table in a gridview, you can use GridView.DataSource = dr directly, and call DataBind(). This will make your GridView bind to the DataReader.

HTH.

Data Reports Vs Crystal Reports

Hi,

What are the Benefits that i'll get when i move to Crystal Reports from VB Data Reports ?

I m using Data Reports Now. Is there any strong Reasons to go for Crystal Reports.

Pls Help .

Suresh ...my personal opinion is that u can use data report to show non complex report..but i think u should give a look at CR coz..from at the first i'm using data report to until i found trouble to design a complex report with it..
and i think it more easy to use CR rather than Data Report..

regards|||Thx Widya,

I'll try to have a look at Crystal rep.. as u said its easy when compared with Data report ..

Suresh .....

Data processing extensions on SQL Server Express Edition?

I developed nice reports using custom data processing extensions. When I deployed the reports on my report server (I am using the express edition of SQL Server 2005) I was surprised to see that my reports were not rendering successfully.

After searching the web, I found this page listing the supported/unsupported features of SQL Server 2005 Express Edition: http://msdn2.microsoft.com/en-us/library/ms365166.aspx

On this page it clearly says “The Reporting Services API extensible platform for delivery, data processing, rendering, and security is not supported.”

Is there a way to get my reports to work on the express edition?

If not, which minimal version of SQL Server should a buy to get it to work (workgroup, standard or enterprise)?

Thanks for your help.

You will need Standard or Enterprise edition:

http://msdn2.microsoft.com/en-us/library/ms143761.aspx

data processing extension sample

I'm trying to write some code to retrieve a reports list from a report folder.
Is it possible to create data processing extension in old asp? Either yes
or no, could someone post a link to some sample code, aspx samples would be
just fine?I forgot to mention that I only know VB. So please provide the samples in
VB. Thx a mil!
"JL" wrote:
> I'm trying to write some code to retrieve a reports list from a report folder.
> Is it possible to create data processing extension in old asp? Either yes
> or no, could someone post a link to some sample code, aspx samples would be
> just fine?|||http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
try this one. the best i have found.
[]s
Renato
"JL" <JL@.discussions.microsoft.com> escreveu na mensagem
news:1E1F4C39-7C3E-4263-B883-D2865507C968@.microsoft.com...
> I forgot to mention that I only know VB. So please provide the samples in
> VB. Thx a mil!
> "JL" wrote:
> > I'm trying to write some code to retrieve a reports list from a report
folder.
> >
> > Is it possible to create data processing extension in old asp? Either
yes
> > or no, could someone post a link to some sample code, aspx samples would
be
> > just fine?|||Thx a lot. But I only want to retrieve the reports list from a report
folder. Do I need to use the same extension? Or is there an alternative
(easier) way? Thx.
"Renato Aloi" wrote:
> http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
> try this one. the best i have found.
> []s
> Renato
> "JL" <JL@.discussions.microsoft.com> escreveu na mensagem
> news:1E1F4C39-7C3E-4263-B883-D2865507C968@.microsoft.com...
> > I forgot to mention that I only know VB. So please provide the samples in
> > VB. Thx a mil!
> >
> > "JL" wrote:
> >
> > > I'm trying to write some code to retrieve a reports list from a report
> folder.
> > >
> > > Is it possible to create data processing extension in old asp? Either
> yes
> > > or no, could someone post a link to some sample code, aspx samples would
> be
> > > just fine?
>
>|||I saw a sample that demonstrate this... But I don't remmember where... What
I remmember is that you can write some code to do that, using ListChildren
method of Reporting Service Web Server, like this:
dim items() as CatalogItem
items = (new ReportingService).ListChildren("/", True)
then populate a list:
for each item as CatalogItem in items
cboWhatever.Items.Add(new ReportItem(item.name, item.Path))
next
That is it. Do not forget to reference the RS web service...
[]s
Renato
"JL" <JL@.discussions.microsoft.com> escreveu na mensagem
news:F408C4D6-DB48-40F1-A6A5-22BE8E958114@.microsoft.com...
> Thx a lot. But I only want to retrieve the reports list from a report
> folder. Do I need to use the same extension? Or is there an alternative
> (easier) way? Thx.
> "Renato Aloi" wrote:
> >
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
> >
> > try this one. the best i have found.
> >
> > []s
> > Renato
> >
> > "JL" <JL@.discussions.microsoft.com> escreveu na mensagem
> > news:1E1F4C39-7C3E-4263-B883-D2865507C968@.microsoft.com...
> > > I forgot to mention that I only know VB. So please provide the
samples in
> > > VB. Thx a mil!
> > >
> > > "JL" wrote:
> > >
> > > > I'm trying to write some code to retrieve a reports list from a
report
> > folder.
> > > >
> > > > Is it possible to create data processing extension in old asp?
Either
> > yes
> > > > or no, could someone post a link to some sample code, aspx samples
would
> > be
> > > > just fine?
> >
> >
> >

Data missing

Hey I'm really really new to crystal reports and I'm working on setting up a new paramater field and I'm running into some issues. The table for some reason is not showing all the data it should meaning its missing some records. When I go into SQL manager the data all seems to be there and in order but when I pull the same data into crystal part is missing. I looked at the way I had the tables linked to see if that would have something to do with the data is coming up but from the best I can tell everything looks fine. Has anyone noticed similar issues with a report if so what steps did you take to hunt down the problem?Did you use any Selection Formulas?
If so remove them
Also Do Verify Database

data in the header

It is my understanding that data items can not exist in a header (or
footer). Yet in multi page reports it is often a requirement to reprint a
heading that has data in it. What is the best way to address this issue?
Thanks,
Garycreate read-only parameter with default value from query and then to use
this parameter in the page header textbox.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary D." <Dean@.nospam.com> wrote in message
news:%23F1%233OVhEHA.1768@.TK2MSFTNGP10.phx.gbl...
> It is my understanding that data items can not exist in a header (or
> footer). Yet in multi page reports it is often a requirement to reprint a
> heading that has data in it. What is the best way to address this issue?
> Thanks,
> Gary
>|||Lev:
Sorry, but I've looked through the docs (no search capability) and I just
can't figure out what you mean. could you pleas elaborate on what a
read-only parameter is? I have never worked with reporting software before
where putting data in the heading was problem.
Thanks,
Gary
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:uvsl$ZVhEHA.2784@.TK2MSFTNGP09.phx.gbl...
> create read-only parameter with default value from query and then to use
> this parameter in the page header textbox.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Gary D." <Dean@.nospam.com> wrote in message
> news:%23F1%233OVhEHA.1768@.TK2MSFTNGP10.phx.gbl...
> > It is my understanding that data items can not exist in a header (or
> > footer). Yet in multi page reports it is often a requirement to reprint
a
> > heading that has data in it. What is the best way to address this
issue?
> > Thanks,
> > Gary
> >
> >
>|||Here is some info about adding parameters :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_38du.asp
You need to create a parameter with no prompt (If the prompt is left blank,
and a default parameter value is specified, the default value is used, and
the input box for the parameter is not displayed when the user runs the
report), set default value to "From query" and select dataset and field for
default value.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary D." <Dean@.nospam.com> wrote in message
news:O8oRF2ghEHA.2620@.TK2MSFTNGP10.phx.gbl...
> Lev:
> Sorry, but I've looked through the docs (no search capability) and I just
> can't figure out what you mean. could you pleas elaborate on what a
> read-only parameter is? I have never worked with reporting software
> before
> where putting data in the heading was problem.
> Thanks,
> Gary
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> news:uvsl$ZVhEHA.2784@.TK2MSFTNGP09.phx.gbl...
>> create read-only parameter with default value from query and then to use
>> this parameter in the page header textbox.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Gary D." <Dean@.nospam.com> wrote in message
>> news:%23F1%233OVhEHA.1768@.TK2MSFTNGP10.phx.gbl...
>> > It is my understanding that data items can not exist in a header (or
>> > footer). Yet in multi page reports it is often a requirement to
>> > reprint
> a
>> > heading that has data in it. What is the best way to address this
> issue?
>> > Thanks,
>> > Gary
>> >
>> >
>>
>|||It works great, but you must add the RS parameter in the stored procedure.
Without this, you'll have an error.
"Lev Semenets [MSFT]" wrote:
> Here is some info about adding parameters :
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_38du.asp
> You need to create a parameter with no prompt (If the prompt is left blank,
> and a default parameter value is specified, the default value is used, and
> the input box for the parameter is not displayed when the user runs the
> report), set default value to "From query" and select dataset and field for
> default value.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Gary D." <Dean@.nospam.com> wrote in message
> news:O8oRF2ghEHA.2620@.TK2MSFTNGP10.phx.gbl...
> > Lev:
> > Sorry, but I've looked through the docs (no search capability) and I just
> > can't figure out what you mean. could you pleas elaborate on what a
> > read-only parameter is? I have never worked with reporting software
> > before
> > where putting data in the heading was problem.
> > Thanks,
> > Gary
> >
> > "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> > news:uvsl$ZVhEHA.2784@.TK2MSFTNGP09.phx.gbl...
> >> create read-only parameter with default value from query and then to use
> >> this parameter in the page header textbox.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >> "Gary D." <Dean@.nospam.com> wrote in message
> >> news:%23F1%233OVhEHA.1768@.TK2MSFTNGP10.phx.gbl...
> >> > It is my understanding that data items can not exist in a header (or
> >> > footer). Yet in multi page reports it is often a requirement to
> >> > reprint
> > a
> >> > heading that has data in it. What is the best way to address this
> > issue?
> >> > Thanks,
> >> > Gary
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Data in dataset, no data in CR?

Hi,
I am using VS.net 2003 with emb. Crystal reports.

I retrieve data from a database using VB.net and populate a dataset. The records in the dataset are OK, but no data is shown in the report. How come? I use the following code:

I created a schema, called DSUrenPerProject.xsd. In the IDE I put 6 tables from a SQLserver-database on it.

Then I created the Crystal report and put some field from different tables on the report.

================ Then I created the next class============

Imports System.Data
Imports System.Data.OleDb
Public Class DataSetConfiguration

Public Shared ReadOnly Property CustomerDataSet() As DataSet
Get
Dim myDataSet As DSUrenPerProject = New DSUrenPerProject
Dim myOleDBConnection As SqlClient.SqlConnection = New SqlClient.SqlConnection(DB4D)
Dim myOleDbDataAdapter As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter(mSQL, myOleDBConnection)

Try
myOleDbDataAdapter.Fill(myDataSet, "Uren")
Catch ee As Exception
MsgBox(ee.Message)
End Try
Return myDataSet
End Get
End Property
End Class
===========Then I created the next procedure in another form=====
Private Sub btnPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPrint.Click
Dim m_Year As Integer
Dim m_Month As Integer
Dim m_Day As Integer
m_Year = DatePart(DateInterval.Year, Date.Parse(DTDatum.Text))
m_Month = DatePart(DateInterval.Month, Date.Parse(DTDatum.Text))
m_Day = DatePart(DateInterval.Day, Date.Parse(DTDatum.Text))

Dim m_Str As String
Dim m_Positie As Integer
m_Positie = InStr(cmbProjecten.Text, "-")
m_Str = Mid(cmbProjecten.Text, 1, m_Positie - 1)
Call init_Pr_PrNr(m_Str)
m_ProjectID = CInt(ds.Tables("Projecten").Rows(0).Item("ProjectID"))
Call Close_init()
If RBDag.Checked = True Then
m_Projectnr = Trim(m_Str)
m_Datum = CDate(Format(Date.Parse(DTDatum.Text), "dd/MM/yyyy"))
'Tbv 4DUren
mSQL = "SELECT Medewerkers.Voornaam as MedNaam, Medewerkers.Achternaam, Opdrachtgevers.Naam as OGNaam, "
mSQL = mSQL & "Contactpersonen.Achternaam as CPNaam, Projecten.Projectnummer, Projecten.Projectomschrijving, "
mSQL = mSQL & "CONVERT(char(10),Urenverantwoording.Datum, 120), Urenverantwoording.Uren100, Urenverantwoording.Uren150, "
mSQL = mSQL & "Urenverantwoording.Ziek, Urenverantwoording.Verlof, Urenverantwoording.Diverse "
mSQL = mSQL & "from Medewerkers, Opdrachtgevers, Contactpersonen, Urenverantwoording, Projecten "
mSQL = mSQL & "WHERE Urenverantwoording.ProjID= " & m_ProjectID & " AND DATEPART(YEAR, Urenverantwoording.Datum) =" & m_Year & " AND DATEPART(MONTH, Urenverantwoording.Datum) = " & m_Month & " AND DATEPART(DAY, Urenverantwoording.Datum) = " & m_Day
mSQL = mSQL & " AND Urenverantwoording.MedID = Medewerkers.MedewerkerID "
mSQL = mSQL & "AND Urenverantwoording.OGID = Opdrachtgevers.OpdrachtgeverID "
mSQL = mSQL & "AND Urenverantwoording.CPID = Contactpersonen.ContactpersoonID "
mSQL = mSQL & "AND Urenverantwoording.ProjID = Projecten.ProjectID "
mSQL = mSQL & "ORDER BY Urenverantwoording.Datum"

End If
frmPrint.ShowDialog()
End Sub
=================at the end I created the next class=========

Imports System.Data
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared

Public Class frmPrintForm
Inherits System.Windows.Forms.Form
Private customerReport As ReportDocument
Dim myDataSet As DataSet

#Region " Windows Form Designer generated code "

Public Sub New()
MyBase.New()

'This call is required by the Windows Form Designer.
InitializeComponent()
'ConfigureCrystalReports()

'Add any initialization after the InitializeComponent() call

End Sub

'Form overrides dispose to clean up the component list.
Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If
MyBase.Dispose(disposing)
End Sub

'Required by the Windows Form Designer
Private components As System.ComponentModel.IContainer

'NOTE: The following procedure is required by the Windows Form Designer
'It can be modified using the Windows Form Designer.
'Do not modify it using the code editor.
Friend WithEvents myCrystalReportViewer As CrystalDecisions.Windows.Forms.CrystalReportViewer
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Me.myCrystalReportViewer = New CrystalDecisions.Windows.Forms.CrystalReportViewer
Me.SuspendLayout()
'
'myCrystalReportViewer
'
Me.myCrystalReportViewer.ActiveViewIndex = -1
Me.myCrystalReportViewer.Dock = System.Windows.Forms.DockStyle.Fill
Me.myCrystalReportViewer.Location = New System.Drawing.Point(0, 0)
Me.myCrystalReportViewer.Name = "myCrystalReportViewer"
Me.myCrystalReportViewer.ReportSource = Nothing
Me.myCrystalReportViewer.Size = New System.Drawing.Size(560, 421)
Me.myCrystalReportViewer.TabIndex = 0
'
'frmPrintForm
'
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
Me.ClientSize = New System.Drawing.Size(560, 421)
Me.Controls.Add(Me.myCrystalReportViewer)
Me.Name = "frmPrintForm"
Me.Text = "Printen van..."
Me.WindowState = System.Windows.Forms.FormWindowState.Maximized
Me.ResumeLayout(False)

End Sub

#End Region
Private Sub ConfigureCrystalReports()
customerReport = New ReportDocument
Dim reportPath As String = ""
'reportPath = Application.StartupPath.Substring(0, Len(Application.StartupPath) - 3) & "Test.rpt"

reportPath = Application.StartupPath.Substring(0, Len(Application.StartupPath) - 3) & "CR_UrenPerProject.rpt"
customerReport.Load(reportPath)
Dim myDataSet As DataSet = DataSetConfiguration.CustomerDataSet
customerReport.SetDataSource(myDataSet)
myCrystalReportViewer.ReportSource = customerReport

End Sub

Private Sub frmPrintForm_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
ConfigureCrystalReports()
End Sub
End Class
=============================================

Thank you for your patience. Can someone help me ?

regards, Ger.Open the report and do very database

Data flow task reports different row count than actual rowcount

I have a data flow task that moves all the rows from 18 tables on a production server to a reporting services server. One table, which does not contain the most rows (about 650K rows) reports all the rows have been transferred. However, if I go in to the SQL Mgmt Studio and do a Select count(*) on the table, there are only 110k rows.

Has anyone else experienced this problem?

Thanks,

Nick Anzano

How does the data flow report that 650k rows have been transferred? Are you looking in the logs?

SSIS could certainly report that it has sent 650k to the database - what happens then is up to the database! Is the target database SQL Server? If so, use SQL Profiler to see what is happening when the rows are being sent to the server. Perhaps they are not being committed for some reason.

Donald Farmer