Adding the date to a subscription report name

Does anyone have information on how I can add a file date to my named report when a subscription writes that file to a network folder? I am exporting as .pdf files. For example, today I have filename abc.pdf but I'd like it to be abc03312006.pdf. Likewise, tomorrow's file would be abc04012006.pdf.

Any help is greatly appreciated.

You have to go for reporting services programming and create a subscription programatically and pass the date as a value to subscription's description parameter like this.

service.CreateSubscription(reportpath, extSettings, description, eventType, matchData, parameters );

|||

Can you please give more details on it? Where to go and how to do this?

Thanks,

-Rohit

Adding the date to a subscription report name

Does anyone have information on how I can add a file date to my named report when a subscription writes that file to a network folder? I am exporting as .pdf files. For example, today I have filename abc.pdf but I'd like it to be abc03312006.pdf. Likewise, tomorrow's file would be abc04012006.pdf.

Any help is greatly appreciated.

You have to go for reporting services programming and create a subscription programatically and pass the date as a value to subscription's description parameter like this.

service.CreateSubscription(reportpath, extSettings, description, eventType, matchData, parameters );

|||

Can you please give more details on it? Where to go and how to do this?

Thanks,

-Rohit

Adding text to RS home page folder.aspx

I would like to be able to add some text to the SQL RS home page (folder.aspx I believe). Is this possible and if so, how? Also, what if I would like to add a graphic (logo) to it as well.

thanks!

Martha

Hi Martha,

Can you please clarify your question? What do you mean by SQL Reporting Service home page.

Sincerely,

Amde

|||What you can do is to tweak the CSS file which is included in Reporting Services to get a company look-a-like.

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

HTH, Jens Suessmeyer.

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

I would like to be able to go to the page that lists the SQL RS reports that can be run and add some text, for example, "Sales data last updated 6/23/06". The page where I would like to see this show up is http://servername/reports/Pages/Folder.aspx

thanks!

Adding subfolders to to a project

Can subfolders be added to a project?
i want a few folder like : dashboards, full reports , management
reports etc.
in each folder i would like to store only the relevanr .rdl files and
images used in the reports.
but i dont see an option to add a folder when i right click on the
project name.
the only options i get when right clicking is new report or new
dataset.
i know folders can be added on the report server itself using the
manager but then i have to manually move all the files i wish to use in
the report and the report itself, and the next time i deploy the
reports, the updated files wont automaticaly be put in the folders.
any ideas?
thanks,
Gal.In your report solution, you can have several projects.
In Visual Studio (2005), click on your Solution. CLick on File -> Add -> New
project
Choose Reporting Services project
Give your project a name, and make sure the location of it is in the same
folder as the solution. (You'll get a new folder in the solution folder for
your new project)
Click OK, and you now have a sub-project in your solution.
Save your solution to not loose the connections to the new project. (Click
on the Save All, not just Save)
You now have to create all the data sources in your new project. But they
are easy to copy, just copy from your main solution, and paste to the new
project. You have to paste to the project, not in the data sources folder,
as VS gets confused by this... You might have to check the credentials in
your data sources too, sometimes mine are blanked out when I do this.
Kaisa M. Lindahl Lervik
"Galg" <gal.granov@.gmail.com> wrote in message
news:1151411108.304933.276730@.y41g2000cwy.googlegroups.com...
> Can subfolders be added to a project?
> i want a few folder like : dashboards, full reports , management
> reports etc.
> in each folder i would like to store only the relevanr .rdl files and
> images used in the reports.
> but i dont see an option to add a folder when i right click on the
> project name.
> the only options i get when right clicking is new report or new
> dataset.
> i know folders can be added on the report server itself using the
> manager but then i have to manually move all the files i wish to use in
> the report and the report itself, and the next time i deploy the
> reports, the updated files wont automaticaly be put in the folders.
> any ideas?
> thanks,
> Gal.
>|||thanks,
but cant i use the same data source for all?
i want to make a logical sepration of types of reports... no need to created
the same data source a few times.
"Kaisa M. Lindahl Lervik" wrote:
> In your report solution, you can have several projects.
> In Visual Studio (2005), click on your Solution. CLick on File -> Add -> New
> project
> Choose Reporting Services project
> Give your project a name, and make sure the location of it is in the same
> folder as the solution. (You'll get a new folder in the solution folder for
> your new project)
> Click OK, and you now have a sub-project in your solution.
> Save your solution to not loose the connections to the new project. (Click
> on the Save All, not just Save)
> You now have to create all the data sources in your new project. But they
> are easy to copy, just copy from your main solution, and paste to the new
> project. You have to paste to the project, not in the data sources folder,
> as VS gets confused by this... You might have to check the credentials in
> your data sources too, sometimes mine are blanked out when I do this.
> Kaisa M. Lindahl Lervik
>
> "Galg" <gal.granov@.gmail.com> wrote in message
> news:1151411108.304933.276730@.y41g2000cwy.googlegroups.com...
> > Can subfolders be added to a project?
> > i want a few folder like : dashboards, full reports , management
> > reports etc.
> > in each folder i would like to store only the relevanr .rdl files and
> > images used in the reports.
> > but i dont see an option to add a folder when i right click on the
> > project name.
> > the only options i get when right clicking is new report or new
> > dataset.
> >
> > i know folders can be added on the report server itself using the
> > manager but then i have to manually move all the files i wish to use in
> > the report and the report itself, and the next time i deploy the
> > reports, the updated files wont automaticaly be put in the folders.
> >
> > any ideas?
> >
> > thanks,
> >
> > Gal.
> >
>
>

