Print Page | Close Window

Dynamic Report with unknown columns name

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14882
Printed Date: 18 Apr 2025 at 10:56pm


Topic: Dynamic Report with unknown columns name
Posted By: bekeer020
Subject: Dynamic Report with unknown columns name
Date Posted: 06 Nov 2011 at 10:58pm
Hi All
 
I have stored procedure that return set of columns depend on date passed to stored procedure
 
If user pass for example: 1/1/2011
 
the stored procedure return 10 columns first column name is 1/1/2011 and second column name is 2/1/2011 and third column name is 3/1/2011 and .. until 10th column name is 10/1/2011 
 
Note : column name is different depend on passed date value
 
now how i can design cretal report in VS.Net to solve like this problem
 
Can any one help me


Replies:
Posted By: lockwelle
Date Posted: 08 Nov 2011 at 4:26am
don't name your columns like that...
use month1/month2 etc
 
have a column in your stored proc that reports the string to be displayed.
 
this way, the column names are always the same, and CR will be happy
 
HTH

Posted By: bekeer020
Date Posted: 14 Nov 2011 at 12:28am
Thank you i already solve it
 
i use temp table and change columns name
 
 
Thank you


Print Page | Close Window