Hi all, I just havea general question I hope you guys could answer.
What is the best way to both backup my Report Development (i.e. visual
studio report project) and also my deployment on the Report Server?
Thanks for any advice.
Kind regards
TazBackup Report Project:
Do file backup (NTBackup Utility) of the folder containing both project
(rptproj), solution (sln), data source (rds) and report definition (rdl)
files.
Or use Visual Source Safe or similar products to have a centralized code
base, and backup that according to best practices for that product.
Backup Report Server:
Do file backup on the config files for Report Manager and Report Server
Do backup of IIS metadata for the virtual directories
Extract the encryption key and save this, using RSKeyMgmt.exe
These two only needs to be done when making changes to the Report Server,
which shouldn't be too often.
Then do SQL backup of the ReportServer database once a day.
Kaisa M. Lindahl Lervik
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:OpTQd092GHA.4924@.TK2MSFTNGP05.phx.gbl...
> Hi all, I just havea general question I hope you guys could answer.
> What is the best way to both backup my Report Development (i.e. visual
> studio report project) and also my deployment on the Report Server?
> Thanks for any advice.
> Kind regards
> Taz
>|||Fantastic,
excellent post.
Taz
"Kaisa M. Lindahl Lervik" <kaisaml@.hotmail.com> wrote in message
news:%23KpG4f%232GHA.476@.TK2MSFTNGP06.phx.gbl...
> Backup Report Project:
> Do file backup (NTBackup Utility) of the folder containing both project
> (rptproj), solution (sln), data source (rds) and report definition (rdl)
> files.
> Or use Visual Source Safe or similar products to have a centralized code
> base, and backup that according to best practices for that product.
> Backup Report Server:
> Do file backup on the config files for Report Manager and Report Server
> Do backup of IIS metadata for the virtual directories
> Extract the encryption key and save this, using RSKeyMgmt.exe
> These two only needs to be done when making changes to the Report Server,
> which shouldn't be too often.
> Then do SQL backup of the ReportServer database once a day.
> Kaisa M. Lindahl Lervik
>
> "Tarun Mistry" <nospam@.nospam.com> wrote in message
> news:OpTQd092GHA.4924@.TK2MSFTNGP05.phx.gbl...
>> Hi all, I just havea general question I hope you guys could answer.
>> What is the best way to both backup my Report Development (i.e. visual
>> studio report project) and also my deployment on the Report Server?
>> Thanks for any advice.
>> Kind regards
>> Taz
>
Showing posts with label report. Show all posts
Showing posts with label report. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
Copying tables based on information
I have a report generated in Crystal 10 that is exported to the SQL server
into its own DB. I finally go the report filtered out enough to where it put
s
each person with their designated type (i.e. Store location). My question
isthis: is it possible to have a query of some sort to look at the employee
type and copy all corresponding people in subsequesnt tables that are
associated with that type to another Table that actually corresponds with
their actual store? The 4 Fields that are generated by Crystal
are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it is
possible to analyse the Employee_Type column, then any thing that is
corresponding with says DA and has coresponding information in the tables
across from it and then copy the information from those columns to the
correspoding columns in another table?"Chris Chandler" <see@.top.com> wrote in message
news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>I have a report generated in Crystal 10 that is exported to the SQL server
> into its own DB. I finally go the report filtered out enough to where it
> puts
> each person with their designated type (i.e. Store location). My question
> isthis: is it possible to have a query of some sort to look at the
> employee
> type and copy all corresponding people in subsequesnt tables that are
> associated with that type to another Table that actually corresponds with
> their actual store? The 4 Fields that are generated by Crystal
> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it
> is
> possible to analyse the Employee_Type column, then any thing that is
> corresponding with says DA and has coresponding information in the tables
> across from it and then copy the information from those columns to the
> correspoding columns in another table?
It is probably possible, but it would be much easier to help you if you
could post the DDL and some INSERTS with sample data.
What does the Crystal table look like when it is finished? Give us the
CREATE TABLE statement and some sample INSERTs.
What do your other tables look like that you would like to pull the data
from based on the crystal table's TYPE column.
What do you want your final output to look like or your final table? Give
us the CREATE TABLE statement for that as well and we should be able to help
you out.
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Hm I would gladyl do so but I am so new to SQL and all that I am not sure
where or how to get that exact info. When I go to export it, I just use the
Export Wizard|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Also, what happens is when Crystal generates the report, it has 1 table
with 4 fields as stated above. These fields have about 1400 records per
field. They are sorted by Employee Type (ie the store they work at). Again
this is all stored by type in one field. To a point this is fine, but is
there a way to either get Crystal to create 11 tables out of the one big
report or do I need some sort of code or query to break this down when it
is exported?
I am real real new to this so have patience with me. I am looking thru al
teh help files and even going thru the SBS SQL Server 2000 programming book
from Microsoft.
into its own DB. I finally go the report filtered out enough to where it put
s
each person with their designated type (i.e. Store location). My question
isthis: is it possible to have a query of some sort to look at the employee
type and copy all corresponding people in subsequesnt tables that are
associated with that type to another Table that actually corresponds with
their actual store? The 4 Fields that are generated by Crystal
are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it is
possible to analyse the Employee_Type column, then any thing that is
corresponding with says DA and has coresponding information in the tables
across from it and then copy the information from those columns to the
correspoding columns in another table?"Chris Chandler" <see@.top.com> wrote in message
news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>I have a report generated in Crystal 10 that is exported to the SQL server
> into its own DB. I finally go the report filtered out enough to where it
> puts
> each person with their designated type (i.e. Store location). My question
> isthis: is it possible to have a query of some sort to look at the
> employee
> type and copy all corresponding people in subsequesnt tables that are
> associated with that type to another Table that actually corresponds with
> their actual store? The 4 Fields that are generated by Crystal
> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it
> is
> possible to analyse the Employee_Type column, then any thing that is
> corresponding with says DA and has coresponding information in the tables
> across from it and then copy the information from those columns to the
> correspoding columns in another table?
It is probably possible, but it would be much easier to help you if you
could post the DDL and some INSERTS with sample data.
What does the Crystal table look like when it is finished? Give us the
CREATE TABLE statement and some sample INSERTs.
What do your other tables look like that you would like to pull the data
from based on the crystal table's TYPE column.
What do you want your final output to look like or your final table? Give
us the CREATE TABLE statement for that as well and we should be able to help
you out.
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Hm I would gladyl do so but I am so new to SQL and all that I am not sure
where or how to get that exact info. When I go to export it, I just use the
Export Wizard|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Also, what happens is when Crystal generates the report, it has 1 table
with 4 fields as stated above. These fields have about 1400 records per
field. They are sorted by Employee Type (ie the store they work at). Again
this is all stored by type in one field. To a point this is fine, but is
there a way to either get Crystal to create 11 tables out of the one big
report or do I need some sort of code or query to break this down when it
is exported?
I am real real new to this so have patience with me. I am looking thru al
teh help files and even going thru the SBS SQL Server 2000 programming book
from Microsoft.
Copying tables based on information
I have a report generated in Crystal 10 that is exported to the SQL server
into its own DB. I finally go the report filtered out enough to where it puts
each person with their designated type (i.e. Store location). My question
isthis: is it possible to have a query of some sort to look at the employee
type and copy all corresponding people in subsequesnt tables that are
associated with that type to another Table that actually corresponds with
their actual store? The 4 Fields that are generated by Crystal
are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it is
possible to analyse the Employee_Type column, then any thing that is
corresponding with says DA and has coresponding information in the tables
across from it and then copy the information from those columns to the
correspoding columns in another table?"Chris Chandler" <see@.top.com> wrote in message
news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>I have a report generated in Crystal 10 that is exported to the SQL server
> into its own DB. I finally go the report filtered out enough to where it
> puts
> each person with their designated type (i.e. Store location). My question
> isthis: is it possible to have a query of some sort to look at the
> employee
> type and copy all corresponding people in subsequesnt tables that are
> associated with that type to another Table that actually corresponds with
> their actual store? The 4 Fields that are generated by Crystal
> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it
> is
> possible to analyse the Employee_Type column, then any thing that is
> corresponding with says DA and has coresponding information in the tables
> across from it and then copy the information from those columns to the
> correspoding columns in another table?
It is probably possible, but it would be much easier to help you if you
could post the DDL and some INSERTS with sample data.
What does the Crystal table look like when it is finished? Give us the
CREATE TABLE statement and some sample INSERTs.
What do your other tables look like that you would like to pull the data
from based on the crystal table's TYPE column.
What do you want your final output to look like or your final table? Give
us the CREATE TABLE statement for that as well and we should be able to help
you out.
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>>I have a report generated in Crystal 10 that is exported to the SQL
>>server
>> into its own DB. I finally go the report filtered out enough to where
>> it puts
>> each person with their designated type (i.e. Store location). My
>> question isthis: is it possible to have a query of some sort to look at
>> the employee
>> type and copy all corresponding people in subsequesnt tables that are
>> associated with that type to another Table that actually corresponds
>> with their actual store? The 4 Fields that are generated by Crystal
>> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
>> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if
>> it is
>> possible to analyse the Employee_Type column, then any thing that is
>> corresponding with says DA and has coresponding information in the
>> tables across from it and then copy the information from those columns
>> to the correspoding columns in another table?
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Hm I would gladyl do so but I am so new to SQL and all that I am not sure
where or how to get that exact info. When I go to export it, I just use the
Export Wizard|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>>I have a report generated in Crystal 10 that is exported to the SQL
>>server
>> into its own DB. I finally go the report filtered out enough to where
>> it puts
>> each person with their designated type (i.e. Store location). My
>> question isthis: is it possible to have a query of some sort to look at
>> the employee
>> type and copy all corresponding people in subsequesnt tables that are
>> associated with that type to another Table that actually corresponds
>> with their actual store? The 4 Fields that are generated by Crystal
>> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
>> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if
>> it is
>> possible to analyse the Employee_Type column, then any thing that is
>> corresponding with says DA and has coresponding information in the
>> tables across from it and then copy the information from those columns
>> to the correspoding columns in another table?
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Also, what happens is when Crystal generates the report, it has 1 table
with 4 fields as stated above. These fields have about 1400 records per
field. They are sorted by Employee Type (ie the store they work at). Again
this is all stored by type in one field. To a point this is fine, but is
there a way to either get Crystal to create 11 tables out of the one big
report or do I need some sort of code or query to break this down when it
is exported?
I am real real new to this so have patience with me. I am looking thru al
teh help files and even going thru the SBS SQL Server 2000 Programming book
from Microsoft.
into its own DB. I finally go the report filtered out enough to where it puts
each person with their designated type (i.e. Store location). My question
isthis: is it possible to have a query of some sort to look at the employee
type and copy all corresponding people in subsequesnt tables that are
associated with that type to another Table that actually corresponds with
their actual store? The 4 Fields that are generated by Crystal
are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it is
possible to analyse the Employee_Type column, then any thing that is
corresponding with says DA and has coresponding information in the tables
across from it and then copy the information from those columns to the
correspoding columns in another table?"Chris Chandler" <see@.top.com> wrote in message
news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>I have a report generated in Crystal 10 that is exported to the SQL server
> into its own DB. I finally go the report filtered out enough to where it
> puts
> each person with their designated type (i.e. Store location). My question
> isthis: is it possible to have a query of some sort to look at the
> employee
> type and copy all corresponding people in subsequesnt tables that are
> associated with that type to another Table that actually corresponds with
> their actual store? The 4 Fields that are generated by Crystal
> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it
> is
> possible to analyse the Employee_Type column, then any thing that is
> corresponding with says DA and has coresponding information in the tables
> across from it and then copy the information from those columns to the
> correspoding columns in another table?
It is probably possible, but it would be much easier to help you if you
could post the DDL and some INSERTS with sample data.
What does the Crystal table look like when it is finished? Give us the
CREATE TABLE statement and some sample INSERTs.
What do your other tables look like that you would like to pull the data
from based on the crystal table's TYPE column.
What do you want your final output to look like or your final table? Give
us the CREATE TABLE statement for that as well and we should be able to help
you out.
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>>I have a report generated in Crystal 10 that is exported to the SQL
>>server
>> into its own DB. I finally go the report filtered out enough to where
>> it puts
>> each person with their designated type (i.e. Store location). My
>> question isthis: is it possible to have a query of some sort to look at
>> the employee
>> type and copy all corresponding people in subsequesnt tables that are
>> associated with that type to another Table that actually corresponds
>> with their actual store? The 4 Fields that are generated by Crystal
>> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
>> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if
>> it is
>> possible to analyse the Employee_Type column, then any thing that is
>> corresponding with says DA and has coresponding information in the
>> tables across from it and then copy the information from those columns
>> to the correspoding columns in another table?
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Hm I would gladyl do so but I am so new to SQL and all that I am not sure
where or how to get that exact info. When I go to export it, I just use the
Export Wizard|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>>I have a report generated in Crystal 10 that is exported to the SQL
>>server
>> into its own DB. I finally go the report filtered out enough to where
>> it puts
>> each person with their designated type (i.e. Store location). My
>> question isthis: is it possible to have a query of some sort to look at
>> the employee
>> type and copy all corresponding people in subsequesnt tables that are
>> associated with that type to another Table that actually corresponds
>> with their actual store? The 4 Fields that are generated by Crystal
>> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
>> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if
>> it is
>> possible to analyse the Employee_Type column, then any thing that is
>> corresponding with says DA and has coresponding information in the
>> tables across from it and then copy the information from those columns
>> to the correspoding columns in another table?
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Also, what happens is when Crystal generates the report, it has 1 table
with 4 fields as stated above. These fields have about 1400 records per
field. They are sorted by Employee Type (ie the store they work at). Again
this is all stored by type in one field. To a point this is fine, but is
there a way to either get Crystal to create 11 tables out of the one big
report or do I need some sort of code or query to break this down when it
is exported?
I am real real new to this so have patience with me. I am looking thru al
teh help files and even going thru the SBS SQL Server 2000 Programming book
from Microsoft.
Copying tables based on information
I have a report generated in Crystal 10 that is exported to the SQL server
into its own DB. I finally go the report filtered out enough to where it puts
each person with their designated type (i.e. Store location). My question
isthis: is it possible to have a query of some sort to look at the employee
type and copy all corresponding people in subsequesnt tables that are
associated with that type to another Table that actually corresponds with
their actual store? The 4 Fields that are generated by Crystal
are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it is
possible to analyse the Employee_Type column, then any thing that is
corresponding with says DA and has coresponding information in the tables
across from it and then copy the information from those columns to the
correspoding columns in another table?
"Chris Chandler" <see@.top.com> wrote in message
news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>I have a report generated in Crystal 10 that is exported to the SQL server
> into its own DB. I finally go the report filtered out enough to where it
> puts
> each person with their designated type (i.e. Store location). My question
> isthis: is it possible to have a query of some sort to look at the
> employee
> type and copy all corresponding people in subsequesnt tables that are
> associated with that type to another Table that actually corresponds with
> their actual store? The 4 Fields that are generated by Crystal
> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it
> is
> possible to analyse the Employee_Type column, then any thing that is
> corresponding with says DA and has coresponding information in the tables
> across from it and then copy the information from those columns to the
> correspoding columns in another table?
It is probably possible, but it would be much easier to help you if you
could post the DDL and some INSERTS with sample data.
What does the Crystal table look like when it is finished? Give us the
CREATE TABLE statement and some sample INSERTs.
What do your other tables look like that you would like to pull the data
from based on the crystal table's TYPE column.
What do you want your final output to look like or your final table? Give
us the CREATE TABLE statement for that as well and we should be able to help
you out.
Rick Sawtell
MCT, MCSD, MCDBA
|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Hm I would gladyl do so but I am so new to SQL and all that I am not sure
where or how to get that exact info. When I go to export it, I just use the
Export Wizard
|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Also, what happens is when Crystal generates the report, it has 1 table
with 4 fields as stated above. These fields have about 1400 records per
field. They are sorted by Employee Type (ie the store they work at). Again
this is all stored by type in one field. To a point this is fine, but is
there a way to either get Crystal to create 11 tables out of the one big
report or do I need some sort of code or query to break this down when it
is exported?
I am real real new to this so have patience with me. I am looking thru al
teh help files and even going thru the SBS SQL Server 2000 Programming book
from Microsoft.
sql
into its own DB. I finally go the report filtered out enough to where it puts
each person with their designated type (i.e. Store location). My question
isthis: is it possible to have a query of some sort to look at the employee
type and copy all corresponding people in subsequesnt tables that are
associated with that type to another Table that actually corresponds with
their actual store? The 4 Fields that are generated by Crystal
are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it is
possible to analyse the Employee_Type column, then any thing that is
corresponding with says DA and has coresponding information in the tables
across from it and then copy the information from those columns to the
correspoding columns in another table?
"Chris Chandler" <see@.top.com> wrote in message
news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>I have a report generated in Crystal 10 that is exported to the SQL server
> into its own DB. I finally go the report filtered out enough to where it
> puts
> each person with their designated type (i.e. Store location). My question
> isthis: is it possible to have a query of some sort to look at the
> employee
> type and copy all corresponding people in subsequesnt tables that are
> associated with that type to another Table that actually corresponds with
> their actual store? The 4 Fields that are generated by Crystal
> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it
> is
> possible to analyse the Employee_Type column, then any thing that is
> corresponding with says DA and has coresponding information in the tables
> across from it and then copy the information from those columns to the
> correspoding columns in another table?
It is probably possible, but it would be much easier to help you if you
could post the DDL and some INSERTS with sample data.
What does the Crystal table look like when it is finished? Give us the
CREATE TABLE statement and some sample INSERTs.
What do your other tables look like that you would like to pull the data
from based on the crystal table's TYPE column.
What do you want your final output to look like or your final table? Give
us the CREATE TABLE statement for that as well and we should be able to help
you out.
Rick Sawtell
MCT, MCSD, MCDBA
|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Hm I would gladyl do so but I am so new to SQL and all that I am not sure
where or how to get that exact info. When I go to export it, I just use the
Export Wizard
|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Also, what happens is when Crystal generates the report, it has 1 table
with 4 fields as stated above. These fields have about 1400 records per
field. They are sorted by Employee Type (ie the store they work at). Again
this is all stored by type in one field. To a point this is fine, but is
there a way to either get Crystal to create 11 tables out of the one big
report or do I need some sort of code or query to break this down when it
is exported?
I am real real new to this so have patience with me. I am looking thru al
teh help files and even going thru the SBS SQL Server 2000 Programming book
from Microsoft.
sql
Thursday, March 22, 2012
Copying subreports
I have a subreport inside of a report that I want to copy and paste in another part of the report (two identical subreports in the same report).
What is the easiest way to accomplish this?
Thanks,
MichaelSave the subreport as a report in its own right.
What is the easiest way to accomplish this?
Thanks,
MichaelSave the subreport as a report in its own right.
Tuesday, March 20, 2012
Copying Reports in Report Manager
Is it possible to create a copy of a report in the report manager?
I want to be able to deploy one copy of the report and have users create
multliple copies - each with their own default parameter and name.You can use the Web Service CreateReport method.
Check out this link http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/RSPROG=
/htm/rsp_ref_soapapi_service_ak_1xfd.asp
You will have to manipulate the rdl file from code.
>--Original Message--
>Is it possible to create a copy of a report in the report
manager?
>I want to be able to deploy one copy of the report and
have users create >multliple copies - each with their own default parameter
and name.
>.
>sql
I want to be able to deploy one copy of the report and have users create
multliple copies - each with their own default parameter and name.You can use the Web Service CreateReport method.
Check out this link http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/RSPROG=
/htm/rsp_ref_soapapi_service_ak_1xfd.asp
You will have to manipulate the rdl file from code.
>--Original Message--
>Is it possible to create a copy of a report in the report
manager?
>I want to be able to deploy one copy of the report and
have users create >multliple copies - each with their own default parameter
and name.
>.
>sql
Wednesday, March 7, 2012
copying a subscription
I need to create 3 very similar data-driven subscriptions, with minor changes
in report parameters, and differences in the 3 schedules.
I there a way I can "copy-paste" one subscription into another? Is there a
subscription description language kind of like RDL that I could duplicate?
Any suggestions?
tia.Hi,
From your descriptions, I understood that you would like to use one
subscrition as 'model' and then 'paste' them for other two. Have I
understood you? Correct me if I was wrong.
Based on my scope, unfortuantely, I am afraid you will have to setup the
subscription separately.
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Your answer was all I needed, thanks.
I thought clicking "Was this post helpful to you?" was enough to let you know.
""Michael Cheng [MSFT]"" wrote:
> Hi,
> I wanted to post a quick note to see if you would like additional
> assistance or information regarding this particular issue. We appreciate
> your patience and look forward to hearing from you!
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi,
Thanks for your prompt updates!
Unfortuantely, the result of clicking "Was this post helpful to you?" was
not submitted to me, it was used for another use:(, might be for feedback
collection.
Anyway, it is highly appreciated for your kindest reply letting me know
this, thanks once more. Whenever you have any questions or concerns, don't
hesitate to let me know. We are always here to be of assistance!
Have a good day!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||The easiest way would be to use the SOAP methods. You could call
GetDataDrivenSubscriptionProperties and then call
CreateDataDrivenSubscription with the result. You would have to reenter
data source credentials as these are not returned via SOAP.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"James" <news@.att.com> wrote in message
news:B641549F-FDAA-4068-A5AA-46BF36C64CC5@.microsoft.com...
>I need to create 3 very similar data-driven subscriptions, with minor
>changes
> in report parameters, and differences in the 3 schedules.
> I there a way I can "copy-paste" one subscription into another? Is there a
> subscription description language kind of like RDL that I could duplicate?
> Any suggestions?
> tia.
in report parameters, and differences in the 3 schedules.
I there a way I can "copy-paste" one subscription into another? Is there a
subscription description language kind of like RDL that I could duplicate?
Any suggestions?
tia.Hi,
From your descriptions, I understood that you would like to use one
subscrition as 'model' and then 'paste' them for other two. Have I
understood you? Correct me if I was wrong.
Based on my scope, unfortuantely, I am afraid you will have to setup the
subscription separately.
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Your answer was all I needed, thanks.
I thought clicking "Was this post helpful to you?" was enough to let you know.
""Michael Cheng [MSFT]"" wrote:
> Hi,
> I wanted to post a quick note to see if you would like additional
> assistance or information regarding this particular issue. We appreciate
> your patience and look forward to hearing from you!
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi,
Thanks for your prompt updates!
Unfortuantely, the result of clicking "Was this post helpful to you?" was
not submitted to me, it was used for another use:(, might be for feedback
collection.
Anyway, it is highly appreciated for your kindest reply letting me know
this, thanks once more. Whenever you have any questions or concerns, don't
hesitate to let me know. We are always here to be of assistance!
Have a good day!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||The easiest way would be to use the SOAP methods. You could call
GetDataDrivenSubscriptionProperties and then call
CreateDataDrivenSubscription with the result. You would have to reenter
data source credentials as these are not returned via SOAP.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"James" <news@.att.com> wrote in message
news:B641549F-FDAA-4068-A5AA-46BF36C64CC5@.microsoft.com...
>I need to create 3 very similar data-driven subscriptions, with minor
>changes
> in report parameters, and differences in the 3 schedules.
> I there a way I can "copy-paste" one subscription into another? Is there a
> subscription description language kind of like RDL that I could duplicate?
> Any suggestions?
> tia.
Copying a report to another report in same solution
How can I copy a report and all its supporing queries and make a duplicate so that report1 and report2 are duplicates.
Report 2 will be little different than report1 but the basic queries and parameters will all the same. I can then edit the report layout to what the new report will look like. I do not want to have to cut/paste one object at a time.
Is there a better way?
You can do this directly from within Visual Studio.
Right click on the report you want to copy (in Solution Explorer) and select 'Copy' (or you can just highlight your report and hit Ctrl+C). Then press Ctrl+V. This will create a new duplicate report with 'Copy of ' prefixed on the report name.
Hope this helps.
Jarret
|||Copy does not work as there is no "Paste" function. The Ctl C/V works just fine. Thank you.Saturday, February 25, 2012
Copying "My Reports" between users.
Is there a way to copy a report saved in a users "My Reports" folder to a different users folder? If so what permissions and roles do I need to be in?Using the default settings no user has enough permissions to do this. You would need each user to give you permission or you need to go in as an admin (local RS box admin) and modify the security permissions to give yourself permission.
Subscribe to:
Posts (Atom)