Adding Misc files to Solution Explorer

I assume this is the best forum for this quesiton; if not, please direct me.

I have noticed that I can add (for example) a text file to a misc folder in a SQL Server project by dragging and dropping the file from Windows Explorer onto the Misc folder inside the SQL Server project. Is this the only way to add a file?

I noticed, for example, I could not copy and past to the Misc file folder.
Is there another way? If so, what is it? what is the preferred way?

I noticed that there have bee 55 views of this thread. It was posted Monday morning. would someone take a stab at it?|||The other way to add a file is to right click on the Project, select Add Existing Item, then Browse to the file in question (you need to change the File Type at the bottom to "All" in order to see text files, etc.).

Thanks, MJ

Adding folders under the solution

In RS, can one add a folder under the Reports folder? I don't see where I can do this. We work with many different state's and we would like to organize reports by state.

Thanks for the information.

hi,

Yes, you can. You can do it on the Report Server website (eg: http://reporservername/reports) clicking on the new folder. Then you can set up explicit security on it, if you do not want to have the inherited.

Also you can set up in the VS2005 SSRS project the destination folder in the project properties. It used when you deploy reports in a project. If the folder does not exist, it will create it and inherits the permission from the parent.

Regards,

Janos

|||

What I guess I was hoping to be able to do is to right click in the solution and Add a folder, like I can in a web project. We also use Source Safe and would like a similar directory structure there too. We would like to create one solution with the reports, however each report might vary because of different state requirements. From there, we would like a directory structure of Reports/StateName/thisreport.rdl.

Each state then get a copy of their own reports when the program as a whole is delivered to them. They have no need to see other state reports.

We are trying not to create a new Solution for each state because there are reports that are generic and can be created just once.

|||

You can create your folder structure in a solution. Each folder must have its own project below the solution.

eg.> I'd like a folder structure like this:

\

--US

|

-CA

-WA

Then I create an SSRS solution, then I add 3 projects. 1st project property page set the TargetReportFolder to /US, 2nd /US/CA, 3rd /US/WA.... etc.

I hope it helps.

regrads,

Janos

|||I'm also trying to create a folder structure inside the report project itself, to no avail. I think what guyinkalamazoo3 was really going for is the ability to create folders inside the single report project to keep things organized, without having to add a separate report project for each different state, i.e.:

ReportProject
-Reports (Root directory)
--California (Subdirectory)
--Washington (Subdirectory)

It seems odd that you can add folders to organize your project with any other project type, but you can't organize your reports this way. Was this missed in development of SSRS, or is it just another "feature"?