Creating temporary table using a template table dynamically

I'm having an application for users to extract data from sql 2K. Problem is that I need to split the huge amount of data into few pages on the application screen.

Since my order by clause could be dynamic, which is a big problem, the solution I can think of is to populate a temporary table ( within a stored proc ) and assign a column within the temporary table with a running number.

This stored proc would accept among them, an argument, which is the table name of a base table.

However, I would like to create this stored proc in such a way that I could create a temporary table based on given based table name, complete with the field sizes and types. On top of that, would like to add a new column to this temp table to store a running number key.

Opinions appreciated. :)Refer to this linkSQL Performance (http://www.sql-server-performance.com/rd_temp_tables.asp) for information.

Creating Template Reports in RS 2005

I am tired of creating reports from scratch that contain essentially the
same elements, i.e. page footer with DateTime printed, page numbering, and
headers with report file names, setting the same margins and grid spacing
EACH AND EVERYTIME I write a report.
I want to create a template report that I can select from the Add New Item
report dialog. You can do this in SQL 2000 with RS 2000. You put the RDL
file into the following directory:
C:\Program Files\Microsoft SQL Server\80\Tools\Report
Designer\ProjectItems\ReportProject
But HOW do you do that in SQL 2005 Reporting Services?
I am stumped... :)
The closest I have come to finding it is in this directory:
C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
But I don't think I should be using that folder...
Can any Microsoft Reporting Services Developers answer this question please?
Sincerely,
=-ChrisYou know, sometimes in frustration solutions come to mind... :)
It occured to me that perhaps I was not looking in the right place, so on a
hunch, I did a search for ReportProjectItems.vsdir in Google and came across
Peter Blackburn's book index. I have a copy of Peter Blackburn's book - and
DOH! It shows me what I need to do to get my report templates to show up in
SQL 2005. If the report items are not listed in this file, they do not show
up, whereas in SQL 2000 Report Designer, they did. I also can see I made a
mistake of adding RDL files to this folder without updating the
ReportProjectItems.vsdir file.
Now I am happy!
=-Chris
"Chris Conner" <Chris.Conner@.NOSPAMPolarisLibrary.com> wrote in message
news:eTymPECCHHA.1196@.TK2MSFTNGP02.phx.gbl...
>I am tired of creating reports from scratch that contain essentially the
>same elements, i.e. page footer with DateTime printed, page numbering, and
>headers with report file names, setting the same margins and grid spacing
>EACH AND EVERYTIME I write a report.
> I want to create a template report that I can select from the Add New Item
> report dialog. You can do this in SQL 2000 with RS 2000. You put the RDL
> file into the following directory:
> C:\Program Files\Microsoft SQL Server\80\Tools\Report
> Designer\ProjectItems\ReportProject
> But HOW do you do that in SQL 2005 Reporting Services?
> I am stumped... :)
> The closest I have come to finding it is in this directory:
> C:\Program Files\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
> But I don't think I should be using that folder...
> Can any Microsoft Reporting Services Developers answer this question
> please?
> Sincerely,
> =-Chris
>

Creating report template

HI

I want to create a report template in SQL Server 2005 Reporting Services.

The template will have a fixed header and footer.I want to use this template in all my reports.

How to do so?

Its very simple. Just design the report header and footer as you want.
Deploy the Report.rdl. Take a copy of this Report.rdl form your working folder and paste it in
D:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

The path is the place where your vusual studio is installed.

Enjoy...

|||

Hey

Here is step by step tutorial to help you create a basic table report based on theAdventureWorks database using Report Designer.

Tutorial: Creating a Basic Report

Lesson 1: Creating a Report Server Project

Lesson 2: Setting Up Connection Information

Lesson 3: Defining a Query for the Report

Lesson 4: Adding a Table Data Region

Lesson 5: Previewing the Basic Report

Hope this helps.

Creating Dimension Template...

Hello,

I need to create a dimension that has pre-defined multiple hierarchies, attributes, and the data source table the dimension will be based on would be different for each customer. (The structure of the data source table would be the same though, just the underlying data would be different)

Thus, I thought about using the dimension template. However, the steps in the dimension template wizard is quite confusing to me. Does any know where to find a good document explanning how to create a dimension template? I read through the MSDN library about creating the template, but it's not too helpful either.

Please let me know if I am heading to the wrong direction, or if there is another good way to do this..... Any help is appreciated.

Thanks,

Hsiao-I

A dimension template is just a regular dimension XML file saved in the following location:

C:\Program Files\Microsoft SQL Server\90\Tools\Templates\olap\1033\Dimension Templates

So all you need to do is create a dimension either using the dimension wizard or manually in the dimenison editor, then go to the file system look for the .DIM XML file correpsonding to this dimension in the project folder where you created your project.

Then just copy this .DIM file to the path above and this dimenison will appear as a template in the dimension wizard.

Now the dimenison template only contains metadata information (so things like attributes, hierarchies...), it doesn't contain dimension members since these come from the underlying data source.

Let me know if this helps.